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.INV_SERIAL_PICK_PKG dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 116: mtl_transaction_lots_temp mtlt,

112: update mtl_serial_numbers
113: set group_mark_id = null
114: where serial_number in (select fm_serial_number
115: from mtl_serial_numbers_temp msnt,
116: mtl_transaction_lots_temp mtlt,
117: mtl_material_transactions_temp mmtt
118: where mmtt.move_order_line_id = p_move_order_line_id
119: and mtlt.transaction_temp_id = mmtt.transaction_temp_id
120: and msnt.transaction_temp_id = mtlt.serial_transaction_temp_id

Line 135: mtl_transaction_lots_temp mtlt

131: where mmtt.move_order_line_id = p_move_order_line_id
132: UNION
133: select mtlt.serial_transaction_temp_id
134: from mtl_material_transactions_temp mmtt,
135: mtl_transaction_lots_temp mtlt
136: where mmtt.move_order_line_id = p_move_order_line_id
137: and mtlt.transaction_temp_id = mmtt.transaction_temp_id);
138:
139: delete from mtl_transaction_lots_temp

Line 139: delete from mtl_transaction_lots_temp

135: mtl_transaction_lots_temp mtlt
136: where mmtt.move_order_line_id = p_move_order_line_id
137: and mtlt.transaction_temp_id = mmtt.transaction_temp_id);
138:
139: delete from mtl_transaction_lots_temp
140: where transaction_temp_id in (select transaction_temp_id
141: from mtl_material_transactions_temp mmtt
142: where mmtt.move_order_line_id = p_move_order_line_id);
143: