APPS.MSC_CL_ROUTING_ODS_LOAD dependencies on MSC_ST_ROUTINGS

Line 496: MSC_ST_ROUTINGS msr

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

Line 506: FROM MSC_ST_ROUTINGS msr

502: CURSOR c4_d IS
503: SELECT
504: msr.ROUTING_SEQUENCE_ID,
505: msr.SR_INSTANCE_ID
506: FROM MSC_ST_ROUTINGS msr
507: WHERE msr.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
508: AND msr.DELETED_FLAG= MSC_UTIL.SYS_YES;
509:
510:

Line 584: ||' MSC_ST_ROUTINGS msr'

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
588: ||' AND msr.DELETED_FLAG= '||MSC_UTIL.SYS_NO;