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.

[Home] [Help]

APPS.WMS_PARAMETER_PVT dependencies on WMS_TRANSACTIONS_TEMP

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 5703: FROM wms_transactions_temp

5699: AND mtlt.lot_number <> p_lot_number
5700: UNION ALL
5701: --putaway suggestions already created for this move order
5702: SELECT lot_number
5703: FROM wms_transactions_temp
5704: WHERE type_code = 1
5705: AND line_type_code = 2
5706: AND to_subinventory_code = p_subinventory_code
5707: AND to_locator_id = p_locator_id

Line 5787: FROM wms_transactions_temp

5783: AND transaction_action_id IN (2, 3, 28)
5784: UNION ALL
5785: --suggestions already created for this move order line
5786: SELECT revision
5787: FROM wms_transactions_temp
5788: WHERE type_code = 1
5789: AND line_type_code = 2
5790: AND to_subinventory_code = p_subinventory_code
5791: AND to_locator_id = p_locator_id