DBA Data[Home] [Help]

APPS.INV_RCV_MOBILE_PROCESS_TXN dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 806: FROM mtl_transaction_lots_temp a

802: WHEN no_data_found THEN
803: BEGIN
804: SELECT 1
805: INTO l_exists
806: FROM mtl_transaction_lots_temp a
807: , mtl_material_transactions_temp b
808: WHERE b.inventory_item_id = p_item_id
809: AND a.lot_number = p_lot_number
810: AND a.transaction_temp_id = b.transaction_temp_id