SELECT /*+ GATHER_PLAN_STATISTICS NK2 */ TRUNC(PH.CREATION_DATE) ORDERED_DATE ,PH.TYPE_LOOKUP_CODE PO_TYPE ,PH.AUTHORIZATION_STATUS PO_STATUS ,PLL.CLOSED_CODE LINE_STATUS ,PH.SEGMENT1 PO_NUMBER ,PL.LINE_NUM PO_LINE_NUM ,( SELECT MAX(RELEASE_NUM) FROM APPS.PO_RELEASES_ALL WHERE PO_HEADER_ID = PH.PO_HEADER_ID ) PO_RELEASE_NUM ,( SELECT MSI.SEGMENT1 FROM APPS.MTL_SYSTEM_ITEMS_B MSI WHERE MSI.INVENTORY_ITEM_ID = PL.ITEM_ID AND MSI.ORGANIZATION_ID = PLL.SHIP_TO_ORGANIZATION_ID ) ITEM ,COALESCE(PL.ITEM_DESCRIPTION, ( SELECT MSI.DESCRIPTION FROM APPS.MTL_SYSTEM_ITEMS_B MSI WHERE MSI.INVENTORY_ITEM_ID = PL.ITEM_ID AND MSI.ORGANIZATION_ID = PLL.SHIP_TO_ORGANIZATION_ID )) ITEM_DESCRIPTION ,PLL.QUANTITY ,PLL.QUANTITY_RECEIVED ,PV.VENDOR_NAME SUPPLIER_NAME ,PVS.VENDOR_SITE_CODE SUPPLIER_SITE Plan hash value: 3816232161 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Starts | E-Rows |E-Bytes| Cost (%CPU)| E-Time | A-Rows | A-Time | Buffers | Reads | OMem | 1Mem | O/1/M | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | | | 20246 (100)| | 0 |00:00:00.01 | 0 | 0 | | | | | 1 | SORT AGGREGATE | | 4800 | 1 | 10 | | | 4800 |00:00:00.05 | 1846 | 0 | | | | | 2 | FIRST ROW | | 4800 | 1 | 10 | 3 (0)| 00:00:01 | 0 |00:00:00.04 | 1846 | 0 | | | | |* 3 | INDEX RANGE SCAN (MIN/MAX) | PO_RELEASES_U2 | 4800 | 1 | 10 | 3 (0)| 00:00:01 | 0 |00:00:00.03 | 1846 | 0 | | | | | 4 | TABLE ACCESS BY INDEX ROWID | MTL_SYSTEM_ITEMS_B | 6932 | 1 | 26 | 4 (0)| 00:00:01 | 6932 |00:00:00.41 | 26044 | 42 | | | | |* 5 | INDEX UNIQUE SCAN | MTL_SYSTEM_ITEMS_B_U1 | 6932 | 1 | | 3 (0)| 00:00:01 | 6932 |00:00:00.08 | 19652 | 0 | | | | | 6 | TABLE ACCESS BY INDEX ROWID | MTL_SYSTEM_ITEMS_B | 0 | 1 | 51 | 4 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | |* 7 | INDEX UNIQUE SCAN | MTL_SYSTEM_ITEMS_B_U1 | 0 | 1 | | 3 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | | 8 | TABLE ACCESS BY INDEX ROWID | PER_ALL_PEOPLE_F | 196 | 1 | 40 | 5 (0)| 00:00:01 | 196 |00:00:00.01 | 562 | 0 | | | | |* 9 | INDEX RANGE SCAN | PER_PEOPLE_F_PK | 196 | 6 | | 3 (0)| 00:00:01 | 196 |00:00:00.01 | 396 | 0 | | | | | 10 | SORT AGGREGATE | | 4800 | 1 | 14 | | | 4800 |00:00:00.35 | 19263 | 33 | | | | | 11 | TABLE ACCESS BY INDEX ROWID | PO_LINES_ALL | 4800 | 6 | 84 | 5 (0)| 00:00:01 | 12949 |00:00:00.31 | 19263 | 33 | | | | |* 12 | INDEX RANGE SCAN | PO_LINES_N16 | 4800 | 6 | | 3 (0)| 00:00:01 | 12949 |00:00:00.05 | 9120 | 1 | | | | | 13 | NESTED LOOPS | | 25 | 1 | 34 | 3 (0)| 00:00:01 | 25 |00:00:00.01 | 104 | 0 | | | | | 14 | TABLE ACCESS BY INDEX ROWID | HR_LOCATIONS_ALL_TL | 25 | 1 | 26 | 2 (0)| 00:00:01 | 25 |00:00:00.01 | 52 | 0 | | | | |* 15 | INDEX UNIQUE SCAN | HR_LOCATIONS_ALL_TL_PK | 25 | 1 | | 1 (0)| 00:00:01 | 25 |00:00:00.01 | 27 | 0 | | | | |* 16 | TABLE ACCESS BY INDEX ROWID | HR_LOCATIONS_ALL | 25 | 1 | 8 | 1 (0)| 00:00:01 | 25 |00:00:00.01 | 52 | 0 | | | | |* 17 | INDEX UNIQUE SCAN | HR_LOCATIONS_PK | 25 | 1 | | 0 (0)| | 25 |00:00:00.01 | 28 | 0 | | | | | 18 | NESTED LOOPS | | 3 | 1 | 34 | 3 (0)| 00:00:01 | 3 |00:00:00.01 | 16 | 0 | | | | | 19 | TABLE ACCESS BY INDEX ROWID | HR_LOCATIONS_ALL_TL | 3 | 1 | 26 | 2 (0)| 00:00:01 | 3 |00:00:00.01 | 8 | 0 | | | | |* 20 | INDEX UNIQUE SCAN | HR_LOCATIONS_ALL_TL_PK | 3 | 1 | | 1 (0)| 00:00:01 | 3 |00:00:00.01 | 5 | 0 | | | | |* 21 | TABLE ACCESS BY INDEX ROWID | HR_LOCATIONS_ALL | 3 | 1 | 8 | 1 (0)| 00:00:01 | 3 |00:00:00.01 | 8 | 0 | | | | |* 22 | INDEX UNIQUE SCAN | HR_LOCATIONS_PK | 3 | 1 | | 0 (0)| | 3 |00:00:00.01 | 5 | 0 | | | | |* 23 | TABLE ACCESS BY INDEX ROWID | FND_LOOKUP_VALUES | 4 | 1 | 64 | 5 (0)| 00:00:01 | 3 |00:00:00.01 | 16 | 1 | | | | |* 24 | INDEX RANGE SCAN | FND_LOOKUP_VALUES_X99 | 4 | 1 | | 4 (0)| 00:00:01 | 6 |00:00:00.01 | 10 | 0 | | | | | 25 | SORT UNIQUE | | 8149 | 1 | 46 | 145 (2)| 00:00:01 | 1414 |00:19:44.48 | 91M| 176K| 2048 | 2048 | 2/0/0| | 26 | WINDOW SORT | | 8149 | 1 | 46 | 145 (2)| 00:00:01 | 37811 |00:19:44.47 | 91M| 176K| 214K| 214K| 2/0/0| | 27 | NESTED LOOPS | | 8149 | | | | | 37811 |00:19:58.14 | 91M| 176K| | | | | 28 | NESTED LOOPS | | 8149 | 1 | 46 | 143 (0)| 00:00:01 | 17M|00:14:44.21 | 73M| 90450 | | | | | 29 | TABLE ACCESS BY INDEX ROWID | OE_ORDER_LINES_ALL | 8149 | 1 | 31 | 139 (0)| 00:00:01 | 17M|00:10:17.69 | 19M| 8604 | | | | |* 30 | INDEX RANGE SCAN | XXOM_OE_ORDER_LINES_N100 | 8149 | 142 | | 4 (0)| 00:00:01 | 17M|00:00:20.96 | 100K| 6570 | | | | |* 31 | INDEX RANGE SCAN | XXOM_3LP_SYM_ORA_ORDER_N11 | 17M| 1 | | 3 (0)| 00:00:01 | 17M|00:03:45.52 | 54M| 81846 | | | | |* 32 | TABLE ACCESS BY INDEX ROWID | XXOM_3LP_SYM_ORA_ORDER_LINES | 17M| 1 | 15 | 4 (0)| 00:00:01 | 37811 |00:05:59.72 | 19M| 86126 | | | | | 33 | SORT GROUP BY | | 0 | 1 | 78 | | | 0 |00:00:00.01 | 0 | 0 | 73728 | 73728 | | |* 34 | FILTER | | 0 | | | | | 0 |00:00:00.01 | 0 | 0 | | | | | 35 | NESTED LOOPS | | 0 | | | | | 0 |00:00:00.01 | 0 | 0 | | | | | 36 | NESTED LOOPS | | 0 | 11 | 858 | 49 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | | 37 | NESTED LOOPS | | 0 | 7 | 301 | 42 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | | 38 | NESTED LOOPS | | 0 | 7 | 252 | 28 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | | 39 | TABLE ACCESS BY INDEX ROWID | FND_ATTACHED_DOCUMENTS | 0 | 7 | 98 | 7 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | |* 40 | INDEX RANGE SCAN | FND_ATTACHED_DOCUMENTS_X1 | 0 | 6 | | 4 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | |* 41 | TABLE ACCESS BY INDEX ROWID | FND_DOCUMENTS | 0 | 1 | 22 | 3 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | |* 42 | INDEX UNIQUE SCAN | FND_DOCUMENTS_U1 | 0 | 1 | | 2 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | |* 43 | INDEX UNIQUE SCAN | FND_DOCUMENTS_SHORT_TEXT_U1 | 0 | 1 | 7 | 2 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | |* 44 | INDEX UNIQUE SCAN | FND_DOCUMENT_CATEGORIES_TL_U1 | 0 | 1 | | 0 (0)| | 0 |00:00:00.01 | 0 | 0 | | | | | 45 | TABLE ACCESS BY INDEX ROWID | FND_DOCUMENT_CATEGORIES_TL | 0 | 2 | 70 | 1 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | | 46 | SORT GROUP BY | | 0 | 1 | 334 | | | 0 |00:00:00.01 | 0 | 0 | 73728 | 73728 | | |* 47 | FILTER | | 0 | | | | | 0 |00:00:00.01 | 0 | 0 | | | | | 48 | NESTED LOOPS | | 0 | 11 | 3674 | 49 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | | 49 | NESTED LOOPS | | 0 | 7 | 2212 | 49 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | | 50 | NESTED LOOPS | | 0 | 7 | 252 | 28 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | | 51 | TABLE ACCESS BY INDEX ROWID | FND_ATTACHED_DOCUMENTS | 0 | 7 | 98 | 7 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | |* 52 | INDEX RANGE SCAN | FND_ATTACHED_DOCUMENTS_X1 | 0 | 6 | | 4 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | |* 53 | TABLE ACCESS BY INDEX ROWID | FND_DOCUMENTS | 0 | 1 | 22 | 3 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | |* 54 | INDEX UNIQUE SCAN | FND_DOCUMENTS_U1 | 0 | 1 | | 2 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | | 55 | TABLE ACCESS BY INDEX ROWID | FND_DOCUMENTS_SHORT_TEXT | 0 | 1 | 280 | 3 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | |* 56 | INDEX UNIQUE SCAN | FND_DOCUMENTS_SHORT_TEXT_U1 | 0 | 1 | | 2 (0)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | | | | |* 57 | INDEX UNIQUE SCAN | FND_DOCUMENT_CATEGORIES_TL_U1 | 0 | 2 | 36 | 0 (0)| | 0 |00:00:00.01 | 0 | 0 | | | | | 58 | SORT UNIQUE | | 13108 | 1 | 15 | 7 (29)| 00:00:01 | 9684 |00:00:05.75 | 44178 | 3907 | 2048 | 2048 | 2/0/0| | 59 | WINDOW SORT | | 13108 | 1 | 15 | 7 (29)| 00:00:01 | 17317 |00:00:05.67 | 44178 | 3907 | 2048 | 2048 | 2/0/0| |* 60 | TABLE ACCESS BY INDEX ROWID | PO_LINE_LOCATIONS_ARCHIVE_ALL | 13108 | 1 | 15 | 5 (0)| 00:00:01 | 17317 |00:00:05.71 | 44178 | 3907 | | | | |* 61 | INDEX RANGE SCAN | PO_LINE_LOCATIONS_ARCHIVE_U1 | 13108 | 2 | | 3 (0)| 00:00:01 | 27732 |00:00:00.65 | 18174 | 271 | | | | | 62 | TABLE ACCESS BY INDEX ROWID | FND_LOOKUP_VALUES | 4 | 1 | 64 | 6 (0)| 00:00:01 | 3 |00:00:00.01 | 19 | 0 | | | | |* 63 | INDEX RANGE SCAN | FND_LOOKUP_VALUES_U1 | 4 | 1 | | 5 (0)| 00:00:01 | 3 |00:00:00.01 | 18 | 0 | | | | | 64 | TABLE ACCESS BY INDEX ROWID | PER_ALL_PEOPLE_F | 194 | 1 | 40 | 5 (0)| 00:00:01 | 193 |00:00:00.02 | 566 | 0 | | | | |* 65 | INDEX RANGE SCAN | PER_PEOPLE_F_PK | 194 | 6 | | 3 (0)| 00:00:01 | 193 |00:00:00.01 | 389 | 0 | | | | | 66 | NESTED LOOPS | | 124 | 1 | 34 | 3 (0)| 00:00:01 | 23 |00:00:00.01 | 194 | 0 | | | | | 67 | TABLE ACCESS BY INDEX ROWID | HR_LOCATIONS_ALL_TL | 124 | 1 | 26 | 2 (0)| 00:00:01 | 23 |00:00:00.01 | 148 | 0 | | | | |* 68 | INDEX UNIQUE SCAN | HR_LOCATIONS_ALL_TL_PK | 124 | 1 | | 1 (0)| 00:00:01 | 23 |00:00:00.01 | 125 | 0 | | | | |* 69 | TABLE ACCESS BY INDEX ROWID | HR_LOCATIONS_ALL | 23 | 1 | 8 | 1 (0)| 00:00:01 | 23 |00:00:00.01 | 46 | 0 | | | | |* 70 | INDEX UNIQUE SCAN | HR_LOCATIONS_PK | 23 | 1 | | 0 (0)| | 23 |00:00:00.01 | 25 | 0 | | | | | 71 | TABLE ACCESS BY INDEX ROWID | HZ_LOCATIONS | 102 | 1 | 37 | 3 (0)| 00:00:01 | 101 |00:00:00.01 | 305 | 0 | | | | |* 72 | INDEX UNIQUE SCAN | HZ_LOCATIONS_U1 | 102 | 1 | | 2 (0)| 00:00:01 | 101 |00:00:00.01 | 204 | 0 | | | | | 73 | TABLE ACCESS BY INDEX ROWID | GL_CODE_COMBINATIONS | 43 | 1 | 49 | 3 (0)| 00:00:01 | 42 |00:00:00.01 | 116 | 0 | | | | |* 74 | INDEX UNIQUE SCAN | GL_CODE_COMBINATIONS_U1 | 43 | 1 | | 2 (0)| 00:00:01 | 42 |00:00:00.01 | 74 | 0 | | | | | 75 | TABLE ACCESS BY INDEX ROWID | GL_CODE_COMBINATIONS | 869 | 1 | 49 | 3 (0)| 00:00:01 | 868 |00:00:00.04 | 2603 | 0 | | | | |* 76 | INDEX UNIQUE SCAN | GL_CODE_COMBINATIONS_U1 | 869 | 1 | | 2 (0)| 00:00:01 | 868 |00:00:00.03 | 1735 | 0 | | | | |* 77 | COUNT STOPKEY | | 6932 | | | | | 6674 |00:00:01.60 | 55832 | 961 | | | | | 78 | NESTED LOOPS | | 6932 | | | | | 6674 |00:00:01.57 | 55832 | 961 | | | | | 79 | NESTED LOOPS | | 6932 | 1 | 66 | 5 (0)| 00:00:01 | 6674 |00:00:01.53 | 49158 | 961 | | | | | 80 | NESTED LOOPS | | 6932 | 1 | 38 | 3 (0)| 00:00:01 | 6674 |00:00:01.48 | 34349 | 961 | | | | |* 81 | INDEX UNIQUE SCAN | MTL_CATEGORY_SETS_B_U1 | 6932 | 1 | 16 | 0 (0)| | 6932 |00:00:00.04 | 6932 | 0 | | | | |* 82 | INDEX RANGE SCAN | MTL_ITEM_CATEGORIES_U1 | 6932 | 1 | 22 | 3 (0)| 00:00:01 | 6674 |00:00:01.43 | 27417 | 961 | | | | |* 83 | INDEX UNIQUE SCAN | MTL_CATEGORIES_B_U1 | 6674 | 1 | | 1 (0)| 00:00:01 | 6674 |00:00:00.05 | 14809 | 0 | | | | | 84 | TABLE ACCESS BY INDEX ROWID | MTL_CATEGORIES_B | 6674 | 1 | 28 | 2 (0)| 00:00:01 | 6674 |00:00:00.02 | 6674 | 0 | | | | |* 85 | COUNT STOPKEY | | 6804 | | | | | 6561 |00:00:01.99 | 50865 | 1359 | | | | | 86 | NESTED LOOPS | | 6804 | | | | | 6561 |00:00:01.97 | 50865 | 1359 | | | | | 87 | NESTED LOOPS | | 6804 | 1 | 41 | 6 (0)| 00:00:01 | 6561 |00:00:01.95 | 44304 | 1359 | | | | |* 88 | INDEX RANGE SCAN | MTL_ITEM_CATEGORIES_U1 | 6804 | 1 | 22 | 4 (0)| 00:00:01 | 6561 |00:00:01.88 | 27038 | 1359 | | | | |* 89 | INDEX UNIQUE SCAN | MTL_CATEGORIES_B_U1 | 6561 | 1 | | 1 (0)| 00:00:01 | 6561 |00:00:00.05 | 17266 | 0 | | | | | 90 | TABLE ACCESS BY INDEX ROWID | MTL_CATEGORIES_B | 6561 | 1 | 19 | 2 (0)| 00:00:01 | 6561 |00:00:00.02 | 6561 | 0 | | | | |* 91 | COUNT STOPKEY | | 2 | | | | | 2 |00:00:00.01 | 10 | 0 | | | | |* 92 | TABLE ACCESS BY INDEX ROWID | FND_LOOKUP_VALUES | 2 | 1 | 58 | 5 (0)| 00:00:01 | 2 |00:00:00.01 | 10 | 0 | | | | |* 93 | INDEX RANGE SCAN | FND_LOOKUP_VALUES_X99 | 2 | 1 | | 4 (0)| 00:00:01 | 2 |00:00:00.01 | 8 | 0 | | | | | 94 | SORT AGGREGATE | | 93 | 1 | 17 | | | 93 |00:00:00.01 | 177 | 0 | | | | |* 95 | FILTER | | 93 | | | | | 172 |00:00:00.01 | 177 | 0 | | | | |* 96 | INDEX RANGE SCAN | BOM_CALENDAR_EXCEPTIONS_U1 | 93 | 1 | 17 | 2 (0)| 00:00:01 | 172 |00:00:00.01 | 177 | 0 | | | | | 97 | SORT AGGREGATE | | 93 | 1 | 17 | | | 93 |00:00:00.01 | 3 | 0 | | | | |* 98 | FILTER | | 93 | | | | | 0 |00:00:00.01 | 3 | 0 | | | | |* 99 | INDEX RANGE SCAN | BOM_CALENDAR_EXCEPTIONS_U1 | 1 | 1 | 17 | 2 (0)| 00:00:01 | 0 |00:00:00.01 | 3 | 0 | | | | | 100 | SORT AGGREGATE | | 56 | 1 | 17 | | | 56 |00:00:00.01 | 27 | 0 | | | | |*101 | FILTER | | 56 | | | | | 18 |00:00:00.01 | 27 | 0 | | | | |*102 | INDEX RANGE SCAN | BOM_CALENDAR_EXCEPTIONS_U1 | 33 | 1 | 17 | 2 (0)| 00:00:01 | 18 |00:00:00.01 | 27 | 0 | | | | | 103 | SORT AGGREGATE | | 56 | 1 | 17 | | | 56 |00:00:00.01 | 8 | 0 | | | | |*104 | FILTER | | 56 | | | | | 0 |00:00:00.01 | 8 | 0 | | | | |*105 | INDEX RANGE SCAN | BOM_CALENDAR_EXCEPTIONS_U1 | 24 | 1 | 17 | 2 (0)| 00:00:01 | 0 |00:00:00.01 | 8 | 0 | | | | |*106 | COUNT STOPKEY | | 6932 | | | | | 588 |00:00:00.10 | 20511 | 0 | | | | | 107 | NESTED LOOPS | | 6932 | 1 | 60 | 5 (0)| 00:00:01 | 588 |00:00:00.09 | 20511 | 0 | | | | | 108 | NESTED LOOPS | | 6932 | 1 | 45 | 4 (0)| 00:00:01 | 588 |00:00:00.08 | 19316 | 0 | | | | | 109 | TABLE ACCESS BY INDEX ROWID | MTL_ABC_ASSIGNMENT_GROUPS | 6932 | 1 | 29 | 2 (0)| 00:00:01 | 1053 |00:00:00.05 | 14668 | 0 | | | | |*110 | INDEX UNIQUE SCAN | MTL_ABC_ASSIGNMENT_GROUPS_U2 | 6932 | 1 | | 1 (0)| 00:00:01 | 1053 |00:00:00.04 | 13615 | 0 | | | | | 111 | TABLE ACCESS BY INDEX ROWID | MTL_ABC_ASSIGNMENTS | 1053 | 1 | 16 | 3 (0)| 00:00:01 | 588 |00:00:00.02 | 4648 | 0 | | | | |*112 | INDEX UNIQUE SCAN | MTL_ABC_ASSIGNMENTS_U1 | 1053 | 1 | | 2 (0)| 00:00:01 | 588 |00:00:00.01 | 4049 | 0 | | | | |*113 | TABLE ACCESS BY INDEX ROWID | MTL_ABC_CLASSES | 588 | 1 | 15 | 1 (0)| 00:00:01 | 588 |00:00:00.01 | 1195 | 0 | | | | |*114 | INDEX UNIQUE SCAN | MTL_ABC_CLASSES_U1 | 588 | 1 | | 0 (0)| | 588 |00:00:00.01 | 607 | 0 | | | | | 115 | TABLE ACCESS BY INDEX ROWID | MTL_SYSTEM_ITEMS_B | 6932 | 1 | 13 | 4 (0)| 00:00:01 | 6932 |00:00:00.10 | 26048 | 0 | | | | |*116 | INDEX UNIQUE SCAN | MTL_SYSTEM_ITEMS_B_U1 | 6932 | 1 | | 3 (0)| 00:00:01 | 6932 |00:00:00.06 | 19654 | 0 | | | | | 117 | SORT AGGREGATE | | 13108 | 1 | 35 | | | 13108 |00:00:03.63 | 37023 | 641 | | | | |*118 | TABLE ACCESS BY INDEX ROWID | RCV_TRANSACTIONS | 13108 | 1 | 35 | 5 (0)| 00:00:01 | 3735 |00:00:03.57 | 37023 | 641 | | | | |*119 | INDEX RANGE SCAN | RCV_TRANSACTIONS_N6 | 13108 | 3 | | 3 (0)| 00:00:01 | 21278 |00:00:00.78 | 17869 | 422 | | | | | 120 | SORT AGGREGATE | | 13108 | 1 | 31 | | | 13108 |00:00:00.20 | 36673 | 0 | | | | |*121 | TABLE ACCESS BY INDEX ROWID | RCV_TRANSACTIONS | 13108 | 1 | 31 | 5 (0)| 00:00:01 | 9837 |00:00:00.16 | 36673 | 0 | | | | |*122 | INDEX RANGE SCAN | RCV_TRANSACTIONS_N6 | 13108 | 3 | | 3 (0)| 00:00:01 | 21278 |00:00:00.07 | 17523 | 0 | | | | | 123 | SORT ORDER BY | | 1 | 1 | 621 | 20246 (1)| 00:00:01 | 0 |00:00:00.01 | 0 | 0 | 73728 | 73728 | | |*124 | FILTER | | 1 | | | | | 13114 |00:00:26.90 | 669K| 17902 | | | | | 125 | NESTED LOOPS OUTER | | 1 | 1 | 621 | 20241 (1)| 00:00:01 | 13114 |00:00:26.41 | 641K| 17902 | | | | | 126 | NESTED LOOPS OUTER | | 1 | 1 | 592 | 20234 (1)| 00:00:01 | 13114 |00:00:09.18 | 516K| 2543 | | | | | 127 | NESTED LOOPS OUTER | | 1 | 1 | 581 | 20231 (1)| 00:00:01 | 13114 |00:00:07.80 | 488K| 1571 | | | | | 128 | NESTED LOOPS OUTER | | 1 | 1 | 565 | 20229 (1)| 00:00:01 | 13114 |00:00:07.32 | 475K| 1569 | | | | | 129 | NESTED LOOPS OUTER | | 1 | 1 | 548 | 20227 (1)| 00:00:01 | 13114 |00:00:07.12 | 461K| 1565 | | | | | 130 | NESTED LOOPS OUTER | | 1 | 1 | 536 | 20225 (1)| 00:00:01 | 13114 |00:00:07.09 | 459K| 1565 | | | | | 131 | NESTED LOOPS OUTER | | 1 | 1 | 517 | 20222 (1)| 00:00:01 | 13114 |00:00:07.03 | 456K| 1565 | | | | | 132 | NESTED LOOPS OUTER | | 1 | 1 | 491 | 20218 (1)| 00:00:01 | 13112 |00:00:08.08 | 447K| 1531 | | | | | 133 | NESTED LOOPS OUTER | | 1 | 1 | 479 | 20216 (1)| 00:00:01 | 13112 |00:00:07.41 | 433K| 1405 | | | | | 134 | NESTED LOOPS OUTER | | 1 | 1 | 421 | 20212 (1)| 00:00:01 | 13112 |00:00:06.57 | 405K| 1338 | | | | | 135 | NESTED LOOPS OUTER | | 1 | 1 | 396 | 20209 (1)| 00:00:01 | 13109 |00:00:04.01 | 391K| 1332 | | | | | 136 | NESTED LOOPS | | 1 | 1 | 380 | 20207 (1)| 00:00:01 | 13109 |00:00:03.88 | 360K| 1332 | | | | | 137 | NESTED LOOPS | | 1 | 1 | 362 | 20206 (1)| 00:00:01 | 13109 |00:00:03.79 | 347K| 1332 | | | | | 138 | NESTED LOOPS OUTER | | 1 | 1 | 270 | 20203 (1)| 00:00:01 | 30105 |00:00:03.20 | 158K| 957 | | | | | 139 | NESTED LOOPS | | 1 | 1 | 240 | 20202 (1)| 00:00:01 | 30105 |00:00:03.03 | 115K| 957 | | | | | 140 | NESTED LOOPS | | 1 | 1 | 208 | 20201 (1)| 00:00:01 | 30105 |00:00:02.90 | 81822 | 957 | | | | |*141 | TABLE ACCESS BY INDEX ROWID| PO_HEADERS_ALL | 1 | 1 | 106 | 20197 (1)| 00:00:01 | 6528 |00:00:00.71 | 41843 | 833 | | | | |*142 | INDEX RANGE SCAN | PO_HEADERS_ALL_X1 | 1 | 80709 | | 450 (1)| 00:00:01 | 129K|00:00:00.63 | 836 | 799 | | | | |*143 | TABLE ACCESS BY INDEX ROWID| PO_LINES_ALL | 6528 | 1 | 102 | 4 (0)| 00:00:01 | 30105 |00:00:01.68 | 39979 | 124 | | | | |*144 | INDEX RANGE SCAN | PO_LINES_N16 | 6528 | 6 | | 2 (0)| 00:00:01 | 30105 |00:00:00.43 | 12635 | 77 | | | | | 145 | TABLE ACCESS BY INDEX ROWID | PO_LINE_TYPES_TL | 30105 | 1 | 32 | 1 (0)| 00:00:01 | 30105 |00:00:00.12 | 33207 | 0 | | | | |*146 | INDEX UNIQUE SCAN | PO_LINE_TYPES_TL_U1 | 30105 | 1 | | 0 (0)| | 30105 |00:00:00.06 | 3102 | 0 | | | | | 147 | TABLE ACCESS BY INDEX ROWID | AP_SUPPLIERS | 30105 | 1 | 30 | 1 (0)| 00:00:01 | 30105 |00:00:00.16 | 43522 | 0 | | | | |*148 | INDEX UNIQUE SCAN | AP_SUPPLIERS_U1 | 30105 | 1 | | 0 (0)| | 30105 |00:00:00.09 | 13416 | 0 | | | | |*149 | TABLE ACCESS BY INDEX ROWID | PO_LINE_LOCATIONS_ALL | 30105 | 1 | 92 | 3 (0)| 00:00:01 | 13109 |00:00:01.65 | 189K| 375 | | | | |*150 | INDEX RANGE SCAN | PO_LINE_LOCATIONS_N14 | 30105 | 1 | | 2 (0)| 00:00:01 | 173K|00:00:00.77 | 18598 | 366 | | | | | 151 | TABLE ACCESS BY INDEX ROWID | MTL_PARAMETERS | 13109 | 1 | 18 | 1 (0)| 00:00:01 | 13109 |00:00:00.07 | 13118 | 0 | | | | |*152 | INDEX UNIQUE SCAN | MTL_PARAMETERS_U1 | 13109 | 1 | | 0 (0)| | 13109 |00:00:00.04 | 9 | 0 | | | | | 153 | TABLE ACCESS BY INDEX ROWID | AP_SUPPLIER_SITES_ALL | 13109 | 1 | 16 | 2 (0)| 00:00:01 | 13107 |00:00:00.10 | 31005 | 0 | | | | |*154 | INDEX UNIQUE SCAN | AP_SUPPLIER_SITES_U1 | 13109 | 1 | | 1 (0)| 00:00:01 | 13107 |00:00:00.07 | 16756 | 0 | | | | |*155 | TABLE ACCESS BY INDEX ROWID | OE_DROP_SHIP_SOURCES | 13109 | 1 | 25 | 3 (0)| 00:00:01 | 1089 |00:00:00.15 | 14219 | 6 | | | | |*156 | INDEX RANGE SCAN | OE_DROP_SHIP_SOURCES_N4 | 13109 | 1 | | 2 (0)| 00:00:01 | 1089 |00:00:00.12 | 13689 | 6 | | | | |*157 | TABLE ACCESS BY INDEX ROWID | PO_DISTRIBUTIONS_ALL | 13112 | 1 | 58 | 3 (0)| 00:00:01 | 13102 |00:00:00.83 | 28009 | 67 | | | | |*158 | INDEX RANGE SCAN | PO_DISTRIBUTIONS_N4 | 13112 | 2 | | 2 (0)| 00:00:01 | 13562 |00:00:00.29 | 15581 | 53 | | | | | 159 | TABLE ACCESS BY INDEX ROWID | PO_REQ_DISTRIBUTIONS_ALL | 13112 | 1 | 12 | 2 (0)| 00:00:01 | 5362 |00:00:00.65 | 13322 | 126 | | | | |*160 | INDEX UNIQUE SCAN | PO_REQ_DISTRIBUTIONS_U1 | 13112 | 1 | | 1 (0)| 00:00:01 | 5362 |00:00:00.32 | 7960 | 126 | | | | | 161 | TABLE ACCESS BY INDEX ROWID | PO_ACCEPTANCES | 13112 | 2 | 52 | 4 (0)| 00:00:01 | 7745 |00:00:00.27 | 8916 | 34 | | | | |*162 | INDEX RANGE SCAN | PO_ACCEPTANCES_N1 | 13112 | 2 | | 2 (0)| 00:00:01 | 7745 |00:00:00.13 | 6294 | 34 | | | | |*163 | TABLE ACCESS BY INDEX ROWID | OE_ORDER_LINES_ALL | 13114 | 1 | 19 | 3 (0)| 00:00:01 | 1088 |00:00:00.12 | 3609 | 0 | | | | |*164 | INDEX UNIQUE SCAN | OE_ORDER_LINES_U1 | 13114 | 1 | | 2 (0)| 00:00:01 | 1089 |00:00:00.06 | 2816 | 0 | | | | |*165 | INDEX RANGE SCAN | OE_ORDER_HEADERS_ALL_X7 | 13114 | 1 | 12 | 2 (0)| 00:00:01 | 1088 |00:00:00.05 | 1643 | 0 | | | | | 166 | TABLE ACCESS BY INDEX ROWID | PO_REQUISITION_LINES_ALL | 13114 | 1 | 17 | 2 (0)| 00:00:01 | 5362 |00:00:00.19 | 14503 | 4 | | | | |*167 | INDEX UNIQUE SCAN | PO_REQUISITION_LINES_U1 | 13114 | 1 | | 1 (0)| 00:00:01 | 5362 |00:00:00.14 | 7480 | 0 | | | | | 168 | TABLE ACCESS BY INDEX ROWID | PO_REQUISITION_HEADERS_ALL | 13114 | 1 | 16 | 2 (0)| 00:00:01 | 5362 |00:00:00.27 | 12731 | 2 | | | | |*169 | INDEX UNIQUE SCAN | PO_REQUISITION_HEADERS_U1 | 13114 | 1 | | 1 (0)| 00:00:01 | 5362 |00:00:00.16 | 7364 | 2 | | | | |*170 | INDEX RANGE SCAN | ZX_LINES_X1 | 13114 | 1 | 11 | 3 (0)| 00:00:01 | 13101 |00:00:01.36 | 27791 | 972 | | | | |*171 | TABLE ACCESS BY INDEX ROWID | ZX_LINES_DET_FACTORS | 13114 | 1 | 29 | 7 (0)| 00:00:01 | 13101 |00:00:17.92 | 124K| 15359 | | | | |*172 | INDEX RANGE SCAN | ZX_LINES_DET_FACTORS_N2 | 13114 | 8 | | 3 (0)| 00:00:01 | 202K|00:00:01.43 | 24844 | 1002 | | | | | 173 | SORT AGGREGATE | | 13101 | 1 | 22 | | | 13101 |00:00:00.41 | 28048 | 0 | | | | |*174 | TABLE ACCESS BY INDEX ROWID | PO_DISTRIBUTIONS_ALL | 13101 | 1 | 22 | 4 (0)| 00:00:01 | 13099 |00:00:00.38 | 28048 | 0 | | | | |*175 | INDEX RANGE SCAN | PO_DISTRIBUTIONS_N1 | 13101 | 1 | | 3 (0)| 00:00:01 | 13099 |00:00:00.30 | 16049 | 0 | | | | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Query Block Name / Object Alias (identified by operation id): ------------------------------------------------------------- 1 - SEL$2 3 - SEL$2 / PO_RELEASES_ALL@SEL$2 4 - SEL$3 / MSI@SEL$3 5 - SEL$3 / MSI@SEL$3 6 - SEL$4 / MSI@SEL$4 7 - SEL$4 / MSI@SEL$4 8 - SEL$ABDE6DFF / PER_ALL_PEOPLE_F@SEL$6 9 - SEL$ABDE6DFF / PER_ALL_PEOPLE_F@SEL$6 10 - SEL$7 11 - SEL$7 / PL1@SEL$7 12 - SEL$7 / PL1@SEL$7 13 - SEL$CF5359D5 14 - SEL$CF5359D5 / LOT@SEL$9 15 - SEL$CF5359D5 / LOT@SEL$9 16 - SEL$CF5359D5 / LOC@SEL$9 17 - SEL$CF5359D5 / LOC@SEL$9 18 - SEL$285A8194 19 - SEL$285A8194 / LOT@SEL$11 20 - SEL$285A8194 / LOT@SEL$11 21 - SEL$285A8194 / LOC@SEL$11 22 - SEL$285A8194 / LOC@SEL$11 23 - SEL$A43813BD / FND_LOOKUP_VALUES@SEL$15 24 - SEL$A43813BD / FND_LOOKUP_VALUES@SEL$15 25 - SEL$16 29 - SEL$16 / OL@SEL$16 30 - SEL$16 / OL@SEL$16 31 - SEL$16 / ML@SEL$16 32 - SEL$16 / ML@SEL$16 33 - SEL$E9CE8D49 39 - SEL$E9CE8D49 / B@SEL$17 40 - SEL$E9CE8D49 / B@SEL$17 41 - SEL$E9CE8D49 / C@SEL$17 42 - SEL$E9CE8D49 / C@SEL$17 43 - SEL$E9CE8D49 / DST@SEL$17 44 - SEL$E9CE8D49 / FND_DOCUMENT_CATEGORIES_TL@SEL$19 45 - SEL$E9CE8D49 / FND_DOCUMENT_CATEGORIES_TL@SEL$19 46 - SEL$470E2127 51 - SEL$470E2127 / B@SEL$20 52 - SEL$470E2127 / B@SEL$20 53 - SEL$470E2127 / C@SEL$20 54 - SEL$470E2127 / C@SEL$20 55 - SEL$470E2127 / DST@SEL$20 56 - SEL$470E2127 / DST@SEL$20 57 - SEL$470E2127 / FND_DOCUMENT_CATEGORIES_TL@SEL$22 58 - SEL$23 60 - SEL$23 / PLLA@SEL$23 61 - SEL$23 / PLLA@SEL$23 62 - SEL$187E06DF / FND_LOOKUP_VALUES@SEL$27 63 - SEL$187E06DF / FND_LOOKUP_VALUES@SEL$27 64 - SEL$6BD15B31 / PER_ALL_PEOPLE_F@SEL$29 65 - SEL$6BD15B31 / PER_ALL_PEOPLE_F@SEL$29 66 - SEL$DCCAED8A 67 - SEL$DCCAED8A / LOT@SEL$31 68 - SEL$DCCAED8A / LOT@SEL$31 69 - SEL$DCCAED8A / LOC@SEL$31 70 - SEL$DCCAED8A / LOC@SEL$31 71 - SEL$32 / HZ_LOCATIONS@SEL$32 72 - SEL$32 / HZ_LOCATIONS@SEL$32 73 - SEL$8C085B80 / GL_CODE_COMBINATIONS@SEL$34 74 - SEL$8C085B80 / GL_CODE_COMBINATIONS@SEL$34 75 - SEL$33BBCCBB / GL_CODE_COMBINATIONS@SEL$36 76 - SEL$33BBCCBB / GL_CODE_COMBINATIONS@SEL$36 77 - SEL$318A0CC0 81 - SEL$318A0CC0 / MTL_CATEGORY_SETS_B@SEL$42 82 - SEL$318A0CC0 / MIC@SEL$37 83 - SEL$318A0CC0 / MTL_CATEGORIES_B@SEL$40 84 - SEL$318A0CC0 / MTL_CATEGORIES_B@SEL$40 85 - SEL$4EFE9E69 88 - SEL$4EFE9E69 / MIC@SEL$43 89 - SEL$4EFE9E69 / MTL_CATEGORIES_B@SEL$45 90 - SEL$4EFE9E69 / MTL_CATEGORIES_B@SEL$45 91 - SEL$9D60E82C 92 - SEL$9D60E82C / FND_LOOKUP_VALUES@SEL$48 93 - SEL$9D60E82C / FND_LOOKUP_VALUES@SEL$48 94 - SEL$49 96 - SEL$49 / BCE@SEL$49 97 - SEL$50 99 - SEL$50 / BCE@SEL$50 100 - SEL$51 102 - SEL$51 / BCE@SEL$51 103 - SEL$52 105 - SEL$52 / BCE@SEL$52 106 - SEL$53 109 - SEL$53 / AAG@SEL$53 110 - SEL$53 / AAG@SEL$53 111 - SEL$53 / MAA@SEL$53 112 - SEL$53 / MAA@SEL$53 113 - SEL$53 / MAC@SEL$53 114 - SEL$53 / MAC@SEL$53 115 - SEL$54 / MSI@SEL$54 116 - SEL$54 / MSI@SEL$54 117 - SEL$55 118 - SEL$55 / RT@SEL$55 119 - SEL$55 / RT@SEL$55 120 - SEL$56 121 - SEL$56 / RT@SEL$56 122 - SEL$56 / RT@SEL$56 123 - SEL$ECE137A9 141 - SEL$ECE137A9 / PH@SEL$1 142 - SEL$ECE137A9 / PH@SEL$1 143 - SEL$ECE137A9 / PL@SEL$1 144 - SEL$ECE137A9 / PL@SEL$1 145 - SEL$ECE137A9 / PO_LINE_TYPES_TL@SEL$59 146 - SEL$ECE137A9 / PO_LINE_TYPES_TL@SEL$59 147 - SEL$ECE137A9 / AP_SUPPLIERS@SEL$57 148 - SEL$ECE137A9 / AP_SUPPLIERS@SEL$57 149 - SEL$ECE137A9 / PLL@SEL$1 150 - SEL$ECE137A9 / PLL@SEL$1 151 - SEL$ECE137A9 / MP@SEL$1 152 - SEL$ECE137A9 / MP@SEL$1 153 - SEL$ECE137A9 / PVS@SEL$1 154 - SEL$ECE137A9 / PVS@SEL$1 155 - SEL$ECE137A9 / ODS@SEL$1 156 - SEL$ECE137A9 / ODS@SEL$1 157 - SEL$ECE137A9 / PD@SEL$1 158 - SEL$ECE137A9 / PD@SEL$1 159 - SEL$ECE137A9 / PRDA@SEL$1 160 - SEL$ECE137A9 / PRDA@SEL$1 161 - SEL$ECE137A9 / POA@SEL$1 162 - SEL$ECE137A9 / POA@SEL$1 163 - SEL$ECE137A9 / OEL@SEL$1 164 - SEL$ECE137A9 / OEL@SEL$1 165 - SEL$ECE137A9 / OEH@SEL$1 166 - SEL$ECE137A9 / PRLA@SEL$1 167 - SEL$ECE137A9 / PRLA@SEL$1 168 - SEL$ECE137A9 / PRHA@SEL$1 169 - SEL$ECE137A9 / PRHA@SEL$1 170 - SEL$ECE137A9 / ZXL@SEL$1 171 - SEL$ECE137A9 / ZXD@SEL$1 172 - SEL$ECE137A9 / ZXD@SEL$1 173 - SEL$60 174 - SEL$60 / PD2@SEL$60 175 - SEL$60 / PD2@SEL$60 Outline Data ------------- /*+ BEGIN_OUTLINE_DATA IGNORE_OPTIM_EMBEDDED_HINTS OPTIMIZER_FEATURES_ENABLE('11.2.0.4') DB_VERSION('19.1.0') OPT_PARAM('_b_tree_bitmap_plans' 'false') OPT_PARAM('_fast_full_scan_enabled' 'false') OPT_PARAM('_or_expand_nvl_predicate' 'false') OPT_PARAM('_optim_peek_user_binds' 'false') OPT_PARAM('_optimizer_extended_cursor_sharing' 'none') OPT_PARAM('_optimizer_extended_cursor_sharing_rel' 'none') OPT_PARAM('_optimizer_adaptive_cursor_sharing' 'false') OPT_PARAM('_optimizer_use_feedback' 'false') OPT_PARAM('_optimizer_gather_feedback' 'false') OPT_PARAM('container_data' 'CURRENT_DICTIONARY') OPT_PARAM('_fix_control' '31360214:1') ALL_ROWS FORCE_XML_QUERY_REWRITE XML_DML_RWT_STMT XMLINDEX_REWRITE XMLINDEX_REWRITE_IN_SELECT NO_COST_XML_QUERY_REWRITE OUTLINE_LEAF(@"SEL$2") OUTLINE_LEAF(@"SEL$3") OUTLINE_LEAF(@"SEL$4") OUTLINE_LEAF(@"SEL$ABDE6DFF") MERGE(@"SEL$6" >"SEL$5") OUTLINE_LEAF(@"SEL$7") OUTLINE_LEAF(@"SEL$CF5359D5") MERGE(@"SEL$9" >"SEL$8") OUTLINE_LEAF(@"SEL$285A8194") MERGE(@"SEL$11" >"SEL$10") OUTLINE_LEAF(@"SEL$A43813BD") MERGE(@"SEL$A3DCF13B" >"SEL$12") OUTLINE_LEAF(@"SEL$16") OUTLINE_LEAF(@"SEL$E9CE8D49") MERGE(@"SEL$07C48A2D" >"SEL$17") OUTLINE_LEAF(@"SEL$470E2127") MERGE(@"SEL$109DB78D" >"SEL$20") OUTLINE_LEAF(@"SEL$23") OUTLINE_LEAF(@"SEL$187E06DF") MERGE(@"SEL$EA0C5ECA" >"SEL$24") OUTLINE_LEAF(@"SEL$6BD15B31") MERGE(@"SEL$29" >"SEL$28") OUTLINE_LEAF(@"SEL$DCCAED8A") MERGE(@"SEL$31" >"SEL$30") OUTLINE_LEAF(@"SEL$32") OUTLINE_LEAF(@"SEL$8C085B80") MERGE(@"SEL$34" >"SEL$33") OUTLINE_LEAF(@"SEL$33BBCCBB") MERGE(@"SEL$36" >"SEL$35") OUTLINE_LEAF(@"SEL$318A0CC0") MERGE(@"SEL$5BE7B2F8" >"SEL$37") MERGE(@"SEL$629F62D6" >"SEL$37") OUTLINE_LEAF(@"SEL$4EFE9E69") MERGE(@"SEL$BE0BA760" >"SEL$43") OUTLINE_LEAF(@"SEL$9D60E82C") MERGE(@"SEL$FEB2CA50" >"SEL$46") OUTLINE_LEAF(@"SEL$49") OUTLINE_LEAF(@"SEL$50") OUTLINE_LEAF(@"SEL$51") OUTLINE_LEAF(@"SEL$52") OUTLINE_LEAF(@"SEL$53") OUTLINE_LEAF(@"SEL$54") OUTLINE_LEAF(@"SEL$55") OUTLINE_LEAF(@"SEL$56") OUTLINE_LEAF(@"SEL$60") OUTLINE_LEAF(@"SEL$ECE137A9") MERGE(@"SEL$260377DE" >"SEL$1") MERGE(@"SEL$57" >"SEL$1") OUTLINE(@"SEL$5") OUTLINE(@"SEL$6") OUTLINE(@"SEL$8") OUTLINE(@"SEL$9") OUTLINE(@"SEL$10") OUTLINE(@"SEL$11") OUTLINE(@"SEL$12") OUTLINE(@"SEL$A3DCF13B") MERGE(@"SEL$1FB6C052" >"SEL$13") OUTLINE(@"SEL$17") OUTLINE(@"SEL$07C48A2D") MERGE(@"SEL$19" >"SEL$18") OUTLINE(@"SEL$20") OUTLINE(@"SEL$109DB78D") MERGE(@"SEL$22" >"SEL$21") OUTLINE(@"SEL$24") OUTLINE(@"SEL$EA0C5ECA") MERGE(@"SEL$FFAA604D" >"SEL$25") OUTLINE(@"SEL$28") OUTLINE(@"SEL$29") OUTLINE(@"SEL$30") OUTLINE(@"SEL$31") OUTLINE(@"SEL$33") OUTLINE(@"SEL$34") OUTLINE(@"SEL$35") OUTLINE(@"SEL$36") OUTLINE(@"SEL$37") OUTLINE(@"SEL$5BE7B2F8") MERGE(@"SEL$42" >"SEL$41") OUTLINE(@"SEL$629F62D6") MERGE(@"SEL$79D9B115" >"SEL$38") OUTLINE(@"SEL$43") OUTLINE(@"SEL$BE0BA760") MERGE(@"SEL$45" >"SEL$44") OUTLINE(@"SEL$46") OUTLINE(@"SEL$FEB2CA50") MERGE(@"SEL$48" >"SEL$47") OUTLINE(@"SEL$1") OUTLINE(@"SEL$260377DE") MERGE(@"SEL$59" >"SEL$58") OUTLINE(@"SEL$57") OUTLINE(@"SEL$13") OUTLINE(@"SEL$1FB6C052") MERGE(@"SEL$15" >"SEL$14") OUTLINE(@"SEL$18") OUTLINE(@"SEL$19") OUTLINE(@"SEL$21") OUTLINE(@"SEL$22") OUTLINE(@"SEL$25") OUTLINE(@"SEL$FFAA604D") MERGE(@"SEL$27" >"SEL$26") OUTLINE(@"SEL$41") OUTLINE(@"SEL$42") OUTLINE(@"SEL$38") OUTLINE(@"SEL$79D9B115") MERGE(@"SEL$40" >"SEL$39") OUTLINE(@"SEL$44") OUTLINE(@"SEL$45") OUTLINE(@"SEL$47") OUTLINE(@"SEL$48") OUTLINE(@"SEL$58") OUTLINE(@"SEL$59") OUTLINE(@"SEL$14") OUTLINE(@"SEL$15") OUTLINE(@"SEL$26") OUTLINE(@"SEL$27") OUTLINE(@"SEL$39") OUTLINE(@"SEL$40") INDEX_RS_ASC(@"SEL$ECE137A9" "PH"@"SEL$1" "PO_HEADERS_ALL_X1") INDEX_RS_ASC(@"SEL$ECE137A9" "PL"@"SEL$1" ("PO_LINES_ALL"."PO_HEADER_ID" "PO_LINES_ALL"."VENDOR_PRODUCT_NUM")) INDEX_RS_ASC(@"SEL$ECE137A9" "PO_LINE_TYPES_TL"@"SEL$59" ("PO_LINE_TYPES_TL"."LINE_TYPE_ID" "PO_LINE_TYPES_TL"."LANGUAGE" "PO_LINE_TYPES_TL"."ZD_EDITION_NAME")) INDEX_RS_ASC(@"SEL$ECE137A9" "AP_SUPPLIERS"@"SEL$57" ("AP_SUPPLIERS"."VENDOR_ID")) INDEX_RS_ASC(@"SEL$ECE137A9" "PLL"@"SEL$1" ("PO_LINE_LOCATIONS_ALL"."PO_HEADER_ID" "PO_LINE_LOCATIONS_ALL"."PO_RELEASE_ID")) INDEX_RS_ASC(@"SEL$ECE137A9" "MP"@"SEL$1" ("MTL_PARAMETERS"."ORGANIZATION_ID")) INDEX_RS_ASC(@"SEL$ECE137A9" "PVS"@"SEL$1" ("AP_SUPPLIER_SITES_ALL"."VENDOR_SITE_ID")) INDEX_RS_ASC(@"SEL$ECE137A9" "ODS"@"SEL$1" ("OE_DROP_SHIP_SOURCES"."LINE_LOCATION_ID")) INDEX_RS_ASC(@"SEL$ECE137A9" "PD"@"SEL$1" ("PO_DISTRIBUTIONS_ALL"."PO_LINE_ID")) INDEX_RS_ASC(@"SEL$ECE137A9" "PRDA"@"SEL$1" ("PO_REQ_DISTRIBUTIONS_ALL"."DISTRIBUTION_ID")) INDEX_RS_ASC(@"SEL$ECE137A9" "POA"@"SEL$1" ("PO_ACCEPTANCES"."PO_HEADER_ID")) INDEX_RS_ASC(@"SEL$ECE137A9" "OEL"@"SEL$1" ("OE_ORDER_LINES_ALL"."LINE_ID")) INDEX(@"SEL$ECE137A9" "OEH"@"SEL$1" ("OE_ORDER_HEADERS_ALL"."HEADER_ID" "OE_ORDER_HEADERS_ALL"."ORG_ID" "OE_ORDER_HEADERS_ALL"."ORDER_NUMBER" "OE_ORDER_HEADERS_ALL"."ORDERED_DATE" "OE_ORDER_HEADERS_ALL"."ORDER_TYPE_ID" "OE_ORDER_HEADERS_ALL"."OPEN_FLAG" "OE_ORDER_HEADERS_ALL"."CANCELLED_FLAG")) INDEX_RS_ASC(@"SEL$ECE137A9" "PRLA"@"SEL$1" ("PO_REQUISITION_LINES_ALL"."REQUISITION_LINE_ID")) INDEX_RS_ASC(@"SEL$ECE137A9" "PRHA"@"SEL$1" ("PO_REQUISITION_HEADERS_ALL"."REQUISITION_HEADER_ID")) INDEX(@"SEL$ECE137A9" "ZXL"@"SEL$1" ("ZX_LINES"."TRX_LINE_ID" "ZX_LINES"."TRX_ID" "ZX_LINES"."APPLICATION_ID")) INDEX_RS_ASC(@"SEL$ECE137A9" "ZXD"@"SEL$1" ("ZX_LINES_DET_FACTORS"."TRX_ID" "ZX_LINES_DET_FACTORS"."LEDGER_ID")) LEADING(@"SEL$ECE137A9" "PH"@"SEL$1" "PL"@"SEL$1" "PO_LINE_TYPES_TL"@"SEL$59" "AP_SUPPLIERS"@"SEL$57" "PLL"@"SEL$1" "MP"@"SEL$1" "PVS"@"SEL$1" "ODS"@"SEL$1" "PD"@"SEL$1" "PRDA"@"SEL$1" "POA"@"SEL$1" "OEL"@"SEL$1" "OEH"@"SEL$1" "PRLA"@"SEL$1" "PRHA"@"SEL$1" "ZXL"@"SEL$1" "ZXD"@"SEL$1") USE_NL(@"SEL$ECE137A9" "PL"@"SEL$1") USE_NL(@"SEL$ECE137A9" "PO_LINE_TYPES_TL"@"SEL$59") USE_NL(@"SEL$ECE137A9" "AP_SUPPLIERS"@"SEL$57") USE_NL(@"SEL$ECE137A9" "PLL"@"SEL$1") USE_NL(@"SEL$ECE137A9" "MP"@"SEL$1") USE_NL(@"SEL$ECE137A9" "PVS"@"SEL$1") USE_NL(@"SEL$ECE137A9" "ODS"@"SEL$1") USE_NL(@"SEL$ECE137A9" "PD"@"SEL$1") USE_NL(@"SEL$ECE137A9" "PRDA"@"SEL$1") USE_NL(@"SEL$ECE137A9" "POA"@"SEL$1") USE_NL(@"SEL$ECE137A9" "OEL"@"SEL$1") USE_NL(@"SEL$ECE137A9" "OEH"@"SEL$1") USE_NL(@"SEL$ECE137A9" "PRLA"@"SEL$1") USE_NL(@"SEL$ECE137A9" "PRHA"@"SEL$1") USE_NL(@"SEL$ECE137A9" "ZXL"@"SEL$1") USE_NL(@"SEL$ECE137A9" "ZXD"@"SEL$1") PQ_FILTER(@"SEL$ECE137A9" SERIAL) INDEX_RS_ASC(@"SEL$60" "PD2"@"SEL$60" ("PO_DISTRIBUTIONS_ALL"."LINE_LOCATION_ID")) INDEX_RS_ASC(@"SEL$56" "RT"@"SEL$56" ("RCV_TRANSACTIONS"."PO_LINE_LOCATION_ID")) INDEX_RS_ASC(@"SEL$55" "RT"@"SEL$55" ("RCV_TRANSACTIONS"."PO_LINE_LOCATION_ID")) INDEX_RS_ASC(@"SEL$54" "MSI"@"SEL$54" ("MTL_SYSTEM_ITEMS_B"."INVENTORY_ITEM_ID" "MTL_SYSTEM_ITEMS_B"."ORGANIZATION_ID")) INDEX_RS_ASC(@"SEL$53" "AAG"@"SEL$53" ("MTL_ABC_ASSIGNMENT_GROUPS"."ORGANIZATION_ID" "MTL_ABC_ASSIGNMENT_GROUPS"."ASSIGNMENT_GROUP_NAME")) INDEX_RS_ASC(@"SEL$53" "MAA"@"SEL$53" ("MTL_ABC_ASSIGNMENTS"."ASSIGNMENT_GROUP_ID" "MTL_ABC_ASSIGNMENTS"."INVENTORY_ITEM_ID")) INDEX_RS_ASC(@"SEL$53" "MAC"@"SEL$53" ("MTL_ABC_CLASSES"."ABC_CLASS_ID")) LEADING(@"SEL$53" "AAG"@"SEL$53" "MAA"@"SEL$53" "MAC"@"SEL$53") USE_NL(@"SEL$53" "MAA"@"SEL$53") USE_NL(@"SEL$53" "MAC"@"SEL$53") INDEX(@"SEL$52" "BCE"@"SEL$52" ("BOM_CALENDAR_EXCEPTIONS"."CALENDAR_CODE" "BOM_CALENDAR_EXCEPTIONS"."EXCEPTION_SET_ID" "BOM_CALENDAR_EXCEPTIONS"."EXCEPTION_DATE")) INDEX(@"SEL$51" "BCE"@"SEL$51" ("BOM_CALENDAR_EXCEPTIONS"."CALENDAR_CODE" "BOM_CALENDAR_EXCEPTIONS"."EXCEPTION_SET_ID" "BOM_CALENDAR_EXCEPTIONS"."EXCEPTION_DATE")) INDEX(@"SEL$50" "BCE"@"SEL$50" ("BOM_CALENDAR_EXCEPTIONS"."CALENDAR_CODE" "BOM_CALENDAR_EXCEPTIONS"."EXCEPTION_SET_ID" "BOM_CALENDAR_EXCEPTIONS"."EXCEPTION_DATE")) INDEX(@"SEL$49" "BCE"@"SEL$49" ("BOM_CALENDAR_EXCEPTIONS"."CALENDAR_CODE" "BOM_CALENDAR_EXCEPTIONS"."EXCEPTION_SET_ID" "BOM_CALENDAR_EXCEPTIONS"."EXCEPTION_DATE")) INDEX_RS_ASC(@"SEL$9D60E82C" "FND_LOOKUP_VALUES"@"SEL$48" ("FND_LOOKUP_VALUES"."LOOKUP_TYPE" "FND_LOOKUP_VALUES"."LOOKUP_CODE" "FND_LOOKUP_VALUES"."LANGUAGE")) INDEX(@"SEL$4EFE9E69" "MIC"@"SEL$43" ("MTL_ITEM_CATEGORIES"."ORGANIZATION_ID" "MTL_ITEM_CATEGORIES"."INVENTORY_ITEM_ID" "MTL_ITEM_CATEGORIES"."CATEGORY_SET_ID" "MTL_ITEM_CATEGORIES"."CATEGORY_ID")) INDEX(@"SEL$4EFE9E69" "MTL_CATEGORIES_B"@"SEL$45" ("MTL_CATEGORIES_B"."CATEGORY_ID" "MTL_CATEGORIES_B"."ZD_EDITION_NAME")) LEADING(@"SEL$4EFE9E69" "MIC"@"SEL$43" "MTL_CATEGORIES_B"@"SEL$45") USE_NL(@"SEL$4EFE9E69" "MTL_CATEGORIES_B"@"SEL$45") NLJ_BATCHING(@"SEL$4EFE9E69" "MTL_CATEGORIES_B"@"SEL$45") INDEX(@"SEL$318A0CC0" "MTL_CATEGORY_SETS_B"@"SEL$42" ("MTL_CATEGORY_SETS_B"."CATEGORY_SET_ID" "MTL_CATEGORY_SETS_B"."ZD_EDITION_NAME")) INDEX(@"SEL$318A0CC0" "MIC"@"SEL$37" ("MTL_ITEM_CATEGORIES"."ORGANIZATION_ID" "MTL_ITEM_CATEGORIES"."INVENTORY_ITEM_ID" "MTL_ITEM_CATEGORIES"."CATEGORY_SET_ID" "MTL_ITEM_CATEGORIES"."CATEGORY_ID")) INDEX(@"SEL$318A0CC0" "MTL_CATEGORIES_B"@"SEL$40" ("MTL_CATEGORIES_B"."CATEGORY_ID" "MTL_CATEGORIES_B"."ZD_EDITION_NAME")) LEADING(@"SEL$318A0CC0" "MTL_CATEGORY_SETS_B"@"SEL$42" "MIC"@"SEL$37" "MTL_CATEGORIES_B"@"SEL$40") USE_NL(@"SEL$318A0CC0" "MIC"@"SEL$37") USE_NL(@"SEL$318A0CC0" "MTL_CATEGORIES_B"@"SEL$40") NLJ_BATCHING(@"SEL$318A0CC0" "MTL_CATEGORIES_B"@"SEL$40") INDEX_RS_ASC(@"SEL$33BBCCBB" "GL_CODE_COMBINATIONS"@"SEL$36" ("GL_CODE_COMBINATIONS"."CODE_COMBINATION_ID")) INDEX_RS_ASC(@"SEL$8C085B80" "GL_CODE_COMBINATIONS"@"SEL$34" ("GL_CODE_COMBINATIONS"."CODE_COMBINATION_ID")) INDEX_RS_ASC(@"SEL$32" "HZ_LOCATIONS"@"SEL$32" ("HZ_LOCATIONS"."LOCATION_ID")) INDEX_RS_ASC(@"SEL$DCCAED8A" "LOT"@"SEL$31" ("HR_LOCATIONS_ALL_TL"."LOCATION_ID" "HR_LOCATIONS_ALL_TL"."LANGUAGE")) INDEX_RS_ASC(@"SEL$DCCAED8A" "LOC"@"SEL$31" ("HR_LOCATIONS_ALL"."LOCATION_ID")) LEADING(@"SEL$DCCAED8A" "LOT"@"SEL$31" "LOC"@"SEL$31") USE_NL(@"SEL$DCCAED8A" "LOC"@"SEL$31") INDEX_RS_ASC(@"SEL$6BD15B31" "PER_ALL_PEOPLE_F"@"SEL$29" ("PER_ALL_PEOPLE_F"."PERSON_ID" "PER_ALL_PEOPLE_F"."EFFECTIVE_START_DATE" "PER_ALL_PEOPLE_F"."EFFECTIVE_END_DATE")) INDEX_RS_ASC(@"SEL$187E06DF" "FND_LOOKUP_VALUES"@"SEL$27" ("FND_LOOKUP_VALUES"."LOOKUP_TYPE" "FND_LOOKUP_VALUES"."VIEW_APPLICATION_ID" "FND_LOOKUP_VALUES"."LOOKUP_CODE" "FND_LOOKUP_VALUES"."SECURITY_GROUP_ID" "FND_LOOKUP_VALUES"."LANGUAGE" "FND_LOOKUP_VALUES"."ZD_EDITION_NAME")) INDEX_RS_ASC(@"SEL$23" "PLLA"@"SEL$23" ("PO_LINE_LOCATIONS_ARCHIVE_ALL"."LINE_LOCATION_ID" "PO_LINE_LOCATIONS_ARCHIVE_ALL"."REVISION_NUM")) INDEX_RS_ASC(@"SEL$470E2127" "B"@"SEL$20" ("FND_ATTACHED_DOCUMENTS"."PK1_VALUE")) INDEX_RS_ASC(@"SEL$470E2127" "C"@"SEL$20" ("FND_DOCUMENTS"."DOCUMENT_ID")) INDEX_RS_ASC(@"SEL$470E2127" "DST"@"SEL$20" ("FND_DOCUMENTS_SHORT_TEXT"."MEDIA_ID")) INDEX(@"SEL$470E2127" "FND_DOCUMENT_CATEGORIES_TL"@"SEL$22" ("FND_DOCUMENT_CATEGORIES_TL"."CATEGORY_ID" "FND_DOCUMENT_CATEGORIES_TL"."LANGUAGE" "FND_DOCUMENT_CATEGORIES_TL"."ZD_EDITION_NAME")) LEADING(@"SEL$470E2127" "B"@"SEL$20" "C"@"SEL$20" "DST"@"SEL$20" "FND_DOCUMENT_CATEGORIES_TL"@"SEL$22") USE_NL(@"SEL$470E2127" "C"@"SEL$20") USE_NL(@"SEL$470E2127" "DST"@"SEL$20") USE_NL(@"SEL$470E2127" "FND_DOCUMENT_CATEGORIES_TL"@"SEL$22") INDEX_RS_ASC(@"SEL$E9CE8D49" "B"@"SEL$17" ("FND_ATTACHED_DOCUMENTS"."PK1_VALUE")) INDEX_RS_ASC(@"SEL$E9CE8D49" "C"@"SEL$17" ("FND_DOCUMENTS"."DOCUMENT_ID")) INDEX(@"SEL$E9CE8D49" "DST"@"SEL$17" ("FND_DOCUMENTS_SHORT_TEXT"."MEDIA_ID")) INDEX(@"SEL$E9CE8D49" "FND_DOCUMENT_CATEGORIES_TL"@"SEL$19" ("FND_DOCUMENT_CATEGORIES_TL"."CATEGORY_ID" "FND_DOCUMENT_CATEGORIES_TL"."LANGUAGE" "FND_DOCUMENT_CATEGORIES_TL"."ZD_EDITION_NAME")) LEADING(@"SEL$E9CE8D49" "B"@"SEL$17" "C"@"SEL$17" "DST"@"SEL$17" "FND_DOCUMENT_CATEGORIES_TL"@"SEL$19") USE_NL(@"SEL$E9CE8D49" "C"@"SEL$17") USE_NL(@"SEL$E9CE8D49" "DST"@"SEL$17") USE_NL(@"SEL$E9CE8D49" "FND_DOCUMENT_CATEGORIES_TL"@"SEL$19") NLJ_BATCHING(@"SEL$E9CE8D49" "FND_DOCUMENT_CATEGORIES_TL"@"SEL$19") INDEX_RS_ASC(@"SEL$16" "OL"@"SEL$16" ("OE_ORDER_LINES_ALL"."INVENTORY_ITEM_ID" "OE_ORDER_LINES_ALL"."SHIP_FROM_ORG_ID" "OE_ORDER_LINES_ALL"."CANCELLED_FLAG")) INDEX(@"SEL$16" "ML"@"SEL$16" ("XXOM_3LP_SYM_ORA_ORDER_LINES"."LINE_ID" "XXOM_3LP_SYM_ORA_ORDER_LINES"."ORG_ID" "XXOM_3LP_SYM_ORA_ORDER_LINES"."ASSEMBLY_TYPE")) LEADING(@"SEL$16" "OL"@"SEL$16" "ML"@"SEL$16") USE_NL(@"SEL$16" "ML"@"SEL$16") NLJ_BATCHING(@"SEL$16" "ML"@"SEL$16") INDEX_RS_ASC(@"SEL$A43813BD" "FND_LOOKUP_VALUES"@"SEL$15" ("FND_LOOKUP_VALUES"."LOOKUP_TYPE" "FND_LOOKUP_VALUES"."LOOKUP_CODE" "FND_LOOKUP_VALUES"."LANGUAGE")) INDEX_RS_ASC(@"SEL$285A8194" "LOT"@"SEL$11" ("HR_LOCATIONS_ALL_TL"."LOCATION_ID" "HR_LOCATIONS_ALL_TL"."LANGUAGE")) INDEX_RS_ASC(@"SEL$285A8194" "LOC"@"SEL$11" ("HR_LOCATIONS_ALL"."LOCATION_ID")) LEADING(@"SEL$285A8194" "LOT"@"SEL$11" "LOC"@"SEL$11") USE_NL(@"SEL$285A8194" "LOC"@"SEL$11") INDEX_RS_ASC(@"SEL$CF5359D5" "LOT"@"SEL$9" ("HR_LOCATIONS_ALL_TL"."LOCATION_ID" "HR_LOCATIONS_ALL_TL"."LANGUAGE")) INDEX_RS_ASC(@"SEL$CF5359D5" "LOC"@"SEL$9" ("HR_LOCATIONS_ALL"."LOCATION_ID")) LEADING(@"SEL$CF5359D5" "LOT"@"SEL$9" "LOC"@"SEL$9") USE_NL(@"SEL$CF5359D5" "LOC"@"SEL$9") INDEX_RS_ASC(@"SEL$7" "PL1"@"SEL$7" ("PO_LINES_ALL"."PO_HEADER_ID" "PO_LINES_ALL"."VENDOR_PRODUCT_NUM")) INDEX_RS_ASC(@"SEL$ABDE6DFF" "PER_ALL_PEOPLE_F"@"SEL$6" ("PER_ALL_PEOPLE_F"."PERSON_ID" "PER_ALL_PEOPLE_F"."EFFECTIVE_START_DATE" "PER_ALL_PEOPLE_F"."EFFECTIVE_END_DATE")) INDEX_RS_ASC(@"SEL$4" "MSI"@"SEL$4" ("MTL_SYSTEM_ITEMS_B"."INVENTORY_ITEM_ID" "MTL_SYSTEM_ITEMS_B"."ORGANIZATION_ID")) INDEX_RS_ASC(@"SEL$3" "MSI"@"SEL$3" ("MTL_SYSTEM_ITEMS_B"."INVENTORY_ITEM_ID" "MTL_SYSTEM_ITEMS_B"."ORGANIZATION_ID")) INDEX(@"SEL$2" "PO_RELEASES_ALL"@"SEL$2" ("PO_RELEASES_ALL"."PO_HEADER_ID" "PO_RELEASES_ALL"."RELEASE_NUM")) END_OUTLINE_DATA */ Predicate Information (identified by operation id): --------------------------------------------------- 3 - access("PO_HEADER_ID"=:B1) 5 - access("MSI"."INVENTORY_ITEM_ID"=:B1 AND "MSI"."ORGANIZATION_ID"=:B2) 7 - access("MSI"."INVENTORY_ITEM_ID"=:B1 AND "MSI"."ORGANIZATION_ID"=:B2) 9 - access("PERSON_ID"=:B1 AND "EFFECTIVE_END_DATE">=TRUNC(SYSDATE@!) AND "EFFECTIVE_START_DATE"<=TRUNC(SYSDATE@!)) filter("EFFECTIVE_END_DATE">=TRUNC(SYSDATE@!)) 12 - access("PL1"."PO_HEADER_ID"=:B1) 15 - access("LOT"."LOCATION_ID"=:B1 AND "LOT"."LANGUAGE"=USERENV('LANG')) 16 - filter(NVL("LOC"."BUSINESS_GROUP_ID",NVL("HR_GENERAL"."GET_BUSINESS_GROUP_ID"(),(-99)))=NVL("HR_GENERAL"."GET_BUSINESS_GROUP_ID"(),NVL("LOC"."BUSINESS_GROUP_ID",(-99)))) 17 - access("LOC"."LOCATION_ID"=:B1) 20 - access("LOT"."LOCATION_ID"=:B1 AND "LOT"."LANGUAGE"=USERENV('LANG')) 21 - filter(NVL("LOC"."BUSINESS_GROUP_ID",NVL("HR_GENERAL"."GET_BUSINESS_GROUP_ID"(),(-99)))=NVL("HR_GENERAL"."GET_BUSINESS_GROUP_ID"(),NVL("LOC"."BUSINESS_GROUP_ID",(-99)))) 22 - access("LOC"."LOCATION_ID"=:B1) 23 - filter(("VIEW_APPLICATION_ID"=201 AND NVL("ZD_EDITION_NAME",'ORA$BASE')='SET2' AND "SECURITY_GROUP_ID"="FND_GLOBAL"."LOOKUP_SECURITY_GROUP"("LOOKUP_TYPE","VIEW_APPLICATION_ID"))) 24 - access("LOOKUP_TYPE"='ACCEPTANCE TYPE' AND "LOOKUP_CODE"=:B1 AND "LANGUAGE"=USERENV('LANG')) 30 - access("OL"."INVENTORY_ITEM_ID"=:B1 AND "OL"."SHIP_FROM_ORG_ID"=:B2) 31 - access("ML"."LINE_ID"="OL"."LINE_ID" AND "ML"."ORG_ID"="OL"."ORG_ID") 32 - filter("MODEL_STRING" IS NOT NULL) 34 - filter(:INCLUDEATTACHEMENTDATA='Yes') 40 - access("B"."PK1_VALUE"=TO_CHAR(:B1)) 41 - filter("C"."DATATYPE_ID"=1) 42 - access("C"."DOCUMENT_ID"="B"."DOCUMENT_ID") 43 - access("DST"."MEDIA_ID"="C"."MEDIA_ID") 44 - access("C"."CATEGORY_ID"="CATEGORY_ID" AND "LANGUAGE"='US' AND "ZD_EDITION_NAME"='ORA$BASE') 47 - filter(:INCLUDEATTACHEMENTDATA='Yes') 52 - access("B"."PK1_VALUE"=TO_CHAR(:B1)) 53 - filter("C"."DATATYPE_ID"=1) 54 - access("C"."DOCUMENT_ID"="B"."DOCUMENT_ID") 56 - access("DST"."MEDIA_ID"="C"."MEDIA_ID") 57 - access("C"."CATEGORY_ID"="CATEGORY_ID" AND "LANGUAGE"='US' AND "ZD_EDITION_NAME"='ORA$BASE') 60 - filter("PLLA"."PROMISED_DATE" IS NOT NULL) 61 - access("PLLA"."LINE_LOCATION_ID"=:B1) 63 - access("LOOKUP_TYPE"='RCV_ROUTING_HEADERS' AND "VIEW_APPLICATION_ID"=0 AND "SECURITY_GROUP_ID"=0 AND "LANGUAGE"=USERENV('LANG') AND "ZD_EDITION_NAME"='SET2') filter(("ZD_EDITION_NAME"='SET2' AND TO_NUMBER("LOOKUP_CODE")=:B1 AND "LANGUAGE"=USERENV('LANG') AND "SECURITY_GROUP_ID"=0)) 65 - access("PERSON_ID"=:B1 AND "EFFECTIVE_END_DATE">=TRUNC(SYSDATE@!) AND "EFFECTIVE_START_DATE"<=TRUNC(SYSDATE@!)) filter("EFFECTIVE_END_DATE">=TRUNC(SYSDATE@!)) 68 - access("LOT"."LOCATION_ID"=:B1 AND "LOT"."LANGUAGE"=USERENV('LANG')) 69 - filter(NVL("LOC"."BUSINESS_GROUP_ID",NVL("HR_GENERAL"."GET_BUSINESS_GROUP_ID"(),(-99)))=NVL("HR_GENERAL"."GET_BUSINESS_GROUP_ID"(),NVL("LOC"."BUSINESS_GROUP_ID",(-99)))) 70 - access("LOC"."LOCATION_ID"=:B1) 72 - access("LOCATION_ID"=:B1) 74 - access("CODE_COMBINATION_ID"=:B1) 76 - access("CODE_COMBINATION_ID"=:B1) 77 - filter(ROWNUM<2) 81 - access("CATEGORY_SET_ID"=1100000041 AND "ZD_EDITION_NAME"='ORA$BASE') 82 - access("MIC"."ORGANIZATION_ID"=:B1 AND "MIC"."INVENTORY_ITEM_ID"=:B2 AND "MIC"."CATEGORY_SET_ID"=1100000041) 83 - access("MIC"."CATEGORY_ID"="CATEGORY_ID" AND "ZD_EDITION_NAME"='ORA$BASE') 85 - filter(ROWNUM<2) 88 - access("MIC"."ORGANIZATION_ID"=85 AND "MIC"."INVENTORY_ITEM_ID"=:B1 AND "MIC"."CATEGORY_SET_ID"=1100000021) 89 - access("MIC"."CATEGORY_ID"="CATEGORY_ID" AND "ZD_EDITION_NAME"='ORA$BASE') 91 - filter(ROWNUM<2) 92 - filter(NVL("ZD_EDITION_NAME",'ORA$BASE')='SET2') 93 - access("LOOKUP_TYPE"='INVOICE MATCH OPTION' AND "LOOKUP_CODE"=:B1 AND "LANGUAGE"='US') 95 - filter(TRUNC(:B1)>=TRUNC(SYSDATE@!)) 96 - access("BCE"."CALENDAR_CODE"=:B1) filter((TRUNC(INTERNAL_FUNCTION("BCE"."EXCEPTION_DATE"))>=TRUNC(SYSDATE@!) AND TRUNC(INTERNAL_FUNCTION("BCE"."EXCEPTION_DATE"))<=TRUNC(:B1))) 98 - filter(TRUNC(SYSDATE@!)>=TRUNC(:B1)) 99 - access("BCE"."CALENDAR_CODE"=:B1) filter((TRUNC(INTERNAL_FUNCTION("BCE"."EXCEPTION_DATE"))<=TRUNC(SYSDATE@!) AND TRUNC(INTERNAL_FUNCTION("BCE"."EXCEPTION_DATE"))>=TRUNC(:B1))) 101 - filter(TRUNC(:B1)>=TRUNC(SYSDATE@!)) 102 - access("BCE"."CALENDAR_CODE"=:B1) filter((TRUNC(INTERNAL_FUNCTION("BCE"."EXCEPTION_DATE"))>=TRUNC(SYSDATE@!) AND TRUNC(INTERNAL_FUNCTION("BCE"."EXCEPTION_DATE"))<=TRUNC(:B1))) 104 - filter(TRUNC(SYSDATE@!)>=TRUNC(:B1)) 105 - access("BCE"."CALENDAR_CODE"=:B1) filter((TRUNC(INTERNAL_FUNCTION("BCE"."EXCEPTION_DATE"))<=TRUNC(SYSDATE@!) AND TRUNC(INTERNAL_FUNCTION("BCE"."EXCEPTION_DATE"))>=TRUNC(:B1))) 106 - filter(ROWNUM<2) 110 - access("AAG"."ORGANIZATION_ID"=:B1 AND "AAG"."ASSIGNMENT_GROUP_NAME"='SG4 PLANNING ABC') 112 - access("MAA"."ASSIGNMENT_GROUP_ID"="AAG"."ASSIGNMENT_GROUP_ID" AND "MAA"."INVENTORY_ITEM_ID"=:B1) 113 - filter("MAC"."ORGANIZATION_ID"=:B1) 114 - access("MAC"."ABC_CLASS_ID"="MAA"."ABC_CLASS_ID") 116 - access("MSI"."INVENTORY_ITEM_ID"=:B1 AND "MSI"."ORGANIZATION_ID"=:B2) 118 - filter(("RT"."PO_LINE_ID"=:B1 AND "RT"."PO_HEADER_ID"=:B2 AND "RT"."TRANSACTION_TYPE"='RECEIVE' AND NVL("RT"."PO_DISTRIBUTION_ID",(-1))=NVL(:B3,(-1)))) 119 - access("RT"."PO_LINE_LOCATION_ID"=:B1) 121 - filter(("RT"."PO_LINE_ID"=:B1 AND "RT"."PO_HEADER_ID"=:B2 AND "RT"."TRANSACTION_TYPE"='RECEIVE')) 122 - access("RT"."PO_LINE_LOCATION_ID"=:B1) 124 - filter(NVL("PD"."DISTRIBUTION_NUM",1)=NVL(,1)) 141 - filter(("PH"."ORG_ID"=9082 AND ((-1)=:BUYER OR "PH"."AGENT_ID"=:BUYER) AND (SYS_OP_C2C(COALESCE("PH"."CLOSED_CODE",'OPEN'))=U'OPEN' OR SYS_OP_C2C(COALESCE("PH"."CLOSED_CODE",'OPEN'))=U'CLOSED'))) 142 - access("PH"."SYS_NC00152$">=TO_DATE(' 2022-10-01 00:00:00', 'syyyy-mm-dd hh24:mi:ss') AND "PH"."SYS_NC00152$"<=TO_DATE(' 2023-06-15 00:00:00', 'syyyy-mm-dd hh24:mi:ss')) 143 - filter("PL"."ORG_ID"=9082) 144 - access("PH"."PO_HEADER_ID"="PL"."PO_HEADER_ID") 146 - access("LINE_TYPE_ID"="PL"."LINE_TYPE_ID" AND "LANGUAGE"='US' AND "ZD_EDITION_NAME"='ORA$BASE') 148 - access("PH"."VENDOR_ID"="VENDOR_ID") 149 - filter(("PLL"."ORG_ID"=9082 AND INTERNAL_FUNCTION("PLL"."SHIP_TO_ORGANIZATION_ID") AND "PL"."PO_LINE_ID"="PLL"."PO_LINE_ID")) 150 - access("PL"."PO_HEADER_ID"="PLL"."PO_HEADER_ID") filter("PH"."PO_HEADER_ID"="PLL"."PO_HEADER_ID") 152 - access("MP"."ORGANIZATION_ID"="PLL"."SHIP_TO_ORGANIZATION_ID") filter(("MP"."ORGANIZATION_ID"=9083 OR "MP"."ORGANIZATION_ID"=12389 OR "MP"."ORGANIZATION_ID"=12390 OR "MP"."ORGANIZATION_ID"=12469 OR "MP"."ORGANIZATION_ID"=12549)) 154 - access("PH"."VENDOR_SITE_ID"="PVS"."VENDOR_SITE_ID") 155 - filter(("ODS"."PO_HEADER_ID" IS NOT NULL AND "ODS"."PO_LINE_ID" IS NOT NULL AND "PLL"."PO_HEADER_ID"="ODS"."PO_HEADER_ID" AND "PLL"."PO_LINE_ID"="ODS"."PO_LINE_ID")) 156 - access("PLL"."LINE_LOCATION_ID"="ODS"."LINE_LOCATION_ID") filter("ODS"."LINE_LOCATION_ID" IS NOT NULL) 157 - filter(("PLL"."PO_HEADER_ID"="PD"."PO_HEADER_ID" AND "PLL"."LINE_LOCATION_ID"="PD"."LINE_LOCATION_ID")) 158 - access("PLL"."PO_LINE_ID"="PD"."PO_LINE_ID") 160 - access("PD"."REQ_DISTRIBUTION_ID"="PRDA"."DISTRIBUTION_ID") 162 - access("POA"."PO_HEADER_ID"="PH"."PO_HEADER_ID") 163 - filter("OEL"."CANCELLED_FLAG"<>'Y') 164 - access("OEL"."LINE_ID"="ODS"."LINE_ID") 165 - access("OEH"."HEADER_ID"="OEL"."HEADER_ID") 167 - access("PRDA"."REQUISITION_LINE_ID"="PRLA"."REQUISITION_LINE_ID") 169 - access("PRLA"."REQUISITION_HEADER_ID"="PRHA"."REQUISITION_HEADER_ID") 170 - access("ZXL"."TRX_LINE_ID"="PLL"."LINE_LOCATION_ID" AND "ZXL"."TRX_ID"="PLL"."PO_HEADER_ID") 171 - filter(("ZXD"."ENTITY_CODE"='PURCHASE_ORDER' AND "ZXD"."TRX_LINE_ID"="ZXL"."TRX_LINE_ID")) 172 - access("ZXD"."TRX_ID"="ZXL"."TRX_ID") 174 - filter(("PD2"."PO_LINE_ID"=:B1 AND "PD2"."PO_HEADER_ID"=:B2)) 175 - access("PD2"."LINE_LOCATION_ID"=:B1) Column Projection Information (identified by operation id): ----------------------------------------------------------- 1 - (#keys=0) MAX("RELEASE_NUM")[22] 2 - "RELEASE_NUM"[NUMBER,22] 3 - "RELEASE_NUM"[NUMBER,22] 4 - "MSI"."SEGMENT1"[VARCHAR2,40] 5 - "MSI".ROWID[ROWID,10] 6 - "MSI"."DESCRIPTION"[VARCHAR2,240] 7 - "MSI".ROWID[ROWID,10] 8 - "FULL_NAME"[VARCHAR2,240] 9 - "PER_ALL_PEOPLE_F".ROWID[ROWID,10] 10 - (#keys=0) SUM("PL1"."QUANTITY"*"PL1"."UNIT_PRICE")[22] 11 - "PL1"."UNIT_PRICE"[NUMBER,22], "PL1"."QUANTITY"[NUMBER,22] 12 - "PL1".ROWID[ROWID,10] 13 - "LOT"."LOCATION_CODE"[VARCHAR2,60] 14 - "LOT"."LOCATION_CODE"[VARCHAR2,60] 15 - "LOT".ROWID[ROWID,10] 17 - "LOC".ROWID[ROWID,10] 18 - "LOT"."LOCATION_CODE"[VARCHAR2,60] 19 - "LOT"."LOCATION_CODE"[VARCHAR2,60] 20 - "LOT".ROWID[ROWID,10] 22 - "LOC".ROWID[ROWID,10] 23 - "MEANING"[VARCHAR2,80] 24 - "FND_LOOKUP_VALUES".ROWID[ROWID,10], "LOOKUP_TYPE"[VARCHAR2,30] 25 - (#keys=1) FIRST_VALUE("MODEL_STRING") OVER ( PARTITION BY "OL"."INVENTORY_ITEM_ID" ORDER BY "OL"."CREATION_DATE" RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW )[240] 26 - (#keys=3) "OL"."INVENTORY_ITEM_ID"[NUMBER,22], "OL"."CREATION_DATE"[DATE,7], "MODEL_STRING"[VARCHAR2,240], "OL".ROWID[ROWID,10], "OL"."LINE_ID"[NUMBER,22], "ML"."LINE_ID"[NUMBER,22], "ML"."ORG_ID"[NUMBER,22], "OL"."SHIP_FROM_ORG_ID"[NUMBER,22], "OL"."ORG_ID"[NUMBER,22], "ML".ROWID[ROWID,10], FIRST_VALUE("MODEL_STRING") OVER ( PARTITION BY "OL"."INVENTORY_ITEM_ID" ORDER BY "OL"."CREATION_DATE" RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW )[240] 27 - "OL".ROWID[ROWID,10], "OL"."LINE_ID"[NUMBER,22], "OL"."CREATION_DATE"[DATE,7], "OL"."INVENTORY_ITEM_ID"[NUMBER,22], "OL"."SHIP_FROM_ORG_ID"[NUMBER,22], "OL"."ORG_ID"[NUMBER,22], "ML".ROWID[ROWID,10], "ML"."ORG_ID"[NUMBER,22], "MODEL_STRING"[VARCHAR2,240], "ML"."LINE_ID"[NUMBER,22] 28 - "OL".ROWID[ROWID,10], "OL"."LINE_ID"[NUMBER,22], "OL"."CREATION_DATE"[DATE,7], "OL"."INVENTORY_ITEM_ID"[NUMBER,22], "OL"."SHIP_FROM_ORG_ID"[NUMBER,22], "OL"."ORG_ID"[NUMBER,22], "ML".ROWID[ROWID,10], "ML"."LINE_ID"[NUMBER,22], "ML"."ORG_ID"[NUMBER,22] 29 - "OL".ROWID[ROWID,10], "OL"."LINE_ID"[NUMBER,22], "OL"."CREATION_DATE"[DATE,7], "OL"."INVENTORY_ITEM_ID"[NUMBER,22], "OL"."SHIP_FROM_ORG_ID"[NUMBER,22], "OL"."ORG_ID"[NUMBER,22] 30 - "OL".ROWID[ROWID,10], "OL"."INVENTORY_ITEM_ID"[NUMBER,22], "OL"."SHIP_FROM_ORG_ID"[NUMBER,22] 31 - "ML".ROWID[ROWID,10], "ML"."LINE_ID"[NUMBER,22], "ML"."ORG_ID"[NUMBER,22] 32 - "ML".ROWID[ROWID,10], "MODEL_STRING"[VARCHAR2,240] 33 - (#keys=0) unknown-uag()[64] 34 - "USER_NAME"[VARCHAR2,255] 35 - "USER_NAME"[VARCHAR2,255] 36 - "FND_DOCUMENT_CATEGORIES_TL".ROWID[ROWID,10] 37 - "C"."CATEGORY_ID"[NUMBER,22] 38 - "C"."CATEGORY_ID"[NUMBER,22], "C"."MEDIA_ID"[NUMBER,22] 39 - "B"."DOCUMENT_ID"[NUMBER,22] 40 - "B".ROWID[ROWID,10] 41 - "C"."CATEGORY_ID"[NUMBER,22], "C"."MEDIA_ID"[NUMBER,22] 42 - "C".ROWID[ROWID,10] 44 - "FND_DOCUMENT_CATEGORIES_TL".ROWID[ROWID,10] 45 - "USER_NAME"[VARCHAR2,255] 46 - (#keys=0) unknown-uag()[64] 47 - "DST"."SHORT_TEXT"[VARCHAR2,4000] 48 - "DST"."SHORT_TEXT"[VARCHAR2,4000] 49 - "C"."CATEGORY_ID"[NUMBER,22], "DST"."SHORT_TEXT"[VARCHAR2,4000] 50 - "C"."CATEGORY_ID"[NUMBER,22], "C"."MEDIA_ID"[NUMBER,22] 51 - "B"."DOCUMENT_ID"[NUMBER,22] 52 - "B".ROWID[ROWID,10] 53 - "C"."CATEGORY_ID"[NUMBER,22], "C"."MEDIA_ID"[NUMBER,22] 54 - "C".ROWID[ROWID,10] 55 - "DST"."SHORT_TEXT"[VARCHAR2,4000] 56 - "DST".ROWID[ROWID,10] 58 - (#keys=1) FIRST_VALUE("PLLA"."PROMISED_DATE") OVER ( ORDER BY "REVISION_NUM" RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW )[7] 59 - (#keys=2) "REVISION_NUM"[NUMBER,22], "PLLA"."PROMISED_DATE"[DATE,7], "PLLA".ROWID[ROWID,10], "PLLA"."LINE_LOCATION_ID"[NUMBER,22], FIRST_VALUE("PLLA"."PROMISED_DATE") OVER ( ORDER BY "REVISION_NUM" RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW )[7] 60 - "PLLA".ROWID[ROWID,10], "PLLA"."LINE_LOCATION_ID"[NUMBER,22], "PLLA"."PROMISED_DATE"[DATE,7], "REVISION_NUM"[NUMBER,22] 61 - "PLLA".ROWID[ROWID,10], "PLLA"."LINE_LOCATION_ID"[NUMBER,22], "REVISION_NUM"[NUMBER,22] 62 - "MEANING"[VARCHAR2,80] 63 - "FND_LOOKUP_VALUES".ROWID[ROWID,10] 64 - "FULL_NAME"[VARCHAR2,240] 65 - "PER_ALL_PEOPLE_F".ROWID[ROWID,10] 66 - "LOT"."LOCATION_CODE"[VARCHAR2,60] 67 - "LOT"."LOCATION_CODE"[VARCHAR2,60] 68 - "LOT".ROWID[ROWID,10] 70 - "LOC".ROWID[ROWID,10] 71 - "ADDRESS1"[VARCHAR2,240], "CITY"[VARCHAR2,60] 72 - "HZ_LOCATIONS".ROWID[ROWID,10] 73 - "CHART_OF_ACCOUNTS_ID"[NUMBER,22], "SEGMENT1"[VARCHAR2,25], "SEGMENT2"[VARCHAR2,25], "SEGMENT3"[VARCHAR2,25], "SEGMENT4"[VARCHAR2,25], "SEGMENT5"[VARCHAR2,25], "SEGMENT6"[VARCHAR2,25], "SEGMENT7"[VARCHAR2,25], "SEGMENT8"[VARCHAR2,25] 74 - "GL_CODE_COMBINATIONS".ROWID[ROWID,10] 75 - "CHART_OF_ACCOUNTS_ID"[NUMBER,22], "SEGMENT1"[VARCHAR2,25], "SEGMENT2"[VARCHAR2,25], "SEGMENT3"[VARCHAR2,25], "SEGMENT4"[VARCHAR2,25], "SEGMENT5"[VARCHAR2,25], "SEGMENT6"[VARCHAR2,25], "SEGMENT7"[VARCHAR2,25], "SEGMENT8"[VARCHAR2,25] 76 - "GL_CODE_COMBINATIONS".ROWID[ROWID,10] 77 - "SEGMENT2"[VARCHAR2,40] 78 - "SEGMENT2"[VARCHAR2,40] 79 - "MTL_CATEGORIES_B".ROWID[ROWID,10] 80 - "MIC"."CATEGORY_ID"[NUMBER,22] 82 - "MIC"."CATEGORY_ID"[NUMBER,22] 83 - "MTL_CATEGORIES_B".ROWID[ROWID,10] 84 - "SEGMENT2"[VARCHAR2,40] 85 - "SEGMENT1"[VARCHAR2,40] 86 - "SEGMENT1"[VARCHAR2,40] 87 - "MTL_CATEGORIES_B".ROWID[ROWID,10] 88 - "MIC"."CATEGORY_ID"[NUMBER,22] 89 - "MTL_CATEGORIES_B".ROWID[ROWID,10] 90 - "SEGMENT1"[VARCHAR2,40] 91 - "MEANING"[VARCHAR2,80] 92 - "MEANING"[VARCHAR2,80] 93 - "FND_LOOKUP_VALUES".ROWID[ROWID,10] 94 - (#keys=0) COUNT(*)[22] 97 - (#keys=0) COUNT(*)[22] 100 - (#keys=0) COUNT(*)[22] 103 - (#keys=0) COUNT(*)[22] 106 - "MAC"."ABC_CLASS_NAME"[VARCHAR2,40] 107 - "MAC"."ABC_CLASS_NAME"[VARCHAR2,40] 108 - "MAA"."ABC_CLASS_ID"[NUMBER,22] 109 - "AAG"."ASSIGNMENT_GROUP_ID"[NUMBER,22] 110 - "AAG".ROWID[ROWID,10] 111 - "MAA"."ABC_CLASS_ID"[NUMBER,22] 112 - "MAA".ROWID[ROWID,10] 113 - "MAC"."ABC_CLASS_NAME"[VARCHAR2,40] 114 - "MAC".ROWID[ROWID,10] 115 - "MSI"."PLANNER_CODE"[VARCHAR2,10] 116 - "MSI".ROWID[ROWID,10] 117 - (#keys=0) MAX(TRUNC(INTERNAL_FUNCTION("TRANSACTION_DATE")))[7] 118 - "TRANSACTION_DATE"[DATE,7] 119 - "RT".ROWID[ROWID,10] 120 - (#keys=0) MAX(TRUNC(INTERNAL_FUNCTION("TRANSACTION_DATE")))[7] 121 - "TRANSACTION_DATE"[DATE,7] 122 - "RT".ROWID[ROWID,10] 123 - (#keys=3) "PH"."SEGMENT1"[VARCHAR2,20], "PL"."LINE_NUM"[NUMBER,22], "PLL"."SHIPMENT_NUM"[NUMBER,22], "PH"."SYS_NC00152$"[DATE,7], "PH"."TYPE_LOOKUP_CODE"[VARCHAR2,25], "PH"."AUTHORIZATION_STATUS"[VARCHAR2,25], "PLL"."CLOSED_CODE"[VARCHAR2,30], [22], [40], COALESCE("PL"."ITEM_DESCRIPTION",)[240], "PLL"."QUANTITY"[NUMBER,22], "PLL"."QUANTITY_RECEIVED"[NUMBER,22], "VENDOR_NAME"[VARCHAR2,240], "PVS"."VENDOR_SITE_CODE"[VARCHAR2,15], [240], "PH"."REVISION_NUM"[NUMBER,22], "PH"."COMMENTS"[VARCHAR2,240], "PH"."CURRENCY_CODE"[VARCHAR2,15], "PL"."UNIT_PRICE"[NUMBER,22], "PL"."UNIT_PRICE"*"PLL"."QUANTITY"[22], [22], ROUND(NVL("PH"."RATE",1)*"PL"."UNIT_PRICE",5)[22], [60], [60], "POA"."ACTION"[VARCHAR2,240], "POA"."ACCEPTED_FLAG"[VARCHAR2,1], [80], "PL"."ITEM_REVISION"[VARCHAR2,3], "PL"."NOTE_TO_VENDOR"[VARCHAR2,480], "PLL"."NOTE_TO_RECEIVER"[VARCHAR2,480], "LINE_TYPE"[VARCHAR2,25], "PL"."UNIT_MEAS_LOOKUP_CODE"[VARCHAR2,25], ROUND(NVL("PH"."RATE",1)*"PL"."UNIT_PRICE",5)*"PLL"."QUANTITY"[22], [240], "PLL"."QUANTITY_CANCELLED"[NUMBER,22], CAST(TO_CLOB(CASE WHEN :INCLUDEATTACHEMENTDATA='No' THEN NULL ELSE END ) AS VARCHAR2(4000))[4000], CAST(TO_CLOB(CASE :INCLUDEATTACHEMENTDATA WHEN 'No' THEN NULL ELSE REPLACE(REPLACE(,' ','; '),' ','; ') END ) AS VARCHAR2(4000))[4000], TRUNC(INTERNAL_FUNCTION("PLL"."PROMISED_DATE"))[8], TRUNC(INTERNAL_FUNCTION("PLL"."NEED_BY_DATE"))[8], TRUNC()[8], CASE WHEN ("PLL"."INSPECTION_REQUIRED_FLAG"='N' AND "PLL"."RECEIPT_REQUIRED_FLAG"='N') THEN '2WAY' WHEN ("PLL"."INSPECTION_REQUIRED_FLAG"='N' AND "PLL"."RECEIPT_REQUIRED_FLAG"='Y') THEN '3WAY' WHEN ("PLL"."INSPECTION_REQUIRED_FLAG" IS NULL OR "PLL"."RECEIPT_REQUIRED_FLAG" IS NULL) THEN '3WAY' ELSE '4WAY' END [4], "PLL"."ATTRIBUTE2"[VARCHAR2,150], "PLL"."ATTRIBUTE3"[VARCHAR2,150], "PLL"."ATTRIBUTE1"[VARCHAR2,150], [80], [240], COALESCE(,)[301], "PD"."DESTINATION_SUBINVENTORY"[VARCHAR2,10], "PRHA"."SEGMENT1"[VARCHAR2,20], "PRLA"."LINE_NUM"[NUMBER,22], "OEH"."ORDER_NUMBER"[NUMBER,22], "OEL"."LINE_NUMBER"[NUMBER,22], [207], [207], "PD"."ATTRIBUTE15"[VARCHAR2,150], "PL"."ATTRIBUTE1"[VARCHAR2,150], "PL"."ATTRIBUTE4"[VARCHAR2,150], "MP"."ORGANIZATION_CODE"[VARCHAR2,3], COALESCE("PH"."CLOSED_CODE",'OPEN')[25], COALESCE("PL"."CLOSED_CODE",'OPEN')[25], "PLL"."QUANTITY"-"PLL"."QUANTITY_RECEIVED"[22], [40], [40], [80], CASE WHEN COALESCE("PLL"."CLOSED_CODE",'OPEN')<>'OPEN' THEN 'CLOSED' WHEN TRUNC(INTERNAL_FUNCTION("PLL"."PROMISED_DATE"))TRUNC(SYSDATE@!))) THEN 1 ELSE 0 END -CASE WHEN ((TO_CHAR(INTERNAL_FUNCTION("PLL"."PROMISED_DATE"),'DY','nls_date_language=''ENGLISH''')='SAT') AND (TRUNC(INTERNAL_FUNCTION("PLL"."PROMISED_DATE"))<>TRUNC(SYSDATE@!))) THEN 1 ELSE 0 END -+>=0 AND TRUNC(INTERNAL_FUNCTION("PLL"."PROMISED_DATE"))-TRUNC(SYSDATE@!)-(TRUNC(INTERNAL_FUNCTION("PLL"."PRO MISED_DATE"),'fmd')-TRUNC(SYSDATE@!,'fmd'))/7*2-CASE WHEN ((TO_CHAR(TRUNC(SYSDATE@!),'DY','nls_date_language=''ENGLISH''')='SUN') AND (TRUNC(INTERNAL_FUNCTION("PLL"."PROMISED_DATE"))<>TRUNC(SYSDATE@!))) THEN 1 ELSE 0 END -CASE WHEN ((TO_CHAR(INTERNAL_FUNCTION("PLL"."PROMISED_DATE"),'DY','nls_date_language=''ENGLISH''')='SAT') AND (TRUNC(INTERNAL_FUNCTION("PLL"."PROMISED_DATE"))<>TRUNC(SYSDATE@!))) THEN 1 ELSE 0 END -+<=9) THEN 'IN-TRANSIT PO' WHEN ("PLL"."PROMISED_DATE" IS NULL AND TRUNC(INTERNAL_FUNCTION("PLL"."NEED_BY_DATE"))-TRUNC(SYSDATE@!)-(TRUNC(INTERNAL_FUNCTION("PLL"."NEED_BY_DATE"),'fmd')-TRUNC(SYSDATE@!,'fmd'))/7*2-CASE WHEN ((TO_CHAR(TRUNC(SYSDATE@!),'DY','nls_date_language=''ENGLISH''')='SUN') AND (TRUNC(INTERNAL_FUNCTION("PLL"."NEED_BY_DATE"))<>TRUNC(SYSDATE@!))) THEN 1 ELSE 0 END -CASE WHEN ((TO_CHAR(INTERNAL_FUNCTION("PLL"."NEED_BY_DATE"),'DY','nls_date_lang 124 - "PH"."PO_HEADER_ID"[NUMBER,22], "PH"."AGENT_ID"[NUMBER,22], "PH"."TYPE_LOOKUP_CODE"[VARCHAR2,25], "PH"."SEGMENT1"[VARCHAR2,20], "PH"."SHIP_TO_LOCATION_ID"[NUMBER,22], "PH"."BILL_TO_LOCATION_ID"[NUMBER,22], "PH"."CURRENCY_CODE"[VARCHAR2,15], "PH"."RATE"[NUMBER,22], "PH"."AUTHORIZATION_STATUS"[VARCHAR2,25], "PH"."REVISION_NUM"[NUMBER,22], "PH"."COMMENTS"[VARCHAR2,240], "PH"."CLOSED_CODE"[VARCHAR2,25], "PH"."SYS_NC00152$"[DATE,7], "PL"."PO_LINE_ID"[NUMBER,22], "PL"."PO_HEADER_ID"[NUMBER,22], "PL"."LINE_NUM"[NUMBER,22], "PL"."ITEM_ID"[NUMBER,22], "PL"."ITEM_REVISION"[VARCHAR2,3], "PL"."ITEM_DESCRIPTION"[VARCHAR2,240], "PL"."UNIT_MEAS_LOOKUP_CODE"[VARCHAR2,25], "PL"."UNIT_PRICE"[NUMBER,22], "PL"."NOTE_TO_VENDOR"[VARCHAR2,480], "PL"."ATTRIBUTE1"[VARCHAR2,150], "PL"."ATTRIBUTE4"[VARCHAR2,150], "PL"."CLOSED_CODE"[VARCHAR2,25], "LINE_TYPE"[VARCHAR2,25], "VENDOR_NAME"[VARCHAR2,240], "PLL"."LINE_LOCATION_ID"[NUMBER,22], "PLL"."PO_HEADER_ID"[NUMBER,22], "PLL"."PO_LINE_ID"[NUMBER,22], "PLL"."QUANTITY"[NUMBER,22], "PLL"."QUANTITY_RECEIVED"[NUMBER,22], "PLL"."QUANTITY_CANCELLED"[NUMBER,22], "PLL"."NEED_BY_DATE"[DATE,7], "PLL"."PROMISED_DATE"[DATE,7], "PLL"."ATTRIBUTE1"[VARCHAR2,150], "PLL"."ATTRIBUTE2"[VARCHAR2,150], "PLL"."ATTRIBUTE3"[VARCHAR2,150], "PLL"."ATTRIBUTE5"[VARCHAR2,150], "PLL"."ATTRIBUTE6"[VARCHAR2,150], "PLL"."ATTRIBUTE7"[VARCHAR2,150], "PLL"."INSPECTION_REQUIRED_FLAG"[VARCHAR2,1], "PLL"."RECEIPT_REQUIRED_FLAG"[VARCHAR2,1], "PLL"."SHIP_TO_ORGANIZATION_ID"[NUMBER,22], "PLL"."SHIPMENT_NUM"[NUMBER,22], "PLL"."CLOSED_CODE"[VARCHAR2,30], "PLL"."RECEIVING_ROUTING_ID"[NUMBER,22], "PLL"."MATCH_OPTION"[VARCHAR2,25], "PLL"."NOTE_TO_RECEIVER"[VARCHAR2,480], "MP"."ORGANIZATION_CODE"[VARCHAR2,3], "MP"."CALENDAR_CODE"[VARCHAR2,10], "PVS"."VENDOR_SITE_CODE"[VARCHAR2,15], "PD"."PO_DISTRIBUTION_ID"[NUMBER,22], "PD"."CODE_COMBINATION_ID"[NUMBER,22], "PD"."DELIVER_TO_LOCATION_ID"[NUMBER,22], "PD"."DELIVER_TO_PERSON_ID"[NUMBER,22], "PD"."DESTINATION_SUBINVENTORY"[VARCHAR2,10], "PD"."ATTRIBUTE15"[VARCHAR2,150], "PD"."ACCRUAL_ACCOUNT_ID"[NUMBER,22], "POA"."ACTION"[VARCHAR2,240], "POA"."ACTION_DATE"[DATE,7], "POA"."ACCEPTED_FLAG"[VARCHAR2,1], "POA"."ACCEPTANCE_LOOKUP_CODE"[VARCHAR2,25], "OEL"."LINE_NUMBER"[NUMBER,22], "OEH"."ORDER_NUMBER"[NUMBER,22], "PRLA"."LINE_NUM"[NUMBER,22], "PRHA"."SEGMENT1"[VARCHAR2,20], "ZXD"."INPUT_TAX_CLASSIFICATION_CODE"[VARCHAR2,50] 125 - "PH"."PO_HEADER_ID"[NUMBER,22], "PH"."AGENT_ID"[NUMBER,22], "PH"."TYPE_LOOKUP_CODE"[VARCHAR2,25], "PH"."SEGMENT1"[VARCHAR2,20], "PH"."SHIP_TO_LOCATION_ID"[NUMBER,22], "PH"."BILL_TO_LOCATION_ID"[NUMBER,22], "PH"."CURRENCY_CODE"[VARCHAR2,15], "PH"."RATE"[NUMBER,22], "PH"."AUTHORIZATION_STATUS"[VARCHAR2,25], "PH"."REVISION_NUM"[NUMBER,22], "PH"."COMMENTS"[VARCHAR2,240], "PH"."CLOSED_CODE"[VARCHAR2,25], "PH"."SYS_NC00152$"[DATE,7], "PL"."PO_LINE_ID"[NUMBER,22], "PL"."PO_HEADER_ID"[NUMBER,22], "PL"."LINE_NUM"[NUMBER,22], "PL"."ITEM_ID"[NUMBER,22], "PL"."ITEM_REVISION"[VARCHAR2,3], "PL"."ITEM_DESCRIPTION"[VARCHAR2,240], "PL"."UNIT_MEAS_LOOKUP_CODE"[VARCHAR2,25], "PL"."UNIT_PRICE"[NUMBER,22], "PL"."NOTE_TO_VENDOR"[VARCHAR2,480], "PL"."ATTRIBUTE1"[VARCHAR2,150], "PL"."ATTRIBUTE4"[VARCHAR2,150], "PL"."CLOSED_CODE"[VARCHAR2,25], "LINE_TYPE"[VARCHAR2,25], "VENDOR_NAME"[VARCHAR2,240], "PLL"."LINE_LOCATION_ID"[NUMBER,22], "PLL"."PO_HEADER_ID"[NUMBER,22], "PLL"."PO_LINE_ID"[NUMBER,22], "PLL"."QUANTITY"[NUMBER,22], "PLL"."QUANTITY_RECEIVED"[NUMBER,22], "PLL"."QUANTITY_CANCELLED"[NUMBER,22], "PLL"."NEED_BY_DATE"[DATE,7], "PLL"."PROMISED_DATE"[DATE,7], "PLL"."ATTRIBUTE1"[VARCHAR2,150], "PLL"."ATTRIBUTE2"[VARCHAR2,150], "PLL"."ATTRIBUTE3"[VARCHAR2,150], "PLL"."ATTRIBUTE5"[VARCHAR2,150], "PLL"."ATTRIBUTE6"[VARCHAR2,150], "PLL"."ATTRIBUTE7"[VARCHAR2,150], "PLL"."INSPECTION_REQUIRED_FLAG"[VARCHAR2,1], "PLL"."RECEIPT_REQUIRED_FLAG"[VARCHAR2,1], "PLL"."SHIP_TO_ORGANIZATION_ID"[NUMBER,22], "PLL"."SHIPMENT_NUM"[NUMBER,22], "PLL"."CLOSED_CODE"[VARCHAR2,30], "PLL"."RECEIVING_ROUTING_ID"[NUMBER,22], "PLL"."MATCH_OPTION"[VARCHAR2,25], "PLL"."NOTE_TO_RECEIVER"[VARCHAR2,480], "MP"."ORGANIZATION_CODE"[VARCHAR2,3], "MP"."CALENDAR_CODE"[VARCHAR2,10], "PVS"."VENDOR_SITE_CODE"[VARCHAR2,15], "PD"."PO_DISTRIBUTION_ID"[NUMBER,22], "PD"."PO_HEADER_ID"[NUMBER,22], "PD"."PO_LINE_ID"[NUMBER,22], "PD"."LINE_LOCATION_ID"[NUMBER,22], "PD"."CODE_COMBINATION_ID"[NUMBER,22], "PD"."DELIVER_TO_LOCATION_ID"[NUMBER,22], "PD"."DELIVER_TO_PERSON_ID"[NUMBER,22], "PD"."DESTINATION_SUBINVENTORY"[VARCHAR2,10], "PD"."ATTRIBUTE15"[VARCHAR2,150], "PD"."ACCRUAL_ACCOUNT_ID"[NUMBER,22], "PD"."DISTRIBUTION_NUM"[NUMBER,22], "POA"."ACTION"[VARCHAR2,240], "POA"."ACTION_DATE"[DATE,7], "POA"."ACCEPTED_FLAG"[VARCHAR2,1], "POA"."ACCEPTANCE_LOOKUP_CODE"[VARCHAR2,25], "OEL"."LINE_NUMBER"[NUMBER,22], "OEH"."ORDER_NUMBER"[NUMBER,22], "PRLA"."LINE_NUM"[NUMBER,22], "PRHA"."SEGMENT1"[VARCHAR2,20], "ZXD"."INPUT_TAX_CLASSIFICATION_CODE"[VARCHAR2,50] 126 - "PH"."PO_HEADER_ID"[NUMBER,22], "PH"."AGENT_ID"[NUMBER,22], "PH"."TYPE_LOOKUP_CODE"[VARCHAR2,25], "PH"."SEGMENT1"[VARCHAR2,20], "PH"."SHIP_TO_LOCATION_ID"[NUMBER,22], "PH"."BILL_TO_LOCATION_ID"[NUMBER,22], "PH"."CURRENCY_CODE"[VARCHAR2,15], "PH"."RATE"[NUMBER,22], "PH"."AUTHORIZATION_STATUS"[VARCHAR2,25], "PH"."REVISION_NUM"[NUMBER,22], "PH"."COMMENTS"[VARCHAR2,240], "PH"."CLOSED_CODE"[VARCHAR2,25], "PH"."SYS_NC00152$"[DATE,7], "PL"."PO_LINE_ID"[NUMBER,22], "PL"."PO_HEADER_ID"[NUMBER,22], "PL"."LINE_NUM"[NUMBER,22], "PL"."ITEM_ID"[NUMBER,22], "PL"."ITEM_REVISION"[VARCHAR2,3], "PL"."ITEM_DESCRIPTION"[VARCHAR2,240], "PL"."UNIT_MEAS_LOOKUP_CODE"[VARCHAR2,25], "PL"."UNIT_PRICE"[NUMBER,22], "PL"."NOTE_TO_VENDOR"[VARCHAR2,480], "PL"."ATTRIBUTE1"[VARCHAR2,150], "PL"."ATTRIBUTE4"[VARCHAR2,150], "PL"."CLOSED_CODE"[VARCHAR2,25], "LINE_TYPE"[VARCHAR2,25], "VENDOR_NAME"[VARCHAR2,240], "PLL"."LINE_LOCATION_ID"[NUMBER,22], "PLL"."PO_HEADER_ID"[NUMBER,22], "PLL"."PO_LINE_ID"[NUMBER,22], "PLL"."QUANTITY"[NUMBER,22], "PLL"."QUANTITY_RECEIVED"[NUMBER,22], "PLL"."QUANTITY_CANCELLED"[NUMBER,22], "PLL"."NEED_BY_DATE"[DATE,7], "PLL"."PROMISED_DATE"[DATE,7], "PLL"."ATTRIBUTE1"[VARCHAR2,150], "PLL"."ATTRIBUTE2"[VARCHAR2,150], "PLL"."ATTRIBUTE3"[VARCHAR2,150], "PLL"."ATTRIBUTE5"[VARCHAR2,150], "PLL"."ATTRIBUTE6"[VARCHAR2,150], "PLL"."ATTRIBUTE7"[VARCHAR2,150], "PLL"."INSPECTION_REQUIRED_FLAG"[VARCHAR2,1], "PLL"."RECEIPT_REQUIRED_FLAG"[VARCHAR2,1], "PLL"."SHIP_TO_ORGANIZATION_ID"[NUMBER,22], "PLL"."SHIPMENT_NUM"[NUMBER,22], "PLL"."CLOSED_CODE"[VARCHAR2,30], "PLL"."RECEIVING_ROUTING_ID"[NUMBER,22], "PLL"."MATCH_OPTION"[VARCHAR2,25], "PLL"."NOTE_TO_RECEIVER"[VARCHAR2,480], "MP"."ORGANIZATION_CODE"[VARCHAR2,3], "MP"."CALENDAR_CODE"[VARCHAR2,10], "PVS"."VENDOR_SITE_CODE"[VARCHAR2,15], "PD"."PO_DISTRIBUTION_ID"[NUMBER,22], "PD"."PO_HEADER_ID"[NUMBER,22], "PD"."PO_LINE_ID"[NUMBER,22], "PD"."LINE_LOCATION_ID"[NUMBER,22], "PD"."CODE_COMBINATION_ID"[NUMBER,22], "PD"."DELIVER_TO_LOCATION_ID"[NUMBER,22], "PD"."DELIVER_TO_PERSON_ID"[NUMBER,22], "PD"."DESTINATION_SUBINVENTORY"[VARCHAR2,10], "PD"."ATTRIBUTE15"[VARCHAR2,150], "PD"."ACCRUAL_ACCOUNT_ID"[NUMBER,22], "PD"."DISTRIBUTION_NUM"[NUMBER,22], "POA"."ACTION"[VARCHAR2,240], "POA"."ACTION_DATE"[DATE,7], "POA"."ACCEPTED_FLAG"[VARCHAR2,1], "POA"."ACCEPTANCE_LOOKUP_CODE"[VARCHAR2,25], "OEL"."LINE_NUMBER"[NUMBER,22], "OEH"."ORDER_NUMBER"[NUMBER,22], "PRLA"."LINE_NUM"[NUMBER,22], "PRHA"."SEGMENT1"[VARCHAR2,20], "ZXL"."TRX_ID"[NUMBER,22], "ZXL"."TRX_LINE_ID"[NUMBER,22] 127 - "PH"."PO_HEADER_ID"[NUMBER,22], "PH"."AGENT_ID"[NUMBER,22], "PH"."TYPE_LOOKUP_CODE"[VARCHAR2,25], "PH"."SEGMENT1"[VARCHAR2,20], "PH"."SHIP_TO_LOCATION_ID"[NUMBER,22], "PH"."BILL_TO_LOCATION_ID"[NUMBER,22], "PH"."CURRENCY_CODE"[VARCHAR2,15], "PH"."RATE"[NUMBER,22], "PH"."AUTHORIZATION_STATUS"[VARCHAR2,25], "PH"."REVISION_NUM"[NUMBER,22], "PH"."COMMENTS"[VARCHAR2,240], "PH"."CLOSED_CODE"[VARCHAR2,25], "PH"."SYS_NC00152$"[DATE,7], "PL"."PO_LINE_ID"[NUMBER,22], "PL"."PO_HEADER_ID"[NUMBER,22], "PL"."LINE_NUM"[NUMBER,22], "PL"."ITEM_ID"[NUMBER,22], "PL"."ITEM_REVISION"[VARCHAR2,3], "PL"."ITEM_DESCRIPTION"[VARCHAR2,240], "PL"."UNIT_MEAS_LOOKUP_CODE"[VARCHAR2,25], "PL"."UNIT_PRICE"[NUMBER,22], "PL"."NOTE_TO_VENDOR"[VARCHAR2,480], "PL"."ATTRIBUTE1"[VARCHAR2,150], "PL"."ATTRIBUTE4"[VARCHAR2,150], "PL"."CLOSED_CODE"[VARCHAR2,25], "LINE_TYPE"[VARCHAR2,25], "VENDOR_NAME"[VARCHAR2,240], "PLL"."LINE_LOCATION_ID"[NUMBER,22], "PLL"."PO_HEADER_ID"[NUMBER,22], "PLL"."PO_LINE_ID"[NUMBER,22], "PLL"."QUANTITY"[NUMBER,22], "PLL"."QUANTITY_RECEIVED"[NUMBER,22], "PLL"."QUANTITY_CANCELLED"[NUMBER,22], "PLL"."NEED_BY_DATE"[DATE,7], "PLL"."PROMISED_DATE"[DATE,7], "PLL"."ATTRIBUTE1"[VARCHAR2,150], "PLL"."ATTRIBUTE2"[VARCHAR2,150], "PLL"."ATTRIBUTE3"[VARCHAR2,150], "PLL"."ATTRIBUTE5"[VARCHAR2,150], "PLL"."ATTRIBUTE6"[VARCHAR2,150], "PLL"."ATTRIBUTE7"[VARCHAR2,150], "PLL"."INSPECTION_REQUIRED_FLAG"[VARCHAR2,1], "PLL"."RECEIPT_REQUIRED_FLAG"[VARCHAR2,1], "PLL"."SHIP_TO_ORGANIZATION_ID"[NUMBER,22], "PLL"."SHIPMENT_NUM"[NUMBER,22], "PLL"."CLOSED_CODE"[VARCHAR2,30], "PLL"."RECEIVING_ROUTING_ID"[NUMBER,22], "PLL"."MATCH_OPTION"[VARCHAR2,25], "PLL"."NOTE_TO_RECEIVER"[VARCHAR2,480], "MP"."ORGANIZATION_CODE"[VARCHAR2,3], "MP"."CALENDAR_CODE"[VARCHAR2,10], "PVS"."VENDOR_SITE_CODE"[VARCHAR2,15], "PD"."PO_DISTRIBUTION_ID"[NUMBER,22], "PD"."PO_HEADER_ID"[NUMBER,22], "PD"."PO_LINE_ID"[NUMBER,22], "PD"."LINE_LOCATION_ID"[NUMBER,22], "PD"."CODE_COMBINATION_ID"[NUMBER,22], "PD"."DELIVER_TO_LOCATION_ID"[NUMBER,22], "PD"."DELIVER_TO_PERSON_ID"[NUMBER,22], "PD"."DESTINATION_SUBINVENTORY"[VARCHAR2,10], "PD"."ATTRIBUTE15"[VARCHAR2,150], "PD"."ACCRUAL_ACCOUNT_ID"[NUMBER,22], "PD"."DISTRIBUTION_NUM"[NUMBER,22], "POA"."ACTION"[VARCHAR2,240], "POA"."ACTION_DATE"[DATE,7], "POA"."ACCEPTED_FLAG"[VARCHAR2,1], "POA"."ACCEPTANCE_LOOKUP_CODE"[VARCHAR2,25], "OEL"."LINE_NUMBER"[NUMBER,22], "OEH"."ORDER_NUMBER"[NUMBER,22], "PRLA"."LINE_NUM"[NUMBER,22], "PRHA"."SEGMENT1"[VARCHAR2,20] 128 - "PH"."PO_HEADER_ID"[NUMBER,22], "PH"."AGENT_ID"[NUMBER,22], "PH"."TYPE_LOOKUP_CODE"[VARCHAR2,25], "PH"."SEGMENT1"[VARCHAR2,20], "PH"."SHIP_TO_LOCATION_ID"[NUMBER,22], "PH"."BILL_TO_LOCATION_ID"[NUMBER,22], "PH"."CURRENCY_CODE"[VARCHAR2,15], "PH"."RATE"[NUMBER,22], "PH"."AUTHORIZATION_STATUS"[VARCHAR2,25], "PH"."REVISION_NUM"[NUMBER,22], "PH"."COMMENTS"[VARCHAR2,240], "PH"."CLOSED_CODE"[VARCHAR2,25], "PH"."SYS_NC00152$"[DATE,7], "PL"."PO_LINE_ID"[NUMBER,22], "PL"."PO_HEADER_ID"[NUMBER,22], "PL"."LINE_NUM"[NUMBER,22], "PL"."ITEM_ID"[NUMBER,22], "PL"."ITEM_REVISION"[VARCHAR2,3], "PL"."ITEM_DESCRIPTION"[VARCHAR2,240], "PL"."UNIT_MEAS_LOOKUP_CODE"[VARCHAR2,25], "PL"."UNIT_PRICE"[NUMBER,22], "PL"."NOTE_TO_VENDOR"[VARCHAR2,480], "PL"."ATTRIBUTE1"[VARCHAR2,150], "PL"."ATTRIBUTE4"[VARCHAR2,150], "PL"."CLOSED_CODE"[VARCHAR2,25], "LINE_TYPE"[VARCHAR2,25], "VENDOR_NAME"[VARCHAR2,240], "PLL"."LINE_LOCATION_ID"[NUMBER,22], "PLL"."PO_HEADER_ID"[NUMBER,22], "PLL"."PO_LINE_ID"[NUMBER,22], "PLL"."QUANTITY"[NUMBER,22], "PLL"."QUANTITY_RECEIVED"[NUMBER,22], "PLL"."QUANTITY_CANCELLED"[NUMBER,22], "PLL"."NEED_BY_DATE"[DATE,7], "PLL"."PROMISED_DATE"[DATE,7], "PLL"."ATTRIBUTE1"[VARCHAR2,150], "PLL"."ATTRIBUTE2"[VARCHAR2,150], "PLL"."ATTRIBUTE3"[VARCHAR2,150], "PLL"."ATTRIBUTE5"[VARCHAR2,150], "PLL"."ATTRIBUTE6"[VARCHAR2,150], "PLL"."ATTRIBUTE7"[VARCHAR2,150], "PLL"."INSPECTION_REQUIRED_FLAG"[VARCHAR2,1], "PLL"."RECEIPT_REQUIRED_FLAG"[VARCHAR2,1], "PLL"."SHIP_TO_ORGANIZATION_ID"[NUMBER,22], "PLL"."SHIPMENT_NUM"[NUMBER,22], "PLL"."CLOSED_CODE"[VARCHAR2,30], "PLL"."RECEIVING_ROUTING_ID"[NUMBER,22], "PLL"."MATCH_OPTION"[VARCHAR2,25], "PLL"."NOTE_TO_RECEIVER"[VARCHAR2,480], "MP"."ORGANIZATION_CODE"[VARCHAR2,3], "MP"."CALENDAR_CODE"[VARCHAR2,10], "PVS"."VENDOR_SITE_CODE"[VARCHAR2,15], "PD"."PO_DISTRIBUTION_ID"[NUMBER,22], "PD"."PO_HEADER_ID"[NUMBER,22], "PD"."PO_LINE_ID"[NUMBER,22], "PD"."LINE_LOCATION_ID"[NUMBER,22], "PD"."CODE_COMBINATION_ID"[NUMBER,22], "PD"."DELIVER_TO_LOCATION_ID"[NUMBER,22], "PD"."DELIVER_TO_PERSON_ID"[NUMBER,22], "PD"."DESTINATION_SUBINVENTORY"[VARCHAR2,10], "PD"."ATTRIBUTE15"[VARCHAR2,150], "PD"."ACCRUAL_ACCOUNT_ID"[NUMBER,22], "PD"."DISTRIBUTION_NUM"[NUMBER,22], "POA"."ACTION"[VARCHAR2,240], "POA"."ACTION_DATE"[DATE,7], "POA"."ACCEPTED_FLAG"[VARCHAR2,1], "POA"."ACCEPTANCE_LOOKUP_CODE"[VARCHAR2,25], "OEL"."LINE_NUMBER"[NUMBER,22], "OEH"."ORDER_NUMBER"[NUMBER,22], "PRLA"."REQUISITION_HEADER_ID"[NUMBER,22], "PRLA"."LINE_NUM"[NUMBER,22] 129 - "PH"."PO_HEADER_ID"[NUMBER,22], "PH"."AGENT_ID"[NUMBER,22], "PH"."TYPE_LOOKUP_CODE"[VARCHAR2,25], "PH"."SEGMENT1"[VARCHAR2,20], "PH"."SHIP_TO_LOCATION_ID"[NUMBER,22], "PH"."BILL_TO_LOCATION_ID"[NUMBER,22], "PH"."CURRENCY_CODE"[VARCHAR2,15], "PH"."RATE"[NUMBER,22], "PH"."AUTHORIZATION_STATUS"[VARCHAR2,25], "PH"."REVISION_NUM"[NUMBER,22], "PH"."COMMENTS"[VARCHAR2,240], "PH"."CLOSED_CODE"[VARCHAR2,25], "PH"."SYS_NC00152$"[DATE,7], "PL"."PO_LINE_ID"[NUMBER,22], "PL"."PO_HEADER_ID"[NUMBER,22], "PL"."LINE_NUM"[NUMBER,22], "PL"."ITEM_ID"[NUMBER,22], "PL"."ITEM_REVISION"[VARCHAR2,3], "PL"."ITEM_DESCRIPTION"[VARCHAR2,240], "PL"."UNIT_MEAS_LOOKUP_CODE"[VARCHAR2,25], "PL"."UNIT_PRICE"[NUMBER,22], "PL"."NOTE_TO_VENDOR"[VARCHAR2,480], "PL"."ATTRIBUTE1"[VARCHAR2,150], "PL"."ATTRIBUTE4"[VARCHAR2,150], "PL"."CLOSED_CODE"[VARCHAR2,25], "LINE_TYPE"[VARCHAR2,25], "VENDOR_NAME"[VARCHAR2,240], "PLL"."LINE_LOCATION_ID"[NUMBER,22], "PLL"."PO_HEADER_ID"[NUMBER,22], "PLL"."PO_LINE_ID"[NUMBER,22], "PLL"."QUANTITY"[NUMBER,22], "PLL"."QUANTITY_RECEIVED"[NUMBER,22], "PLL"."QUANTITY_CANCELLED"[NUMBER,22], "PLL"."NEED_BY_DATE"[DATE,7], "PLL"."PROMISED_DATE"[DATE,7], "PLL"."ATTRIBUTE1"[VARCHAR2,150], "PLL"."ATTRIBUTE2"[VARCHAR2,150], "PLL"."ATTRIBUTE3"[VARCHAR2,150], "PLL"."ATTRIBUTE5"[VARCHAR2,150], "PLL"."ATTRIBUTE6"[VARCHAR2,150], "PLL"."ATTRIBUTE7"[VARCHAR2,150], "PLL"."INSPECTION_REQUIRED_FLAG"[VARCHAR2,1], "PLL"."RECEIPT_REQUIRED_FLAG"[VARCHAR2,1], "PLL"."SHIP_TO_ORGANIZATION_ID"[NUMBER,22], "PLL"."SHIPMENT_NUM"[NUMBER,22], "PLL"."CLOSED_CODE"[VARCHAR2,30], "PLL"."RECEIVING_ROUTING_ID"[NUMBER,22], "PLL"."MATCH_OPTION"[VARCHAR2,25], "PLL"."NOTE_TO_RECEIVER"[VARCHAR2,480], "MP"."ORGANIZATION_CODE"[VARCHAR2,3], "MP"."CALENDAR_CODE"[VARCHAR2,10], "PVS"."VENDOR_SITE_CODE"[VARCHAR2,15], "PD"."PO_DISTRIBUTION_ID"[NUMBER,22], "PD"."PO_HEADER_ID"[NUMBER,22], "PD"."PO_LINE_ID"[NUMBER,22], "PD"."LINE_LOCATION_ID"[NUMBER,22], "PD"."CODE_COMBINATION_ID"[NUMBER,22], "PD"."DELIVER_TO_LOCATION_ID"[NUMBER,22], "PD"."DELIVER_TO_PERSON_ID"[NUMBER,22], "PD"."DESTINATION_SUBINVENTORY"[VARCHAR2,10], "PD"."ATTRIBUTE15"[VARCHAR2,150], "PD"."ACCRUAL_ACCOUNT_ID"[NUMBER,22], "PD"."DISTRIBUTION_NUM"[NUMBER,22], "PRDA"."REQUISITION_LINE_ID"[NUMBER,22], "POA"."ACTION"[VARCHAR2,240], "POA"."ACTION_DATE"[DATE,7], "POA"."ACCEPTED_FLAG"[VARCHAR2,1], "POA"."ACCEPTANCE_LOOKUP_CODE"[VARCHAR2,25], "OEL"."LINE_NUMBER"[NUMBER,22], "OEH"."ORDER_NUMBER"[NUMBER,22] 130 - "PH"."PO_HEADER_ID"[NUMBER,22], "PH"."AGENT_ID"[NUMBER,22], "PH"."TYPE_LOOKUP_CODE"[VARCHAR2,25], "PH"."SEGMENT1"[VARCHAR2,20], "PH"."SHIP_TO_LOCATION_ID"[NUMBER,22], "PH"."BILL_TO_LOCATION_ID"[NUMBER,22], "PH"."CURRENCY_CODE"[VARCHAR2,15], "PH"."RATE"[NUMBER,22], "PH"."AUTHORIZATION_STATUS"[VARCHAR2,25], "PH"."REVISION_NUM"[NUMBER,22], "PH"."COMMENTS"[VARCHAR2,240], "PH"."CLOSED_CODE"[VARCHAR2,25], "PH"."SYS_NC00152$"[DATE,7], "PL"."PO_LINE_ID"[NUMBER,22], "PL"."PO_HEADER_ID"[NUMBER,22], "PL"."LINE_NUM"[NUMBER,22], "PL"."ITEM_ID"[NUMBER,22], "PL"."ITEM_REVISION"[VARCHAR2,3], "PL"."ITEM_DESCRIPTION"[VARCHAR2,240], "PL"."UNIT_MEAS_LOOKUP_CODE"[VARCHAR2,25], "PL"."UNIT_PRICE"[NUMBER,22], "PL"."NOTE_TO_VENDOR"[VARCHAR2,480], "PL"."ATTRIBUTE1"[VARCHAR2,150], "PL"."ATTRIBUTE4"[VARCHAR2,150], "PL"."CLOSED_CODE"[VARCHAR2,25], "LINE_TYPE"[VARCHAR2,25], "VENDOR_NAME"[VARCHAR2,240], "PLL"."LINE_LOCATION_ID"[NUMBER,22], "PLL"."PO_HEADER_ID"[NUMBER,22], "PLL"."PO_LINE_ID"[NUMBER,22], "PLL"."QUANTITY"[NUMBER,22], "PLL"."QUANTITY_RECEIVED"[NUMBER,22], "PLL"."QUANTITY_CANCELLED"[NUMBER,22], "PLL"."NEED_BY_DATE"[DATE,7], "PLL"."PROMISED_DATE"[DATE,7], "PLL"."ATTRIBUTE1"[VARCHAR2,150], "PLL"."ATTRIBUTE2"[VARCHAR2,150], "PLL"."ATTRIBUTE3"[VARCHAR2,150], "PLL"."ATTRIBUTE5"[VARCHAR2,150], "PLL"."ATTRIBUTE6"[VARCHAR2,150], "PLL"."ATTRIBUTE7"[VARCHAR2,150], "PLL"."INSPECTION_REQUIRED_FLAG"[VARCHAR2,1], "PLL"."RECEIPT_REQUIRED_FLAG"[VARCHAR2,1], "PLL"."SHIP_TO_ORGANIZATION_ID"[NUMBER,22], "PLL"."SHIPMENT_NUM"[NUMBER,22], "PLL"."CLOSED_CODE"[VARCHAR2,30], "PLL"."RECEIVING_ROUTING_ID"[NUMBER,22], "PLL"."MATCH_OPTION"[VARCHAR2,25], "PLL"."NOTE_TO_RECEIVER"[VARCHAR2,480], "MP"."ORGANIZATION_CODE"[VARCHAR2,3], "MP"."CALENDAR_CODE"[VARCHAR2,10], "PVS"."VENDOR_SITE_CODE"[VARCHAR2,15], "PD"."PO_DISTRIBUTION_ID"[NUMBER,22], "PD"."PO_HEADER_ID"[NUMBER,22], "PD"."PO_LINE_ID"[NUMBER,22], "PD"."LINE_LOCATION_ID"[NUMBER,22], "PD"."CODE_COMBINATION_ID"[NUMBER,22], "PD"."DELIVER_TO_LOCATION_ID"[NUMBER,22], "PD"."DELIVER_TO_PERSON_ID"[NUMBER,22], "PD"."DESTINATION_SUBINVENTORY"[VARCHAR2,10], "PD"."ATTRIBUTE15"[VARCHAR2,150], "PD"."ACCRUAL_ACCOUNT_ID"[NUMBER,22], "PD"."DISTRIBUTION_NUM"[NUMBER,22], "PRDA"."REQUISITION_LINE_ID"[NUMBER,22], "POA"."ACTION"[VARCHAR2,240], "POA"."ACTION_DATE"[DATE,7], "POA"."ACCEPTED_FLAG"[VARCHAR2,1], "POA"."ACCEPTANCE_LOOKUP_CODE"[VARCHAR2,25], "OEL"."HEADER_ID"[NUMBER,22], "OEL"."LINE_NUMBER"[NUMBER,22] 131 - "PH"."PO_HEADER_ID"[NUMBER,22], "PH"."AGENT_ID"[NUMBER,22], "PH"."TYPE_LOOKUP_CODE"[VARCHAR2,25], "PH"."SEGMENT1"[VARCHAR2,20], "PH"."SHIP_TO_LOCATION_ID"[NUMBER,22], "PH"."BILL_TO_LOCATION_ID"[NUMBER,22], "PH"."CURRENCY_CODE"[VARCHAR2,15], "PH"."RATE"[NUMBER,22], "PH"."AUTHORIZATION_STATUS"[VARCHAR2,25], "PH"."REVISION_NUM"[NUMBER,22], "PH"."COMMENTS"[VARCHAR2,240], "PH"."CLOSED_CODE"[VARCHAR2,25], "PH"."SYS_NC00152$"[DATE,7], "PL"."PO_LINE_ID"[NUMBER,22], "PL"."PO_HEADER_ID"[NUMBER,22], "PL"."LINE_NUM"[NUMBER,22], "PL"."ITEM_ID"[NUMBER,22], "PL"."ITEM_REVISION"[VARCHAR2,3], "PL"."ITEM_DESCRIPTION"[VARCHAR2,240], "PL"."UNIT_MEAS_LOOKUP_CODE"[VARCHAR2,25], "PL"."UNIT_PRICE"[NUMBER,22], "PL"."NOTE_TO_VENDOR"[VARCHAR2,480], "PL"."ATTRIBUTE1"[VARCHAR2,150], "PL"."ATTRIBUTE4"[VARCHAR2,150], "PL"."CLOSED_CODE"[VARCHAR2,25], "LINE_TYPE"[VARCHAR2,25], "VENDOR_NAME"[VARCHAR2,240], "PLL"."LINE_LOCATION_ID"[NUMBER,22], "PLL"."PO_HEADER_ID"[NUMBER,22], "PLL"."PO_LINE_ID"[NUMBER,22], "PLL"."QUANTITY"[NUMBER,22], "PLL"."QUANTITY_RECEIVED"[NUMBER,22], "PLL"."QUANTITY_CANCELLED"[NUMBER,22], "PLL"."NEED_BY_DATE"[DATE,7], "PLL"."PROMISED_DATE"[DATE,7], "PLL"."ATTRIBUTE1"[VARCHAR2,150], "PLL"."ATTRIBUTE2"[VARCHAR2,150], "PLL"."ATTRIBUTE3"[VARCHAR2,150], "PLL"."ATTRIBUTE5"[VARCHAR2,150], "PLL"."ATTRIBUTE6"[VARCHAR2,150], "PLL"."ATTRIBUTE7"[VARCHAR2,150], "PLL"."INSPECTION_REQUIRED_FLAG"[VARCHAR2,1], "PLL"."RECEIPT_REQUIRED_FLAG"[VARCHAR2,1], "PLL"."SHIP_TO_ORGANIZATION_ID"[NUMBER,22], "PLL"."SHIPMENT_NUM"[NUMBER,22], "PLL"."CLOSED_CODE"[VARCHAR2,30], "PLL"."RECEIVING_ROUTING_ID"[NUMBER,22], "PLL"."MATCH_OPTION"[VARCHAR2,25], "PLL"."NOTE_TO_RECEIVER"[VARCHAR2,480], "MP"."ORGANIZATION_CODE"[VARCHAR2,3], "MP"."CALENDAR_CODE"[VARCHAR2,10], "PVS"."VENDOR_SITE_CODE"[VARCHAR2,15], "ODS"."LINE_ID"[NUMBER,22], "PD"."PO_DISTRIBUTION_ID"[NUMBER,22], "PD"."PO_HEADER_ID"[NUMBER,22], "PD"."PO_LINE_ID"[NUMBER,22], "PD"."LINE_LOCATION_ID"[NUMBER,22], "PD"."CODE_COMBINATION_ID"[NUMBER,22], "PD"."DELIVER_TO_LOCATION_ID"[NUMBER,22], "PD"."DELIVER_TO_PERSON_ID"[NUMBER,22], "PD"."DESTINATION_SUBINVENTORY"[VARCHAR2,10], "PD"."ATTRIBUTE15"[VARCHAR2,150], "PD"."ACCRUAL_ACCOUNT_ID"[NUMBER,22], "PD"."DISTRIBUTION_NUM"[NUMBER,22], "PRDA"."REQUISITION_LINE_ID"[NUMBER,22], "POA"."ACTION"[VARCHAR2,240], "POA"."ACTION_DATE"[DATE,7], "POA"."ACCEPTED_FLAG"[VARCHAR2,1], "POA"."ACCEPTANCE_LOOKUP_CODE"[VARCHAR2,25] 132 - "PH"."PO_HEADER_ID"[NUMBER,22], "PH"."AGENT_ID"[NUMBER,22], "PH"."TYPE_LOOKUP_CODE"[VARCHAR2,25], "PH"."SEGMENT1"[VARCHAR2,20], "PH"."SHIP_TO_LOCATION_ID"[NUMBER,22], "PH"."BILL_TO_LOCATION_ID"[NUMBER,22], "PH"."CURRENCY_CODE"[VARCHAR2,15], "PH"."RATE"[NUMBER,22], "PH"."AUTHORIZATION_STATUS"[VARCHAR2,25], "PH"."REVISION_NUM"[NUMBER,22], "PH"."COMMENTS"[VARCHAR2,240], "PH"."CLOSED_CODE"[VARCHAR2,25], "PH"."SYS_NC00152$"[DATE,7], "PL"."PO_LINE_ID"[NUMBER,22], "PL"."PO_HEADER_ID"[NUMBER,22], "PL"."LINE_NUM"[NUMBER,22], "PL"."ITEM_ID"[NUMBER,22], "PL"."ITEM_REVISION"[VARCHAR2,3], "PL"."ITEM_DESCRIPTION"[VARCHAR2,240], "PL"."UNIT_MEAS_LOOKUP_CODE"[VARCHAR2,25], "PL"."UNIT_PRICE"[NUMBER,22], "PL"."NOTE_TO_VENDOR"[VARCHAR2,480], "PL"."ATTRIBUTE1"[VARCHAR2,150], "PL"."ATTRIBUTE4"[VARCHAR2,150], "PL"."CLOSED_CODE"[VARCHAR2,25], "LINE_TYPE"[VARCHAR2,25], "VENDOR_NAME"[VARCHAR2,240], "PLL"."LINE_LOCATION_ID"[NUMBER,22], "PLL"."PO_HEADER_ID"[NUMBER,22], "PLL"."PO_LINE_ID"[NUMBER,22], "PLL"."QUANTITY"[NUMBER,22], "PLL"."QUANTITY_RECEIVED"[NUMBER,22], "PLL"."QUANTITY_CANCELLED"[NUMBER,22], "PLL"."NEED_BY_DATE"[DATE,7], "PLL"."PROMISED_DATE"[DATE,7], "PLL"."ATTRIBUTE1"[VARCHAR2,150], "PLL"."ATTRIBUTE2"[VARCHAR2,150], "PLL"."ATTRIBUTE3"[VARCHAR2,150], "PLL"."ATTRIBUTE5"[VARCHAR2,150], "PLL"."ATTRIBUTE6"[VARCHAR2,150], "PLL"."ATTRIBUTE7"[VARCHAR2,150], "PLL"."INSPECTION_REQUIRED_FLAG"[VARCHAR2,1], "PLL"."RECEIPT_REQUIRED_FLAG"[VARCHAR2,1], "PLL"."SHIP_TO_ORGANIZATION_ID"[NUMBER,22], "PLL"."SHIPMENT_NUM"[NUMBER,22], "PLL"."CLOSED_CODE"[VARCHAR2,30], "PLL"."RECEIVING_ROUTING_ID"[NUMBER,22], "PLL"."MATCH_OPTION"[VARCHAR2,25], "PLL"."NOTE_TO_RECEIVER"[VARCHAR2,480], "MP"."ORGANIZATION_CODE"[VARCHAR2,3], "MP"."CALENDAR_CODE"[VARCHAR2,10], "PVS"."VENDOR_SITE_CODE"[VARCHAR2,15], "ODS"."LINE_ID"[NUMBER,22], "PD"."PO_DISTRIBUTION_ID"[NUMBER,22], "PD"."PO_HEADER_ID"[NUMBER,22], "PD"."PO_LINE_ID"[NUMBER,22], "PD"."LINE_LOCATION_ID"[NUMBER,22], "PD"."CODE_COMBINATION_ID"[NUMBER,22], "PD"."DELIVER_TO_LOCATION_ID"[NUMBER,22], "PD"."DELIVER_TO_PERSON_ID"[NUMBER,22], "PD"."DESTINATION_SUBINVENTORY"[VARCHAR2,10], "PD"."ATTRIBUTE15"[VARCHAR2,150], "PD"."ACCRUAL_ACCOUNT_ID"[NUMBER,22], "PD"."DISTRIBUTION_NUM"[NUMBER,22], "PRDA"."REQUISITION_LINE_ID"[NUMBER,22] 133 - "PH"."PO_HEADER_ID"[NUMBER,22], "PH"."AGENT_ID"[NUMBER,22], "PH"."TYPE_LOOKUP_CODE"[VARCHAR2,25], "PH"."SEGMENT1"[VARCHAR2,20], "PH"."SHIP_TO_LOCATION_ID"[NUMBER,22], "PH"."BILL_TO_LOCATION_ID"[NUMBER,22], "PH"."CURRENCY_CODE"[VARCHAR2,15], "PH"."RATE"[NUMBER,22], "PH"."AUTHORIZATION_STATUS"[VARCHAR2,25], "PH"."REVISION_NUM"[NUMBER,22], "PH"."COMMENTS"[VARCHAR2,240], "PH"."CLOSED_CODE"[VARCHAR2,25], "PH"."SYS_NC00152$"[DATE,7], "PL"."PO_LINE_ID"[NUMBER,22], "PL"."PO_HEADER_ID"[NUMBER,22], "PL"."LINE_NUM"[NUMBER,22], "PL"."ITEM_ID"[NUMBER,22], "PL"."ITEM_REVISION"[VARCHAR2,3], "PL"."ITEM_DESCRIPTION"[VARCHAR2,240], "PL"."UNIT_MEAS_LOOKUP_CODE"[VARCHAR2,25], "PL"."UNIT_PRICE"[NUMBER,22], "PL"."NOTE_TO_VENDOR"[VARCHAR2,480], "PL"."ATTRIBUTE1"[VARCHAR2,150], "PL"."ATTRIBUTE4"[VARCHAR2,150], "PL"."CLOSED_CODE"[VARCHAR2,25], "LINE_TYPE"[VARCHAR2,25], "VENDOR_NAME"[VARCHAR2,240], "PLL"."LINE_LOCATION_ID"[NUMBER,22], "PLL"."PO_HEADER_ID"[NUMBER,22], "PLL"."PO_LINE_ID"[NUMBER,22], "PLL"."QUANTITY"[NUMBER,22], "PLL"."QUANTITY_RECEIVED"[NUMBER,22], "PLL"."QUANTITY_CANCELLED"[NUMBER,22], "PLL"."NEED_BY_DATE"[DATE,7], "PLL"."PROMISED_DATE"[DATE,7], "PLL"."ATTRIBUTE1"[VARCHAR2,150], "PLL"."ATTRIBUTE2"[VARCHAR2,150], "PLL"."ATTRIBUTE3"[VARCHAR2,150], "PLL"."ATTRIBUTE5"[VARCHAR2,150], "PLL"."ATTRIBUTE6"[VARCHAR2,150], "PLL"."ATTRIBUTE7"[VARCHAR2,150], "PLL"."INSPECTION_REQUIRED_FLAG"[VARCHAR2,1], "PLL"."RECEIPT_REQUIRED_FLAG"[VARCHAR2,1], "PLL"."SHIP_TO_ORGANIZATION_ID"[NUMBER,22], "PLL"."SHIPMENT_NUM"[NUMBER,22], "PLL"."CLOSED_CODE"[VARCHAR2,30], "PLL"."RECEIVING_ROUTING_ID"[NUMBER,22], "PLL"."MATCH_OPTION"[VARCHAR2,25], "PLL"."NOTE_TO_RECEIVER"[VARCHAR2,480], "MP"."ORGANIZATION_CODE"[VARCHAR2,3], "MP"."CALENDAR_CODE"[VARCHAR2,10], "PVS"."VENDOR_SITE_CODE"[VARCHAR2,15], "ODS"."LINE_ID"[NUMBER,22], "PD"."PO_DISTRIBUTION_ID"[NUMBER,22], "PD"."PO_HEADER_ID"[NUMBER,22], "PD"."PO_LINE_ID"[NUMBER,22], "PD"."LINE_LOCATION_ID"[NUMBER,22], "PD"."CODE_COMBINATION_ID"[NUMBER,22], "PD"."REQ_DISTRIBUTION_ID"[NUMBER,22], "PD"."DELIVER_TO_LOCATION_ID"[NUMBER,22], "PD"."DELIVER_TO_PERSON_ID"[NUMBER,22], "PD"."DESTINATION_SUBINVENTORY"[VARCHAR2,10], "PD"."ATTRIBUTE15"[VARCHAR2,150], "PD"."ACCRUAL_ACCOUNT_ID"[NUMBER,22], "PD"."DISTRIBUTION_NUM"[NUMBER,22] 134 - "PH"."PO_HEADER_ID"[NUMBER,22], "PH"."AGENT_ID"[NUMBER,22], "PH"."TYPE_LOOKUP_CODE"[VARCHAR2,25], "PH"."SEGMENT1"[VARCHAR2,20], "PH"."SHIP_TO_LOCATION_ID"[NUMBER,22], "PH"."BILL_TO_LOCATION_ID"[NUMBER,22], "PH"."CURRENCY_CODE"[VARCHAR2,15], "PH"."RATE"[NUMBER,22], "PH"."AUTHORIZATION_STATUS"[VARCHAR2,25], "PH"."REVISION_NUM"[NUMBER,22], "PH"."COMMENTS"[VARCHAR2,240], "PH"."CLOSED_CODE"[VARCHAR2,25], "PH"."SYS_NC00152$"[DATE,7], "PL"."PO_LINE_ID"[NUMBER,22], "PL"."PO_HEADER_ID"[NUMBER,22], "PL"."LINE_NUM"[NUMBER,22], "PL"."ITEM_ID"[NUMBER,22], "PL"."ITEM_REVISION"[VARCHAR2,3], "PL"."ITEM_DESCRIPTION"[VARCHAR2,240], "PL"."UNIT_MEAS_LOOKUP_CODE"[VARCHAR2,25], "PL"."UNIT_PRICE"[NUMBER,22], "PL"."NOTE_TO_VENDOR"[VARCHAR2,480], "PL"."ATTRIBUTE1"[VARCHAR2,150], "PL"."ATTRIBUTE4"[VARCHAR2,150], "PL"."CLOSED_CODE"[VARCHAR2,25], "LINE_TYPE"[VARCHAR2,25], "VENDOR_NAME"[VARCHAR2,240], "PLL"."LINE_LOCATION_ID"[NUMBER,22], "PLL"."PO_HEADER_ID"[NUMBER,22], "PLL"."PO_LINE_ID"[NUMBER,22], "PLL"."QUANTITY"[NUMBER,22], "PLL"."QUANTITY_RECEIVED"[NUMBER,22], "PLL"."QUANTITY_CANCELLED"[NUMBER,22], "PLL"."NEED_BY_DATE"[DATE,7], "PLL"."PROMISED_DATE"[DATE,7], "PLL"."ATTRIBUTE1"[VARCHAR2,150], "PLL"."ATTRIBUTE2"[VARCHAR2,150], "PLL"."ATTRIBUTE3"[VARCHAR2,150], "PLL"."ATTRIBUTE5"[VARCHAR2,150], "PLL"."ATTRIBUTE6"[VARCHAR2,150], "PLL"."ATTRIBUTE7"[VARCHAR2,150], "PLL"."INSPECTION_REQUIRED_FLAG"[VARCHAR2,1], "PLL"."RECEIPT_REQUIRED_FLAG"[VARCHAR2,1], "PLL"."SHIP_TO_ORGANIZATION_ID"[NUMBER,22], "PLL"."SHIPMENT_NUM"[NUMBER,22], "PLL"."CLOSED_CODE"[VARCHAR2,30], "PLL"."RECEIVING_ROUTING_ID"[NUMBER,22], "PLL"."MATCH_OPTION"[VARCHAR2,25], "PLL"."NOTE_TO_RECEIVER"[VARCHAR2,480], "MP"."ORGANIZATION_CODE"[VARCHAR2,3], "MP"."CALENDAR_CODE"[VARCHAR2,10], "PVS"."VENDOR_SITE_CODE"[VARCHAR2,15], "ODS"."LINE_ID"[NUMBER,22] 135 - "PH"."PO_HEADER_ID"[NUMBER,22], "PH"."AGENT_ID"[NUMBER,22], "PH"."TYPE_LOOKUP_CODE"[VARCHAR2,25], "PH"."SEGMENT1"[VARCHAR2,20], "PH"."SHIP_TO_LOCATION_ID"[NUMBER,22], "PH"."BILL_TO_LOCATION_ID"[NUMBER,22], "PH"."CURRENCY_CODE"[VARCHAR2,15], "PH"."RATE"[NUMBER,22], "PH"."AUTHORIZATION_STATUS"[VARCHAR2,25], "PH"."REVISION_NUM"[NUMBER,22], "PH"."COMMENTS"[VARCHAR2,240], "PH"."CLOSED_CODE"[VARCHAR2,25], "PH"."SYS_NC00152$"[DATE,7], "PL"."PO_LINE_ID"[NUMBER,22], "PL"."PO_HEADER_ID"[NUMBER,22], "PL"."LINE_NUM"[NUMBER,22], "PL"."ITEM_ID"[NUMBER,22], "PL"."ITEM_REVISION"[VARCHAR2,3], "PL"."ITEM_DESCRIPTION"[VARCHAR2,240], "PL"."UNIT_MEAS_LOOKUP_CODE"[VARCHAR2,25], "PL"."UNIT_PRICE"[NUMBER,22], "PL"."NOTE_TO_VENDOR"[VARCHAR2,480], "PL"."ATTRIBUTE1"[VARCHAR2,150], "PL"."ATTRIBUTE4"[VARCHAR2,150], "PL"."CLOSED_CODE"[VARCHAR2,25], "LINE_TYPE"[VARCHAR2,25], "VENDOR_NAME"[VARCHAR2,240], "PLL"."LINE_LOCATION_ID"[NUMBER,22], "PLL"."PO_HEADER_ID"[NUMBER,22], "PLL"."PO_LINE_ID"[NUMBER,22], "PLL"."QUANTITY"[NUMBER,22], "PLL"."QUANTITY_RECEIVED"[NUMBER,22], "PLL"."QUANTITY_CANCELLED"[NUMBER,22], "PLL"."NEED_BY_DATE"[DATE,7], "PLL"."PROMISED_DATE"[DATE,7], "PLL"."ATTRIBUTE1"[VARCHAR2,150], "PLL"."ATTRIBUTE2"[VARCHAR2,150], "PLL"."ATTRIBUTE3"[VARCHAR2,150], "PLL"."ATTRIBUTE5"[VARCHAR2,150], "PLL"."ATTRIBUTE6"[VARCHAR2,150], "PLL"."ATTRIBUTE7"[VARCHAR2,150], "PLL"."INSPECTION_REQUIRED_FLAG"[VARCHAR2,1], "PLL"."RECEIPT_REQUIRED_FLAG"[VARCHAR2,1], "PLL"."SHIP_TO_ORGANIZATION_ID"[NUMBER,22], "PLL"."SHIPMENT_NUM"[NUMBER,22], "PLL"."CLOSED_CODE"[VARCHAR2,30], "PLL"."RECEIVING_ROUTING_ID"[NUMBER,22], "PLL"."MATCH_OPTION"[VARCHAR2,25], "PLL"."NOTE_TO_RECEIVER"[VARCHAR2,480], "MP"."ORGANIZATION_CODE"[VARCHAR2,3], "MP"."CALENDAR_CODE"[VARCHAR2,10], "PVS"."VENDOR_SITE_CODE"[VARCHAR2,15] 136 - "PH"."PO_HEADER_ID"[NUMBER,22], "PH"."AGENT_ID"[NUMBER,22], "PH"."TYPE_LOOKUP_CODE"[VARCHAR2,25], "PH"."SEGMENT1"[VARCHAR2,20], "PH"."VENDOR_SITE_ID"[NUMBER,22], "PH"."SHIP_TO_LOCATION_ID"[NUMBER,22], "PH"."BILL_TO_LOCATION_ID"[NUMBER,22], "PH"."CURRENCY_CODE"[VARCHAR2,15], "PH"."RATE"[NUMBER,22], "PH"."AUTHORIZATION_STATUS"[VARCHAR2,25], "PH"."REVISION_NUM"[NUMBER,22], "PH"."COMMENTS"[VARCHAR2,240], "PH"."CLOSED_CODE"[VARCHAR2,25], "PH"."SYS_NC00152$"[DATE,7], "PL"."PO_LINE_ID"[NUMBER,22], "PL"."PO_HEADER_ID"[NUMBER,22], "PL"."LINE_NUM"[NUMBER,22], "PL"."ITEM_ID"[NUMBER,22], "PL"."ITEM_REVISION"[VARCHAR2,3], "PL"."ITEM_DESCRIPTION"[VARCHAR2,240], "PL"."UNIT_MEAS_LOOKUP_CODE"[VARCHAR2,25], "PL"."UNIT_PRICE"[NUMBER,22], "PL"."NOTE_TO_VENDOR"[VARCHAR2,480], "PL"."ATTRIBUTE1"[VARCHAR2,150], "PL"."ATTRIBUTE4"[VARCHAR2,150], "PL"."CLOSED_CODE"[VARCHAR2,25], "LINE_TYPE"[VARCHAR2,25], "VENDOR_NAME"[VARCHAR2,240], "PLL"."LINE_LOCATION_ID"[NUMBER,22], "PLL"."PO_HEADER_ID"[NUMBER,22], "PLL"."PO_LINE_ID"[NUMBER,22], "PLL"."QUANTITY"[NUMBER,22], "PLL"."QUANTITY_RECEIVED"[NUMBER,22], "PLL"."QUANTITY_CANCELLED"[NUMBER,22], "PLL"."NEED_BY_DATE"[DATE,7], "PLL"."PROMISED_DATE"[DATE,7], "PLL"."ATTRIBUTE1"[VARCHAR2,150], "PLL"."ATTRIBUTE2"[VARCHAR2,150], "PLL"."ATTRIBUTE3"[VARCHAR2,150], "PLL"."ATTRIBUTE5"[VARCHAR2,150], "PLL"."ATTRIBUTE6"[VARCHAR2,150], "PLL"."ATTRIBUTE7"[VARCHAR2,150], "PLL"."INSPECTION_REQUIRED_FLAG"[VARCHAR2,1], "PLL"."RECEIPT_REQUIRED_FLAG"[VARCHAR2,1], "PLL"."SHIP_TO_ORGANIZATION_ID"[NUMBER,22], "PLL"."SHIPMENT_NUM"[NUMBER,22], "PLL"."CLOSED_CODE"[VARCHAR2,30], "PLL"."RECEIVING_ROUTING_ID"[NUMBER,22], "PLL"."MATCH_OPTION"[VARCHAR2,25], "PLL"."NOTE_TO_RECEIVER"[VARCHAR2,480], "MP"."ORGANIZATION_CODE"[VARCHAR2,3], "MP"."CALENDAR_CODE"[VARCHAR2,10] 137 - "PH"."PO_HEADER_ID"[NUMBER,22], "PH"."AGENT_ID"[NUMBER,22], "PH"."TYPE_LOOKUP_CODE"[VARCHAR2,25], "PH"."SEGMENT1"[VARCHAR2,20], "PH"."VENDOR_SITE_ID"[NUMBER,22], "PH"."SHIP_TO_LOCATION_ID"[NUMBER,22], "PH"."BILL_TO_LOCATION_ID"[NUMBER,22], "PH"."CURRENCY_CODE"[VARCHAR2,15], "PH"."RATE"[NUMBER,22], "PH"."AUTHORIZATION_STATUS"[VARCHAR2,25], "PH"."REVISION_NUM"[NUMBER,22], "PH"."COMMENTS"[VARCHAR2,240], "PH"."CLOSED_CODE"[VARCHAR2,25], "PH"."SYS_NC00152$"[DATE,7], "PL"."PO_LINE_ID"[NUMBER,22], "PL"."PO_HEADER_ID"[NUMBER,22], "PL"."LINE_NUM"[NUMBER,22], "PL"."ITEM_ID"[NUMBER,22], "PL"."ITEM_REVISION"[VARCHAR2,3], "PL"."ITEM_DESCRIPTION"[VARCHAR2,240], "PL"."UNIT_MEAS_LOOKUP_CODE"[VARCHAR2,25], "PL"."UNIT_PRICE"[NUMBER,22], "PL"."NOTE_TO_VENDOR"[VARCHAR2,480], "PL"."ATTRIBUTE1"[VARCHAR2,150], "PL"."ATTRIBUTE4"[VARCHAR2,150], "PL"."CLOSED_CODE"[VARCHAR2,25], "LINE_TYPE"[VARCHAR2,25], "VENDOR_NAME"[VARCHAR2,240], "PLL"."LINE_LOCATION_ID"[NUMBER,22], "PLL"."PO_HEADER_ID"[NUMBER,22], "PLL"."PO_LINE_ID"[NUMBER,22], "PLL"."QUANTITY"[NUMBER,22], "PLL"."QUANTITY_RECEIVED"[NUMBER,22], "PLL"."QUANTITY_CANCELLED"[NUMBER,22], "PLL"."NEED_BY_DATE"[DATE,7], "PLL"."PROMISED_DATE"[DATE,7], "PLL"."ATTRIBUTE1"[VARCHAR2,150], "PLL"."ATTRIBUTE2"[VARCHAR2,150], "PLL"."ATTRIBUTE3"[VARCHAR2,150], "PLL"."ATTRIBUTE5"[VARCHAR2,150], "PLL"."ATTRIBUTE6"[VARCHAR2,150], "PLL"."ATTRIBUTE7"[VARCHAR2,150], "PLL"."INSPECTION_REQUIRED_FLAG"[VARCHAR2,1], "PLL"."RECEIPT_REQUIRED_FLAG"[VARCHAR2,1], "PLL"."SHIP_TO_ORGANIZATION_ID"[NUMBER,22], "PLL"."SHIPMENT_NUM"[NUMBER,22], "PLL"."CLOSED_CODE"[VARCHAR2,30], "PLL"."RECEIVING_ROUTING_ID"[NUMBER,22], "PLL"."MATCH_OPTION"[VARCHAR2,25], "PLL"."NOTE_TO_RECEIVER"[VARCHAR2,480] 138 - "PH"."PO_HEADER_ID"[NUMBER,22], "PH"."AGENT_ID"[NUMBER,22], "PH"."TYPE_LOOKUP_CODE"[VARCHAR2,25], "PH"."SEGMENT1"[VARCHAR2,20], "PH"."VENDOR_SITE_ID"[NUMBER,22], "PH"."SHIP_TO_LOCATION_ID"[NUMBER,22], "PH"."BILL_TO_LOCATION_ID"[NUMBER,22], "PH"."CURRENCY_CODE"[VARCHAR2,15], "PH"."RATE"[NUMBER,22], "PH"."AUTHORIZATION_STATUS"[VARCHAR2,25], "PH"."REVISION_NUM"[NUMBER,22], "PH"."COMMENTS"[VARCHAR2,240], "PH"."CLOSED_CODE"[VARCHAR2,25], "PH"."SYS_NC00152$"[DATE,7], "PL"."PO_LINE_ID"[NUMBER,22], "PL"."PO_HEADER_ID"[NUMBER,22], "PL"."LINE_NUM"[NUMBER,22], "PL"."ITEM_ID"[NUMBER,22], "PL"."ITEM_REVISION"[VARCHAR2,3], "PL"."ITEM_DESCRIPTION"[VARCHAR2,240], "PL"."UNIT_MEAS_LOOKUP_CODE"[VARCHAR2,25], "PL"."UNIT_PRICE"[NUMBER,22], "PL"."NOTE_TO_VENDOR"[VARCHAR2,480], "PL"."ATTRIBUTE1"[VARCHAR2,150], "PL"."ATTRIBUTE4"[VARCHAR2,150], "PL"."CLOSED_CODE"[VARCHAR2,25], "LINE_TYPE"[VARCHAR2,25], "VENDOR_NAME"[VARCHAR2,240] 139 - "PH"."PO_HEADER_ID"[NUMBER,22], "PH"."AGENT_ID"[NUMBER,22], "PH"."TYPE_LOOKUP_CODE"[VARCHAR2,25], "PH"."SEGMENT1"[VARCHAR2,20], "PH"."VENDOR_ID"[NUMBER,22], "PH"."VENDOR_SITE_ID"[NUMBER,22], "PH"."SHIP_TO_LOCATION_ID"[NUMBER,22], "PH"."BILL_TO_LOCATION_ID"[NUMBER,22], "PH"."CURRENCY_CODE"[VARCHAR2,15], "PH"."RATE"[NUMBER,22], "PH"."AUTHORIZATION_STATUS"[VARCHAR2,25], "PH"."REVISION_NUM"[NUMBER,22], "PH"."COMMENTS"[VARCHAR2,240], "PH"."CLOSED_CODE"[VARCHAR2,25], "PH"."SYS_NC00152$"[DATE,7], "PL"."PO_LINE_ID"[NUMBER,22], "PL"."PO_HEADER_ID"[NUMBER,22], "PL"."LINE_NUM"[NUMBER,22], "PL"."ITEM_ID"[NUMBER,22], "PL"."ITEM_REVISION"[VARCHAR2,3], "PL"."ITEM_DESCRIPTION"[VARCHAR2,240], "PL"."UNIT_MEAS_LOOKUP_CODE"[VARCHAR2,25], "PL"."UNIT_PRICE"[NUMBER,22], "PL"."NOTE_TO_VENDOR"[VARCHAR2,480], "PL"."ATTRIBUTE1"[VARCHAR2,150], "PL"."ATTRIBUTE4"[VARCHAR2,150], "PL"."CLOSED_CODE"[VARCHAR2,25], "LINE_TYPE"[VARCHAR2,25] 140 - "PH"."PO_HEADER_ID"[NUMBER,22], "PH"."AGENT_ID"[NUMBER,22], "PH"."TYPE_LOOKUP_CODE"[VARCHAR2,25], "PH"."SEGMENT1"[VARCHAR2,20], "PH"."VENDOR_ID"[NUMBER,22], "PH"."VENDOR_SITE_ID"[NUMBER,22], "PH"."SHIP_TO_LOCATION_ID"[NUMBER,22], "PH"."BILL_TO_LOCATION_ID"[NUMBER,22], "PH"."CURRENCY_CODE"[VARCHAR2,15], "PH"."RATE"[NUMBER,22], "PH"."AUTHORIZATION_STATUS"[VARCHAR2,25], "PH"."REVISION_NUM"[NUMBER,22], "PH"."COMMENTS"[VARCHAR2,240], "PH"."CLOSED_CODE"[VARCHAR2,25], "PH"."SYS_NC00152$"[DATE,7], "PL"."PO_LINE_ID"[NUMBER,22], "PL"."PO_HEADER_ID"[NUMBER,22], "PL"."LINE_TYPE_ID"[NUMBER,22], "PL"."LINE_NUM"[NUMBER,22], "PL"."ITEM_ID"[NUMBER,22], "PL"."ITEM_REVISION"[VARCHAR2,3], "PL"."ITEM_DESCRIPTION"[VARCHAR2,240], "PL"."UNIT_MEAS_LOOKUP_CODE"[VARCHAR2,25], "PL"."UNIT_PRICE"[NUMBER,22], "PL"."NOTE_TO_VENDOR"[VARCHAR2,480], "PL"."ATTRIBUTE1"[VARCHAR2,150], "PL"."ATTRIBUTE4"[VARCHAR2,150], "PL"."CLOSED_CODE"[VARCHAR2,25] 141 - "PH"."PO_HEADER_ID"[NUMBER,22], "PH"."AGENT_ID"[NUMBER,22], "PH"."TYPE_LOOKUP_CODE"[VARCHAR2,25], "PH"."SEGMENT1"[VARCHAR2,20], "PH"."VENDOR_ID"[NUMBER,22], "PH"."VENDOR_SITE_ID"[NUMBER,22], "PH"."SHIP_TO_LOCATION_ID"[NUMBER,22], "PH"."BILL_TO_LOCATION_ID"[NUMBER,22], "PH"."CURRENCY_CODE"[VARCHAR2,15], "PH"."RATE"[NUMBER,22], "PH"."AUTHORIZATION_STATUS"[VARCHAR2,25], "PH"."REVISION_NUM"[NUMBER,22], "PH"."COMMENTS"[VARCHAR2,240], "PH"."CLOSED_CODE"[VARCHAR2,25], "PH"."SYS_NC00152$"[DATE,7] 142 - "PH".ROWID[ROWID,10], "PH"."SYS_NC00152$"[DATE,7] 143 - "PL"."PO_LINE_ID"[NUMBER,22], "PL"."PO_HEADER_ID"[NUMBER,22], "PL"."LINE_TYPE_ID"[NUMBER,22], "PL"."LINE_NUM"[NUMBER,22], "PL"."ITEM_ID"[NUMBER,22], "PL"."ITEM_REVISION"[VARCHAR2,3], "PL"."ITEM_DESCRIPTION"[VARCHAR2,240], "PL"."UNIT_MEAS_LOOKUP_CODE"[VARCHAR2,25], "PL"."UNIT_PRICE"[NUMBER,22], "PL"."NOTE_TO_VENDOR"[VARCHAR2,480], "PL"."ATTRIBUTE1"[VARCHAR2,150], "PL"."ATTRIBUTE4"[VARCHAR2,150], "PL"."CLOSED_CODE"[VARCHAR2,25] 144 - "PL".ROWID[ROWID,10], "PL"."PO_HEADER_ID"[NUMBER,22] 145 - "LINE_TYPE"[VARCHAR2,25] 146 - "PO_LINE_TYPES_TL".ROWID[ROWID,10] 147 - "VENDOR_NAME"[VARCHAR2,240] 148 - "AP_SUPPLIERS".ROWID[ROWID,10] 149 - "PLL"."LINE_LOCATION_ID"[NUMBER,22], "PLL"."PO_HEADER_ID"[NUMBER,22], "PLL"."PO_LINE_ID"[NUMBER,22], "PLL"."QUANTITY"[NUMBER,22], "PLL"."QUANTITY_RECEIVED"[NUMBER,22], "PLL"."QUANTITY_CANCELLED"[NUMBER,22], "PLL"."NEED_BY_DATE"[DATE,7], "PLL"."PROMISED_DATE"[DATE,7], "PLL"."ATTRIBUTE1"[VARCHAR2,150], "PLL"."ATTRIBUTE2"[VARCHAR2,150], "PLL"."ATTRIBUTE3"[VARCHAR2,150], "PLL"."ATTRIBUTE5"[VARCHAR2,150], "PLL"."ATTRIBUTE6"[VARCHAR2,150], "PLL"."ATTRIBUTE7"[VARCHAR2,150], "PLL"."INSPECTION_REQUIRED_FLAG"[VARCHAR2,1], "PLL"."RECEIPT_REQUIRED_FLAG"[VARCHAR2,1], "PLL"."SHIP_TO_ORGANIZATION_ID"[NUMBER,22], "PLL"."SHIPMENT_NUM"[NUMBER,22], "PLL"."CLOSED_CODE"[VARCHAR2,30], "PLL"."RECEIVING_ROUTING_ID"[NUMBER,22], "PLL"."MATCH_OPTION"[VARCHAR2,25], "PLL"."NOTE_TO_RECEIVER"[VARCHAR2,480] 150 - "PLL".ROWID[ROWID,10], "PLL"."PO_HEADER_ID"[NUMBER,22] 151 - "MP"."ORGANIZATION_CODE"[VARCHAR2,3], "MP"."CALENDAR_CODE"[VARCHAR2,10] 152 - "MP".ROWID[ROWID,10] 153 - "PVS"."VENDOR_SITE_CODE"[VARCHAR2,15] 154 - "PVS".ROWID[ROWID,10] 155 - "ODS"."LINE_ID"[NUMBER,22] 156 - "ODS".ROWID[ROWID,10] 157 - "PD"."PO_DISTRIBUTION_ID"[NUMBER,22], "PD"."PO_HEADER_ID"[NUMBER,22], "PD"."PO_LINE_ID"[NUMBER,22], "PD"."LINE_LOCATION_ID"[NUMBER,22], "PD"."CODE_COMBINATION_ID"[NUMBER,22], "PD"."REQ_DISTRIBUTION_ID"[NUMBER,22], "PD"."DELIVER_TO_LOCATION_ID"[NUMBER,22], "PD"."DELIVER_TO_PERSON_ID"[NUMBER,22], "PD"."DESTINATION_SUBINVENTORY"[VARCHAR2,10], "PD"."ATTRIBUTE15"[VARCHAR2,150], "PD"."ACCRUAL_ACCOUNT_ID"[NUMBER,22], "PD"."DISTRIBUTION_NUM"[NUMBER,22] 158 - "PD".ROWID[ROWID,10], "PD"."PO_LINE_ID"[NUMBER,22] 159 - "PRDA"."REQUISITION_LINE_ID"[NUMBER,22] 160 - "PRDA".ROWID[ROWID,10] 161 - "POA"."ACTION"[VARCHAR2,240], "POA"."ACTION_DATE"[DATE,7], "POA"."ACCEPTED_FLAG"[VARCHAR2,1], "POA"."ACCEPTANCE_LOOKUP_CODE"[VARCHAR2,25] 162 - "POA".ROWID[ROWID,10] 163 - "OEL"."HEADER_ID"[NUMBER,22], "OEL"."LINE_NUMBER"[NUMBER,22] 164 - "OEL".ROWID[ROWID,10] 165 - "OEH"."ORDER_NUMBER"[NUMBER,22] 166 - "PRLA"."REQUISITION_HEADER_ID"[NUMBER,22], "PRLA"."LINE_NUM"[NUMBER,22] 167 - "PRLA".ROWID[ROWID,10] 168 - "PRHA"."SEGMENT1"[VARCHAR2,20] 169 - "PRHA".ROWID[ROWID,10] 170 - "ZXL"."TRX_ID"[NUMBER,22], "ZXL"."TRX_LINE_ID"[NUMBER,22] 171 - "ZXD"."INPUT_TAX_CLASSIFICATION_CODE"[VARCHAR2,50] 172 - "ZXD".ROWID[ROWID,10] 173 - (#keys=0) MAX("PD2"."DISTRIBUTION_NUM")[22] 174 - "PD2"."DISTRIBUTION_NUM"[NUMBER,22] 175 - "PD2".ROWID[ROWID,10] Hint Report (identified by operation id / Query Block Name / Object Alias): Total hints for statement: 1 (E - Syntax error (1)) --------------------------------------------------------------------------- 0 - SEL$1 E - NK2 Query Block Registry: ---------------------

VW

VW< /h>

VW

VW

VW

VW

VW

VW< /h>

VW

VW

VW< /f>

VW< /h>

VW

VW

VW

VW

VW

VW

VW< /f>

VWVW

VW

VW

VW

VW

VWVW

VW< /h>

VW