eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_CL_ROUTING_ODS_LOAD dependencies on MSC_ST_ROUTINGS

Line 497: MSC_ST_ROUTINGS msr

493: msr.LAST_OP_SEQ_NUM,
494: msr.common_routing_sequence_id,
495: msr.auto_step_qty_flag
496: FROM MSC_ITEM_ID_LID t1,
497: MSC_ST_ROUTINGS msr
498: WHERE t1.SR_INVENTORY_ITEM_ID= msr.assembly_item_id
499: AND t1.sr_instance_id= msr.sr_instance_id
500: AND msr.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
501: AND msr.DELETED_FLAG= MSC_UTIL.SYS_NO;

Line 507: FROM MSC_ST_ROUTINGS msr

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

Line 585: ||' MSC_ST_ROUTINGS msr'

581: ||' msr.LAST_OP_SEQ_NUM,'
582: ||' msr.COMMON_ROUTING_SEQUENCE_ID,'
583: ||' msr.AUTO_STEP_QTY_FLAG '
584: ||' FROM MSC_ITEM_ID_LID t1,'
585: ||' MSC_ST_ROUTINGS msr'
586: ||' WHERE t1.SR_INVENTORY_ITEM_ID= msr.assembly_item_id'
587: ||' AND t1.sr_instance_id= msr.sr_instance_id'
588: ||' AND msr.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
589: ||' AND msr.DELETED_FLAG= '||MSC_UTIL.SYS_NO;

Line 2504: from MSC_ST_ROUTINGS mr,MSC_ROUTING_OPERATIONS mn

2500: IS
2501:
2502: cursor c1 IS
2503: select distinct mr.ROUTING_SEQUENCE_ID,trunc(mn.effectivity_date) effectivity_date
2504: from MSC_ST_ROUTINGS mr,MSC_ROUTING_OPERATIONS mn
2505: where
2506: mr.sr_instance_id=mn.sr_instance_id
2507: and mr.routing_sequence_id= mn.routing_sequence_id
2508: and mr.CFM_ROUTING_FLAG=3