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_SERIAL_NUMBERS_EVENT_PKG dependencies on CSM_MTL_ONHAND_QTY_ACC

Line 81: FROM csm_mtl_onhand_qty_acc ohqacc,

77: FROM mtl_serial_numbers ser
78: WHERE ser.current_status IN (1,4) --Not assigned and out of subinv
79: AND EXISTS (
80: SELECT 'x'
81: FROM csm_mtl_onhand_qty_acc ohqacc,
82: mtl_system_items sys
83: WHERE ohqacc.inventory_item_id = ser.inventory_item_id
84: AND ohqacc.organization_id = ser.current_organization_id
85: AND ohqacc.user_id = p_userid

Line 264: csm_mtl_onhand_qty_acc ohqacc,

260: )
261: AND NOT EXISTS
262: ( SELECT 1
263: FROM mtl_serial_numbers ser,
264: csm_mtl_onhand_qty_acc ohqacc,
265: mtl_system_items sys
266: WHERE ser.current_status in (1,4)
267: AND ohqacc.user_id = acc.user_id
268: AND ser.serial_number = acc.serial_number