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_LPN_TRX_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 189: , v_mmtt_rec IN OUT NOCOPY mtl_material_transactions_temp%ROWTYPE

185: , v_subinv VARCHAR2
186: , v_locatorid NUMBER
187: , v_trxqty NUMBER
188: , v_cost_group_id NUMBER := NULL
189: , v_mmtt_rec IN OUT NOCOPY mtl_material_transactions_temp%ROWTYPE
190: , x_trxtempid OUT NOCOPY NUMBER
191: , v_sectrxqty NUMBER := NULL --INVCONV kkillams
192: ) IS
193: l_cst_grp_id NUMBER;

Line 259: INSERT INTO mtl_material_transactions_temp

255: -- trx_flow_header_id and logical_trx_type_code
256: -- Added original_transaction_temp_id to MMTT as part of ERES changes
257: -- Added source_line_id and source_code for bug 4931515
258: -- Added SOURCE_PROJECT_ID and SOURCE_TASK_ID for bug#5224902
259: INSERT INTO mtl_material_transactions_temp
260: (
261: transaction_header_id
262: , transaction_temp_id
263: , source_code

Line 585: FUNCTION explode_and_insert(p_lpn_id NUMBER, p_hdr_id NUMBER, p_mmtt IN OUT NOCOPY mtl_material_transactions_temp%ROWTYPE)

581:
582: /********************************************************************
583: * Explode the contents of the lpn and insert into MMTT, MSNT and MTLT
584: *******************************************************************/
585: FUNCTION explode_and_insert(p_lpn_id NUMBER, p_hdr_id NUMBER, p_mmtt IN OUT NOCOPY mtl_material_transactions_temp%ROWTYPE)
586: RETURN NUMBER IS
587: tb_lpn_cnts wms_container_pub.wms_container_tbl_type;
588: lpnitndx NUMBER;
589: curlpnrec wms_container_pub.wms_container_content_rec_type;

Line 681: UPDATE mtl_material_transactions_temp

677: -- Going to used the transaction_temp_id for the batch and 1 for the sequence.
678: p_mmtt.transaction_batch_id := NVL(p_mmtt.transaction_batch_id, p_mmtt.transaction_temp_id);
679: p_mmtt.transaction_batch_seq := NVL(p_mmtt.transaction_batch_seq, 1);
680:
681: UPDATE mtl_material_transactions_temp
682: SET inventory_item_id = -1
683: , transaction_batch_id = p_mmtt.transaction_batch_id
684: , transaction_batch_seq = p_mmtt.transaction_batch_seq
685: , subinventory_code = NVL(subinventory_code, l_lpn_subinv)

Line 709: UPDATE mtl_material_transactions_temp

705: RAISE fnd_api.g_exc_error;
706: END IF;
707: END IF;
708: ELSIF(p_mmtt.inventory_item_id <> -1) THEN
709: UPDATE mtl_material_transactions_temp
710: SET inventory_item_id = -1
711: WHERE transaction_temp_id = p_mmtt.transaction_temp_id;
712: END IF;
713:

Line 1063: UPDATE mtl_material_transactions_temp

1059: IF (l_debug = 1) THEN
1060: inv_log_util.TRACE('** Going to upd lst rec1. qty = ' || v_lastitemqty, 'INV_LPN_TRX_PUB', 9);
1061: END IF;
1062:
1063: UPDATE mtl_material_transactions_temp
1064: SET transaction_quantity = v_lastitemqty
1065: , primary_quantity = v_lastitemqty * l_conv_fact /*Bug#5486052.*/
1066: , secondary_transaction_quantity = CASE WHEN v_lastitemsecqty <> 0 THEN v_lastitemsecqty ELSE secondary_transaction_quantity END --INVCONV kkillams
1067: WHERE transaction_temp_id = v_lasttrxtmpid;

Line 1232: UPDATE mtl_material_transactions_temp

1228: END IF;
1229: END IF;
1230:
1231:
1232: UPDATE mtl_material_transactions_temp
1233: SET transaction_quantity = v_lastitemqty
1234: , primary_quantity = v_lastitemqty * l_conv_fact /*Bug#5486052.*/
1235: -- nsinghi bug#5553546 v_lastitemsecqty is being wrongly assigned as v_lastitemqty in THEN part. change it to v_lastitemsecqty
1236: -- , secondary_transaction_quantity = CASE WHEN v_lastitemsecqty <> 0 THEN v_lastitemqty ELSE secondary_transaction_quantity END

Line 1298: v_mmtt IN OUT NOCOPY mtl_material_transactions_temp%ROWTYPE

1294:
1295: --FOB changes. Patchset J. This API is only called wif PO pathset J is installed
1296: -- We track the FOB info in MMTT + MMT.
1297: PROCEDURE update_fob_point(
1298: v_mmtt IN OUT NOCOPY mtl_material_transactions_temp%ROWTYPE
1299: , x_return_status IN OUT NOCOPY VARCHAR2
1300: , x_msg_data IN OUT NOCOPY VARCHAR2
1301: , x_msg_count IN OUT NOCOPY NUMBER
1302: ) IS

Line 1352: UPDATE mtl_material_transactions_temp

1348: fnd_msg_pub.ADD;
1349: RAISE fnd_api.g_exc_error;
1350: END;
1351:
1352: UPDATE mtl_material_transactions_temp
1353: SET fob_point = l_fob_point
1354: , intransit_account = l_intransit_inv_account
1355: WHERE transaction_temp_id = v_mmtt.transaction_temp_id;
1356:

Line 1424: UPDATE mtl_material_transactions_temp

1420: END IF;
1421: RAISE fnd_api.g_exc_error;
1422: END;
1423: END IF;
1424: UPDATE mtl_material_transactions_temp
1425: SET fob_point = l_fob_point
1426: , intransit_account = l_intransit_inv_account
1427: WHERE transaction_temp_id = v_mmtt.transaction_temp_id;
1428:

Line 3320: FROM mtl_material_transactions_temp

3316:
3317: -- Bug# 7435480 Added trasanction_batch_seq in the order by clause
3318: CURSOR c_mmtt IS
3319: SELECT *
3320: FROM mtl_material_transactions_temp
3321: WHERE transaction_header_id = p_trx_hdr_id
3322: AND NVL(transaction_status, 1) <> 2 -- don't consider suggestions
3323: AND process_flag = 'Y'
3324: ORDER BY transaction_batch_id,transaction_batch_seq;

Line 3430: v_mmtt mtl_material_transactions_temp%ROWTYPE;

3426: insrowcnt NUMBER := 0;
3427: failedrowcnt NUMBER := 0;
3428: expldrowcnt NUMBER := 0;
3429: retval NUMBER := 0;
3430: v_mmtt mtl_material_transactions_temp%ROWTYPE;
3431: v_lpn wms_container_pub.lpn;
3432: v_deleterow BOOLEAN := FALSE; -- Should the original row in MMTT be deleted ?
3433: l_cst_grp VARCHAR2(30);
3434: l_req_id NUMBER;

Line 3575: FROM mtl_material_transactions_temp

3571: INTO l_is_cartonization
3572: FROM DUAL
3573: WHERE EXISTS(
3574: SELECT 1
3575: FROM mtl_material_transactions_temp
3576: WHERE transaction_action_id = inv_globals.g_action_containerpack
3577: AND transfer_lpn_id IS NULL
3578: AND transaction_header_id = p_trx_hdr_id);
3579: EXCEPTION

Line 3602: FROM mtl_material_transactions_temp

3598: SELECT organization_id
3599: , MAX(containers)
3600: INTO l_org
3601: , l_containers
3602: FROM mtl_material_transactions_temp
3603: WHERE transaction_header_id = p_trx_hdr_id
3604: AND NVL(transaction_status, 1) <> 2
3605: AND process_flag = 'Y'
3606: GROUP BY organization_id;

Line 3672: UPDATE mtl_material_transactions_temp

3668: IF (l_debug = 1) THEN
3669: inv_log_util.TRACE('Transfering Cartonization suggestions', 'INV_LPN_TRX_PUB', 9);
3670: END IF;
3671:
3672: UPDATE mtl_material_transactions_temp
3673: SET transfer_lpn_id = cartonization_id
3674: WHERE transaction_header_id = p_trx_hdr_id;
3675:
3676: IF (l_debug = 1) THEN

Line 3982: UPDATE mtl_material_transactions_temp

3978: AND wip_constants.dmf_patchset_level >= wip_constants.dmf_patchset_j_value) THEN
3979: IF (wip_mtltempproc_grp.istxnidrequired(v_mmtt.transaction_temp_id)) THEN
3980: inv_log_util.TRACE('Going to update mmtt with material_allocation_temp_id', 'INV_LPN_TRX_PUB', 1);
3981:
3982: UPDATE mtl_material_transactions_temp
3983: SET material_allocation_temp_id = mtl_material_transactions_s.NEXTVAL
3984: WHERE transaction_temp_id = v_mmtt.transaction_temp_id;
3985: END IF;
3986: END IF;

