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_PUB dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 260: , mtl_transaction_lots_interface mtli

256: , mti.transaction_batch_seq
257: , mti.kanban_card_id
258: , mti.transaction_mode --J-dev
259: FROM mtl_transactions_interface mti
260: , mtl_transaction_lots_interface mtli
261: , mtl_system_items_b msi
262: WHERE mti.transaction_interface_id = p_interface_id
263: AND mti.transaction_interface_id = mtli.transaction_interface_id
264: AND mti.organization_id = msi.organization_id

Line 363: FROM mtl_transaction_lots_interface mtli

359: , parent_object_number2 --R12 Genealogy enhancements
360: FROM mtl_serial_numbers_interface msni
361: WHERE msni.transaction_interface_id =
362: (SELECT serial_transaction_temp_id
363: FROM mtl_transaction_lots_interface mtli
364: WHERE mtli.transaction_interface_id = p_parent_id)
365: AND inv_serial_number_pub.get_serial_diff (msni.fm_serial_number
366: , p_serial_number
367: ) <> -1

Line 386: FROM mtl_transaction_lots_interface mtli

382: , NVL (to_serial_number, fm_serial_number) to_serial_number
383: FROM mtl_serial_numbers_interface msni
384: WHERE msni.transaction_interface_id IN (
385: SELECT serial_transaction_temp_id
386: FROM mtl_transaction_lots_interface mtli
387: WHERE mtli.transaction_interface_id IN (
388: SELECT transaction_interface_id
389: FROM mtl_transactions_interface mti
390: WHERE mti.parent_id = p_parent_id

Line 403: FROM mtl_transaction_lots_interface mtli

399: , NVL (to_serial_number, fm_serial_number) to_serial_number
400: FROM mtl_serial_numbers_interface msni
401: WHERE msni.transaction_interface_id =
402: (SELECT serial_transaction_temp_id
403: FROM mtl_transaction_lots_interface mtli
404: WHERE mtli.transaction_interface_id =
405: (SELECT transaction_interface_id
406: FROM mtl_transactions_interface mti
407: WHERE mti.parent_id = p_parent_id

Line 593: INSERT INTO mtl_transaction_lots_interface

589: THEN
590: inv_log_util.TRACE ('l_breadcrumb 40', 'INV_TXN_MANAGER_PUB', '9');
591: END IF;
592:
593: INSERT INTO mtl_transaction_lots_interface
594: (transaction_interface_id --J-dev
595: , last_update_date
596: , last_updated_by
597: , creation_date

Line 1255: UPDATE mtl_transaction_lots_interface

1251: l_rem_var_index := l_rem_serial_tbl.NEXT (l_rem_var_index);
1252: END LOOP;
1253:
1254: /*Need to update the MTLI with serial_txn_temP_id to connect with the MSNIs*/
1255: UPDATE mtl_transaction_lots_interface
1256: SET serial_transaction_temp_id = l_sequence
1257: WHERE transaction_interface_id = l_transaction_interface_id;
1258: END IF; --end of is_serial_controlled
1259: EXCEPTION

Line 2154: FROM MTL_TRANSACTION_LOTS_INTERFACE MTLI,

2150: 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,
2151: p_line_rec_type.TRANSFER_LOCATOR,
2152: p_line_rec_type.transaction_date,
2153: MP.NEGATIVE_INV_RECEIPT_CODE
2154: FROM MTL_TRANSACTION_LOTS_INTERFACE MTLI,
2155: MTL_PARAMETERS MP,
2156: MTL_SYSTEM_ITEMS MSI
2157: WHERE MP.ORGANIZATION_ID = p_line_rec_type.ORGANIZATION_ID
2158: --AND MP.NEGATIVE_INV_RECEIPT_CODE = 2 'bug 3679189'

Line 5038: FROM mtl_transaction_lots_interface mtli

5034: )
5035: , p_line_rec_type.transfer_locator
5036: , p_line_rec_type.transaction_date
5037: , mp.negative_inv_receipt_code
5038: FROM mtl_transaction_lots_interface mtli
5039: , mtl_parameters mp
5040: , mtl_system_items msi
5041: WHERE mp.organization_id = p_line_rec_type.organization_id
5042: -- AND MP.NEGATIVE_INV_RECEIPT_CODE = 2