2 Replies Latest reply: Feb 8, 2013 6:20 PM by 865659 RSS

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

    865659
      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