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_ITEM_SUBINV_EVENT_PKG dependencies on CSP_INV_LOC_ASSIGNMENTS

Line 51: csp_inv_loc_assignments cila,

47: IS
48: SELECT cila_acc.user_id, mis.inventory_item_id, mis.organization_id, mis.secondary_inventory
49: FROM csm_mtl_system_items_acc msi_acc,
50: csm_inv_loc_ass_acc cila_acc,
51: csp_inv_loc_assignments cila,
52: mtl_item_sub_inventories mis
53: WHERE msi_acc.inventory_item_id = mis.inventory_item_id
54: AND msi_acc.organization_id = mis.organization_id
55: AND cila.csp_inv_loc_assignment_id = cila_acc.csp_inv_loc_assignment_id

Line 305: csp_inv_loc_assignments cila,

301: IS
302: SELECT cila_acc.user_id, mis.inventory_item_id, mis.organization_id, mis.secondary_inventory
303: FROM csm_mtl_system_items_acc msi_acc,
304: csm_inv_loc_ass_acc cila_acc,
305: csp_inv_loc_assignments cila,
306: mtl_item_sub_inventories mis
307: WHERE msi_acc.inventory_item_id = mis.inventory_item_id
308: AND msi_acc.organization_id = mis.organization_id
309: AND cila.csp_inv_loc_assignment_id = cila_acc.csp_inv_loc_assignment_id

Line 343: csp_inv_loc_assignments cila,

339: WHERE NOT EXISTS
340: (SELECT 1
341: FROM csm_mtl_system_items_acc msi_acc,
342: csm_inv_loc_ass_acc cila_acc,
343: csp_inv_loc_assignments cila,
344: mtl_item_sub_inventories mis
345: WHERE msi_acc.inventory_item_id = mis.inventory_item_id
346: AND msi_acc.organization_id = mis.organization_id
347: AND cila.csp_inv_loc_assignment_id = cila_acc.csp_inv_loc_assignment_id