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 4883: FROM MTL_SERIAL_NUMBERS_INTERFACE

4879: THEN
4880: BEGIN
4881: SELECT 1
4882: into l_tnum
4883: FROM MTL_SERIAL_NUMBERS_INTERFACE
4884: WHERE TRANSACTION_INTERFACE_ID = l_sertempid
4885: AND ROWNUM < 2;
4886: EXCEPTION
4887: WHEN NO_DATA_FOUND THEN

Line 4918: DELETE FROM MTL_SERIAL_NUMBERS_INTERFACE

4914: END;
4915:
4916: ELSE
4917: IF (l_sertempid IS NOT NULL) THEN
4918: DELETE FROM MTL_SERIAL_NUMBERS_INTERFACE
4919: WHERE TRANSACTION_INTERFACE_ID = l_sertempid;
4920: END IF;
4921:
4922: END IF;

Line 5968: * MTL_TRANSACTION_LOTS_INTERFACE and MTL_SERIAL_NUMBERS_INTERFACE records

5964: *
5965: * validate_lot_serial_for_rcpt()
5966: * SDPAUL Bug# 5710830
5967: * This private procedure is used to validate a set of
5968: * MTL_TRANSACTION_LOTS_INTERFACE and MTL_SERIAL_NUMBERS_INTERFACE records
5969: * and inserts them into the corresponding master tables.
5970: * These validations are only needed for Receipt into stores transaction -> 27
5971: * and for the transaction sources -> 3,6 and 13.
5972: *

Line 6081: FROM MTL_SERIAL_NUMBERS_INTERFACE

6077:
6078: CURSOR cur_MSNI(interface_id NUMBER) IS
6079: SELECT FM_SERIAL_NUMBER
6080: , TO_SERIAL_NUMBER
6081: FROM MTL_SERIAL_NUMBERS_INTERFACE
6082: WHERE TRANSACTION_INTERFACE_ID = interface_id;
6083:
6084: -- PL/SQL table to store lot attributes
6085: l_attributes_tbl inv_lot_api_pub.char_tbl;

Line 8048: FROM mtl_serial_numbers_interface msni

8044: AND ABS(nvl(mtli.primary_quantity, inv_convert.inv_um_convert
8045: (l_itemid,5,mtli.transaction_quantity,l_trxuom,l_priuom,'','')))
8046: = (SELECT SUM(get_serial_diff_wrp
8047: (msni.fm_serial_number,nvl(msni.to_serial_number,msni.fm_serial_number)))
8048: FROM mtl_serial_numbers_interface msni
8049: WHERE msni.transaction_interface_id
8050: = mtli.serial_transaction_temp_id);
8051: EXCEPTION
8052: WHEN others THEN

Line 8096: FROM mtl_serial_numbers_interface msni

8092:
8093: SELECT SUM(get_serial_diff_wrp
8094: (fm_serial_number,NVL(to_serial_number,fm_serial_number)))
8095: INTO l_lot_ser_qty
8096: FROM mtl_serial_numbers_interface msni
8097: WHERE msni.transaction_interface_id =l_intid;
8098: EXCEPTION
8099: WHEN others THEN
8100: IF (l_debug = 1) THEN

Line 8283: FROM MTL_SERIAL_NUMBERS_INTERFACE

8279: ELSE
8280: BEGIN
8281: SELECT 1
8282: into l_tnum
8283: FROM MTL_SERIAL_NUMBERS_INTERFACE
8284: WHERE TRANSACTION_INTERFACE_ID = l_intid
8285: AND ROWNUM < 2;
8286: EXCEPTION
8287: WHEN NO_DATA_FOUND THEN

Line 8297: DELETE FROM MTL_SERIAL_NUMBERS_INTERFACE

8293: END;
8294: END IF;--l_intid is null
8295: ELSE
8296: IF (l_intid IS NOT NULL) THEN
8297: DELETE FROM MTL_SERIAL_NUMBERS_INTERFACE
8298: WHERE TRANSACTION_INTERFACE_ID = l_intid;
8299: END IF;
8300: END IF; --actions for serials.
8301: END IF;--if check actions for lots

Line 8921: select 1 FROM mtl_serial_numbers msn, mtl_serial_numbers_interface msni,

