OPERATIOOPTIONS OBJECT_NOBJECT_OOBJECT_NOBJECT_IOBJECT_TOPTIMIZESEARCH_CID PARENTIDPOSITIONCOST CARDINALBYTES CPU_COSTIO_COST ACCESS_PFILTER_PREDICATES 1SELECT STATEMENT CHOOSE 0 26 26 8 1160 5 25 2VIEW SYS 1 0 1 26 8 1160 3SORT UNIQUE 2 1 1 26 8 3256 5 25 4FILTER 3 2 1 MIN((TO_NUMBER(DECODE(RPAD("SYS_ALIAS_2"."DEFAULT_LOCATION",8),"B"."INVENTORY_LOCATION",TO_CHAR("B"."INVENTORY_QTY"),'0'))+"PSS"."REPORT_PKG"."INCOMPLETE_SKITS_FNC"("SYS_ALIAS_1"."END_ITEM_PART_NUMBER","SYS_ALIAS_1"."SITE_CODE","SYS_ALIAS_1"."SUB_KIT_CODE","SYS_ALIAS_2"."DEFAULT_LOCATION","SYS_ALIAS_1"."PART_NUMBER"))/DECODE(NVL("D"."KIT_QTY",0),0,"B"."INVENTORY_QTY"+1,"D"."KIT_QTY"))>=1 5SORT GROUP BY 4 3 1 26 8 3256 5 25 6NESTED LOOPS 5 4 1 11 157 63899 5 10 7NESTED LOOPS 6 5 1 10 1 387 5 9 8NESTED LOOPS 7 6 1 9 1 353 5 8 9NESTED LOOPS 8 7 1 8 1 303 4 7 10NESTED LOOPS 9 8 1 7 5 1290 3 6 11NESTED LOOPS 10 9 1 6 1 201 2 5 12NESTED LOOPS 11 10 1 5 1 137 1 4 13TABLE ACFULL PSS PSS_KIT_ 3 ANALYZED 12 11 1 3 1 66 3 LTRIM(RTRIM("SYS_ALIAS_2"."DEFAULT_LOCATION"))=LTRIM(RTRIM("SYS_ALIAS_2"."DEFAULT_LOCATI 14INDEX RANGE SCAN PSS PSS_SUB_KIT_STRUUNIQUE ANALYZED 3 13 11 2 1 5 355 1"SYS_ALI"SYS_ALIAS_1"."SITE_CODE"='E' 15TABLE ACBY INDEX ROWID PSS PSS_INVE 2 ANALYZED 14 10 2 2 3 192 1 1 "SYS_ALIAS_2"."DEFAULT_LOCATION"="B"."INVENTORY_LOCATION" 16INDEX RANGE SCAN PSS PSS_INVENTORY_PKUNIQUE ANALYZED 2 15 14 1 1 3 1"SYS_ALI"SYS_ALIAS_1"."SITE_CODE"="B"."SITE_CODE" AND "B"."INVENTORY_LOCATION" NOT LIKE 'XXX%' 17INDEX FULL SCAN PSS PSS_SUB_KIT_STRUUNIQUE ANALYZED 1 16 9 2 8 52 2964 8"SYS_ALI"SYS_ALIAS_1"."END_ITEM_PART_NUMBER"||'|'||"SYS_ALIAS_1"."SUB_KIT_CODE"="SYS_ALIAS_1"."E 18TABLE ACBY INDEX ROWID PSS PSS_KIT_ 9 ANALYZED 17 8 2 2 1 45 1 1 LTRIM(RTRIM("SYS_ALIAS_2"."DEFAULT_LOCATION"))=LTRIM(RTRIM("SYS_ALIAS_2"."DEFAULT_LOCATI 19INDEX UNIQUE SCAN PSS PSS_KIT_STRUCTURUNIQUE ANALYZED 3 18 17 1 2 "SYS_ALI"SYS_ALIAS_1"."SITE_CODE"="SYS_ALIAS_2"."SITE_CODE" 20TABLE ACBY INDEX ROWID PSS PSS_INVE 8 ANALYZED 19 7 2 2 3 150 1 1 "SYS_ALIAS_2"."DEFAULT_LOCATION"="B"."INVENTORY_LOCATION" 21INDEX RANGE SCAN PSS PSS_INVENTORY_PKUNIQUE ANALYZED 2 20 19 1 1 3 1"SYS_ALI"SYS_ALIAS_1"."SITE_CODE"="B"."SITE_CODE" AND "B"."INVENTORY_LOCATION" NOT LIKE 'XXX%' 22TABLE ACBY USER ROWID PSS PSS_PACK 4 ANALYZED 21 6 2 1 1383 47022 1 23SORT AGGREGATE 22 21 1 1 66 24NESTED LOOPS 23 22 1 3 1 66 2 2 25TABLE ACBY INDEX ROWID PSS PSS_PACK 6 ANALYZED 24 23 1 2 1 38 1 1 "Y"."PACK_DESIGN_SEQ_ID" IS NOT NULL AND "Y"."PICK_PACK_IND"=0 26INDEX RANGE SCAN PSS PSS_PACK_DESIGN_NON-UNIQANALYZED 2 25 24 1 3 1 3"Y"."PART_NUMBER"=:B1 AND "Y"."PART_DESTINATION"=:B2 27TABLE ACBY INDEX ROWID PSS PSS_PACK 5 ANALYZED 26 23 2 2 1 28 1 1 "X"."KIT_QTY" IS NOT NULL AND "X"."KIT_QTY">0 AND "X"."PICK_PACK_IND"=0 28INDEX UNIQUE SCAN PSS PSS_PACK_DESIGN_UNIQUE ANALYZED 1 27 26 1 1 "X"."PACK_DESIGN_SEQ_ID"="Y"."PACK_DESIGN_SEQ_ID" 29TABLE ACBY USER ROWID PSS PSS_PACK 10 ANALYZED 28 5 2 1 1383 27660 1 30SORT AGGREGATE 29 28 1 1 66 31NESTED LOOPS 30 29 1 3 1 66 2 2 32TABLE ACBY INDEX ROWID PSS PSS_PACK 12 ANALYZED 31 30 1 2 1 38 1 1 "Y"."PACK_DESIGN_SEQ_ID" IS NOT NULL AND "Y"."PICK_PACK_IND"=0 33INDEX RANGE SCAN PSS PSS_PACK_DESIGN_NON-UNIQANALYZED 2 32 31 1 3 1 3"Y"."PART_NUMBER"=:B1 AND "Y"."PART_DESTINATION"=:B2 34TABLE ACBY INDEX ROWID PSS PSS_PACK 11 ANALYZED 33 30 2 2 1 28 1 1 "X"."KIT_QTY" IS NOT NULL AND "X"."KIT_QTY">0 AND "X"."PICK_PACK_IND"=0 35INDEX UNIQUE SCAN PSS PSS_PACK_DESIGN_UNIQUE ANALYZED 1 34 33 1 1 "X"."PACK_DESIGN_SEQ_ID"="Y"."PACK_DESIGN_SEQ_ID" ON")) AND "SYS_ALIAS_2"."KIT_CODE"="SYS_ALIAS_2"."KIT_CODE" AND "SYS_ALIAS_2"."SITE_CODE"='E' ND_ITEM_PART_NUMBER"||'|'||"SYS_ALIAS_1"."SUB_KIT_CODE" AND "SYS_ALIAS_1"."SITE_CODE"='E' ON")) AND "SYS_ALIAS_2"."KIT_CODE"="SYS_ALIAS_2"."KIT_CODE" VL("D"."KIT_QTY",0),0,"B"."INVENTORY_QTY"+1,"D"."KIT_QTY"))>=1