Results for “okl_view_trx_assets_v”

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

Overview

OKL_VIEW_TRX_ASSETS_V is a user-facing view owned by the APPS schema in Oracle E-Business Suite, belonging to the OKL (Lease and Finance Management) product family. Its documented purpose is to present asset level accounting transactions for display through the ETRM user interface. It is classified as VALID in the ETRM 12.2.2 metadata dictionary, confirming it is a supported, compilable database object rather than an obsolete or disabled construct.

The view occupies a reporting and integration role rather than a transactional one. It does not store data; it projectively joins contract header, contract line, line style, and fixed asset information into a single flattened row set. This allows ETRM screens, concurrent programs, and downstream extracts to retrieve asset-level accounting detail without issuing the multi-table joins themselves. The view is equally available in 12.1.1 and 12.2.2 environments, as its underlying objects (OKC and OKL contract tables plus the OKX assets view) are present in both releases.

Underlying Base Objects

The ETRM 12.2.2 metadata documents the following referenced base objects, all exposed to APPS as synonyms: OKC_K_ITEMS, OKC_K_LINES_B, OKC_K_LINES_TL, OKC_LINE_STYLES_B, OKL_K_HEADERS, OKL_K_LINES, and the view OKX_ASSETS_V. The published view text additionally joins the CLE (contract line) alias to contract header and line structures, draws lease type and lease classification from the LS (line style) alias, and pulls asset attributes from OKX_ASSETS_V aliased as FA. The TOP_KLE alias retrieves the original cost (OEC) value from a top-level line instance, and the KLE alias supplies YEAR_BUILT.

• OKC_K_ITEMS / OKC_K_LINES_B / OKC_K_LINES_TL — contract line items and their translated descriptions, supplying CLE.ID, CLE_ID, LINE_NUMBER, start and end dates, and termination date.
• OKC_LINE_STYLES_B — line style definition, supplying LTY_CODE, LSE_TYPE, and LSE_PARENT_ID.
• OKL_K_HEADERS / OKL_K_LINES — lease header and line data used to resolve the contract context and top-level line cost.
• OKX_ASSETS_V — the fixed asset view providing asset number, cost, depreciation, and book attributes.

Key Columns

The view exposes identity, status, financial, and depreciation columns. Notable groupings include:

• Identity and lineage: ID1 (contract line ID), PARENT_LINE_ID (CLE_ID), CHR_ID, DNZ_CHR_ID, LINE_NUMBER.
• Status: STATUS is derived with a DECODE over SYSDATE against START_DATE and END_DATE, returning 'A' for active or 'I' for inactive or not-yet-started; LINE_STATUS surfaces the stored STS_CODE.
• Asset detail: ASSET_ID, ASSET_NUMBER, TAG_NUMBER, SERIAL_NUMBER, CURRENT_UNITS, UNIT_OF_MEASURE_CODE, YEAR_BUILT, NEW_USED, IN_SERVICE_DATE, MANUFACTURER_NAME, MODEL_NUMBER, ASSET_TYPE.
• Cost and depreciation: ORIGINAL_COST, COST, ADJUSTED_COST, SALVAGE_VALUE, PERCENT_SALVAGE_VALUE, RECOVERABLE_COST, DEPRECIATION_CATEGORY, DEPRN_START_DATE, DEPRN_METHOD_CODE, BASIC_RATE, ADJUSTED_RATE, RATE_ADJUSTMENT_FACTOR, LIFE_IN_MONTHS, REVAL_CEILING.
• Accounting context: ORG_ID, SET_OF_BOOKS_ID, CORPORATE_BOOK, IN_USE_FLAG, OWNED_LEASED, INVENTORIAL, PROPERTY_TYPE_CODE, PROPERTY_1245_1250_CODE.

Common Use Cases and Queries

Typical uses include asset-level transaction inquiry, reconciliation of lease lines to fixed assets, and reporting on depreciation status by contract. All queries must supply an ORG_ID predicate to respect multi-org security.

• List active assets for an operating unit:
  SELECT asset_number, tag_number, cost, depreciation_category FROM okl_view_trx_assets_v WHERE org_id = :p_org_id AND status = 'A';
• Retrieve original versus adjusted cost per contract line:
  SELECT id1, line_number, original_cost, adjusted_cost FROM okl_view_trx_assets_v WHERE chr_id = :p_chr_id;
• Depreciation summary by method and category:
  SELECT deprn_method_code, depreciation_category, COUNT(*) FROM okl_view_trx_assets_v WHERE set_of_books_id = :p_sob GROUP BY deprn_method_code, depreciation_category;