DBA Data[Home] [Help]

APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 379: FROM mtl_serial_numbers_temp msnt

375: l_debug number;
376:
377: CURSOR serial_numbers(p_transaction_temp_id NUMBER) IS
378: SELECT msnt.fm_serial_number
379: FROM mtl_serial_numbers_temp msnt
380: WHERE transaction_temp_id = p_transaction_temp_id;
381:
382: cursor delivery_details(p_lpn_id NUMBER) is
383: select wdd.delivery_detail_id

Line 5078: insert into mtl_serial_numbers_temp

5074: l_login_id := fnd_global.login_id;
5075:
5076: l_serial_prefix := rtrim(l_fm_serial_number, '0123456789');
5077:
5078: insert into mtl_serial_numbers_temp
5079: (
5080: transaction_Temp_id,
5081: last_update_date,
5082: last_updated_by,