Search Results okc_k_lines_b

Overview

The OKC_K_LINES_B table is a core data object within the Oracle E-Business Suite Contracts Core module (OKC). It serves as the primary transactional table for storing contract lines. A contract line represents a deliverable item or a logical grouping of items within a contract, typically defined by a unitary price, delivery schedule, or other classification. This table is fundamental to the contract's structure, holding the detailed line-level information that defines the obligations, pricing, and deliverables of a contractual agreement. Its integrity is maintained through complex relationships with numerous other modules, including Service, Order Management, and Pricing.

Key Information Stored

The table stores the essential attributes for each contract line. The primary key is the unique identifier ID. Crucially, each line is linked to its parent contract header via the CHR_ID column, which is a foreign key to OKC_K_HEADERS_B. The CLE_ID column, part of a unique key with CHR_ID and LINE_NUMBER, serves as a functional identifier. Other significant columns define the line's relationships and state: LSE_ID links to a line style in OKC_LINE_STYLES_B, STS_CODE links to a status in OKC_STATUSES_B, and PH_QP_REFERENCE_ID connects to pricing lists in QP_LIST_HEADERS_B and QP_LIST_LINES. Columns like CLE_ID_RENEWED and CLE_ID_RENEWED_TO manage line renewal hierarchies, while CONFIG_TOP_MODEL_LINE_ID supports configurable items.

Common Use Cases and Queries

This table is central to reporting and data extraction for contract line details. Common operational queries include fetching all lines for a specific contract, analyzing lines by status, or joining with pricing tables to review line-level financials. For instance, to retrieve active lines for a contract, one might use:

• SELECT cle_id, line_number, sts_code FROM okc_k_lines_b WHERE chr_id = :p_contract_id;

Integration scenarios are extensive. Service modules (CSD_REPAIRS, CS_INCIDENTS_ALL_B) reference contract lines to associate service requests. The Oracle Service Contracts module (OKS) uses the CLE_ID for billing line details (OKS_BILL_CONT_LINES, OKS_BILL_SUB_LINES). Data migration or interface programs often populate or extract from this table to synchronize contract data with external systems, leveraging its key identifiers.

Related Objects

OKC_K_LINES_B has a vast network of dependencies, underscoring its integration scope. Its primary parent is OKC_K_HEADERS_B. Key child tables within Contracts Core include OKC_K_ITEMS for line items and OKC_ARTICLE_TRANS for article transactions. Critical foreign key relationships exist with service modules (AHL_UNIT_EFFECTIVITIES_B, CSD_REPAIRS), billing in Service Contracts (OKS_BILL_CONT_LINES, OKS_BILL_SUB_LINES), and pricing (QP_LIST_HEADERS_B). The table also maintains recursive relationships with itself for modeling renewals and configurations via columns like CLE_ID_RENEWED and CLE_ID_RENEWED_TO.