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_ROUTING_OPERATIONS

Line 1498: FROM MSC_ST_ROUTING_OPERATIONS msro

1494: msro.STEP_QUANTITY_UOM,
1495: msro.DELETED_FLAG,
1496: msro.SR_INSTANCE_ID,
1497: msro.ORGANIZATION_ID
1498: FROM MSC_ST_ROUTING_OPERATIONS msro
1499: WHERE msro.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1500: AND msro.DELETED_FLAG= MSC_UTIL.SYS_NO;
1501:
1502: CURSOR c5_d IS

Line 1507: FROM MSC_ST_ROUTING_OPERATIONS msro

1503: SELECT
1504: msro.ROUTING_SEQUENCE_ID,
1505: msro.OPERATION_SEQUENCE_ID,
1506: msro.SR_INSTANCE_ID
1507: FROM MSC_ST_ROUTING_OPERATIONS msro
1508: WHERE msro.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1509: AND msro.DELETED_FLAG= MSC_UTIL.SYS_YES;
1510:
1511:

Line 1610: ||' FROM MSC_ST_ROUTING_OPERATIONS msro '

1606: ||' :v_current_date, '
1607: ||' :v_current_user, '
1608: ||' :v_current_date, '
1609: ||' :v_current_user '
1610: ||' FROM MSC_ST_ROUTING_OPERATIONS msro '
1611: ||' WHERE msro.SR_INSTANCE_ID= ' || MSC_CL_COLLECTION.v_instance_id
1612: ||' AND msro.DELETED_FLAG= ' || MSC_UTIL.SYS_NO;
1613:
1614: EXECUTE IMMEDIATE lv_sql_ins