Line 4034: UPDATE mtl_material_transactions_temp

4030:
4031: -- Continue with the process based on the value of l_proc_mode
4032: IF l_proc_mode = 2 THEN -- Concurrent Mode
4033: -- Concurrent request. Submit request and return to caller
4034: UPDATE mtl_material_transactions_temp
4035: SET transaction_mode = inv_txn_manager_pub.proc_mode_mmtt_async
4036: WHERE transaction_header_id = p_trx_hdr_id;
4037:
4038: l_req_id := fnd_request.submit_request(application => 'INV', program => 'INVMBTRX', argument1 => p_trx_hdr_id);

Line 4068: UPDATE mtl_material_transactions_temp

4064: END IF;
4065:
4066: -- In this case, the background transaction manager would pick
4067: -- up this row from MMTT. Update transaction_mode and return to caller
4068: UPDATE mtl_material_transactions_temp
4069: SET transaction_mode = inv_txn_manager_pub.proc_mode_mmtt_bgrnd
4070: WHERE transaction_header_id = p_trx_hdr_id;
4071:
4072: fnd_message.set_name('INV', 'INV_TXN_REQ_QUEUED');

Line 4110: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP

4106: --get -ve of absolute
4107: v_mmtt.secondary_transaction_quantity := -1 * abs(v_mmtt.secondary_transaction_quantity);
4108: END IF;
4109: --END INVCONV kkillams
4110: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP
4111: SET PRIMARY_QUANTITY = v_mmtt.primary_quantity,
4112: TRANSACTION_QUANTITY = v_mmtt.transaction_quantity,
4113: SECONDARY_TRANSACTION_QUANTITY = CASE WHEN v_mmtt.secondary_uom_code IS NOT NULL THEN v_mmtt.secondary_transaction_quantity
4114: ELSE SECONDARY_TRANSACTION_QUANTITY

