APPS.INV_TXN_MANAGER_PUB dependencies on MTL_SERIAL_NUMBERS_INTERFACE

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 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