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.WMS_PARAMETER_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 4535: FROM mtl_txn_request_lines mtrl, wms_transactions_temp wtt, mtl_transaction_types mtt

4531: , mtrl.inventory_item_id
4532: , wtt.to_subinventory_code subinventory_code
4533: , wtt.to_locator_id locator_id
4534: , wtt.primary_quantity
4535: FROM mtl_txn_request_lines mtrl, wms_transactions_temp wtt, mtl_transaction_types mtt
4536: WHERE wtt.type_code = 1 -- put away
4537: AND wtt.line_type_code = 2 -- output
4538: AND mtrl.line_id = wtt.transaction_temp_id
4539: AND mtrl.transaction_type_id = mtt.transaction_type_id) onhand

Line 4610: FROM mtl_txn_request_lines mtrl, wms_transactions_temp wtt, mtl_transaction_types mtt

4606: , mtrl.inventory_item_id
4607: , wtt.to_subinventory_code subinventory_code
4608: , wtt.to_locator_id locator_id
4609: , wtt.primary_quantity
4610: FROM mtl_txn_request_lines mtrl, wms_transactions_temp wtt, mtl_transaction_types mtt
4611: WHERE wtt.type_code = 1 -- put away
4612: AND wtt.line_type_code = 2 -- output
4613: AND mtrl.line_id = wtt.transaction_temp_id
4614: AND mtrl.transaction_type_id = mtt.transaction_type_id) onhand

Line 4689: FROM mtl_txn_request_lines mtrl, wms_transactions_temp wtt, mtl_transaction_types mtt

4685: , mtrl.inventory_item_id
4686: , wtt.to_subinventory_code subinventory_code
4687: , wtt.to_locator_id locator_id
4688: , wtt.primary_quantity
4689: FROM mtl_txn_request_lines mtrl, wms_transactions_temp wtt, mtl_transaction_types mtt
4690: WHERE wtt.type_code = 1 -- put away
4691: AND wtt.line_type_code = 2 -- output
4692: AND mtrl.line_id = wtt.transaction_temp_id
4693: AND mtrl.transaction_type_id = mtt.transaction_type_id) onhand

Line 4941: FROM mtl_txn_request_lines mtrl, wms_transactions_temp wtt, mtl_transaction_types mtt

4937: , mtrl.inventory_item_id
4938: , wtt.to_subinventory_code subinventory_code
4939: , wtt.to_locator_id locator_id
4940: , wtt.primary_quantity
4941: FROM mtl_txn_request_lines mtrl, wms_transactions_temp wtt, mtl_transaction_types mtt
4942: WHERE wtt.type_code = 1 -- put away
4943: AND wtt.line_type_code = 2 -- output
4944: AND mtrl.line_id = wtt.transaction_temp_id
4945: AND mtrl.transaction_type_id = mtt.transaction_type_id) onhand

Line 6117: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh

6113:
6114: BEGIN
6115: SELECT mtrh.move_order_type
6116: INTO l_hdr_type
6117: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl, mtl_txn_request_headers mtrh
6118: WHERE mmtt.transaction_temp_id = p_transaction_temp_id
6119: AND mtrl.line_id = mmtt.move_order_line_id
6120: AND mtrh.header_id = mtrl.header_id;
6121: