DBA Data[Home] [Help]

APPS.WMS_PARAMETER_PVT dependencies on MTL_TRANSACTION_TYPES

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