Payment details query in R12 EBS

 SELECT ipa.payee_name                   supplier_name,
             ipa.payee_supplier_number        supplier_number,
             ipa.payee_supplier_site_name     supplier_site,
             hou.name                         ou_name,
             ipa.payment_process_request_name ppr_name,
             aisc.creation_date               creation_date,
             ipa.payment_status               payment_status,
             ipa.payment_amount               payment_amount_batch,
             ipa.payment_currency_code        payment_currency_code_batch,
             ipa.payment_method_code          payment_method,
             ipa.payment_reference_number     payment_refernce_number,
             ipa.payment_profile_sys_name     payment_process_profile,
             ipa.int_bank_account_name        int_bank_account_name,
             ipa.int_bank_account_number      int_bank_account_number,
             apt.template_name                template_name,
             idpa.calling_app_doc_ref_number  invoice_number,
             idpa.payment_amount              payment_amount,
             idpa.payment_currency_code       payment_currency,
             ipa.payment_date                 payment_date,
             ipa.ext_bank_name                supplier_bank_name,
             ipa.ext_bank_number              supplier_bank_number,
             ipa.ext_eft_swift_code           eft_number,
             ipa.ext_bank_branch_name         bank_branch_name,
             ipa.ext_branch_number            bank_branch_number,
             ipa.ext_bank_account_name        bank_account_name,
             ipa.ext_bank_account_number      bank_acount_number,
             ipa.ext_bank_account_type        account_type,
             ipa.external_bank_account_id,
             isppb.OUTBOUND_PMT_FILE_DIRECTORY, isppb.OUTBOUND_PMT_FILE_EXTENSION,
             isppb.OUTBOUND_PMT_FILE_PREFIX,isppb.POSITIVE_PAY_FILE_DIRECTORY,isppb.POSITIVE_PAY_FILE_PREFIX
       FROM iby_payments_all              ipa,
             hr_operating_units            hou,
             ap_inv_selection_criteria_all aisc,
             ap_payment_templates          apt,
             iby_docs_payable_all          idpa,
             IBY_SYS_PMT_PROFILES_b        isppb,
             IBY_SYS_PMT_PROFILES_tl       ispp
       WHERE 1 = 1
         AND ipa.org_id = hou.organization_id
         AND ipa.payment_process_request_name = aisc.checkrun_name
         AND aisc.template_id = apt.template_id(+)
         AND ipa.payment_id = idpa.payment_id
         AND ipa.Payment_status IN ('FORMATTED', 'ISSUED')
         --AND ipa.paper_document_number IS NULL
         AND ipa.process_type = 'STANDARD'
         AND TRUNC(ipa.creation_date) >= TO_DATE('18/12/2015', 'DD/MM/YYYY')
         AND ispp.language='US'
         AND  isppb.SYSTEM_PROFILE_CODE=ispp.SYSTEM_PROFILE_CODE
         and ipa.payment_profile_sys_name=ispp.SYSTEM_PROFILE_NAME
       ORDER BY aisc.creation_date