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_OTHER_ODS_LOAD dependencies on MSC_CATEGORY_SET_ID_LID

Line 234: MSC_CATEGORY_SET_ID_LID mcsil,

230: mssa.SR_ASSIGNMENT_INSTANCE_ID
231: FROM MSC_ITEM_ID_LID miil,
232: MSC_TP_ID_LID mtil,
233: MSC_TP_SITE_ID_LID mtsil,
234: MSC_CATEGORY_SET_ID_LID mcsil,
235: MSC_Assignment_SETS mas,
236: MSC_Sourcing_Rules msr,
237: MSC_ST_SR_ASSIGNMENTS mssa
238: WHERE mas.SR_ASSIGNMENT_SET_ID= mssa.ASSIGNMENT_SET_ID -- Assignment Set

Line 265: select 1 from MSC_CATEGORY_SET_ID_LID mcsil1

261: )
262: OR
263: EXISTS
264: (
265: select 1 from MSC_CATEGORY_SET_ID_LID mcsil1
266: where mcsil1.SR_Category_Set_ID= mssa.Category_Set_Identifier AND
267: mcsil1.SR_Instance_ID= mssa.SR_ASSIGNMENT_Instance_ID AND
268: mssa.assignment_type in (2,5)
269: )

Line 913: MSC_CATEGORY_SET_ID_LID mcsil,

909: MSC_CL_COLLECTION.v_current_user
910: FROM MSC_ITEM_ID_LID miil,
911: MSC_TP_ID_LID mtil,
912: MSC_TP_SITE_ID_LID mtsil,
913: MSC_CATEGORY_SET_ID_LID mcsil,
914: MSC_Assignment_SETS mas,
915: MSC_Sourcing_Rules msr,
916: MSC_ST_SR_ASSIGNMENTS mssa
917: WHERE mas.SR_ASSIGNMENT_SET_ID= mssa.ASSIGNMENT_SET_ID -- Assignment Set

Line 944: select 1 from MSC_CATEGORY_SET_ID_LID mcsil1

940: )
941: OR
942: EXISTS
943: (
944: select 1 from MSC_CATEGORY_SET_ID_LID mcsil1
945: where mcsil1.SR_Category_Set_ID= mssa.Category_Set_Identifier AND
946: mcsil1.SR_Instance_ID= mssa.SR_ASSIGNMENT_Instance_ID AND
947: mssa.assignment_type in (2,5)
948: )