APPS.INV_RCV_INTEGRATION_APIS dependencies on RCV_LOTS_SUPPLY

Line 3353: FROM rcv_lots_supply rsl

3349: AND rt.group_id = p_group_id
3350: AND rt.lpn_group_id = p_lpn_group_id
3351: AND ((msi.lot_control_code = 2
3352: AND exists (SELECT 1
3353: FROM rcv_lots_supply rsl
3354: WHERE rsl.transaction_id = rs.rcv_transaction_id)
3355: )
3356: OR
3357: (msi.lot_control_code = 1))