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_OPERATION_RESOURCE_SEQS

Line 1128: FROM MSC_ST_OPERATION_RESOURCE_SEQS msors

1124: msors.DEPARTMENT_ID,
1125: msors.ACTIVITY_GROUP_ID,
1126: msors.SR_INSTANCE_ID,
1127: msors.ORGANIZATION_ID
1128: FROM MSC_ST_OPERATION_RESOURCE_SEQS msors
1129: WHERE msors.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1130: AND msors.DELETED_FLAG= MSC_UTIL.SYS_NO;
1131:
1132: CURSOR c7_d IS

Line 1138: FROM MSC_ST_OPERATION_RESOURCE_SEQS msors

1134: msors.ROUTING_SEQUENCE_ID,
1135: msors.OPERATION_SEQUENCE_ID,
1136: msors.RESOURCE_SEQ_NUM,
1137: msors.SR_INSTANCE_ID
1138: FROM MSC_ST_OPERATION_RESOURCE_SEQS msors
1139: WHERE msors.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1140: AND msors.DELETED_FLAG= MSC_UTIL.SYS_YES;
1141:
1142:

Line 1208: ||' FROM MSC_ST_OPERATION_RESOURCE_SEQS msors'

1204: ||' :v_current_date,'
1205: ||' :v_current_user,'
1206: ||' :v_current_date,'
1207: ||' :v_current_user '
1208: ||' FROM MSC_ST_OPERATION_RESOURCE_SEQS msors'
1209: ||' WHERE msors.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
1210: ||' AND msors.DELETED_FLAG= '||MSC_UTIL.SYS_NO
1211: ||' GROUP BY '
1212: ||' msors.ROUTING_SEQUENCE_ID, '