Line 4241: UPDATE mtl_material_transactions_temp

4237: --Set message in MMTT line based in header id
4238: -- Bug 3804314: Changed the where clause to transaction_header_id
4239: BEGIN
4240: -- Update MMTT records with error message and set status to error
4241: UPDATE mtl_material_transactions_temp
4242: SET ERROR_CODE = l_error_code
4243: , error_explanation = x_proc_msg
4244: , process_flag = 'E'
4245: , lock_flag = 'N'

Line 4280: FROM mtl_material_transactions_temp

4276:
4277: -- Remove from MSNT rows with same MMTT transaction_temp_id
4278: DELETE FROM mtl_serial_numbers_temp
4279: WHERE transaction_temp_id IN(SELECT transaction_temp_id
4280: FROM mtl_material_transactions_temp
4281: WHERE transaction_header_id = p_trx_hdr_id -- Bug 5748351
4282: AND transaction_batch_id = v_mmtt.transaction_batch_id);
4283:
4284: -- Remove from MSNT rows with same MTNT transaction_temp_id

Line 4289: FROM mtl_material_transactions_temp

4285: DELETE FROM mtl_serial_numbers_temp
4286: WHERE transaction_temp_id IN(SELECT serial_transaction_temp_id
4287: FROM mtl_transaction_lots_temp
4288: WHERE transaction_temp_id IN(SELECT transaction_temp_id
4289: FROM mtl_material_transactions_temp
4290: WHERE transaction_header_id = p_trx_hdr_id -- Bug 5748351
4291: AND transaction_batch_id = v_mmtt.transaction_batch_id));
4292:
4293: -- Remove from MTLT rows with same MMTT transaction_temp_id

Line 4296: FROM mtl_material_transactions_temp

4292:
4293: -- Remove from MTLT rows with same MMTT transaction_temp_id
4294: DELETE FROM mtl_transaction_lots_temp
4295: WHERE transaction_temp_id IN(SELECT transaction_temp_id
4296: FROM mtl_material_transactions_temp
4297: WHERE transaction_header_id = p_trx_hdr_id -- Bug 5748351
4298: AND transaction_batch_id = v_mmtt.transaction_batch_id);
4299:
4300: -- Remove from MMTT rows with same transaction group id

Line 4301: DELETE FROM mtl_material_transactions_temp

4297: WHERE transaction_header_id = p_trx_hdr_id -- Bug 5748351
4298: AND transaction_batch_id = v_mmtt.transaction_batch_id);
4299:
4300: -- Remove from MMTT rows with same transaction group id
4301: DELETE FROM mtl_material_transactions_temp
4302: WHERE transaction_header_id = p_trx_hdr_id -- Bug 5748351
4303: AND transaction_batch_id = v_mmtt.transaction_batch_id;
4304:
4305: ELSE -- IF v_mmtt.transaction_batch_id IS NULL

