Search Results oks_k_lines_b_pk

Overview

The OKS_K_LINES_B table is a core data object within the Oracle E-Business Suite (EBS) Service Contracts module (OKS). It functions as the primary transactional table for storing the fundamental attributes of individual service contract lines. Every line item on a service contract, such as a covered service, a warranty, or a subscription offering, is represented by a record in this table. Its role is to persist the essential business data that defines the scope, pricing, and terms of each contractual line, forming the detailed foundation upon which the entire service contract is built. This table is central to contract line management, revenue recognition, and service fulfillment processes.

Key Information Stored

While the provided metadata does not list specific columns, based on its role as the line attributes table, OKS_K_LINES_B typically stores critical identifiers and contractual details for each line. The primary key is the ID column, as indicated by the OKS_K_LINES_B_PK constraint. Common columns include a link to the parent contract header (likely CHR_ID), a line sequence number (CLE_ID), and identifiers for the covered product or service. It also stores key financial and operational attributes such as the line start and end dates, pricing information (list price, adjusted price), coverage and billing information, and references to the item or service template from the inventory or service catalog. Status and processing flags governing the line's lifecycle are also standard.

Common Use Cases and Queries

This table is integral to numerous operational and reporting activities. Common use cases include generating detailed line-item reports for contract analysis, feeding data into revenue recognition engines, and providing the line detail for service entitlement checks. A typical query would join this table to the contract header (OKS_K_HEADERS_B) to retrieve a full contract view.

• Sample Query for Contract Lines: SELECT kln.id, kln.cle_id, kln.start_date, kln.end_date, kln.object_version_number FROM oks.oks_k_lines_b kln WHERE kln.chr_id = :p_contract_id ORDER BY kln.cle_id;
• Reporting Use Case: Analyzing the distribution of service line types or calculating the total contract value by summing line-level amounts, often joined with the transactional currency table (FND_CURRENCIES).

Related Objects

OKS_K_LINES_B is a central hub within the Service Contracts schema. Its primary relationship is with the contract header table, OKS_K_HEADERS_B, via a foreign key (e.g., CHR_ID). It is also closely related to the line details table, OKS_K_LINES_DETAILS_B, which holds additional, more granular attributes for each line. Key transactional views, such as OKS_K_LINES_V, are likely built upon this base table to provide an application-friendly perspective. For data manipulation, the module's PL/SQL APIs (e.g., packages under the OKS_ prefix) will interact with this table to create, update, and process contract lines.