Results for “invoice_line_description”

15 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FA_ASSET_INVOICES_V is a business view owned by the APPS schema in Oracle EBS 12.1.1 and 12.2.2, delivered as part of the OFA (Oracle Assets) product family. It presents a consolidated, reportable picture of capitalized asset identification, financial, and purchasing information by joining depreciation and category data from Oracle Assets to the originating vendor invoice data from Oracle Payables. The view is intended for reporting and integration scenarios where a single row per asset-to-invoice relationship is required, such as reconciling asset cost to supplier invoices, sourcing vendor and purchase order details for capitalized assets, and driving downstream extract processes. Because it is a view rather than a table, it carries no independent storage and derives all data from its underlying base objects at query time, so results always reflect the current state of those objects subject to the filters applied within its definition.

Underlying Base Objects

The view is defined over seven referenced base objects, joined primarily on ASSET_ID and category and lookup identifiers:

The WHERE clause restricts output to corporate book assets that are not fully retired, have no ineffective book or invoice rows, are not deleted, and are tied to a valid vendor.

Key Columns

Identification columns include ASSET_NUMBER, TAG_NUMBER, DESCRIPTION, MANUFACTURER_NAME, SERIAL_NUMBER, and MODEL_NUMBER. The ASSET_TYPE column resolves the lookup meaning, while MAJOR_CATEGORY and SUB_CATEGORY expose the flexible category segments — the SUB_CATEGORY column, sourced from CA.SEGMENT2, is the column most often sought by users searching for "sub_category". Financial columns include BOOK_TYPE_CODE, DATE_PLACED_IN_SERVICE, DEPRN_METHOD_CODE, LIFE_IN_MONTHS, SALVAGE_VALUE, ADJUSTED_RATE, and PRODUCTION_CAPACITY. Purchasing and invoice columns include VENDOR_NAME, VENDOR_NUMBER, PO_NUMBER, INVOICE_NUMBER, INVOICE_ID, INVOICE_LINE_NUMBER, INVOICE_LINE_DESCRIPTION, INVOICE_COST (the capitalized FIXED_ASSETS_COST), DISTRIBUTION_LINE_NUMBER, PRIOR_SOURCE_LINE_ID, INVOICE_DISTRIBUTION_ID, and PO_DISTRIBUTION_ID.

Common Use Cases and Queries

Typical scenarios include asset-to-invoice reconciliation, supplier spend analysis by category, and extract generation for external systems. A representative query filtering on sub-category:

  • SELECT asset_number, tag_number, sub_category, vendor_name, invoice_number, invoice_cost FROM fa_asset_invoices_v WHERE sub_category = :p_sub_category;
  • SELECT major_category, sub_category, COUNT(*), SUM(invoice_cost) FROM fa_asset_invoices_v GROUP BY major_category, sub_category;
  • SELECT asset_number, vendor_name, po_number, invoice_number FROM fa_asset_invoices_v WHERE vendor_number = :p_vendor;

Because BOOK_CLASS is hard-coded to 'CORPORATE', queries cannot retrieve non-corporate book data without a custom view, and the SUB_CATEGORY column reflects category segment2, which may be blank for categories that do not use a second segment.