APPS.MSC_CL_BOM_ODS_LOAD dependencies on MSC_ITEM_ID_LID

Line 662: FROM MSC_ITEM_ID_LID t1,

658: mscs.ORGANIZATION_ID,
659: t1.INVENTORY_ITEM_ID SUBSTITUTE_ITEM_ID, -- mscs.SUBSTITUTE_ITEM_ID,
660: mscs.COMPONENT_SEQUENCE_ID,
661: mscs.SR_INSTANCE_ID
662: FROM MSC_ITEM_ID_LID t1,
663: MSC_ST_COMPONENT_SUBSTITUTES mscs
664: WHERE t1.SR_INVENTORY_ITEM_ID= mscs.substitute_item_id
665: AND t1.sr_instance_id= mscs.sr_instance_id
666: AND mscs.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

Line 675: FROM MSC_ITEM_ID_LID t1,

671: mscs.BILL_SEQUENCE_ID,
672: mscs.COMPONENT_SEQUENCE_ID,
673: t1.INVENTORY_ITEM_ID SUBSTITUTE_ITEM_ID, -- mscs.SUBSTITUTE_ITEM_ID,
674: mscs.SR_INSTANCE_ID
675: FROM MSC_ITEM_ID_LID t1,
676: MSC_ST_COMPONENT_SUBSTITUTES mscs
677: WHERE ((t1.SR_INVENTORY_ITEM_ID= mscs.substitute_item_id) AND (mscs.substitute_item_id
678: is NOT NULL))
679: AND t1.sr_instance_id= mscs.sr_instance_id

Line 908: FROM MSC_ITEM_ID_LID t1,

904: msbr.SR_TRANSACTION_ID,
905: t1.INVENTORY_ITEM_ID ASSEMBLY_ITEM_ID,
906: t2.INVENTORY_ITEM_ID SOURCE_ITEM_ID,
907: msbr.SR_INSTANCE_ID
908: FROM MSC_ITEM_ID_LID t1,
909: MSC_ITEM_ID_LID t2,
910: MSC_ST_BOR_REQUIREMENTS msbr
911: WHERE t1.SR_INVENTORY_ITEM_ID= msbr.assembly_item_id
912: AND t1.sr_instance_id= msbr.sr_instance_id

Line 909: MSC_ITEM_ID_LID t2,

905: t1.INVENTORY_ITEM_ID ASSEMBLY_ITEM_ID,
906: t2.INVENTORY_ITEM_ID SOURCE_ITEM_ID,
907: msbr.SR_INSTANCE_ID
908: FROM MSC_ITEM_ID_LID t1,
909: MSC_ITEM_ID_LID t2,
910: MSC_ST_BOR_REQUIREMENTS msbr
911: WHERE t1.SR_INVENTORY_ITEM_ID= msbr.assembly_item_id
912: AND t1.sr_instance_id= msbr.sr_instance_id
913: AND t2.SR_INVENTORY_ITEM_ID= msbr.source_item_id

Line 1214: FROM MSC_ITEM_ID_LID miil,

1210: msor.LOAD_DISTRIBUTION_PRIORITY,
1211: msor.ITEM_PROCESS_COST,
1212: msor.SR_INSTANCE_ID,
1213: msor.RECIPE
1214: FROM MSC_ITEM_ID_LID miil,
1215: MSC_ST_PROCESS_EFFECTIVITY msor
1216: WHERE miil.SR_INVENTORY_ITEM_ID= msor.ITEM_ID
1217: AND miil.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1218: AND msor.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

Line 1229: FROM MSC_ITEM_ID_LID miil,

1225: msor.ROUTING_SEQUENCE_ID,
1226: msor.BILL_SEQUENCE_ID,
1227: msor.LINE_ID,
1228: msor.SR_INSTANCE_ID
1229: FROM MSC_ITEM_ID_LID miil,
1230: MSC_ST_PROCESS_EFFECTIVITY msor
1231: WHERE miil.SR_INVENTORY_ITEM_ID(+)= msor.ITEM_ID
1232: AND miil.SR_INSTANCE_ID(+)= MSC_CL_COLLECTION.v_instance_id
1233: AND msor.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

Line 1565: FROM MSC_ITEM_ID_LID t1,

1561: t1.INVENTORY_ITEM_ID ASSEMBLY_ITEM_ID, -- msb.ASSEMBLY_ITEM_ID,
1562: msb.BILL_SEQUENCE_ID,
1563: msb.SR_INSTANCE_ID,
1564: msb.operation_seq_num /* ds change for opm: yielding op seq num */
1565: FROM MSC_ITEM_ID_LID t1,
1566: MSC_ST_BOMS msb
1567: WHERE t1.SR_INVENTORY_ITEM_ID= msb.assembly_item_id
1568: AND t1.sr_instance_id= msb.sr_instance_id
1569: AND msb.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

Line 1702: ||' FROM MSC_ITEM_ID_LID t1,'

