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.CSM_MTL_SYSTEM_ITEMS_EVENT_PKG dependencies on CSI_ITEM_INSTANCES

Line 1178: from csm_item_instances_acc acc ,csi_item_instances ii

1174: where req_acc.user_id=au.user_id
1175: and req_acc.item_id=a.inventory_item_id
1176: and req_acc.org_id =a.organization_id) --htm5 user ordered/reserved item
1177: and not exists(select 1
1178: from csm_item_instances_acc acc ,csi_item_instances ii
1179: where acc.instance_id=ii.instance_id
1180: and acc.user_id=au.user_id
1181: and ii.inventory_item_id=a.inventory_item_id
1182: and a.organization_id=NVL(ii.inv_organization_id,ii.LAST_VLD_ORGANIZATION_ID)) --sr instance and its children/parent