Query to Get Payable Invoice Details in Oracle Fusion ERP Application - Orapoint

This query will help you to get payable invoice details like invoice number, invoice amount, source, amount paid, currency, invoice date 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"."SOURCE" as "SOURCE",
      "AP_INVOICES_ALL"."AMOUNT_PAID" as "AMOUNT_PAID",
      "AP_INVOICES_ALL"."INVOICE_CURRENCY_CODE" as "INVOICE_CURRENCY_CODE",
      "AP_TERMS_TL_1"."NAME" as "PAYMENT_TERM",
      "AP_INVOICES_ALL"."INVOICE_TYPE_LOOKUP_CODE" as "INVOICE_TYPE_LOOKUP_CODE",
      "HR_ALL_ORGANIZATION_UNITS"."NAME" as "BUSINESS_UNIT",
      "AP_INVOICES_ALL"."INVOICE_DATE" as "INVOICE_DATE",
      "HZ_PARTIES_2"."PARTY_NAME" as "SUPPLIER",
      "HZ_PARTIES_3"."PARTY_NAME" as "SUPPLIER_SITE",
      "AP_INVOICE_LINES_ALL"."LINE_NUMBER" as "LINE_NUMBER",
      "AP_INVOICE_LINES_ALL"."DESCRIPTION" as "DESCRIPTION",
      "AP_INVOICE_LINES_ALL"."LINE_SOURCE" as "LINE_SOURCE",
      "AP_INVOICE_LINES_ALL"."ITEM_DESCRIPTION" as "ITEM_DESCRIPTION",
      "AP_INVOICE_LINES_ALL"."DISTRIBUTION_SET_ID" as "DISTRIBUTION_SET_ID",
      "AP_INVOICE_LINES_ALL"."AMOUNT" as "AMOUNT",
      "AP_INVOICE_LINES_ALL"."ACCOUNT_SEGMENT" as "ACCOUNT_SEGMENT",
      "AP_INVOICE_LINES_ALL"."BALANCING_SEGMENT" as "BALANCING_SEGMENT",
      "AP_INVOICE_LINES_ALL"."COST_CENTER_SEGMENT" as "COST_CENTER_SEGMENT",
      "AP_INVOICE_LINES_ALL"."ACCOUNTING_DATE" as "ACCOUNTING_DATE",
      "AP_INVOICE_LINES_ALL"."QUANTITY_INVOICED" as "QUANTITY_INVOICED",
      "AP_INVOICE_LINES_ALL"."UNIT_PRICE" as "UNIT_PRICE",
      "AP_INVOICE_LINES_ALL"."SHIP_TO_LOCATION_ID" as "SHIP_TO_LOCATION_ID" 
  from    "FUSION"."AP_INVOICE_LINES_ALL" "AP_INVOICE_LINES_ALL",
     "FUSION"."HZ_PARTIES" "HZ_PARTIES_3",
     "FUSION"."HZ_PARTY_SITES" "HZ_PARTY_SITES_1",
     "FUSION"."HZ_PARTIES" "HZ_PARTIES_2",
     "FUSION"."HR_ALL_ORGANIZATION_UNITS" "HR_ALL_ORGANIZATION_UNITS",
     "FUSION"."AP_TERMS_TL" "AP_TERMS_TL_1",
     "FUSION"."AP_INVOICES_ALL" "AP_INVOICES_ALL" 
  where   "AP_INVOICES_ALL"."TERMS_ID"="AP_TERMS_TL_1"."TERM_ID"
  and     "AP_INVOICES_ALL"."ORG_ID"="HR_ALL_ORGANIZATION_UNITS"."ORGANIZATION_ID"
  and     "AP_INVOICES_ALL"."PARTY_ID"="HZ_PARTIES_2"."PARTY_ID"
  and     "AP_INVOICES_ALL"."PARTY_SITE_ID"="HZ_PARTY_SITES_1"."PARTY_SITE_ID"
  and     "HZ_PARTY_SITES_1"."PARTY_ID"="HZ_PARTIES_3"."PARTY_ID"
  and     "AP_INVOICES_ALL"."INVOICE_ID"="AP_INVOICE_LINES_ALL"."INVOICE_ID"
   and      "AP_INVOICES_ALL"."INVOICE_NUM" ='Test Inv 1' 
    and     "AP_TERMS_TL_1"."LANGUAGE" ='US'