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 117: INSERT INTO mtl_material_transactions_temp

113: v_trx_hdr_id := x_trx_tmp_id;
114: END IF; */
115:
116:
117: INSERT INTO mtl_material_transactions_temp
118: (
119: transaction_header_id
120: , transaction_temp_id
121: , process_flag

Line 259: -- MTL_MATERIAL_TRANSACTIONS_TEMP

255: --
256: -- Functions: This function inserts a Lot Transaction record into
257: -- MTL_TRANSACTION_LOT_NUMBERS. The argument p_trx_tmp_id is
258: -- used to couple this record with a transaction-line in
259: -- MTL_MATERIAL_TRANSACTIONS_TEMP
260: --
261: FUNCTION insert_lot_trx(
262: p_trx_tmp_id IN NUMBER
263: , p_user_id IN NUMBER

Line 577: FROM mtl_lot_numbers mln, mtl_material_transactions_temp mmtt

573: , l_n_attribute9
574: , l_n_attribute10
575: , l_vendor_id
576: , l_territory_code
577: FROM mtl_lot_numbers mln, mtl_material_transactions_temp mmtt
578: WHERE mln.lot_number = LTRIM(RTRIM(p_lot_number))
579: AND mmtt.transaction_temp_id = p_trx_tmp_id
580: AND mln.organization_id = mmtt.organization_id
581: AND mln.inventory_item_id = mmtt.inventory_item_id;

Line 783: -- MTL_MATERIAL_TRANSACTIONS_TEMP

779: --
780: -- Functions: This API inserts a Serial Transaction record into
781: -- MTL_SERIAL_NUMBERS_TEMP. The argument p_trx_tmp_id is
782: -- used to couple this record with a transaction-line in
783: -- MTL_MATERIAL_TRANSACTIONS_TEMP
784: --
785: FUNCTION insert_ser_trx(
786: p_trx_tmp_id IN NUMBER
787: , p_user_id IN NUMBER

Line 915: FROM mtl_material_transactions_temp mmtt

911: , l_org_id
912: , l_trx_type_id
913: , l_subinventory_code
914: , l_locator_id
915: FROM mtl_material_transactions_temp mmtt
916: WHERE mmtt.transaction_temp_id = p_trx_tmp_id;
917: EXCEPTION
918: WHEN NO_DATA_FOUND THEN
919: -- both lot and serial controlled, then p_trx_tmp_id is coupled

Line 938: FROM mtl_transaction_lots_temp mtlt, mtl_material_transactions_temp mmtt

934: , l_trx_type_id
935: , l_subinventory_code
936: , l_locator_id
937: , l_lot_number
938: FROM mtl_transaction_lots_temp mtlt, mtl_material_transactions_temp mmtt
939: WHERE mtlt.serial_transaction_temp_id = p_trx_tmp_id
940: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id;
941:
942: l_serial_trx_tmp_id := p_trx_tmp_id;

Line 1277: FROM mtl_material_transactions_temp mmtt

1273: l_transaction_uom mtl_system_items.primary_uom_code%TYPE;
1274:
1275: CURSOR c_mmtt_info IS
1276: SELECT mmtt.organization_id, mmtt.inventory_item_id, mmtt.transaction_uom
1277: FROM mtl_material_transactions_temp mmtt
1278: WHERE mmtt.transaction_temp_id = p_transaction_temp_id;
1279:
1280: CURSOR c_item_info IS
1281: SELECT primary_uom_code

Line 1406: INSERT INTO mtl_material_transactions_temp(

1402:
1403:
1404: SELECT mtl_material_transactions_s.NEXTVAL INTO x_new_txn_temp_id FROM DUAL;
1405:
1406: INSERT INTO mtl_material_transactions_temp(
1407: transaction_header_id
1408: , transaction_temp_id
1409: , inventory_item_id
1410: , revision

Line 1794: FROM mtl_material_transactions_temp

1790: , program_application_id
1791: , program_id
1792: , program_update_date
1793: , decode(p_sec_txn_qty, fnd_api.g_miss_num, NULL, NULL, secondary_transaction_quantity, p_sec_txn_qty) --INVCONV KKILLAMS
1794: FROM mtl_material_transactions_temp
1795: WHERE transaction_temp_id = p_transaction_temp_id;
1796:
1797: IF l_debug = 1 THEN
1798: 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 1879: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt

1875:
1876: CURSOR c_item_info IS
1877: SELECT msi.inventory_item_id, msi.lot_control_code, msi.serial_number_control_code, mmtt.parent_line_id
1878: ,mmtt.transaction_header_id --Bug#6211912
1879: FROM mtl_system_items msi, mtl_material_transactions_temp mmtt
1880: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
1881: AND msi.inventory_item_id = mmtt.inventory_item_id
1882: AND msi.organization_id = mmtt.organization_id;
1883:

Line 1983: DELETE mtl_material_transactions_temp

1979: TRACE('Records deleted in WDT = ' || SQL%ROWCOUNT, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');
1980: END IF;
1981:
1982: -- Deleting the Transaction
1983: DELETE mtl_material_transactions_temp
1984: WHERE transaction_temp_id = p_transaction_temp_id;
1985:
1986: IF l_debug = 1 THEN
1987: TRACE('Records deleted in MMTT = ' || SQL%ROWCOUNT, 'INV_TRX_UTIL_PUB.DELETE_TRANSACTION');

Line 2123: FROM mtl_material_transactions_temp c, mtl_material_transactions_temp p

2119: l_serials_tbl inv_globals.varchar_tbl_type;
2120:
2121: CURSOR c_child_details IS
2122: SELECT c.inventory_item_id, c.primary_quantity, c.transaction_quantity, c.transaction_uom, p.transaction_uom
2123: FROM mtl_material_transactions_temp c, mtl_material_transactions_temp p
2124: WHERE c.transaction_temp_id = p_child_line_id
2125: AND p.transaction_temp_id = p_parent_line_id;
2126: BEGIN
2127: x_return_status := fnd_api.g_ret_sts_success;

Line 2201: UPDATE mtl_material_transactions_temp

2197: IF l_debug = 1 THEN
2198: TRACE('Updating the Parent Task with Txn Temp ID = ' || p_parent_line_id, 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');
2199: END IF;
2200:
2201: UPDATE mtl_material_transactions_temp
2202: 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)
2203: , primary_quantity = primary_quantity - l_child_pri_qty
2204: WHERE transaction_temp_id = p_parent_line_id
2205: RETURNING primary_quantity INTO l_parent_pri_qty;

Line 2236: DELETE mtl_material_transactions_temp WHERE transaction_temp_id = p_parent_line_id;

2232: TRACE('Deleting the Parent Task with Txn Temp ID = ' || p_parent_line_id, 'INV_TRX_UTIL_PUB.UPDATE_PARENT_MMTT');
2233: END IF;
2234:
2235: DELETE wms_dispatched_tasks WHERE transaction_temp_id = p_parent_line_id;
2236: DELETE mtl_material_transactions_temp WHERE transaction_temp_id = p_parent_line_id;
2237: END IF;
2238: END IF;
2239: EXCEPTION
2240: WHEN OTHERS THEN