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.WIP_SO_RESERVATIONS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1250: from mtl_material_transactions_temp

1246: p_transaction_temp_id NUMBER) IS
1247: select completion_transaction_id,
1248: transaction_action_id,
1249: transaction_temp_id
1250: from mtl_material_transactions_temp
1251: where transaction_header_id = p_transaction_header_id
1252: and transaction_temp_id = nvl(p_transaction_temp_id,transaction_temp_id);
1253:
1254: BEGIN

Line 1402: -- mtl_material_transactions_temp (and lots_temp if lot

1398: --
1399: -- PROCEDURE get_transaction_lines
1400: --
1401: -- This procedure returns a table of transaction records from
1402: -- mtl_material_transactions_temp (and lots_temp if lot
1403: -- controlled)
1404: -- Used to match with reservation.
1405: --
1406: --

Line 1450: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

1446: mmtt.transaction_temp_id,
1447: null --never an lpn associated with a non-lpn completion
1448: FROM MTL_SYSTEM_ITEMS MSI,
1449: MTL_TRANSACTION_LOTS_TEMP MTLT,
1450: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
1451: WHERE mmtt.completion_transaction_id = cp_transaction_header_id
1452: AND mmtt.transaction_action_id = cp_transaction_action_id
1453: AND mmtt.transaction_source_type_id = 5 /* Job or Schedule */
1454: AND mtlt.transaction_temp_id (+) = mmtt.transaction_temp_id