Search Results okl_asset_components_b

Overview

The OKL_ASSET_COMPONENTS_B table is a core data object within the Oracle E-Business Suite (EBS) module for Leasing and Finance Management (OKL). It serves as the primary transactional table for storing detailed information about individual components that constitute a quoted asset. As indicated in the ETRM documentation, these components are sourced from inventory items and are always created within the context of a Quoted Asset. This table is fundamental to the asset structuring process in leasing contracts, enabling the breakdown of a complex leased asset into its constituent, trackable parts for financial and operational management.

Key Information Stored

The table's structure is designed to link asset components to their source inventory items and parent quoted assets. While the full column list is not detailed in the provided excerpt, the documented primary key constraint (OKL_ASO_PK on the ID column) confirms the table's unique identifier. Based on its purpose and standard EBS design patterns, the table typically contains columns such as: a unique ID (ID), a foreign key to the parent quoted asset (e.g., QTE_ID or ASSET_ID), a foreign key to the inventory item (e.g., INVENTORY_ITEM_ID), quantity, unit of measure, unit cost, and descriptive attributes. It also includes standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for auditing.

Common Use Cases and Queries

This table is central to processes involving the configuration and pricing of leased assets. Common use cases include generating a detailed bill of materials for a quoted asset, calculating total asset cost by summing component costs, and validating component availability against inventory. A typical reporting query would join this table to inventory and asset master tables to list all components for a specific lease quote.

SELECT ac.id, ac.inventory_item_id, msib.segment1 item_code,
       ac.quantity, ac.unit_price
FROM okl_asset_components_b ac,
     mtl_system_items_b msib
WHERE ac.inventory_item_id = msib.inventory_item_id
  AND ac.organization_id = msib.organization_id
  AND ac.qte_id = :p_quote_id;

Related Objects

The table maintains critical relationships with other OKL and Inventory modules objects. The primary relationship, as defined by its purpose, is with the parent Quoted Asset table (likely named OKL_QUOTED_ASSETS_B or similar), joined via a foreign key column (e.g., QTE_ID or ASSET_ID) referencing the primary key of that table. It also has a mandatory relationship with the Inventory module's MTL_SYSTEM_ITEMS_B table, joined on INVENTORY_ITEM_ID and ORGANIZATION_ID, to source component details. The documented primary key constraint, OKL_ASO_PK, is itself referenced by foreign key constraints from any child or intersection tables that may store additional data specific to asset components.