DBA Data[Home] [Help]

APPS.MSC_CL_BOM_ODS_LOAD dependencies on MSC_ST_COMPONENT_SUBSTITUTES

Line 663: MSC_ST_COMPONENT_SUBSTITUTES mscs

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
667: AND mscs.DELETED_FLAG= MSC_UTIL.SYS_NO;

Line 676: MSC_ST_COMPONENT_SUBSTITUTES mscs

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
680: AND mscs.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

Line 688: FROM MSC_ST_COMPONENT_SUBSTITUTES mscs

684: mscs.BILL_SEQUENCE_ID,
685: mscs.COMPONENT_SEQUENCE_ID,
686: TO_NUMBER(NULL) SUBSTITUTE_ITEM_ID,
687: mscs.SR_INSTANCE_ID
688: FROM MSC_ST_COMPONENT_SUBSTITUTES mscs
689: WHERE mscs.substitute_item_id IS NULL
690: AND mscs.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
691: AND mscs.DELETED_FLAG= MSC_UTIL.SYS_YES;
692: