FA Asset Invoices (Oracle Fusion SQL)

Enterprise Resource Planning (ERP) Oracle Fixed Assets (FA-Fusion-SQL's)
1

This FA Asset Invoices query displays invoice and vendor details for each asset, helping users reconcile asset purchases with financial records.

#sqlquery

SELECT
  --SQL4Fusion (An Orbit Analytics Project)
  --Lists invoices linked to assets with vendor, PO, and cost details.
  PSV.SEGMENT1              SUPPLIER_NUMBER,
  PSV.VENDOR_NAME           SUPPLIER_NAME,
  FAI.PO_NUMBER,
  FAB.ASSET_NUMBER,
  FAI.INVOICE_NUMBER,
  FAI.INVOICE_DATE,
  FAI.AP_DISTRIBUTION_LINE_NUMBER,
  FAI.DESCRIPTION         ASSET_INVOICE_DESCRIPTION,
  FAI.FEEDER_SYSTEM_NAME, --Name of the feeder system that created the FA_MASS_ADDITIONS row.  
  FAI.PAYABLES_COST,
  FAI.FIXED_ASSETS_COST
FROM
  FA_ASSET_INVOICES FAI,
  FA_ADDITIONS_B FAB,
  POZ_SUPPLIERS_V PSV
WHERE
  FAI.PO_VENDOR_ID = PSV.VENDOR_ID
  AND FAI.DATE_INEFFECTIVE IS NULL
  AND FAB.ASSET_ID = FAI.ASSET_ID
ORDER BY FAB.ASSET_NUMBER ;