8917: AND PROCESS_FLAG = 1
8918: AND (
8919: EXISTS
8920: (
8921: select 1 FROM mtl_serial_numbers msn, mtl_serial_numbers_interface msni,
8922: mtl_transactions_interface mti, mtl_material_transactions_temp mmtt
8923: WHERE msn.serial_number BETWEEN msni.fm_serial_number AND msni.to_serial_number
8924: AND Length(msn.serial_number) = Length(msni.fm_serial_number)
8925: AND msn.current_organization_id = mti.organization_id

Line 8938: FROM mtl_serial_numbers msn, mtl_serial_numbers_interface msni,

8934: )
8935: OR EXISTS
8936: (
8937: select msn.serial_number, msn.group_mark_id,mti.transaction_interface_id
8938: FROM mtl_serial_numbers msn, mtl_serial_numbers_interface msni,
8939: mtl_transactions_interface mti,mtl_transaction_lots_interface mtli,
8940: mtl_material_transactions_temp mmtt
8941: WHERE msn.serial_number BETWEEN msni.fm_serial_number AND msni.to_serial_number
8942: AND Length(msn.serial_number) = Length(msni.fm_serial_number)

Line 10755: INSERT INTO MTL_SERIAL_NUMBERS_TEMP

10751: ));
10752:
10753:
10754:
10755: INSERT INTO MTL_SERIAL_NUMBERS_TEMP
10756: (TRANSACTION_TEMP_ID,
10757: LAST_UPDATE_DATE,
10758: LAST_UPDATED_BY,
10759: CREATION_DATE,

Line 10919: FROM MTL_SERIAL_NUMBERS_INTERFACE

10915: parent_item_id, --R12 Genealogy enhancements
10916: parent_object_type2, --R12 Genealogy enhancements
10917: parent_object_id2, --R12 Genealogy enhancements
10918: parent_object_number2 --R12 Genealogy enhancements
10919: FROM MTL_SERIAL_NUMBERS_INTERFACE
10920: WHERE (TRANSACTION_INTERFACE_ID IN (
10921: SELECT TRANSACTION_INTERFACE_ID
10922: FROM MTL_TRANSACTIONS_INTERFACE MTI
10923: WHERE TRANSACTION_HEADER_ID = p_header_id

Line 11277: serial_column_csr ('MTL_SERIAL_NUMBERS_INTERFACE')

11273: type and length of Serial Attributes, as this is being done in seperate procedure
11274: get_serial_attr_table. */
11275:
11276: /*FOR l_lot_ser_column_csr IN
11277: serial_column_csr ('MTL_SERIAL_NUMBERS_INTERFACE')
11278: LOOP
11279: l_column_idx := l_column_idx + 1;
11280: l_lot_ser_attr_tbl (l_column_idx).column_name :=
11281: l_lot_ser_column_csr.column_name;

Line 11329: || ' from mtl_serial_numbers_interface msni,'

11325: -- in the system
11326: /*
11327: l_select_stmt :=
11328: l_select_stmt
11329: || ' from mtl_serial_numbers_interface msni,'
11330: || ' mtl_serial_numbers msn,'
11331: || ' mtl_transaction_lots_interface mtli,'
11332: || ' mtl_transactions_interface mti'
11333: || ' where mti.parent_id = :b_parent_id'

Line 11330: || ' mtl_serial_numbers msn,'

11326: /*
11327: l_select_stmt :=
11328: l_select_stmt
11329: || ' from mtl_serial_numbers_interface msni,'
11330: || ' mtl_serial_numbers msn,'
11331: || ' mtl_transaction_lots_interface mtli,'
11332: || ' mtl_transactions_interface mti'
11333: || ' where mti.parent_id = :b_parent_id'
11334: || ' and mti.transaction_interface_id <> mti.parent_id'

Line 11881: FROM mtl_serial_numbers_interface msni

11877: , cycles_since_visit
11878: , time_since_mark
11879: , cycles_since_mark
11880: , number_of_repairs
11881: FROM mtl_serial_numbers_interface msni
11882: WHERE transaction_interface_id = l_serial_transaction_temp_id;
11883:
11884: CURSOR msn_serial_attributes_csr (
11885: l_serial_number IN VARCHAR2

Line 11960: FROM mtl_serial_numbers msn

11956: , cycles_since_visit
11957: , time_since_mark
11958: , cycles_since_mark
11959: , number_of_repairs
11960: FROM mtl_serial_numbers msn
11961: WHERE msn.serial_number = l_serial_number
11962: AND msn.inventory_item_id = l_inventory_item_id
11963: AND msn.current_organization_id = l_organization_id;
11964:

Line 12061: FROM mtl_serial_numbers

12057: , cycles_since_visit
12058: , time_since_mark
12059: , cycles_since_mark
12060: , number_of_repairs
12061: FROM mtl_serial_numbers
12062: WHERE inventory_item_id = p_inventory_item_id
12063: AND current_organization_id = p_organization_id
12064: AND current_status = 3
12065: AND current_subinventory_code = p_subinventory_code

Line 12078: FROM mtl_serial_numbers_temp

12074: CURSOR msnt_serials_csr (l_serial_transaction_temp_id IN NUMBER)
12075: IS
12076: SELECT fm_serial_number
12077: , transaction_temp_id
12078: FROM mtl_serial_numbers_temp
12079: WHERE transaction_temp_id = l_serial_transaction_temp_id
12080: FOR UPDATE NOWAIT;
12081:
12082: CURSOR mtli_parent_lots_csr (l_transaction_interface_id IN NUMBER)

Line 13030: INSERT INTO mtl_serial_numbers_temp

13026: THEN
13027: mydebug ('Inserting into MSNT', 'tmpinsert2');
13028: END IF;
13029:
13030: INSERT INTO mtl_serial_numbers_temp
13031: (transaction_temp_id
13032: , last_update_date
13033: , last_updated_by
13034: , creation_date

Line 13223: INSERT INTO mtl_serial_numbers_temp

13219: , 'tmpinsert2'
13220: );
13221: END IF;
13222:
13223: INSERT INTO mtl_serial_numbers_temp
13224: (transaction_temp_id
13225: , last_update_date
13226: , last_updated_by
13227: , creation_date

Line 13557: INSERT INTO mtl_serial_numbers_temp

13553: , 'tmpinsert2'
13554: );
13555: END IF;
13556:
13557: INSERT INTO mtl_serial_numbers_temp
13558: (transaction_temp_id
13559: , last_update_date
13560: , last_updated_by
13561: , creation_date

Line 13826: UPDATE mtl_serial_numbers_temp

13822: , 'tmpinsert2'
13823: );
13824: END IF;
13825: /*The behaviour here is taken from LotTrxManager.Bit Strange!*/
13826: UPDATE mtl_serial_numbers_temp
13827: SET parent_object_number2 = l_mtli_csr.lot_number
13828: , parent_object_number = fm_serial_number
13829: , object_number2 = l_parent_object_number2
13830: , object_type2 = 1

Line 13854: UPDATE mtl_serial_numbers_temp

13850: , 'tmpinsert2'
13851: );
13852: END IF;
13853:
13854: UPDATE mtl_serial_numbers_temp
13855: SET parent_object_number2 = l_parent_object_number2
13856: , parent_object_number = fm_serial_number
13857: , object_number2 = l_mtli_csr.lot_number
13858: , object_type2 = 1

Line 15253: DELETE FROM MTL_SERIAL_NUMBERS_INTERFACE

15249: return -1;
15250: ELSE
15251: --delete from mti/mtli/msni
15252:
15253: DELETE FROM MTL_SERIAL_NUMBERS_INTERFACE
15254: WHERE TRANSACTION_INTERFACE_ID
15255: IN(
15256: SELECT TRANSACTION_INTERFACE_ID
15257: FROM MTL_TRANSACTIONS_INTERFACE

Line 16102: FROM mtl_serial_numbers

16098: ELSIF p_object_type = 2 THEN
16099: IF (l_debug = 1) THEN mydebug('{{ Select serial_number from MSN }}' ); END IF;
16100: SELECT serial_number
16101: INTO l_object_number
16102: FROM mtl_serial_numbers
16103: WHERE gen_object_id = p_object_id;
16104: END IF;
16105: IF (l_debug = 1) THEN mydebug('l_object_number : ' || l_object_number ); END IF;
16106:

Line 16122: FROM mtl_serial_numbers

16118: ELSIF p_object_type = 2 THEN
16119: IF (l_debug = 1) THEN mydebug('{{ Select gen_object_id from MSN}}' ); END IF;
16120: SELECT gen_object_id
16121: INTO l_object_id
16122: FROM mtl_serial_numbers
16123: WHERE current_organization_id = p_org_id
16124: AND inventory_item_id = p_item_id
16125: AND serial_number = p_object_number;
16126: END IF;

Line 16142: FROM mtl_serial_numbers

16138: ELSIF p_object_type2 = 2 THEN
16139: IF (l_debug = 1) THEN mydebug('{{ Select serial_number from MSN }}' ); END IF;
16140: SELECT serial_number
16141: INTO l_object_number2
16142: FROM mtl_serial_numbers
16143: WHERE gen_object_id = p_object_id2;
16144: END IF;
16145: IF (l_debug = 1) THEN mydebug('l_object_number2 : ' || l_object_number2 ); END IF;
16146: ELSIF p_object_type2 is NOT NULL AND p_object_number2 IS NOT NULL AND p_item_id IS NOT NULL

Line 16161: FROM mtl_serial_numbers

16157: ELSIF p_object_type = 2 THEN
16158: IF (l_debug = 1) THEN mydebug('{{ Select gen_object_id from MSN}}' ); END IF;
16159: SELECT gen_object_id
16160: INTO l_object_id2
16161: FROM mtl_serial_numbers
16162: WHERE current_organization_id = p_org_id
16163: AND inventory_item_id = p_item_id
16164: AND serial_number = p_object_number2;
16165: END IF;

Line 16180: UPDATE MTL_SERIAL_NUMBERS_INTERFACE MSNI

16176: ,parent_object_number = l_object_number
16177: ,parent_object_number2 = l_object_number2
16178: WHERE ROWID = p_rowid;
16179: ELSIF p_table = 'MSNI' THEN
16180: UPDATE MTL_SERIAL_NUMBERS_INTERFACE MSNI
16181: SET parent_object_id = l_object_id
16182: ,parent_object_id2 = l_object_id2
16183: ,parent_object_number = l_object_number
16184: ,parent_object_number2 = l_object_number2

Line 16217: FROM MTL_SERIAL_NUMBERS_INTERFACE

16213: ,PARENT_OBJECT_ID2
16214: ,PARENT_OBJECT_NUMBER2
16215: ,PARENT_ITEM_ID
16216: ,ROWID
16217: FROM MTL_SERIAL_NUMBERS_INTERFACE
16218: WHERE TRANSACTION_INTERFACE_ID = p_interface_id;
16219:
16220: BEGIN
16221: x_return_status := lg_ret_sts_success;