APPS.INV_TXN_MANAGER_GRP dependencies on MTL_SERIAL_NUMBERS_INTERFACE

Line 159: MTL_SERIAL_NUMBERS_INTERFACE MSNI,

155: MSN.ATTRIBUTE14),
156: NVL(MSNI.ATTRIBUTE15,
157: MSN.ATTRIBUTE15)
158: FROM
159: MTL_SERIAL_NUMBERS_INTERFACE MSNI,
160: MTL_SERIAL_NUMBERS MSN
161: WHERE
162: MSNI.TRANSACTION_INTERFACE_ID = :B_PARENT_ID AND
163: MSNI.FM_SERIAL_NUMBER = :B_FM_SERIAL_NUMBER AND

Line 4580: FROM MTL_SERIAL_NUMBERS_INTERFACE

4576: THEN
4577: BEGIN
4578: SELECT 1
4579: into l_tnum
4580: FROM MTL_SERIAL_NUMBERS_INTERFACE
4581: WHERE TRANSACTION_INTERFACE_ID = l_sertempid
4582: AND ROWNUM < 2;
4583: EXCEPTION
4584: WHEN NO_DATA_FOUND THEN

Line 4615: DELETE FROM MTL_SERIAL_NUMBERS_INTERFACE

4611: END;
4612:
4613: ELSE
4614: IF (l_sertempid IS NOT NULL) THEN
4615: DELETE FROM MTL_SERIAL_NUMBERS_INTERFACE
4616: WHERE TRANSACTION_INTERFACE_ID = l_sertempid;
4617: END IF;
4618:
4619: END IF;

Line 5589: * MTL_TRANSACTION_LOTS_INTERFACE and MTL_SERIAL_NUMBERS_INTERFACE records

5585: *
5586: * validate_lot_serial_for_rcpt()
5587: * SDPAUL Bug# 5710830
5588: * This private procedure is used to validate a set of
5589: * MTL_TRANSACTION_LOTS_INTERFACE and MTL_SERIAL_NUMBERS_INTERFACE records
5590: * and inserts them into the corresponding master tables.
5591: * These validations are only needed for Receipt into stores transaction -> 27
5592: * and for the transaction sources -> 3,6 and 13.
5593: *

Line 5702: FROM MTL_SERIAL_NUMBERS_INTERFACE

5698:
5699: CURSOR cur_MSNI(interface_id NUMBER) IS
5700: SELECT FM_SERIAL_NUMBER
5701: , TO_SERIAL_NUMBER
5702: FROM MTL_SERIAL_NUMBERS_INTERFACE
5703: WHERE TRANSACTION_INTERFACE_ID = interface_id;
5704:
5705: -- PL/SQL table to store lot attributes
5706: l_attributes_tbl inv_lot_api_pub.char_tbl;

Line 7607: FROM mtl_serial_numbers_interface msni

7603: AND ABS(nvl(mtli.primary_quantity, inv_convert.inv_um_convert
7604: (l_itemid,5,mtli.transaction_quantity,l_trxuom,l_priuom,'','')))
7605: = (SELECT SUM(get_serial_diff_wrp
7606: (msni.fm_serial_number,nvl(msni.to_serial_number,msni.fm_serial_number)))
7607: FROM mtl_serial_numbers_interface msni
7608: WHERE msni.transaction_interface_id
7609: = mtli.serial_transaction_temp_id);
7610: EXCEPTION
7611: WHEN others THEN

Line 7647: FROM mtl_serial_numbers_interface msni

7643:
7644: SELECT SUM(get_serial_diff_wrp
7645: (fm_serial_number,NVL(to_serial_number,fm_serial_number)))
7646: INTO l_lot_ser_qty
7647: FROM mtl_serial_numbers_interface msni
7648: WHERE msni.transaction_interface_id =l_intid;
7649: EXCEPTION
7650: WHEN others THEN
7651: IF (l_debug = 1) THEN

Line 7786: FROM MTL_SERIAL_NUMBERS_INTERFACE

7782: ELSE
7783: BEGIN
7784: SELECT 1
7785: into l_tnum
7786: FROM MTL_SERIAL_NUMBERS_INTERFACE
7787: WHERE TRANSACTION_INTERFACE_ID = l_intid
7788: AND ROWNUM < 2;
7789: EXCEPTION
7790: WHEN NO_DATA_FOUND THEN

