Query to get Customer Bank account details

Query to get Customer Bank account details

SELECT ieba.iban,

       ieba.bank_account_name,

       ieba.bank_account_num,

       ipiua.instrument_payment_use_id,

       ieba.ext_bank_account_id,

       ipiua.attribute1,

       ieba.object_version_number,

       ieba.start_date,

       ieba.creation_date,

       ipiua.creation_date

  FROM apps.iby_external_payers_all  iepa,

       apps.iby_pmt_instr_uses_all   ipiua,

       apps.iby_ext_bank_accounts    ieba,

       apps.hz_cust_accounts         hca

 WHERE     iepa.ext_payer_id = ipiua.ext_pmt_party_id

       AND ipiua.instrument_id = ieba.ext_bank_account_id

       AND ipiua.instrument_type = 'BANKACCOUNT'

       AND ipiua.payment_function = 'CUSTOMER_PAYMENT'

       AND iepa.cust_account_id = hca.cust_account_id

       AND hca.account_number = '12345678'  -- Provide customer account number

       AND ipiua.end_date IS NULL;