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;
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
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: