DBA Data[Home] [Help]

APPS.INV_LABEL dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 3977: FROM mtl_material_transactions_temp mmtt , mtl_transaction_lots_temp mtlt

3973: AND Nvl(mmtt.item_lot_control_code,-99) <> 2
3974: UNION
3975: SELECT mmtt.organization_id , mmtt.subinventory_code , mmtt.locator_id ,
3976: NVL(mmtt.lpn_id,mmtt.content_lpn_id) lpn_id , mmtt.transaction_action_id
3977: FROM mtl_material_transactions_temp mmtt , mtl_transaction_lots_temp mtlt
3978: WHERE mmtt.transaction_temp_id =p_transaction_id
3979: AND mmtt.inventory_item_id = l_inventory_item_id
3980: AND Nvl(mmtt.item_lot_control_code,-99) = 2
3981: AND mtlt.transaction_temp_id = mmtt.transaction_temp_id