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_ITEM_CATEGORIES

Line 1061: MSC_ST_ITEM_CATEGORIES msic

1057: msic.SR_INSTANCE_ID,
1058: msic.SR_CATEGORY_ID
1059: FROM MSC_CATEGORY_SET_ID_LID mcsil,
1060: MSC_ITEM_ID_LID t1,
1061: MSC_ST_ITEM_CATEGORIES msic
1062: WHERE t1.SR_INVENTORY_ITEM_ID= msic.inventory_item_id
1063: AND t1.sr_instance_id= msic.sr_instance_id
1064: AND mcsil.SR_Category_Set_ID= msic.SR_Category_Set_ID
1065: AND mcsil.SR_Instance_ID= msic.SR_Instance_ID

Line 1078: MSC_ST_ITEM_CATEGORIES msic

1074: msic.SR_INSTANCE_ID,
1075: msic.SR_CATEGORY_ID
1076: FROM MSC_CATEGORY_SET_ID_LID mcsil,
1077: MSC_ITEM_ID_LID t1,
1078: MSC_ST_ITEM_CATEGORIES msic
1079: WHERE t1.SR_INVENTORY_ITEM_ID= msic.inventory_item_id
1080: AND t1.sr_instance_id= msic.sr_instance_id
1081: AND mcsil.SR_Category_Set_ID= msic.SR_Category_Set_ID
1082: AND mcsil.SR_Instance_ID= msic.SR_Instance_ID

Line 1181: ||' MSC_ST_ITEM_CATEGORIES msic'

1177: ||' :v_current_date , '
1178: ||' :v_current_user '
1179: ||' FROM MSC_CATEGORY_SET_ID_LID mcsil,'
1180: ||' MSC_ITEM_ID_LID t1,'
1181: ||' MSC_ST_ITEM_CATEGORIES msic'
1182: ||' WHERE t1.SR_INVENTORY_ITEM_ID = msic.inventory_item_id '
1183: ||' AND t1.sr_instance_id = msic.sr_instance_id '
1184: ||' AND mcsil.SR_Category_Set_ID = msic.SR_Category_Set_ID '
1185: ||' AND mcsil.SR_Instance_ID = msic.SR_Instance_ID '