Line 4338: DELETE FROM mtl_material_transactions_temp

4334: DELETE FROM mtl_transaction_lots_temp
4335: WHERE transaction_temp_id = v_mmtt.transaction_temp_id;
4336:
4337: -- Remove from MMTT rows with same transaction group id
4338: DELETE FROM mtl_material_transactions_temp
4339: WHERE transaction_temp_id = v_mmtt.transaction_temp_id;
4340: END IF;
4341: EXCEPTION
4342: WHEN OTHERS THEN

Line 4351: UPDATE mtl_material_transactions_temp

4347: ELSE -- record originated in MMTT
4348: IF (v_mmtt.transaction_batch_id IS NOT NULL) THEN
4349: -- This record belongs to a batch. Fail all records of this batch
4350: -- stamp error-explanation only on the row that caused error
4351: UPDATE mtl_material_transactions_temp
4352: SET ERROR_CODE = l_error_code
4353: , error_explanation = x_proc_msg
4354: , process_flag = 'E'
4355: , lock_flag = 'N'

Line 4359: UPDATE mtl_material_transactions_temp

4355: , lock_flag = 'N'
4356: WHERE transaction_temp_id = v_mmtt.transaction_temp_id;
4357:
4358: -- stamp error-code on all records of the batch
4359: UPDATE mtl_material_transactions_temp
4360: SET ERROR_CODE = l_error_code
4361: , process_flag = 'E'
4362: , lock_flag = 'N'
4363: WHERE transaction_header_id = p_trx_hdr_id -- Bug 5748351

Line 4368: UPDATE mtl_material_transactions_temp

4364: AND transaction_batch_id = v_mmtt.transaction_batch_id;
4365: ELSE
4366: -- This record does not belong to a batch.
4367: -- Update MMTT records with error message and set status to error
4368: UPDATE mtl_material_transactions_temp
4369: SET ERROR_CODE = l_error_code
4370: , error_explanation = x_proc_msg
4371: , process_flag = 'E'
4372: , lock_flag = 'N'

Line 4390: update mtl_material_transactions_temp

4386: AND (sign(v_mmtt.secondary_transaction_quantity) <> sign(v_mmtt.transaction_quantity))
4387: --Bug# 5453879 - if trx qty is 0 leave the sec qty as it is.
4388: AND (v_mmtt.transaction_quantity <> 0) THEN
4389: l_secondary_txn_quantity := sign(v_mmtt.transaction_quantity) * abs(v_mmtt.secondary_transaction_quantity);
4390: update mtl_material_transactions_temp
4391: set secondary_transaction_quantity = l_secondary_txn_quantity
4392: where transaction_temp_id = v_mmtt.transaction_temp_id;
4393: END IF;
4394: IF (l_debug = 1) THEN

Line 4417: FROM mtl_material_transactions_temp

4413: -- by process code also. Otherwise, we will still call the TM.
4414: BEGIN
4415: SELECT COUNT(1)
4416: INTO l_process
4417: FROM mtl_material_transactions_temp
4418: WHERE transaction_header_id = p_trx_hdr_id
4419: AND process_flag = 'Y'
4420: AND ROWNUM < 2;
4421: IF (l_debug = 1) THEN

Line 4664: FROM mtl_material_transactions_temp

4660: SELECT 1
4661: INTO l_is_from_mti
4662: FROM DUAL
4663: WHERE EXISTS(SELECT 1
4664: FROM mtl_material_transactions_temp
4665: WHERE transaction_header_id = p_trx_hdr_id
4666: AND transaction_mode = inv_txn_manager_pub.proc_mode_mti);
4667: EXCEPTION
4668: WHEN NO_DATA_FOUND THEN

Line 4688: FROM mtl_material_transactions_temp

4684:
4685: -- Remove from MSNT rows with same MMTT Transaction_header_id
4686: DELETE FROM mtl_serial_numbers_temp
4687: WHERE transaction_temp_id IN(SELECT transaction_temp_id
4688: FROM mtl_material_transactions_temp
4689: WHERE transaction_header_id = p_trx_hdr_id);
4690:
4691: -- Remove from MSNT rows with same MTNT Transaction_header_id
4692: DELETE FROM mtl_serial_numbers_temp

Line 4696: FROM mtl_material_transactions_temp

4692: DELETE FROM mtl_serial_numbers_temp
4693: WHERE transaction_temp_id IN(SELECT serial_transaction_temp_id
4694: FROM mtl_transaction_lots_temp
4695: WHERE transaction_temp_id IN(SELECT transaction_temp_id
4696: FROM mtl_material_transactions_temp
4697: WHERE transaction_header_id = p_trx_hdr_id));
4698:
4699: -- Remove from MTLT rows with same MMTT Transaction_header_id
4700: DELETE FROM mtl_transaction_lots_temp

