APPS.INV_RCV_INTEGRATION_APIS dependencies on RCV_LOTS_SUPPLY

Line 3324: FROM rcv_lots_supply rsl

3320: AND rt.group_id = p_group_id
3321: AND rt.lpn_group_id = p_lpn_group_id
3322: AND ((msi.lot_control_code = 2
3323: AND exists (SELECT 1
3324: FROM rcv_lots_supply rsl
3325: WHERE rsl.transaction_id = rs.rcv_transaction_id)
3326: )
3327: OR
3328: (msi.lot_control_code = 1))