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_TRANSACTION_LOTS_INTERFACE

Line 437: MTL_TRANSACTION_LOTS_INTERFACE MTLI,

433: mti.transaction_batch_seq,
434: mti.kanban_card_id,
435: mti.transaction_mode --J-dev
436: FROM MTL_TRANSACTIONS_INTERFACE MTI,
437: MTL_TRANSACTION_LOTS_INTERFACE MTLI,
438: MTL_SYSTEM_ITEMS_B MSI
439: WHERE mti.transaction_interface_id = p_interface_id
440: AND MTI.transaction_interface_id = mtli.transaction_interface_id
441: AND MTI.organization_id = msi.organization_id

Line 573: INSERT INTO mtl_transaction_lots_interface

569: l_mti_csr.cost_group_id,
570: l_mti_csr.transaction_batch_id,
571: l_mti_csr.transaction_batch_seq,
572: l_mti_csr.kanban_card_id);
573: INSERT INTO mtl_transaction_lots_interface
574: (transaction_interface_id, --J-dev
575: last_update_date ,
576: last_updated_by ,
577: creation_date ,

Line 1303: UPDATE MTL_TRANSACTION_LOTS_INTERFACE MTLI

1299: --Jalaj Srivastava Bug 4969885
1300: --if errors are for lot record then also update MLTI
1301: IF (lot_rowid IS NOT NULL) THEN
1302:
1303: UPDATE MTL_TRANSACTION_LOTS_INTERFACE MTLI
1304: SET LAST_UPDATE_DATE = SYSDATE,
1305: LAST_UPDATED_BY = l_userid,
1306: LAST_UPDATE_LOGIN = l_loginid,
1307: PROGRAM_UPDATE_DATE = SYSDATE,

Line 4016: FROM MTL_TRANSACTION_LOTS_INTERFACE

4012: parent_item_id, --R12 Genealogy enhancements
4013: parent_object_type2, --R12 Genealogy enhancements
4014: parent_object_id2, --R12 Genealogy enhancements
4015: parent_object_number2 --R12 Genealogy enhancements
4016: FROM MTL_TRANSACTION_LOTS_INTERFACE
4017: WHERE TRANSACTION_INTERFACE_ID = p_intid;
4018: -- INVCONV fabdi end
4019:
4020:

Line 4168: FROM MTL_TRANSACTION_LOTS_INTERFACE MTLI

4164: ERROR_EXPLANATION = substrb(l_error_exp,1,240)
4165: WHERE ROWID = p_rowid
4166: AND ABS(TRANSACTION_QUANTITY) <>
4167: (SELECT ABS(SUM(TRANSACTION_QUANTITY))
4168: FROM MTL_TRANSACTION_LOTS_INTERFACE MTLI
4169: WHERE MTLI.TRANSACTION_INTERFACE_ID = p_intid);
4170:
4171: IF SQL%FOUND THEN
4172: return(FALSE);

Line 4179: UPDATE MTL_TRANSACTION_LOTS_INTERFACE MTLI

4175: IF p_lotuniq = 1 THEN
4176: FND_MESSAGE.set_name('INV','INV_INT_LOTUNIQCODE');
4177: l_error_code := FND_MESSAGE.get;
4178:
4179: UPDATE MTL_TRANSACTION_LOTS_INTERFACE MTLI
4180: SET LAST_UPDATE_DATE = SYSDATE,
4181: LAST_UPDATED_BY = l_userid,
4182: LAST_UPDATE_LOGIN = l_loginid,
4183: PROGRAM_APPLICATION_ID = l_applid,

Line 4300: UPDATE MTL_TRANSACTION_LOTS_INTERFACE MTLI

4296: IF (l_debug = 1) THEN
4297: inv_log_util.trace('validate_quantities IN (lotcheck) ==> PASS ' , 'INV_TXN_MANAGER_GRP', 9);
4298: END IF;
4299:
4300: UPDATE MTL_TRANSACTION_LOTS_INTERFACE MTLI
4301: SET TRANSACTION_QUANTITY = l_lotqty,
4302: SECONDARY_TRANSACTION_QUANTITY = l_secondary_quantity
4303: WHERE ROWID = l_lotrowid;
4304: ELSE

Line 4371: UPDATE MTL_TRANSACTION_LOTS_INTERFACE MTLI

4367: -- Expiration date was getting reset and hence ensured that appropriate value gets updated to MTLI.
4368: -- nsinghi bug#5209065 rework. Added fnd_date.date_to_canonical call.
4369: l_lotexpdate := fnd_date.date_to_canonical(l_expiration_date);
4370:
4371: UPDATE MTL_TRANSACTION_LOTS_INTERFACE MTLI
4372: SET GRADE_CODE = l_grade_code ,
4373: RETEST_DATE = l_retest_date ,
4374: MATURITY_DATE = l_maturity_date,
4375: PARENT_LOT_NUMBER = l_parent_lot_number,

Line 4483: UPDATE MTL_TRANSACTION_LOTS_INTERFACE MTLI

4479:
4480: FND_MESSAGE.set_name('INV','INV_INT_UOMCONVCODE');
4481: l_error_code := FND_MESSAGE.get;
4482:
4483: UPDATE MTL_TRANSACTION_LOTS_INTERFACE MTLI
4484: SET LAST_UPDATE_DATE = SYSDATE,
4485: LAST_UPDATED_BY = l_userid,
4486: LAST_UPDATE_LOGIN = l_loginid,
4487: PROGRAM_APPLICATION_ID = l_applid,

Line 4534: UPDATE MTL_TRANSACTION_LOTS_INTERFACE MTLI

4530: l_error_exp := FND_MESSAGE.get;
4531: FND_MESSAGE.set_name('INV','INV_LOT_EXPREQD');
4532: l_error_code := FND_MESSAGE.get;
4533:
4534: UPDATE MTL_TRANSACTION_LOTS_INTERFACE MTLI
4535: SET LAST_UPDATE_DATE = SYSDATE,
4536: LAST_UPDATED_BY = l_userid,
4537: LAST_UPDATE_LOGIN = l_loginid,
4538: PROGRAM_APPLICATION_ID = l_applid,

Line 4587: UPDATE MTL_TRANSACTION_LOTS_INTERFACE MTLI

4583: EXCEPTION
4584: WHEN NO_DATA_FOUND THEN
4585: loaderrmsg('INV_INT_SERMISCODE','INV_INT_SERMISEXP');
4586:
4587: UPDATE MTL_TRANSACTION_LOTS_INTERFACE MTLI
4588: SET LAST_UPDATE_DATE = SYSDATE,
4589: LAST_UPDATED_BY = l_userid,
4590: LAST_UPDATE_LOGIN = l_loginid,
4591: PROGRAM_APPLICATION_ID = l_applid,

Line 4620: UPDATE MTL_TRANSACTION_LOTS_INTERFACE MTLI

4616: WHERE TRANSACTION_INTERFACE_ID = l_sertempid;
4617: END IF;
4618:
4619: END IF;
4620: UPDATE MTL_TRANSACTION_LOTS_INTERFACE MTLI
4621: SET LAST_UPDATE_DATE = SYSDATE,
4622: LAST_UPDATED_BY = l_userid,
4623: LAST_UPDATE_LOGIN = l_loginid,
4624: PROGRAM_APPLICATION_ID = l_applid,

Line 5496: FROM MTL_TRANSACTION_LOTS_INTERFACE

5492: CURSOR lots IS
5493: SELECT ROWID
5494: , lot_number
5495: , status_id
5496: FROM MTL_TRANSACTION_LOTS_INTERFACE
5497: WHERE transaction_interface_id = p_txn_interface_id;
5498:
5499: Begin
5500: IF (l_debug = 1) THEN

Line 5556: UPDATE mtl_transaction_lots_interface

5552: IF (l_debug = 1) THEN
5553: inv_log_util.trace('Before Update of MTLI', 'INV_TXN_MANAGER_GRP','1');
5554: End If;
5555:
5556: UPDATE mtl_transaction_lots_interface
5557: SET status_id = l_mtli_status_id
5558: ,last_updated_by = fnd_global.user_id
5559: ,last_update_date = sysdate
5560: ,last_update_login = fnd_global.login_id

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 5696: FROM MTL_TRANSACTION_LOTS_INTERFACE

5692: , TERRITORY_CODE
5693: , SUPPLIER_LOT_NUMBER
5694: , VENDOR_NAME
5695: , SERIAL_TRANSACTION_TEMP_ID
5696: FROM MTL_TRANSACTION_LOTS_INTERFACE
5697: WHERE TRANSACTION_INTERFACE_ID = p_interface_id;
5698:
5699: CURSOR cur_MSNI(interface_id NUMBER) IS
5700: SELECT FM_SERIAL_NUMBER

Line 7601: FROM mtl_transaction_lots_interface mtli

7597: END IF;
7598:
7599: SELECT NVL(SUM(ABS(NVL(mtli.transaction_quantity,0))), 0)
7600: INTO l_lot_ser_qty
7601: FROM mtl_transaction_lots_interface mtli
7602: WHERE mtli.transaction_interface_id =l_intid
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

Line 7723: FROM MTL_TRANSACTION_LOTS_INTERFACE

7719: IF l_intid IS NOT NULL THEN
7720: BEGIN
7721: SELECT 1
7722: into l_tnum
7723: FROM MTL_TRANSACTION_LOTS_INTERFACE
7724: WHERE TRANSACTION_INTERFACE_ID = l_intid
7725: AND ROWNUM < 2;
7726:
7727: /**********************************************************

Line 7762: DELETE FROM MTL_TRANSACTION_LOTS_INTERFACE

7758: RAISE fnd_api.g_exc_error;
7759: END IF;--l_intid is null
7760: ELSE
7761: IF l_intid IS NOT NULL THEN
7762: DELETE FROM MTL_TRANSACTION_LOTS_INTERFACE
7763: WHERE TRANSACTION_INTERFACE_ID = l_intid;
7764: END IF;
7765:
7766: /* Additional checking for Dynamic SerCtrl and srctype = 8

Line 8305: FROM MTL_TRANSACTION_LOTS_INTERFACE MTLI

8301: inv_log_util.trace('update secondary quantity on line as sum of lot level secondary quantities', 'INV_TXN_MANAGER_GRP', 9);
8302: END IF;
8303: UPDATE MTL_TRANSACTIONS_INTERFACE MTI
8304: SET secondary_transaction_quantity = (SELECT SUM(SECONDARY_TRANSACTION_QUANTITY)
8305: FROM MTL_TRANSACTION_LOTS_INTERFACE MTLI
8306: WHERE MTLI.TRANSACTION_INTERFACE_ID = p_line_Rec_Type.TRANSACTION_INTERFACE_ID)
8307: WHERE ROWID = l_rowid;
8308: END IF;
8309:

Line 10168: FROM MTL_TRANSACTION_LOTS_INTERFACE

10164: parent_item_id, --R12 Genealogy enhancements
10165: parent_object_type2, --R12 Genealogy enhancements
10166: parent_object_id2, --R12 Genealogy enhancements
10167: parent_object_number2 --R12 Genealogy enhancements
10168: FROM MTL_TRANSACTION_LOTS_INTERFACE
10169: WHERE TRANSACTION_INTERFACE_ID IN (
10170: SELECT TRANSACTION_INTERFACE_ID
10171: FROM MTL_TRANSACTIONS_INTERFACE MTI
10172: WHERE mti.TRANSACTION_HEADER_ID = p_header_id

Line 10363: FROM MTL_TRANSACTION_LOTS_INTERFACE

10359: , inv_globals.g_type_inv_lot_translate
10360: )
10361: UNION ALL
10362: SELECT SERIAL_TRANSACTION_TEMP_ID
10363: FROM MTL_TRANSACTION_LOTS_INTERFACE
10364: WHERE TRANSACTION_INTERFACE_ID IN (
10365: SELECT TRANSACTION_INTERFACE_ID
10366: FROM MTL_TRANSACTIONS_INTERFACE
10367: WHERE TRANSACTION_HEADER_ID = p_header_id

Line 10760: || ' mtl_transaction_lots_interface mtli,'

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'
10764: || ' and mtli.transaction_interface_id = mti.transaction_interface_id'

Line 11220: FROM mtl_transaction_lots_interface

11216: , parent_item_id
11217: , parent_object_type2
11218: , parent_object_id2
11219: , parent_object_number2 --R12 Genealogy enhancements
11220: FROM mtl_transaction_lots_interface
11221: WHERE transaction_interface_id = p_transaction_interface_id;
11222:
11223: CURSOR msni_csr (l_serial_transaction_temp_id IN NUMBER)
11224: IS

Line 11515: FROM mtl_transaction_lots_interface mtli

11511: CURSOR mtli_parent_lots_csr (l_transaction_interface_id IN NUMBER)
11512: IS
11513: SELECT mtli.lot_number
11514: , mtli.serial_transaction_temp_id
11515: FROM mtl_transaction_lots_interface mtli
11516: WHERE mtli.transaction_interface_id =
11517: (SELECT mti.transaction_interface_id
11518: FROM mtl_transactions_interface mti
11519: WHERE mti.parent_id = l_transaction_interface_id

Line 12915: ,mtl_transaction_lots_interface mtli

12911: ,l_old_sub_code
12912: ,l_old_locator_id
12913: ,l_old_lpn_id
12914: FROM mtl_transactions_interface mti
12915: ,mtl_transaction_lots_interface mtli
12916: WHERE mti.transaction_interface_id = mtli.transaction_interface_id
12917: AND mti.transaction_interface_id = mti.parent_id
12918: AND mti.transaction_interface_id = l_mti_csr.parent_id;
12919: IF(l_old_item_id <> l_mti_csr.inventory_item_id) THEN

Line 13214: FROM mtl_transaction_lots_interface

13210: END IF;
13211:
13212: SELECT lot_number
13213: INTO l_parent_object_number2
13214: FROM mtl_transaction_lots_interface
13215: WHERE transaction_interface_id = l_mti_csr.parent_id;
13216:
13217: SELECT serial_transaction_temp_id
13218: INTO l_serial_temp_id

Line 13654: FROM MTL_TRANSACTION_LOTS_INTERFACE MTLI,

13650: decode(p_line_rec_type.TRANSACTION_ACTION_ID,2,p_line_rec_type.TRANSFER_SUBINVENTORY,28,p_line_rec_type.TRANSFER_SUBINVENTORY,5,p_line_rec_type.transfer_subinventory,null) TRANSFER_SUBINVENTORY,
13651: p_line_rec_type.TRANSFER_LOCATOR,
13652: p_line_rec_type.transaction_date,
13653: MP.NEGATIVE_INV_RECEIPT_CODE
13654: FROM MTL_TRANSACTION_LOTS_INTERFACE MTLI,
13655: MTL_PARAMETERS MP,
13656: MTL_SYSTEM_ITEMS MSI
13657: WHERE MP.ORGANIZATION_ID = p_line_rec_type.ORGANIZATION_ID
13658: --AND MP.NEGATIVE_INV_RECEIPT_CODE = 2 'bug 3679189'

Line 14677: FROM MTL_TRANSACTION_LOTS_INTERFACE

14673: WHERE TRANSACTION_HEADER_ID =l_header_id
14674: AND PROCESS_FLAG <> 3
14675: union all
14676: SELECT SERIAL_TRANSACTION_TEMP_ID
14677: FROM MTL_TRANSACTION_LOTS_INTERFACE
14678: WHERE TRANSACTION_INTERFACE_ID
14679: IN (
14680: SELECT TRANSACTION_INTERFACE_ID
14681: FROM MTL_TRANSACTIONS_INTERFACE

Line 14684: DELETE FROM MTL_TRANSACTION_LOTS_INTERFACE

14680: SELECT TRANSACTION_INTERFACE_ID
14681: FROM MTL_TRANSACTIONS_INTERFACE
14682: WHERE TRANSACTION_HEADER_ID = l_header_id
14683: AND PROCESS_FLAG <> 3 )) ;
14684: DELETE FROM MTL_TRANSACTION_LOTS_INTERFACE
14685: WHERE TRANSACTION_INTERFACE_ID IN
14686: (SELECT TRANSACTION_INTERFACE_ID
14687: FROM MTL_TRANSACTIONS_INTERFACE
14688: WHERE TRANSACTION_HEADER_ID =l_header_id

Line 15329: UPDATE MTL_TRANSACTION_LOTS_INTERFACE MTLI

15325: /******************* END Perform Date validation logic ********************/
15326: EXCEPTION
15327: WHEN FND_API.G_EXC_ERROR THEN
15328: x_return_status := FND_API.G_RET_STS_ERROR;
15329: UPDATE MTL_TRANSACTION_LOTS_INTERFACE MTLI
15330: SET LAST_UPDATE_DATE = SYSDATE,
15331: LAST_UPDATED_BY = l_userid,
15332: LAST_UPDATE_LOGIN = l_loginid,
15333: PROGRAM_APPLICATION_ID = l_applid,

Line 15360: UPDATE MTL_TRANSACTION_LOTS_INTERFACE MTLI

15356: end if;
15357:
15358: l_error_code := x_msg_data;
15359: l_error_exp := x_msg_data;
15360: UPDATE MTL_TRANSACTION_LOTS_INTERFACE MTLI
15361: SET LAST_UPDATE_DATE = SYSDATE,
15362: LAST_UPDATED_BY = l_userid,
15363: LAST_UPDATE_LOGIN = l_loginid,
15364: PROGRAM_APPLICATION_ID = l_applid,

Line 15392: UPDATE MTL_TRANSACTION_LOTS_INTERFACE MTLI

15388:
15389: l_error_code := x_msg_data;
15390: l_error_exp := x_msg_data;
15391:
15392: UPDATE MTL_TRANSACTION_LOTS_INTERFACE MTLI
15393: SET LAST_UPDATE_DATE = SYSDATE,
15394: LAST_UPDATED_BY = l_userid,
15395: LAST_UPDATE_LOGIN = l_loginid,
15396: PROGRAM_APPLICATION_ID = l_applid,

Line 15545: UPDATE MTL_TRANSACTION_LOTS_INTERFACE MTLI

15541: IF l_object_id IS NOT NULL OR l_object_number IS NOT NULL OR
15542: l_object_number2 IS NOT NULL OR l_object_id2 IS NOT NULL
15543: THEN
15544: IF p_table = 'MTLI' THEN
15545: UPDATE MTL_TRANSACTION_LOTS_INTERFACE MTLI
15546: SET parent_object_id = l_object_id
15547: ,parent_object_id2 = l_object_id2
15548: ,parent_object_number = l_object_number
15549: ,parent_object_number2 = l_object_number2