DBA Data[Home] [Help]

APPS.GMIVLDX dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 229: FROM mtl_transaction_lots_temp lot, mtl_material_transactions_temp mtl

225: END IF;
226:
227: SELECT COUNT(1)
228: INTO l_count
229: FROM mtl_transaction_lots_temp lot, mtl_material_transactions_temp mtl
230: WHERE mtl.inventory_item_id <> p_odm_item_id
231: AND lot.lot_number = p_odm_lot_number
232: AND mtl.transaction_temp_id = lot.transaction_temp_id
233: AND ROWNUM = 1;

Line 243: FROM mtl_material_transactions_temp mtl

239: END IF;
240:
241: SELECT COUNT(1)
242: INTO l_count
243: FROM mtl_material_transactions_temp mtl
244: WHERE mtl.inventory_item_id <> p_odm_item_id
245: AND mtl.lot_number = p_odm_lot_number
246: AND ROWNUM = 1;
247: