DBA Data[Home] [Help]

APPS.WMS_PARAMETER_PVT dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 5693: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

5689: AND transaction_action_id IN (2, 3, 28)
5690: UNION ALL
5691: --pending receipts and putaway suggestions (lot in MTLT)
5692: SELECT mtlt.lot_number
5693: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
5694: WHERE mmtt.organization_id = p_organization_id
5695: AND mmtt.inventory_item_id = p_inventory_item_id
5696: AND mmtt.subinventory_code = p_subinventory_code
5697: AND mmtt.locator_id = p_locator_id

Line 5705: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt

5701: AND mtlt.lot_number <> p_lot_number
5702: UNION ALL
5703: --pending transfers and suggestions (lot in MTLT)
5704: SELECT mtlt.lot_number
5705: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
5706: WHERE mmtt.organization_id = p_organization_id
5707: AND mmtt.inventory_item_id = p_inventory_item_id
5708: AND mmtt.transfer_subinventory = p_subinventory_code
5709: AND mmtt.transfer_to_location = p_locator_id