PLAN HASH VALUE: 3822504630 --------------------------------------------------------------------------------------------------------------------------------- | ID | Operation | NAME | ROWS | BYTES |TempSpc| COST (%CPU)| TIME | --------------------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 55559 | 113M| | 64714 (3)| 00:03:22 | | 1 | SORT AGGREGATE | | 1 | 12 | | | | |* 2 | TABLE ACCESS FULL | RCV_ROLL_TRANSACTIONS | 2289 | 27468 | | 125 (5)| 00:00:01 | |* 3 | HASH JOIN | | 55559 | 113M| | 64714 (3)| 00:03:22 | | 4 | VIEW | MATERIAL_SUBINVENTORY_V | 27 | 27405 | | 2 (0)| 00:00:01 | | 5 | UNION-ALL | | | | | | | |* 6 | FILTER | | | | | | | |* 7 | INDEX FAST FULL SCAN | SUPPLIER_IDX | 778 | 20228 | | 2 (0)| 00:00:01 | | 8 | TABLE ACCESS BY INDEX ROWID | FND_FLEX_VALUES | 26 | 962 | | 2 (0)| 00:00:01 | |* 9 | INDEX RANGE SCAN | FND_FLEX_VALUES_IDX | 26 | | | 1 (0)| 00:00:01 | |* 10 | HASH JOIN RIGHT OUTER | | 30866 | 32M| | 64711 (3)| 00:03:22 | | 11 | VIEW | | 2144 | 228K| | 4734 (4)| 00:00:15 | | 12 | HASH GROUP BY | | 2144 | 481K| | 4734 (4)| 00:00:15 | |* 13 | HASH JOIN | | 2144 | 481K| | 4732 (4)| 00:00:15 | |* 14 | HASH JOIN | | 2144 | 209K| 2080K| 4166 (4)| 00:00:13 | |* 15 | TABLE ACCESS FULL | PACKING_CARTONS | 50522 | 1480K| | 2040 (5)| 00:00:07 | | 16 | VIEW | | 83301 | 5694K| | 1975 (3)| 00:00:07 | | 17 | SORT UNIQUE | | 83301 | 8089K| 9472K| 1975 (3)| 00:00:07 | | 18 | UNION-ALL | | | | | | | |* 19 | HASH JOIN | | 21672 | 2010K| | 168 (9)| 00:00:01 | | 20 | TABLE ACCESS FULL | ORDER_PACKING_DEFINITION | 5045 | 256K| | 15 (7)| 00:00:01 | |* 21 | TABLE ACCESS FULL | ITEM# | 42964 | 1804K| | 152 (8)| 00:00:01 | |* 22 | HASH JOIN | | 61629 | 6078K| | 173 (7)| 00:00:01 | | 23 | TABLE ACCESS FULL | ORDER_PACKING_DEFINITION | 5045 | 256K| | 15 (7)| 00:00:01 | |* 24 | TABLE ACCESS FULL | PACKING_COMBINATION_IDS_LOOSE | 61629 | 2949K| | 157 (6)| 00:00:01 | | 25 | TABLE ACCESS FULL | ITEMS | 76611 | 9726K| | 564 (3)| 00:00:02 | |* 26 | HASH JOIN RIGHT OUTER | | 30866 | 29M| | 59976 (3)| 00:03:07 | | 27 | VIEW | | 958 | 187K| | 10629 (3)| 00:00:34 | | 28 | HASH GROUP BY | | 958 | 59396 | | 10629 (3)| 00:00:34 | |* 29 | TABLE ACCESS FULL | MOVE_ORDER_LINES | 958 | 59396 | | 10628 (3)| 00:00:34 | |* 30 | HASH JOIN OUTER | | 30866 | 23M| 18M| 49346 (3)| 00:02:34 | |* 31 | HASH JOIN OUTER | | 30866 | 17M| 12M| 28194 (3)| 00:01:28 | |* 32 | HASH JOIN RIGHT OUTER | | 30866 | 12M| | 717 (5)| 00:00:03 | | 33 | VIEW | | 14 | 2800 | | 321 (6)| 00:00:01 | | 34 | HASH GROUP BY | | 14 | 812 | | 321 (6)| 00:00:01 | |* 35 | TABLE ACCESS FULL | ORDER_PEGGING | 14 | 812 | | 320 (5)| 00:00:01 | |* 36 | HASH JOIN | | 30866 | 6329K| | 396 (4)| 00:00:02 | | 37 | TABLE ACCESS FULL | MATERIAL_ONHAND_QUANTITIES | 30866 | 1657K| | 85 (6)| 00:00:01 | | 38 | INDEX FAST FULL SCAN | ITEMS_IDX | 76611 | 11M| | 308 (2)| 00:00:01 | | 39 | VIEW | | 673K| 128M| | 24922 (3)| 00:01:18 | | 40 | HASH GROUP BY | | 673K| 71M| 83M| 24922 (3)| 00:01:18 | |* 41 | HASH JOIN RIGHT OUTER | | 673K| 71M| | 10342 (4)| 00:00:33 | | 42 | VIEW | | 194 | 10476 | | 1481 (4)| 00:00:05 | |* 43 | HASH JOIN OUTER | | 194 | 17266 | | 1481 (4)| 00:00:05 | | 44 | NESTED LOOPS OUTER | | 194 | 14744 | | 1449 (4)| 00:00:05 | | 45 | NESTED LOOPS OUTER | | 194 | 10476 | | 1061 (5)| 00:00:04 | | 46 | NESTED LOOPS | | 194 | 7760 | | 866 (5)| 00:00:03 | |* 47 | TABLE ACCESS FULL | DYED_INSPECTION_REPORT_D | 194 | 6790 | | 866 (5)| 00:00:03 | |* 48 | INDEX UNIQUE SCAN | DYED_INSPECTION_REP_M_PK | 1 | 5 | | 0 (0)| 00:00:01 | | 49 | TABLE ACCESS BY INDEX ROWID| ITEMS | 1 | 14 | | 1 (0)| 00:00:01 | |* 50 | INDEX UNIQUE SCAN | ITEMS_PK | 1 | | | 0 (0)| 00:00:01 | | 51 | TABLE ACCESS BY INDEX ROWID | RCV_TRANSACTIONS | 1 | 22 | | 2 (0)| 00:00:01 | |* 52 | INDEX UNIQUE SCAN | RCV_TRANSACTIONS_PK | 1 | | | 1 (0)| 00:00:01 | | 53 | VIEW | | 41898 | 531K| | 31 (10)| 00:00:01 | |* 54 | HASH JOIN | | 41898 | 531K| | 31 (10)| 00:00:01 | | 55 | INDEX FAST FULL SCAN | SUPPLIER_IDX | 779 | 3116 | | 2 (0)| 00:00:01 | | 56 | INDEX FAST FULL SCAN | POM_IDX | 41898 | 368K| | 27 (4)| 00:00:01 | |* 57 | TABLE ACCESS FULL | RCV_TRANSACTIONS | 673K| 36M| | 8845 (4)| 00:00:28 | | 58 | VIEW | | 619K| 118M| | 18687 (3)| 00:00:59 | | 59 | HASH GROUP BY | | 619K| 36M| 52M| 18687 (3)| 00:00:59 | |* 60 | TABLE ACCESS FULL | MOVE_ORDER_LINES | 619K| 36M| | 10673 (4)| 00:00:34 | --------------------------------------------------------------------------------------------------------------------------------- Predicate Information (IDENTIFIED BY operation ID): --------------------------------------------------- 2 - filter(:B1 LIKE "ROLL_NUMBER"||'%') 3 - access("SUBINVENTORY_CODE"=TO_NUMBER("MOQ"."SUBINVENTORY_CODE")) 6 - filter(NULL IS NOT NULL) 7 - filter("SUPPLIER_NAME" IS NOT NULL) 9 - access("FLEX_VALUE_SET_ID"=106 AND "ENABLED_FLAG"='Y') 10 - access("MOQ"."LOT_NUMBER"="P"."LOT_NUMBER"(+) AND "MOQ"."ORDER_NUMBER"="P"."ORDER_NUMBER"(+) AND "MOQ"."SUBINVENTORY_CODE"="P"."SUBINVENTORY"(+) AND "MOQ"."UNIT_OF_MEASURE"="P"."UNIT_OF_MEASURE"(+) AND "MOQ"."ITEM_CODE"="P"."ITEM_CODE"(+)) 13 - access("OI"."ITEM_ID"="I"."ITEM_ID") 14 - access("PC"."ORDER#"="OI"."ORDER#" AND "PC"."COMBINATION_ID"="OI"."COMBINATION_ID") 15 - filter("PC"."LOADED_IN_CONTAINER"='NO' AND "PC"."PACKING_STATUS"='PACKED') 19 - access("I"."ORDER#"="OPD"."ORDER#") 21 - filter("I"."ITEM_ID" IS NOT NULL AND "I"."QTY" IS NOT NULL) 22 - access("PCL"."ORDER#"="OPD"."ORDER#") 24 - filter("PCL"."ITEM_ID" IS NOT NULL) 26 - access(NVL("MOQ"."ROLL_NUMBER",'0')=NVL("PM"."ROLL_NUMBER"(+),'0') AND NVL("MOQ"."LOT_NUMBER",'0')=NVL("PM"."LOT_NUMBER"(+),'0') AND NVL("MOQ"."ORDER_NUMBER",'0')=NVL("PM"."ORDER_NUMBER"(+),'0') AND "MOQ"."SUBINVENTORY_CODE"="PM"."FROM_SUBINVENTORY"(+) AND "MOQ"."UNIT_OF_MEASURE"="PM"."UNIT_OF_MEASURE"(+) AND "MOQ"."ITEM_CODE"="PM"."ITEM_CODE"(+)) 29 - filter("LINE_STATUS"='Incomplete' OR "LINE_STATUS"='Pending') 30 - access(NVL("MOQ"."ROLL_NUMBER",'0')=NVL("TM"."ROLL_NUMBER"(+),'0') AND NVL("MOQ"."LOT_NUMBER",'0')=NVL("TM"."LOT_NUMBER"(+),'0') AND NVL("MOQ"."ORDER_NUMBER",'0')=NVL("TM"."ORDER_NUMBER"(+),'0') AND "MOQ"."SUBINVENTORY_CODE"="TM"."FROM_SUBINVENTORY"(+) AND "MOQ"."UNIT_OF_MEASURE"="TM"."UNIT_OF_MEASURE"(+) AND "MOQ"."ITEM_CODE"="TM"."ITEM_CODE"(+)) 31 - access(NVL("MOQ"."ROLL_NUMBER",'0')=NVL("INS"."ROLL_NUMBER"(+),'0') AND NVL("MOQ"."LOT_NUMBER",'0')=NVL("INS"."LOT_NUMBER"(+),'0') AND NVL("MOQ"."ORDER_NUMBER",'0')=NVL("INS"."ORDER_NUMBER"(+),'0') AND "MOQ"."SUBINVENTORY_CODE"="INS"."SUBINVENTORY"(+) AND "MOQ"."UNIT_OF_MEASURE"="INS"."UNIT_OF_MEASURE"(+) AND "MOQ"."ITEM_CODE"="INS"."ITEM_CODE"(+)) 32 - access(NVL("MOQ"."ROLL_NUMBER",'0')=NVL("UPG"."ROLL_NUMBER"(+),'0') AND NVL("MOQ"."LOT_NUMBER",'0')=NVL("UPG"."LOT_NUMBER"(+),'0') AND NVL("MOQ"."ORDER_NUMBER",'0')=NVL("UPG"."ORDER_NUMBER"(+),'0') AND "MOQ"."SUBINVENTORY_CODE"="UPG"."SUBINVENTORY"(+) AND "MOQ"."UNIT_OF_MEASURE"="UPG"."UNIT_OF_MEASURE"(+) AND "MOQ"."ITEM_CODE"="UPG"."ITEM_CODE"(+)) 35 - filter("OP"."LINE_STATUS"='Pending') 36 - access("MOQ"."ITEM_CODE"="ITEM_CODE") 41 - access("RT"."ROLL_NUMBER"="DT"."ROLL_NUMBER"(+) AND "RT"."LOT_NUMBER"="DT"."LOT_NUMBER"(+) AND "RT"."ORDER_NUMBER"="DT"."ORDER_NUMBER"(+) AND "RT"."ITEM_CODE"="DT"."ITEM_CODE"(+)) 43 - access("RCV"."PONO"="PS"."PONO"(+)) 47 - filter("DID"."OK_REJECT"='PARTIAL') 48 - access("DIM"."REPORT_NUMBER"="DID"."REPORT_NUMBER") 50 - access("DID"."ITEM_ID"="I"."ITEM_ID"(+)) 52 - access("DID"."RCV_TRANSACTION_ID"="RCV"."RCV_TRANSACTION_ID"(+)) 54 - access("S"."SUPPLIER_CODE"=TO_NUMBER("POM"."SID")) 57 - filter("RT"."TRANSACTION_TYPE"='ACCEPTED') 60 - filter(("FROM_SUBINVENTORY"='100009' OR "FROM_SUBINVENTORY"='100024') AND "LINE_STATUS"='Transacted')