1698: ||' :v_current_date,'
1699: ||' :v_current_user,'
1700: ||' :v_current_date,'
1701: ||' :v_current_user '
1702: ||' FROM MSC_ITEM_ID_LID t1,'
1703: ||' MSC_ST_BOMS msb '
1704: ||' WHERE t1.SR_INVENTORY_ITEM_ID= msb.assembly_item_id'
1705: ||' AND t1.sr_instance_id= msb.sr_instance_id'
1706: ||' AND msb.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id

Line 1942: FROM MSC_ITEM_ID_LID t1,

1938: msbc.ROUNDING_DIRECTION,
1939: msbc.PRIMARY_FLAG,
1940: msbc.CONTRIBUTE_TO_STEP_QTY, /* ds change */
1941: msbc.OLD_COMPONENT_SEQUENCE_ID
1942: FROM MSC_ITEM_ID_LID t1,
1943: MSC_ITEM_ID_LID t2,
1944: MSC_ITEM_ID_LID t3,
1945: MSC_ST_BOM_COMPONENTS msbc
1946: WHERE t1.SR_INVENTORY_ITEM_ID= msbc.inventory_item_id

Line 1943: MSC_ITEM_ID_LID t2,

1939: msbc.PRIMARY_FLAG,
1940: msbc.CONTRIBUTE_TO_STEP_QTY, /* ds change */
1941: msbc.OLD_COMPONENT_SEQUENCE_ID
1942: FROM MSC_ITEM_ID_LID t1,
1943: MSC_ITEM_ID_LID t2,
1944: MSC_ITEM_ID_LID t3,
1945: MSC_ST_BOM_COMPONENTS msbc
1946: WHERE t1.SR_INVENTORY_ITEM_ID= msbc.inventory_item_id
1947: AND t1.sr_instance_id= msbc.sr_instance_id

Line 1944: MSC_ITEM_ID_LID t3,

1940: msbc.CONTRIBUTE_TO_STEP_QTY, /* ds change */
1941: msbc.OLD_COMPONENT_SEQUENCE_ID
1942: FROM MSC_ITEM_ID_LID t1,
1943: MSC_ITEM_ID_LID t2,
1944: MSC_ITEM_ID_LID t3,
1945: MSC_ST_BOM_COMPONENTS msbc
1946: WHERE t1.SR_INVENTORY_ITEM_ID= msbc.inventory_item_id
1947: AND t1.sr_instance_id= msbc.sr_instance_id
1948: AND t2.SR_INVENTORY_ITEM_ID= msbc.using_assembly_id

Line 2203: ||' FROM MSC_ITEM_ID_LID t1,'

2199: ||' :v_current_date , '
2200: ||' :v_current_user , '
2201: ||' :v_current_date , '
2202: ||' :v_current_user '
2203: ||' FROM MSC_ITEM_ID_LID t1,'
2204: ||' MSC_ITEM_ID_LID t2,'
2205: ||' MSC_ITEM_ID_LID t3,'
2206: ||' MSC_ST_BOM_COMPONENTS msbc'
2207: ||' WHERE t1.SR_INVENTORY_ITEM_ID = msbc.inventory_item_id'

Line 2204: ||' MSC_ITEM_ID_LID t2,'

2200: ||' :v_current_user , '
2201: ||' :v_current_date , '
2202: ||' :v_current_user '
2203: ||' FROM MSC_ITEM_ID_LID t1,'
2204: ||' MSC_ITEM_ID_LID t2,'
2205: ||' MSC_ITEM_ID_LID t3,'
2206: ||' MSC_ST_BOM_COMPONENTS msbc'
2207: ||' WHERE t1.SR_INVENTORY_ITEM_ID = msbc.inventory_item_id'
2208: ||' AND t1.sr_instance_id = msbc.sr_instance_id'

Line 2205: ||' MSC_ITEM_ID_LID t3,'

2201: ||' :v_current_date , '
2202: ||' :v_current_user '
2203: ||' FROM MSC_ITEM_ID_LID t1,'
2204: ||' MSC_ITEM_ID_LID t2,'
2205: ||' MSC_ITEM_ID_LID t3,'
2206: ||' MSC_ST_BOM_COMPONENTS msbc'
2207: ||' WHERE t1.SR_INVENTORY_ITEM_ID = msbc.inventory_item_id'
2208: ||' AND t1.sr_instance_id = msbc.sr_instance_id'
2209: ||' AND t2.SR_INVENTORY_ITEM_ID = msbc.using_assembly_id'

Line 2666: MSC_ITEM_ID_LID t1

2662: msdri.EFFECTIVE_END_DATE,
2663: msdri.LAST_KNOWN_SETUP,
2664: msdri.DELETED_FLAG
2665: FROM MSC_ST_DEPT_RES_INSTANCES msdri,
2666: MSC_ITEM_ID_LID t1
2667: WHERE msdri.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2668: AND t1.sr_instance_id (+) = msdri.sr_instance_id
2669: AND t1.sr_inventory_item_id (+) = msdri.equipment_item_id;
2670: /* ds:plan: change end */