Search Results okl_ast_cndtn_lns_all_b




Overview
Explore in AI Chat

Overview

The table OKL_AST_CNDTN_LNS_ALL_B is a core transactional data object within the Oracle E-Business Suite (EBS) module OKL (Lease and Finance Management). It serves as the detailed line-level repository for asset condition reports. In the context of lease and asset management, a condition report documents the physical state of an asset, such as a vehicle or piece of equipment, at critical events like lease inception, return, or periodic inspections. This table stores each specific line item of observation or damage noted within such a report, providing a granular audit trail of asset condition over its lifecycle. Its role is essential for managing asset valuation, billing for damages, and resolving disputes between lessors and lessees.

Key Information Stored

While the full column list is not detailed in the provided metadata, the structure and foreign keys indicate the critical data elements. Each record represents a single line on a condition report. The primary identifier is the ID column, which is the primary key. A crucial foreign key is ACD_ID, which links the line to its parent condition report header in the OKL_ASSET_CNDTNS_ALL table. Another significant foreign key is RPC_ID, which likely references a repair code or damage classification, standardizing the type of condition noted. The table's description, "detailing the item description and damage," confirms it holds columns for textual descriptions of the item and the specific damage or condition observed. Additional columns would typically include creation and last update dates, IDs, and other control attributes common to EBS multi-org tables (indicated by the "_ALL_" suffix).

Common Use Cases and Queries

This table is central to operations involving asset inspection and damage assessment. Common use cases include generating detailed condition reports for lessees, calculating damage charges upon lease termination, and tracking asset deterioration over time. For reporting, one might join this table to the header and asset tables to analyze damage frequency by asset type. A typical query pattern would retrieve all condition lines for a specific asset or contract:

  • SELECT acl.* FROM OKL_AST_CNDTN_LNS_ALL_B acl, OKL_ASSET_CNDTNS_ALL ac WHERE acl.acd_id = ac.id AND ac.khr_id = <contract_id>;

Another critical use case is integration with billing, as indicated by the foreign key from OKL_TXL_AR_INV_LNS_B (invoice lines). This allows specific condition lines, likely those billable for repair costs, to be directly linked to invoice line items for automated charge generation.

Related Objects

The metadata explicitly defines this table's key relationships within the OKL schema. Its primary parent table is OKL_ASSET_CNDTNS_ALL, the condition report header. It is referenced by the transactional invoice line table OKL_TXL_AR_INV_LNS_B via the column ACN_ID_COST, establishing the critical link between documented damage and customer invoicing. The self-referencing foreign key on RPC_ID likely points to a lookup table for standardized repair or condition codes, though its specific target is not named in the excerpt. Developers and integrators would also utilize related public APIs or views, such as OKL_ASSET_CONDITIONS_PUB, for any programmatic creation or modification of condition data, rather than interacting with this base table directly.