Query To Get Payable Invoice 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"."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'