This discussion is archived
2 Replies Latest reply: Feb 8, 2013 4:20 PM by 865659 RSS

query is returning multiple records for a bank account id and party id

865659 Newbie
Currently Being Moderated
Hi All,


I am not getting why this query is returning multiple records for a particular bank account id and party id:

SELECT instrument_payment_use_id
,instrument_type
,instrument_id
,start_date
,ext_pmt_party_id
FROM iby_pmt_instr_uses_all
WHERE instrument_id =:lv_num_ext_bank_account_id
and exists (select 1 from iby_external_payees_all b where PAYEE_PARTY_ID= :lv_num_party_id and b.ext_payee_id = ext_pmt_party_id)

I want above values to be used in api iby_disbursement_setup_pub.set_payee_instr_assignment in R12.


Please help asap.

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points