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.

[Home] [Help]

APPS.MSC_CL_ROUTING_ODS_LOAD dependencies on MSC_ST_ROUTING_OPERATIONS

Line 1492: FROM MSC_ST_ROUTING_OPERATIONS msro

1488: msro.STEP_QUANTITY_UOM,
1489: msro.DELETED_FLAG,
1490: msro.SR_INSTANCE_ID,
1491: msro.ORGANIZATION_ID
1492: FROM MSC_ST_ROUTING_OPERATIONS msro
1493: WHERE msro.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1494: AND msro.DELETED_FLAG= MSC_UTIL.SYS_NO;
1495:
1496: CURSOR c5_d IS

Line 1501: FROM MSC_ST_ROUTING_OPERATIONS msro

1497: SELECT
1498: msro.ROUTING_SEQUENCE_ID,
1499: msro.OPERATION_SEQUENCE_ID,
1500: msro.SR_INSTANCE_ID
1501: FROM MSC_ST_ROUTING_OPERATIONS msro
1502: WHERE msro.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1503: AND msro.DELETED_FLAG= MSC_UTIL.SYS_YES;
1504:
1505:

Line 1604: ||' FROM MSC_ST_ROUTING_OPERATIONS msro '

1600: ||' :v_current_date, '
1601: ||' :v_current_user, '
1602: ||' :v_current_date, '
1603: ||' :v_current_user '
1604: ||' FROM MSC_ST_ROUTING_OPERATIONS msro '
1605: ||' WHERE msro.SR_INSTANCE_ID= ' || MSC_CL_COLLECTION.v_instance_id
1606: ||' AND msro.DELETED_FLAG= ' || MSC_UTIL.SYS_NO;
1607:
1608: EXECUTE IMMEDIATE lv_sql_ins