Payments Query

SELECT pd.payment_document_id
    , pd.payment_document_name
    , ba.bank_account_name
    , app.payment_profile_id
    , app.payment_profile_name
 FROM ce_payment_documents     pd
    , iby_sys_pmt_profiles_b   spp
    , iby_acct_pmt_profiles_vl app
    , iby_formats_b            fmt
    , ce_bank_accounts         ba
WHERE pd.format_code              = spp.payment_format_code
  AND spp.system_profile_code     = app.system_profile_code
  AND fmt.format_code             = spp.payment_format_code
  AND fmt.format_type_code        = 'OUTBOUND_PAYMENT_INSTRUCTION'
  AND pd.internal_bank_account_id = ba.bank_account_id
ORDER BY 1,4