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 1476: MSC_ST_CATEGORY_SETS mscs

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

Line 1495: FROM MSC_ST_CATEGORY_SETS mscs

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

Line 1834: FROM MSC_ST_CATEGORY_SETS mscs,

1830: SELECT distinct
1831: mscs.SR_Category_Set_ID,
1832: mscs.SR_INSTANCE_ID,
1833: mcs.Category_Set_ID
1834: FROM MSC_ST_CATEGORY_SETS mscs,
1835: MSC_CATEGORY_SETS mcs
1836: WHERE NOT EXISTS( select 1
1837: from MSC_CATEGORY_SET_ID_LID mcsil
1838: where mscs.SR_Category_Set_ID= mcsil.SR_Category_Set_ID