APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on MTL_SERIAL_NUMBERS

Line 328: FROM mtl_serial_numbers_temp msnt

324: l_debug number;
325:
326: CURSOR serial_numbers(p_transaction_temp_id NUMBER) IS
327: SELECT msnt.fm_serial_number
328: FROM mtl_serial_numbers_temp msnt
329: WHERE transaction_temp_id = p_transaction_temp_id;
330:
331: cursor delivery_details(p_lpn_id NUMBER) is
332: select wdd.delivery_detail_id

Line 4886: from mtl_serial_numbers

4882: p_serial_number IN VARCHAR2) IS
4883: BEGIN
4884: open x_serial_lov for
4885: select serial_number, current_subinventory_code, current_locator_id, lot_number
4886: from mtl_serial_numbers
4887: where inventory_item_id = p_inventory_item_id
4888: and current_organization_id = p_organization_id
4889: and (group_mark_id is null or group_mark_id = -1)
4890: and ((nvl(current_subinventory_code,'@@@') = nvl(p_subinventory_code,'@@@')

Line 4918: insert into mtl_serial_numbers_temp

4914: l_login_id := fnd_global.login_id;
4915:
4916: l_serial_prefix := rtrim(l_fm_serial_number, '0123456789');
4917:
4918: insert into mtl_serial_numbers_temp
4919: (
4920: transaction_Temp_id,
4921: last_update_date,
4922: last_updated_by,