Results for “fabv_src_lns”
14 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
FABV_SRC_LNS is an APPS-owned, read-only view in the Oracle E-Business Suite Fixed Assets (OFA) module. It is classified as a retrofitted object, meaning it was introduced or preserved to maintain backward compatibility with earlier Oracle EBS releases across the 12.1.1 and 12.2.2 code lines. The name breaks down as "FA" (Fixed Assets), "BV" (a view designation), and "SRC_LNS" (source lines), indicating that it exposes the source transaction lines from which fixed asset additions are derived.
The view presents payables-side invoice and distribution line detail that has not yet been fully capitalized or interfaced into the Fixed Assets module. It serves as a reporting and integration surface that lets Fixed Assets functionality read Accounts Payable invoice cost data without querying the underlying transactional table directly. This is especially relevant to the "fixed_assets_cost" search context, since FIXED_ASSETS_COST is one of the view's primary cost columns.
Underlying Base Objects
Compared against the documented metadata, FABV_SRC_LNS is defined over a single base object: the FA_ASSET_INVOICES synonym, which resolves to the FA_ASSET_INVOICES table in the APPS schema. The view text is a straightforward projection with two filter predicates applied:
INVOICE_TRANSACTION_ID_OUT IS NULL— restricts output to invoice lines that have not yet been transferred out to a downstream asset transaction.DATE_INEFFECTIVE IS NULL— excludes logically deleted or superseded rows.
The view is defined WITH READ ONLY, so it cannot be used as a DML target. Because it references only a synonym, all column definitions inherit directly from FA_ASSET_INVOICES, and no joins, unions, or aggregations are present.
Key Columns
FIXED_ASSETS_COST— the cost amount attributed to the fixed asset side of the invoice line.PAYABLES_COST— the corresponding amount recorded in Payables.ASSET_ID— identifier of the associated asset, where populated.INVOICE_ID,INVOICE_NUMBER,INVOICE_DATE,INVOICE_LINE_NUMBER— AP invoice header and line references.INVOICE_DISTRIBUTION_ID,AP_DISTRIBUTION_LINE_NUMBER— the AP distribution line that carries the cost.PO_VENDOR_ID,PO_NUMBER— purchase order and supplier context.PROJECT_ID,TASK_ID— Oracle Projects references when costs originate from project-related invoices.DESCRIPTION— free-form description of the source line.LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY— standard audit columns.
Common Use Cases and Queries
Typical uses include reconciling capitalized versus uncapitalized invoice costs, supporting the Additions and Adjustments workflows, and diagnosing lines that have not yet been picked up by the Mass Additions process. A common reconciliation query lists pending source lines:
- Identify invoice lines awaiting capitalization by asset.
- Compare FIXED_ASSETS_COST to PAYABLES_COST for variance analysis.
- Trace costs back to AP invoice and PO references for audit.
Sample SQL:
SELECT asset_id,
invoice_number,
invoice_line_number,
fixed_assets_cost,
payables_cost
FROM apps.fabv_src_lns
WHERE invoice_date >= :p_from_date
AND NVL(fixed_assets_cost,0) <> NVL(payables_cost,0);
Because the view is read-only and unfiltered beyond the two predicates, queries should always add date or asset criteria to bound the result set on high-volume instances.
-
View: FABV_SRC_LNS 12.2.2
- Retrofitted
-
View: FABV_SRC_LNS 12.1.1
- Retrofitted
-
VIEW: APPS.FABV_SRC_LNS 12.1.1
-
VIEW: APPS.FABV_SRC_LNS 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
eTRM - OFA Tables and Views 12.1.1
-
eTRM - OFA Tables and Views 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - OFA Tables and Views 12.1.1
-
eTRM - OFA Tables and Views 12.2.2