DBA Data[Home] [Help]

APPS.MSC_CL_BOM_ODS_LOAD dependencies on MSC_ST_COMPONENT_SUBSTITUTES

Line 669: MSC_ST_COMPONENT_SUBSTITUTES mscs

665: t1.INVENTORY_ITEM_ID SUBSTITUTE_ITEM_ID, -- mscs.SUBSTITUTE_ITEM_ID,
666: mscs.COMPONENT_SEQUENCE_ID,
667: mscs.SR_INSTANCE_ID
668: FROM MSC_ITEM_ID_LID t1,
669: MSC_ST_COMPONENT_SUBSTITUTES mscs
670: WHERE t1.SR_INVENTORY_ITEM_ID= mscs.substitute_item_id
671: AND t1.sr_instance_id= mscs.sr_instance_id
672: AND mscs.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
673: AND mscs.DELETED_FLAG= MSC_UTIL.SYS_NO;

Line 682: MSC_ST_COMPONENT_SUBSTITUTES mscs

678: mscs.COMPONENT_SEQUENCE_ID,
679: t1.INVENTORY_ITEM_ID SUBSTITUTE_ITEM_ID, -- mscs.SUBSTITUTE_ITEM_ID,
680: mscs.SR_INSTANCE_ID
681: FROM MSC_ITEM_ID_LID t1,
682: MSC_ST_COMPONENT_SUBSTITUTES mscs
683: WHERE ((t1.SR_INVENTORY_ITEM_ID= mscs.substitute_item_id) AND (mscs.substitute_item_id
684: is NOT NULL))
685: AND t1.sr_instance_id= mscs.sr_instance_id
686: AND mscs.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

Line 694: FROM MSC_ST_COMPONENT_SUBSTITUTES mscs

690: mscs.BILL_SEQUENCE_ID,
691: mscs.COMPONENT_SEQUENCE_ID,
692: TO_NUMBER(NULL) SUBSTITUTE_ITEM_ID,
693: mscs.SR_INSTANCE_ID
694: FROM MSC_ST_COMPONENT_SUBSTITUTES mscs
695: WHERE mscs.substitute_item_id IS NULL
696: AND mscs.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
697: AND mscs.DELETED_FLAG= MSC_UTIL.SYS_YES;
698: