APPS.PJM_UEFF_ONHAND dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 214: FROM mtl_serial_numbers_temp msnt

210: if ( L_src_type_id = 2 and L_trx_src_line_id is not null ) then
211:
212: SELECT count(fm_serial_number)
213: INTO L_trx_qty
214: FROM mtl_serial_numbers_temp msnt
215: WHERE msnt.transaction_temp_id in (
216: SELECT X_trx_temp_id FROM dual
217: UNION ALL
218: SELECT serial_transaction_temp_id

Line 239: FROM mtl_serial_numbers_temp msnt

235: -- transaction serials
236: --
237: SELECT count(*) * L_trx_sign
238: INTO L_trx_qty
239: FROM mtl_serial_numbers_temp msnt
240: , mtl_serial_numbers msn
241: WHERE msnt.transaction_temp_id in (
242: SELECT X_trx_temp_id FROM dual
243: UNION ALL