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_ITEM_ODS_LOAD dependencies on MSC_ST_CATEGORY_SETS

Line 1479: MSC_ST_CATEGORY_SETS mscs

1475: mscs.CONTROL_LEVEL,
1476: mscs.DEFAULT_FLAG,
1477: mscs.SR_INSTANCE_ID
1478: FROM MSC_CATEGORY_SET_ID_LID mcsil,
1479: MSC_ST_CATEGORY_SETS mscs
1480: WHERE mcsil.SR_Category_Set_ID= mscs.SR_Category_Set_ID
1481: AND mcsil.SR_Instance_ID= mscs.SR_Instance_ID
1482: AND mscs.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1483: ORDER BY

Line 1498: FROM MSC_ST_CATEGORY_SETS mscs

1494:
1495: Cursor c8 IS
1496: SELECT DISTINCT
1497: mscs.Category_Set_Name
1498: FROM MSC_ST_CATEGORY_SETS mscs
1499: WHERE NOT EXISTS ( select 1
1500: from MSC_Category_Sets mcs
1501: where mscs.Category_Set_Name= mcs.Category_Set_Name)
1502: AND mscs.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

Line 1838: FROM MSC_ST_CATEGORY_SETS mscs,

1834: SELECT distinct
1835: mscs.SR_Category_Set_ID,
1836: mscs.SR_INSTANCE_ID,
1837: mcs.Category_Set_ID
1838: FROM MSC_ST_CATEGORY_SETS mscs,
1839: MSC_CATEGORY_SETS mcs
1840: WHERE NOT EXISTS( select 1
1841: from MSC_CATEGORY_SET_ID_LID mcsil
1842: where mscs.SR_Category_Set_ID= mcsil.SR_Category_Set_ID