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_SEC_LOCATORS_EVENT_PKG dependencies on CSM_MTL_SYSTEM_ITEMS_ACC

Line 56: FROM csm_mtl_system_items_acc msi_acc,

52: CURSOR l_mtl_sec_loc_ins_csr
53: IS
54: SELECT msi_acc.user_id, msl.inventory_item_id,
55: msl.organization_id, msl.secondary_locator
56: FROM csm_mtl_system_items_acc msi_acc,
57: csm_mtl_item_locations_acc mil_acc,
58: mtl_secondary_locators msl
59: WHERE msl.inventory_item_id = msi_acc.inventory_item_id
60: AND msl.organization_id = msi_acc.organization_id

Line 92: FROM csm_mtl_system_items_acc msi_acc,

88: SELECT acc.user_id, acc.secondary_locator, acc.organization_id, acc.inventory_item_id
89: FROM csm_mtl_secondary_locators_acc acc
90: WHERE NOT EXISTS
91: (SELECT 1
92: FROM csm_mtl_system_items_acc msi_acc,
93: csm_mtl_item_locations_acc mil_acc,
94: mtl_secondary_locators msl
95: WHERE msl.inventory_item_id = msi_acc.inventory_item_id
96: AND msl.organization_id = msi_acc.organization_id