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

Line 14: -- Functions: This API inserts a row into MTL_MATERIAL_TRANSACTIONS_TEMP

10:
11: --
12: -- Name: INSERT_LINE_TRX
13: --
14: -- Functions: This API inserts a row into MTL_MATERIAL_TRANSACTIONS_TEMP
15: -- The function returns the transaction_temp_id which is unique for this
16: -- record, and could be used for coupling Lot and Serial Transaction
17: -- records associated with this transaction.
18: --

Line 229: INSERT INTO mtl_material_transactions_temp

225: l_xfr_project_id := p_project_id;
226: l_xfr_task_id := p_task_id;
227: END IF;
228:
229: INSERT INTO mtl_material_transactions_temp
230: (
231: transaction_header_id
232: , transaction_temp_id
233: , process_flag

Line 387: -- MTL_MATERIAL_TRANSACTIONS_TEMP

383: --
384: -- Functions: This function inserts a Lot Transaction record into
385: -- MTL_TRANSACTION_LOT_NUMBERS. The argument p_trx_tmp_id is
386: -- used to couple this record with a transaction-line in
387: -- MTL_MATERIAL_TRANSACTIONS_TEMP
388: --
389: FUNCTION insert_lot_trx(
390: p_trx_tmp_id IN NUMBER
391: , p_user_id IN NUMBER

Line 705: FROM mtl_lot_numbers mln, mtl_material_transactions_temp mmtt

701: , l_n_attribute9
702: , l_n_attribute10
703: , l_vendor_id
704: , l_territory_code
705: FROM mtl_lot_numbers mln, mtl_material_transactions_temp mmtt
706: WHERE mln.lot_number = LTRIM(RTRIM(p_lot_number))
707: AND mmtt.transaction_temp_id = p_trx_tmp_id
708: AND mln.organization_id = mmtt.organization_id
709: AND mln.inventory_item_id = mmtt.inventory_item_id;

Line 911: -- MTL_MATERIAL_TRANSACTIONS_TEMP

907: --
908: -- Functions: This API inserts a Serial Transaction record into
909: -- MTL_SERIAL_NUMBERS_TEMP. The argument p_trx_tmp_id is
910: -- used to couple this record with a transaction-line in
911: -- MTL_MATERIAL_TRANSACTIONS_TEMP
912: --
913: FUNCTION insert_ser_trx(
914: p_trx_tmp_id IN NUMBER
915: , p_user_id IN NUMBER

Line 1043: FROM mtl_material_transactions_temp mmtt

1039: , l_org_id
1040: , l_trx_type_id
1041: , l_subinventory_code
1042: , l_locator_id
1043: FROM mtl_material_transactions_temp mmtt
1044: WHERE mmtt.transaction_temp_id = p_trx_tmp_id;
1045: EXCEPTION
1046: WHEN NO_DATA_FOUND THEN
1047: -- both lot and serial controlled, then p_trx_tmp_id is coupled

Line 1066: FROM mtl_transaction_lots_temp mtlt, mtl_material_transactions_temp mmtt

1062: , l_trx_type_id
1063: , l_subinventory_code
1064: , l_locator_id
1065: , l_lot_number
1066: FROM mtl_transaction_lots_temp mtlt, mtl_material_transactions_temp mmtt
1067: WHERE mtlt.serial_transaction_temp_id = p_trx_tmp_id
1068: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id;
1069:
1070: l_serial_trx_tmp_id := p_trx_tmp_id;

Line 1406: FROM mtl_material_transactions_temp mmtt

1402: l_secondary_uom varchar2(3);
1403:
1404: CURSOR c_mmtt_info IS
1405: SELECT mmtt.organization_id, mmtt.inventory_item_id, mmtt.transaction_uom
1406: FROM mtl_material_transactions_temp mmtt
1407: WHERE mmtt.transaction_temp_id = p_transaction_temp_id;
1408:
1409: CURSOR c_item_info IS
1410: SELECT primary_uom_code

Line 1538: FROM mtl_material_transactions_temp

1534: INTO l_secondary_uom
1535: FROM mtl_system_items msi
1536: WHERE msi.inventory_item_id =
1537: (SELECT decode(l_inventory_item_id, NULL, inventory_item_id, l_inventory_item_id)
1538: FROM mtl_material_transactions_temp
1539: WHERE transaction_temp_id = p_transaction_temp_id)
1540: AND msi.organization_id = l_organization_id;
1541: SELECT mtl_material_transactions_s.NEXTVAL INTO x_new_txn_temp_id FROM DUAL;
1542:

Line 1543: INSERT INTO mtl_material_transactions_temp(

1539: WHERE transaction_temp_id = p_transaction_temp_id)
1540: AND msi.organization_id = l_organization_id;
1541: SELECT mtl_material_transactions_s.NEXTVAL INTO x_new_txn_temp_id FROM DUAL;
1542:
1543: INSERT INTO mtl_material_transactions_temp(
1544: transaction_header_id
1545: , transaction_temp_id
1546: , inventory_item_id
1547: , revision

Line 1933: FROM mtl_material_transactions_temp

1929: , program_id
1930: , program_update_date
1931: , decode(p_sec_txn_qty, fnd_api.g_miss_num, NULL, NULL, secondary_transaction_quantity, p_sec_txn_qty) --INVCONV KKILLAMS
1932: ,decode(l_secondary_uom, NULL, secondary_uom_code, l_secondary_uom) --Bug#7716563
1933: FROM mtl_material_transactions_temp
1934: WHERE transaction_temp_id = p_transaction_temp_id;
1935:
1936: IF l_debug = 1 THEN
1937: inv_log_util.trace('Inserted a new record into MMTT with TxnTempID = ' || x_new_txn_temp_id, g_pkg_name || '.' || l_api_name, 5);

Line 2020: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt

2016: CURSOR c_item_info IS
2017: SELECT msi.inventory_item_id, msi.lot_control_code, msi.serial_number_control_code, mmtt.parent_line_id
2018: ,mmtt.transaction_header_id --Bug#6211912
2019: ,mmtt.organization_id -- 14259665 Performance Issue
2020: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt
2021: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
2022: AND msi.inventory_item_id = mmtt.inventory_item_id
2023: AND msi.organization_id = mmtt.organization_id;
2024:

Line 2138: DELETE mtl_material_transactions_temp

2134: TRACE('Records deleted in WDT = ' || SQL%ROWCOUNT, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
2135: END IF;
2136:
2137: -- Deleting the Transaction
2138: DELETE mtl_material_transactions_temp
2139: WHERE transaction_temp_id = p_transaction_temp_id;
2140:
2141: IF l_debug = 1 THEN
2142: TRACE('Records deleted in MMTT = ' || SQL%ROWCOUNT, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');

Line 2283: FROM mtl_material_transactions_temp c, mtl_material_transactions_temp p

2279:
2280:
2281: CURSOR c_child_details IS
2282: SELECT c.inventory_item_id, c.primary_quantity, c.transaction_quantity, c.secondary_transaction_quantity, c.transaction_uom, p.transaction_uom --BUG12753174
2283: FROM mtl_material_transactions_temp c, mtl_material_transactions_temp p
2284: WHERE c.transaction_temp_id = p_child_line_id
2285: AND p.transaction_temp_id = p_parent_line_id;
2286:
2287: -- Start 1 of Fix for Bug 11931654

Line 2396: UPDATE mtl_material_transactions_temp

2392: IF l_debug = 1 THEN
2393: TRACE('Updating the Parent Task with Txn Temp ID = ' || p_parent_line_id, 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');
2394: END IF;
2395:
2396: UPDATE mtl_material_transactions_temp
2397: SET transaction_quantity = transaction_quantity - inv_convert.inv_um_convert(inventory_item_id, NULL, l_child_txn_qty, l_child_uom, transaction_uom, NULL, NULL)
2398: , primary_quantity = primary_quantity - l_child_pri_qty
2399: , secondary_transaction_quantity = secondary_transaction_quantity - l_child_sec_txn_qty --BUG12753174
2400: WHERE transaction_temp_id = p_parent_line_id

Line 2432: DELETE mtl_material_transactions_temp WHERE transaction_temp_id = p_parent_line_id;

2428: TRACE('Deleting the Parent Task with Txn Temp ID = ' || p_parent_line_id, 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');
2429: END IF;
2430:
2431: DELETE wms_dispatched_tasks WHERE transaction_temp_id = p_parent_line_id;
2432: DELETE mtl_material_transactions_temp WHERE transaction_temp_id = p_parent_line_id;
2433: END IF;
2434: END IF;
2435: EXCEPTION
2436: WHEN OTHERS THEN