APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on MTL_SERIAL_NUMBERS

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 5046: from mtl_serial_numbers

5042: p_serial_number IN VARCHAR2) IS
5043: BEGIN
5044: open x_serial_lov for
5045: select serial_number, current_subinventory_code, current_locator_id, lot_number
5046: from mtl_serial_numbers
5047: where inventory_item_id = p_inventory_item_id
5048: and current_organization_id = p_organization_id
5049: and (group_mark_id is null or group_mark_id = -1)
5050: and ((nvl(current_subinventory_code,'@@@') = nvl(p_subinventory_code,'@@@')

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,