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 1064: MSC_ST_ITEM_CATEGORIES msic

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

Line 1081: MSC_ST_ITEM_CATEGORIES msic

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

Line 1184: ||' MSC_ST_ITEM_CATEGORIES msic'

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