Line 7800: DELETE FROM MTL_SERIAL_NUMBERS_INTERFACE

7796: END;
7797: END IF;--l_intid is null
7798: ELSE
7799: IF (l_intid IS NOT NULL) THEN
7800: DELETE FROM MTL_SERIAL_NUMBERS_INTERFACE
7801: WHERE TRANSACTION_INTERFACE_ID = l_intid;
7802: END IF;
7803: END IF; --actions for serials.
7804: END IF;--if check actions for lots

Line 10348: FROM MTL_SERIAL_NUMBERS_INTERFACE

10344: parent_item_id, --R12 Genealogy enhancements
10345: parent_object_type2, --R12 Genealogy enhancements
10346: parent_object_id2, --R12 Genealogy enhancements
10347: parent_object_number2 --R12 Genealogy enhancements
10348: FROM MTL_SERIAL_NUMBERS_INTERFACE
10349: WHERE (TRANSACTION_INTERFACE_ID IN (
10350: SELECT TRANSACTION_INTERFACE_ID
10351: FROM MTL_TRANSACTIONS_INTERFACE MTI
10352: WHERE TRANSACTION_HEADER_ID = p_header_id

Line 10706: serial_column_csr ('MTL_SERIAL_NUMBERS_INTERFACE')

10702: type and length of Serial Attributes, as this is being done in seperate procedure
10703: get_serial_attr_table. */
10704:
10705: /*FOR l_lot_ser_column_csr IN
10706: serial_column_csr ('MTL_SERIAL_NUMBERS_INTERFACE')
10707: LOOP
10708: l_column_idx := l_column_idx + 1;
10709: l_lot_ser_attr_tbl (l_column_idx).column_name :=
10710: l_lot_ser_column_csr.column_name;

Line 10758: || ' from mtl_serial_numbers_interface msni,'

10754: -- in the system
10755: /*
10756: l_select_stmt :=
10757: l_select_stmt
10758: || ' from mtl_serial_numbers_interface msni,'
10759: || ' mtl_serial_numbers msn,'
10760: || ' mtl_transaction_lots_interface mtli,'
10761: || ' mtl_transactions_interface mti'
10762: || ' where mti.parent_id = :b_parent_id'

Line 11310: FROM mtl_serial_numbers_interface msni

11306: , cycles_since_visit
11307: , time_since_mark
11308: , cycles_since_mark
11309: , number_of_repairs
11310: FROM mtl_serial_numbers_interface msni
11311: WHERE transaction_interface_id = l_serial_transaction_temp_id;
11312:
11313: CURSOR msn_serial_attributes_csr (
11314: l_serial_number IN VARCHAR2

Line 14668: DELETE FROM MTL_SERIAL_NUMBERS_INTERFACE

14664: return -1;
14665: ELSE
14666: --delete from mti/mtli/msni
14667:
14668: DELETE FROM MTL_SERIAL_NUMBERS_INTERFACE
14669: WHERE TRANSACTION_INTERFACE_ID
14670: IN(
14671: SELECT TRANSACTION_INTERFACE_ID
14672: FROM MTL_TRANSACTIONS_INTERFACE

Line 15552: UPDATE MTL_SERIAL_NUMBERS_INTERFACE MSNI

15548: ,parent_object_number = l_object_number
15549: ,parent_object_number2 = l_object_number2
15550: WHERE ROWID = p_rowid;
15551: ELSIF p_table = 'MSNI' THEN
15552: UPDATE MTL_SERIAL_NUMBERS_INTERFACE MSNI
15553: SET parent_object_id = l_object_id
15554: ,parent_object_id2 = l_object_id2
15555: ,parent_object_number = l_object_number
15556: ,parent_object_number2 = l_object_number2

Line 15589: FROM MTL_SERIAL_NUMBERS_INTERFACE

15585: ,PARENT_OBJECT_ID2
15586: ,PARENT_OBJECT_NUMBER2
15587: ,PARENT_ITEM_ID
15588: ,ROWID
15589: FROM MTL_SERIAL_NUMBERS_INTERFACE
15590: WHERE TRANSACTION_INTERFACE_ID = p_interface_id;
15591:
15592: BEGIN
15593: x_return_status := lg_ret_sts_success;