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 257: csm_mtl_onhand_qty_acc ohqacc,

253: )
254: AND NOT EXISTS
255: ( SELECT 1
256: FROM mtl_serial_numbers ser,
257: csm_mtl_onhand_qty_acc ohqacc,
258: mtl_system_items sys
259: WHERE ser.current_status in (1,4)
260: AND ohqacc.user_id = acc.user_id
261: AND ser.serial_number = acc.serial_number