Query To Get Payable Payment Details In Oracle Fusion ERP Application

 select     "AP_INVOICES_ALL"."INVOICE_ID" as "INVOICE_ID",

      "AP_INVOICES_ALL"."INVOICE_NUM" as "INVOICE_NUM",

      "AP_INVOICES_ALL"."INVOICE_AMOUNT" as "INVOICE_AMOUNT",

      "AP_INVOICES_ALL"."INVOICE_CURRENCY_CODE" as "INVOICE_CURRENCY_CODE",

      "AP_INVOICES_ALL"."AMOUNT_PAID" as "AMOUNT_PAID",

      "AP_INVOICES_ALL"."INVOICE_DATE" as "INVOICE_DATE",

      "AP_INVOICES_ALL"."INVOICE_TYPE_LOOKUP_CODE" as "INVOICE_TYPE_LOOKUP_CODE",

      "AP_INVOICES_ALL"."DESCRIPTION" as "DESCRIPTION",

      "AP_INVOICES_ALL"."PAYMENT_STATUS_FLAG" as "PAYMENT_STATUS_FLAG",

      "AP_INVOICE_PAYMENTS_ALL"."AMOUNT" as "AMOUNT",

      "AP_INVOICE_PAYMENTS_ALL"."ACCOUNTING_DATE" as "ACCOUNTING_DATE",

      "AP_INVOICE_PAYMENTS_ALL"."BANK_ACCOUNT_NUM" as "BANK_ACCOUNT_NUM",

      "AP_INVOICE_PAYMENTS_ALL"."BANK_ACCOUNT_TYPE" as "BANK_ACCOUNT_TYPE",

      "AP_INVOICE_PAYMENTS_ALL"."BANK_NUM" as "BANK_NUM",

      "AP_INVOICE_PAYMENTS_ALL"."CHECK_ID" as "CHECK_ID",

      "AP_CHECKS_ALL"."AMOUNT" as "AMOUNT_1",

      "AP_CHECKS_ALL"."BANK_ACCOUNT_NAME" as "BANK_ACCOUNT_NAME",

      "AP_CHECKS_ALL"."CHECK_DATE" as "CHECK_DATE",

      "AP_CHECKS_ALL"."CHECK_NUMBER" as "CHECK_NUMBER",

      "AP_CHECKS_ALL"."PAYMENT_METHOD_LOOKUP_CODE" as "PAYMENT_METHOD_LOOKUP_CODE",

      "AP_CHECKS_ALL"."PAYMENT_TYPE_FLAG" as "PAYMENT_TYPE_FLAG",

      "AP_CHECKS_ALL"."BANK_ACCOUNT_NUM" as "BANK_ACCOUNT_NUM_1",

      "AP_CHECKS_ALL"."BANK_NUM" as "BANK_NUM_1",

      "AP_CHECKS_ALL"."BANK_ACCOUNT_TYPE" as "BANK_ACCOUNT_TYPE_1",

      "AP_CHECKS_ALL"."DESCRIPTION" as "DESCRIPTION_1",

      "AP_INVOICE_PAYMENTS_ALL"."PAYMENT_NUM" as "PAYMENT_NUM",

      "AP_INVOICE_DISTRIBUTIONS_ALL"."DISTRIBUTION_LINE_NUMBER" as "DISTRIBUTION_LINE_NUMBER",

      "AP_INVOICE_DISTRIBUTIONS_ALL"."AMOUNT" as "AMOUNT_1_1",

      "AP_INVOICE_DISTRIBUTIONS_ALL"."DESCRIPTION" as "DESCRIPTION_1_1",

      "AP_INVOICE_DISTRIBUTIONS_ALL"."UNIT_PRICE" as "UNIT_PRICE",

      "AP_INVOICE_PAYMENTS_ALL"."INVOICING_PARTY_ID" as "INVOICING_PARTY_ID",

      "HZ_PARTIES"."PARTY_NUMBER" as "PARTY_NUMBER",

      "HZ_PARTIES"."PARTY_NAME" as "PARTY_NAME",

      "HZ_PARTIES"."PARTY_TYPE" as "PARTY_TYPE",

      "HZ_PARTIES"."ADDRESS1" as "ADDRESS1",

      "HZ_PARTIES"."ADDRESS2" as "ADDRESS2",

      "HZ_PARTIES"."CITY" as "CITY",

      "HZ_PARTIES"."COUNTRY" as "COUNTRY",

      "HZ_PARTIES"."STATE" as "STATE",

      "HZ_PARTIES"."PROVINCE" as "PROVINCE",

      "AP_INVOICES_ALL"."PARTY_ID" as "PARTY_ID",

      "AP_INVOICES_ALL"."PARTY_SITE_ID" as "PARTY_SITE_ID",

      "HZ_PARTY_SITES"."PARTY_SITE_NAME" as "PARTY_SITE_NAME" 

  from    "FUSION"."HZ_PARTY_SITES" "HZ_PARTY_SITES",

     "FUSION"."HZ_PARTIES" "HZ_PARTIES",

     "FUSION"."AP_INVOICE_DISTRIBUTIONS_ALL" "AP_INVOICE_DISTRIBUTIONS_ALL",

     "FUSION"."AP_CHECKS_ALL" "AP_CHECKS_ALL",

     "FUSION"."AP_INVOICES_ALL" "AP_INVOICES_ALL",

     "FUSION"."AP_INVOICE_PAYMENTS_ALL" "AP_INVOICE_PAYMENTS_ALL" 

  where   "AP_INVOICES_ALL"."INVOICE_ID"="AP_INVOICE_PAYMENTS_ALL"."INVOICE_ID"

  and     "AP_INVOICE_PAYMENTS_ALL"."CHECK_ID"="AP_CHECKS_ALL"."CHECK_ID"

  and     "AP_INVOICES_ALL"."INVOICE_ID"="AP_INVOICE_DISTRIBUTIONS_ALL"."INVOICE_ID"

  and     "AP_INVOICES_ALL"."PARTY_ID"="HZ_PARTIES"."PARTY_ID"(+)

  and     "AP_INVOICES_ALL"."PARTY_SITE_ID"="HZ_PARTY_SITES"."PARTY_SITE_ID"(+)

 order by "AP_INVOICES_ALL"."INVOICE_NUM" ASC