Results for “ap_distribution_line_number”

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

Overview

The view APPS.JAI_FA_AST_RETIR_INAYR_V is a reporting object delivered with the Oracle E-Business Suite JA — Asia/Pacific Localizations product family. It is defined in the APPS schema and holds a VALID status in both Oracle EBS 12.1.1 and 12.2.2. The view presents a consolidated, join-ready result set describing retired fixed assets, enriched with fiscal-year context, invoice (PO) references, and asset book information. Its name — "AST_RETIR" (asset retirement) and "INAYR" — indicates a localized (Asia/Pacific) reporting requirement, typically used to feed statutory or tax reports where the period in which an asset was retired must be correlated to the applicable fiscal year.

Because the view is built exclusively from standard Oracle Assets tables, it functions as a convenience layer: instead of assembling the retirement-to-fiscal-year relationship manually, consumers can query a single object and receive pre-joined retirement, book, and invoice columns. This makes it useful both for ad-hoc reporting and as a data source in localized statutory extracts.

Underlying Base Objects

The view is defined over six documented base objects, all referenced through APPS synonyms:

• FA_RETIREMENTS — the driving table (alias A); supplies ASSET_ID, DATE_RETIRED, and BOOK_TYPE_CODE.
• FA_BOOK_CONTROLS (alias B) — provides the current fiscal year name and joins on BOOK_TYPE_CODE; also supplies SET_OF_BOOKS_ID.
• FA_FISCAL_YEAR (alias C) — supplies FISCAL_YEAR, START_DATE, and END_DATE, and enforces the fiscal-year logic via B.FISCAL_YEAR_NAME = C.FISCAL_YEAR_NAME and B.CURRENT_FISCAL_YEAR = C.FISCAL_YEAR.
• FA_ADDITIONS (alias D) — supplies the descriptive attributes ASSET_NUMBER and DESCRIPTION.
• FA_ASSET_INVOICES (alias E) — supplies PO_NUMBER, INVOICE_ID, and AP_DISTRIBUTION_LINE_NUMBER, restricted to distribution line 1.
• FA_BOOKS (alias F) — supplies DATE_PLACED_IN_SERVICE for the matching asset and book.

Joins are keyed on ASSET_ID across the asset-level tables and on BOOK_TYPE_CODE between retirement, book controls, and books. The fiscal-year join ensures only the fiscal year that contains the retirement (and the current system date) is returned: C.END_DATE >= A.DATE_RETIRED, SYSDATE BETWEEN C.START_DATE AND C.END_DATE, and C.START_DATE <= F.DATE_PLACED_IN_SERVICE.

Key Columns

• ASSET_ID / ASSET_NUMBER / DESCRIPTION — asset identifiers and descriptive text.
• DATE_RETIRED — the date the asset was retired; drives the fiscal-year selection.
• FISCAL_YEAR / START_DATE / END_DATE — the fiscal-year identifier and its boundaries, central to period reporting.
• DATE_PLACED_IN_SERVICE — depreciation start reference from FA_BOOKS.
• BOOK_TYPE_CODE / SET_OF_BOOKS_ID — the depreciation book in which the retirement occurred.
• PO_NUMBER / INVOICE_ID / AP_DISTRIBUTION_LINE_NUMBER — sourcing invoice and purchase-order references, limited to the first distribution line.

Common Use Cases and Queries

The view supports fiscal-year-scoped retirement reporting, such as reconciling retired assets against their originating invoices for statutory filings.

• Listing all assets retired in the current fiscal year.
• Extracting retirement details with PO/invoice references for audit.
• Feeding localized Asia/Pacific asset-retirement returns.

Sample query:

SELECT asset_number, description, book_type_code,
       fiscal_year, date_retired, date_placed_in_service,
       po_number, invoice_id
FROM   apps.jai_fa_ast_retir_inayr_v
WHERE  fiscal_year = '2024'
ORDER  BY date_retired;

Because the view already filters on SYSDATE against the fiscal-year calendar, callers generally need only add descriptive or period predicates; the fiscal-year context is resolved internally.