APPS.MSC_CL_ROUTING_ODS_LOAD dependencies on MSC_ITEM_ID_LID

Line 216: MSC_ITEM_ID_LID t1 /* ds change change */

212: mon.TRANSFER_UOM, /*ds change change end */
213: mon.REFRESH_ID,
214: mon.SR_INSTANCE_ID
215: from MSC_ST_OPERATION_NETWORKS mon,
216: MSC_ITEM_ID_LID t1 /* ds change change */
217: WHERE mon.SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id
218: AND mon.DELETED_FLAG = MSC_UTIL.SYS_NO
219: AND mon.FROM_ITEM_ID = t1.SR_INVENTORY_ITEM_ID(+) /* ds change change */
220: AND mon.sr_instance_id = t1.sr_instance_id(+) ; /* ds change change */

Line 495: FROM MSC_ITEM_ID_LID t1,

491: msr.FIRST_OP_SEQ_NUM,
492: msr.LAST_OP_SEQ_NUM,
493: msr.common_routing_sequence_id,
494: msr.auto_step_qty_flag
495: FROM MSC_ITEM_ID_LID t1,
496: MSC_ST_ROUTINGS msr
497: WHERE t1.SR_INVENTORY_ITEM_ID= msr.assembly_item_id
498: AND t1.sr_instance_id= msr.sr_instance_id
499: AND msr.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

Line 583: ||' FROM MSC_ITEM_ID_LID t1,'

579: ||' msr.FIRST_OP_SEQ_NUM,'
580: ||' msr.LAST_OP_SEQ_NUM,'
581: ||' msr.COMMON_ROUTING_SEQUENCE_ID,'
582: ||' msr.AUTO_STEP_QTY_FLAG '
583: ||' FROM MSC_ITEM_ID_LID t1,'
584: ||' MSC_ST_ROUTINGS msr'
585: ||' WHERE t1.SR_INVENTORY_ITEM_ID= msr.assembly_item_id'
586: ||' AND t1.sr_instance_id= msr.sr_instance_id'
587: ||' AND msr.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id