APPS.PJM_UEFF_ONHAND dependencies on MTL_SERIAL_NUMBERS

Line 73: FROM mtl_serial_numbers msn

69: --- End Bug #4726150
70:
71: SELECT count(*)
72: INTO L_quantity
73: FROM mtl_serial_numbers msn
74: WHERE msn.current_status = 3
75: AND msn.inventory_item_id = X_item_id
76: AND msn.current_organization_id = X_organization_id
77: AND msn.current_subinventory_code = X_subinventory

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

Line 240: , mtl_serial_numbers msn

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
244: SELECT serial_transaction_temp_id