eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_TXN_MANAGER_GRP dependencies on MTL_SERIAL_NUMBERS

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 160: MTL_SERIAL_NUMBERS MSN

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
164: MSNI.TO_SERIAL_NUMBER = :B_TO_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 10184: INSERT INTO MTL_SERIAL_NUMBERS_TEMP

10180: ));
10181:
10182:
10183:
10184: INSERT INTO MTL_SERIAL_NUMBERS_TEMP
10185: (TRANSACTION_TEMP_ID,
10186: LAST_UPDATE_DATE,
10187: LAST_UPDATED_BY,
10188: CREATION_DATE,

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 10759: || ' mtl_serial_numbers msn,'

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'
10763: || ' and mti.transaction_interface_id <> mti.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 11389: FROM mtl_serial_numbers msn

11385: , cycles_since_visit
11386: , time_since_mark
11387: , cycles_since_mark
11388: , number_of_repairs
11389: FROM mtl_serial_numbers msn
11390: WHERE msn.serial_number = l_serial_number
11391: AND msn.inventory_item_id = l_inventory_item_id
11392: AND msn.current_organization_id = l_organization_id;
11393:

Line 11490: FROM mtl_serial_numbers

11486: , cycles_since_visit
11487: , time_since_mark
11488: , cycles_since_mark
11489: , number_of_repairs
11490: FROM mtl_serial_numbers
11491: WHERE inventory_item_id = p_inventory_item_id
11492: AND current_organization_id = p_organization_id
11493: AND current_status = 3
11494: AND current_subinventory_code = p_subinventory_code

Line 11507: FROM mtl_serial_numbers_temp

11503: CURSOR msnt_serials_csr (l_serial_transaction_temp_id IN NUMBER)
11504: IS
11505: SELECT fm_serial_number
11506: , transaction_temp_id
11507: FROM mtl_serial_numbers_temp
11508: WHERE transaction_temp_id = l_serial_transaction_temp_id
11509: FOR UPDATE NOWAIT;
11510:
11511: CURSOR mtli_parent_lots_csr (l_transaction_interface_id IN NUMBER)

Line 12459: INSERT INTO mtl_serial_numbers_temp

12455: THEN
12456: mydebug ('Inserting into MSNT', 'tmpinsert2');
12457: END IF;
12458:
12459: INSERT INTO mtl_serial_numbers_temp
12460: (transaction_temp_id
12461: , last_update_date
12462: , last_updated_by
12463: , creation_date

Line 12652: INSERT INTO mtl_serial_numbers_temp

12648: , 'tmpinsert2'
12649: );
12650: END IF;
12651:
12652: INSERT INTO mtl_serial_numbers_temp
12653: (transaction_temp_id
12654: , last_update_date
12655: , last_updated_by
12656: , creation_date

Line 12986: INSERT INTO mtl_serial_numbers_temp

12982: , 'tmpinsert2'
12983: );
12984: END IF;
12985:
12986: INSERT INTO mtl_serial_numbers_temp
12987: (transaction_temp_id
12988: , last_update_date
12989: , last_updated_by
12990: , creation_date

Line 13255: UPDATE mtl_serial_numbers_temp

13251: , 'tmpinsert2'
13252: );
13253: END IF;
13254: /*The behaviour here is taken from LotTrxManager.Bit Strange!*/
13255: UPDATE mtl_serial_numbers_temp
13256: SET parent_object_number2 = l_mtli_csr.lot_number
13257: , parent_object_number = fm_serial_number
13258: , object_number2 = l_parent_object_number2
13259: , object_type2 = 1

Line 13283: UPDATE mtl_serial_numbers_temp

13279: , 'tmpinsert2'
13280: );
13281: END IF;
13282:
13283: UPDATE mtl_serial_numbers_temp
13284: SET parent_object_number2 = l_parent_object_number2
13285: , parent_object_number = fm_serial_number
13286: , object_number2 = l_mtli_csr.lot_number
13287: , object_type2 = 1

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 15474: FROM mtl_serial_numbers

15470: ELSIF p_object_type = 2 THEN
15471: IF (l_debug = 1) THEN mydebug('{{ Select serial_number from MSN }}' ); END IF;
15472: SELECT serial_number
15473: INTO l_object_number
15474: FROM mtl_serial_numbers
15475: WHERE gen_object_id = p_object_id;
15476: END IF;
15477: IF (l_debug = 1) THEN mydebug('l_object_number : ' || l_object_number ); END IF;
15478:

Line 15494: FROM mtl_serial_numbers

15490: ELSIF p_object_type = 2 THEN
15491: IF (l_debug = 1) THEN mydebug('{{ Select gen_object_id from MSN}}' ); END IF;
15492: SELECT gen_object_id
15493: INTO l_object_id
15494: FROM mtl_serial_numbers
15495: WHERE current_organization_id = p_org_id
15496: AND inventory_item_id = p_item_id
15497: AND serial_number = p_object_number;
15498: END IF;

Line 15514: FROM mtl_serial_numbers

15510: ELSIF p_object_type2 = 2 THEN
15511: IF (l_debug = 1) THEN mydebug('{{ Select serial_number from MSN }}' ); END IF;
15512: SELECT serial_number
15513: INTO l_object_number2
15514: FROM mtl_serial_numbers
15515: WHERE gen_object_id = p_object_id2;
15516: END IF;
15517: IF (l_debug = 1) THEN mydebug('l_object_number2 : ' || l_object_number2 ); END IF;
15518: ELSIF p_object_type2 is NOT NULL AND p_object_number2 IS NOT NULL AND p_item_id IS NOT NULL

Line 15533: FROM mtl_serial_numbers

15529: ELSIF p_object_type = 2 THEN
15530: IF (l_debug = 1) THEN mydebug('{{ Select gen_object_id from MSN}}' ); END IF;
15531: SELECT gen_object_id
15532: INTO l_object_id2
15533: FROM mtl_serial_numbers
15534: WHERE current_organization_id = p_org_id
15535: AND inventory_item_id = p_item_id
15536: AND serial_number = p_object_number2;
15537: END IF;

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;