This Query will help you to get Payable Payment details like invoice number, invoice amount, currency, amount paid, invoice date, payment status and many more columns 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