APPS.INV_TXN_MANAGER_PUB dependencies on MTL_SERIAL_NUMBERS

Line 360: FROM mtl_serial_numbers_interface msni

356: , parent_item_id --R12 Genealogy enhancements
357: , parent_object_type2 --R12 Genealogy enhancements
358: , parent_object_id2 --R12 Genealogy enhancements
359: , parent_object_number2 --R12 Genealogy enhancements
360: FROM mtl_serial_numbers_interface msni
361: WHERE msni.transaction_interface_id =
362: (SELECT serial_transaction_temp_id
363: FROM mtl_transaction_lots_interface mtli
364: WHERE mtli.transaction_interface_id = p_parent_id)

Line 383: FROM mtl_serial_numbers_interface msni

379: CURSOR msni_rs_serials_csr (p_parent_id NUMBER)
380: IS
381: SELECT fm_serial_number
382: , NVL (to_serial_number, fm_serial_number) to_serial_number
383: FROM mtl_serial_numbers_interface msni
384: WHERE msni.transaction_interface_id IN (
385: SELECT serial_transaction_temp_id
386: FROM mtl_transaction_lots_interface mtli
387: WHERE mtli.transaction_interface_id IN (

Line 400: FROM mtl_serial_numbers_interface msni

396: CURSOR msni_st_serials_csr (p_parent_id NUMBER)
397: IS
398: SELECT fm_serial_number
399: , NVL (to_serial_number, fm_serial_number) to_serial_number
400: FROM mtl_serial_numbers_interface msni
401: WHERE msni.transaction_interface_id =
402: (SELECT serial_transaction_temp_id
403: FROM mtl_transaction_lots_interface mtli
404: WHERE mtli.transaction_interface_id =

Line 425: l_rem_var_index mtl_serial_numbers.serial_number%TYPE;

421: l_transaction_interface_id NUMBER; --J-dev
422: l_serial_code NUMBER;
423: l_serial_diff NUMBER;
424: l_sysdate DATE;
425: l_rem_var_index mtl_serial_numbers.serial_number%TYPE;
426: l_next_serial VARCHAR2(30);
427: l_old_serial VARCHAR2(30);
428: l_sequence NUMBER;
429: BEGIN

Line 1058: INSERT INTO mtl_serial_numbers_interface

1054: , '9'
1055: );
1056: END IF;
1057:
1058: INSERT INTO mtl_serial_numbers_interface
1059: (transaction_interface_id
1060: , last_update_date
1061: , last_updated_by
1062: , creation_date

Line 4574: delete from mtl_serial_numbers_temp

4570: END IF;
4571:
4572: -- Bug 5748351: Deleting MSNT/MTLT/MMTT for the headerId, in case they are still present and did not
4573: -- get deleted in TM.
4574: delete from mtl_serial_numbers_temp
4575: where transaction_temp_id in (
4576: select mmtt.transaction_temp_id
4577: from mtl_material_transactions_temp mmtt
4578: where mmtt.transaction_header_id = l_header_id );

Line 4580: delete from mtl_serial_numbers_temp

4576: select mmtt.transaction_temp_id
4577: from mtl_material_transactions_temp mmtt
4578: where mmtt.transaction_header_id = l_header_id );
4579:
4580: delete from mtl_serial_numbers_temp
4581: where transaction_temp_id in (
4582: select mtlt.serial_transaction_temp_id
4583: from mtl_transaction_lots_temp mtlt
4584: where mtlt.transaction_temp_id in (