Line 4702: FROM mtl_material_transactions_temp

4698:
4699: -- Remove from MTLT rows with same MMTT Transaction_header_id
4700: DELETE FROM mtl_transaction_lots_temp
4701: WHERE transaction_temp_id IN(SELECT transaction_temp_id
4702: FROM mtl_material_transactions_temp
4703: WHERE transaction_header_id = p_trx_hdr_id);
4704:
4705: -- Remove from MMTT rows with same Transaction_header_id
4706: DELETE FROM mtl_material_transactions_temp

Line 4706: DELETE FROM mtl_material_transactions_temp

4702: FROM mtl_material_transactions_temp
4703: WHERE transaction_header_id = p_trx_hdr_id);
4704:
4705: -- Remove from MMTT rows with same Transaction_header_id
4706: DELETE FROM mtl_material_transactions_temp
4707: WHERE transaction_header_id = p_trx_hdr_id;
4708: ELSE
4709: UPDATE mtl_material_transactions_temp
4710: SET ERROR_CODE = l_error_code

Line 4709: UPDATE mtl_material_transactions_temp

4705: -- Remove from MMTT rows with same Transaction_header_id
4706: DELETE FROM mtl_material_transactions_temp
4707: WHERE transaction_header_id = p_trx_hdr_id;
4708: ELSE
4709: UPDATE mtl_material_transactions_temp
4710: SET ERROR_CODE = l_error_code
4711: , error_explanation = x_proc_msg
4712: , process_flag = 'E'
4713: , lock_flag = 'N'

Line 5986: FROM mtl_material_transactions_temp

5982:
5983: -- bug 2879208
5984: SELECT wms_task_type
5985: INTO l_system_task_type
5986: FROM mtl_material_transactions_temp
5987: WHERE transaction_temp_id = p_transaction_temp_id;
5988:
5989: IF (l_debug = 1) THEN
5990: inv_log_util.TRACE('l_system_task_type = ' || l_system_task_type, 'INV_LPN_TRX_PUB', 9);

Line 6618: UPDATE mtl_material_transactions_temp

6614: p_transaction_action_id = inv_globals.G_Action_Planxfr OR
6615: p_transaction_action_id = inv_globals.G_Action_Orgxfr OR
6616: p_transaction_action_id = inv_globals.G_Action_IntransitShipment))) then
6617: BEGIN
6618: UPDATE mtl_material_transactions_temp
6619: SET content_lpn_id = (SELECT outermost_lpn_id
6620: FROM wms_license_plate_numbers
6621: WHERE lpn_id = p_content_lpn_id
6622: AND rownum < 2)

Line 6688: FROM mtl_material_transactions_temp

6684: END IF;
6685:
6686: DELETE FROM mtl_serial_numbers_temp
6687: WHERE transaction_temp_id = (SELECT transaction_temp_id
6688: FROM mtl_material_transactions_temp
6689: WHERE transaction_temp_id = p_transaction_temp_id
6690: AND inventory_item_id = -1);
6691:
6692: IF SQL%ROWCOUNT = 0 THEN

Line 6699: FROM mtl_material_transactions_temp

6695: SELECT serial_transaction_temp_id
6696: FROM mtl_transaction_lots_temp
6697: WHERE transaction_temp_id =
6698: (SELECT transaction_temp_id
6699: FROM mtl_material_transactions_temp
6700: WHERE transaction_temp_id = p_transaction_temp_id
6701: AND inventory_item_id = -1));
6702: END IF;
6703:

Line 6710: FROM mtl_material_transactions_temp

6706: END IF;
6707:
6708: DELETE FROM mtl_transaction_lots_temp
6709: WHERE transaction_temp_id = (SELECT transaction_temp_id
6710: FROM mtl_material_transactions_temp
6711: WHERE transaction_temp_id = p_transaction_temp_id
6712: AND inventory_item_id = -1);
6713:
6714: IF (l_debug = 1) THEN

Line 6718: DELETE FROM mtl_material_transactions_temp

6714: IF (l_debug = 1) THEN
6715: inv_log_util.TRACE('* No of MTLT records deleted =' || SQL%ROWCOUNT, 'INV_LPN_TRX_PUB', 1);
6716: END IF;
6717:
6718: DELETE FROM mtl_material_transactions_temp
6719: WHERE transaction_temp_id = p_transaction_temp_id
6720: AND inventory_item_id = -1;
6721:
6722: IF (l_debug = 1) THEN