Results for “lse_parent_id”
50+ results
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;
-
View: OKL_VIEW_TRX_ASSETS_V 12.1.1
User interface view to view asset level accounting transactions
APPS.OKL_VIEW_TRX_ASSETS_V·↳ OKC_K_ITEMS·↳ OKC_K_LINES_B·↳ OKC_K_LINES_TL·Explore OKL module →
-
View: OKX_ASSET_LINES_V 12.1.1
This View is based on fixed asset line of Oracle Contracts for Lease contracts. Fixed asset line points to a fixed asset in Oracle Fixed Asset
APPS.OKX_ASSET_LINES_V·↳ OKC_K_ITEMS·↳ OKC_K_LINES_B·↳ OKC_K_LINES_TL·Explore OKX module →
-
View: OKX_PRODUCT_LINES_V 12.2.2
Contract lines
APPS.OKX_PRODUCT_LINES_V·↳ OKC_K_ITEMS·↳ OKC_K_LINES_B·↳ OKC_K_LINES_TL·Explore OKX module →
-
View: OKX_MODEL_LINES_V 12.2.2
View on Oracle Contracts for Lease, 'LEASE' contract model line
APPS.OKX_MODEL_LINES_V·↳ OKC_K_ITEMS·↳ OKC_K_LINES_B·↳ OKC_K_LINES_TL·Explore OKX module →
-
OKC_LINE_STYLES provides meta-data that governs how lines may be defined in a contract.
-
View: OKC_LINE_STYLES_V 12.1.1
View for table OKC_LINE_STYLE_B
APPS.OKC_LINE_STYLES_V·↳ OKC_LINE_STYLES_B·↳ OKC_LINE_STYLES_TL·Explore OKC module →
-
View: OKC_LINE_STYLES_V 12.2.2
View for table OKC_LINE_STYLE_B
APPS.OKC_LINE_STYLES_V·↳ OKC_LINE_STYLES_B·↳ OKC_LINE_STYLES_TL·Explore OKC module →
-
View: OKL_VIEW_TRX_ASSETS_V 12.2.2
User interface view to view asset level accounting transactions
APPS.OKL_VIEW_TRX_ASSETS_V·↳ OKC_K_ITEMS·↳ OKC_K_LINES_B·↳ OKC_K_LINES_TL·Explore OKL module →
-
View: OKL_ASSET_LINES_ALL_V 12.1.1
View based on fixed asset line in Oracle Contracts for Lease 'LEASE' contracts. Fixed asset line in OKL points to a fixed asset(asset_id) in Oracle FA.Also this view shows asset for loan type of contracts.
APPS.OKL_ASSET_LINES_ALL_V·↳ FA_ADDITIONS_B·↳ FA_ADDITIONS_TL·↳ FA_BOOKS·Explore OKL module →
-
View: OKX_ITEM_INSTS_LINES_V 12.2.2
View on Installed base item instance line of Oracle Lease management lease contract. This line points to an item instance (instance_id ) in IB
APPS.OKX_ITEM_INSTS_LINES_V·↳ OKC_K_ITEMS·↳ OKC_K_LINES_B·↳ OKC_K_LINES_TL·Explore OKX module →
-
View: OKX_PRODUCT_LINES_V 12.1.1
Contract lines
APPS.OKX_PRODUCT_LINES_V·↳ OKC_K_ITEMS·↳ OKC_K_LINES_B·↳ OKC_K_LINES_TL·Explore OKX module →
-
View: OKX_MODEL_LINES_V 12.1.1
View on Oracle Contracts for Lease, 'LEASE' contract model line
APPS.OKX_MODEL_LINES_V·↳ OKC_K_ITEMS·↳ OKC_K_LINES_B·↳ OKC_K_LINES_TL·Explore OKX module →
-
View: OKL_ASSET_LINES_ALL_V 12.2.2
View based on fixed asset line in Oracle Contracts for Lease 'LEASE' contracts. Fixed asset line in OKL points to a fixed asset(asset_id) in Oracle FA.Also this view shows asset for loan type of contracts.
APPS.OKL_ASSET_LINES_ALL_V·↳ FA_ADDITIONS_B·↳ FA_ADDITIONS_TL·↳ FA_BOOKS·Explore OKL module →
-
OKC_LINE_STYLES provides meta-data that governs how lines may be defined in a contract.
-
View: OKX_ASSET_LINES_V 12.2.2
This View is based on fixed asset line of Oracle Contracts for Lease contracts. Fixed asset line points to a fixed asset in Oracle Fixed Asset
APPS.OKX_ASSET_LINES_V·↳ OKC_K_ITEMS·↳ OKC_K_LINES_B·↳ OKC_K_LINES_TL·Explore OKX module →
-
View: OKL_CS_ASSET_LINES_V 12.2.2
View based on fixed asset line in Oracle Contracts for Lease 'LEASE' contracts. Fixed asset line in OKL points to a fixed asset(asset_id) in Oracle FA.Also this view shows asset for loan type of contracts.
APPS.OKL_CS_ASSET_LINES_V·↳ FA_ADDITIONS_B·↳ FA_ADDITIONS_TL·↳ FA_BOOKS·Explore OKL module →
-
View: OKL_CS_ASSET_LINES_V 12.1.1
View based on fixed asset line in Oracle Contracts for Lease 'LEASE' contracts. Fixed asset line in OKL points to a fixed asset(asset_id) in Oracle FA.Also this view shows asset for loan type of contracts.
APPS.OKL_CS_ASSET_LINES_V·↳ FA_ADDITIONS_B·↳ FA_ADDITIONS_TL·↳ FA_BOOKS·Explore OKL module →
-
View: OKX_ITEM_INSTS_LINES_V 12.1.1
View on Installed base item instance line of Oracle Lease management lease contract. This line points to an item instance (instance_id ) in IB
APPS.OKX_ITEM_INSTS_LINES_V·↳ OKC_K_ITEMS·↳ OKC_K_LINES_B·↳ OKC_K_LINES_TL·Explore OKX module →
-
VIEW: OKC.OKC_LINE_STYLES_B# 12.2.2
-
VIEW: OKC.OKC_LINE_STYLES_B# 12.2.2
-
VIEW: APPS.OKC_LINE_STYLES_V 12.2.2
-
VIEW: APPS.OKX_MODEL_LINES_V 12.2.2
-
VIEW: APPS.OKX_MODEL_LINES_V 12.1.1
-
VIEW: APPS.OKX_MODEL_LINES_V 12.2.2
-
VIEW: APPS.OKX_MODEL_LINES_V 12.1.1