Search Results oke_k_lines

Overview

The OKE_K_LINES table is a core data object within the Oracle E-Business Suite Project Contracts (OKE) module. It serves as the repository for extended, contract-specific line information, building upon the foundational contract line data stored in the base OKC_K_LINES_B table. Its primary role is to manage the detailed attributes required for project-oriented contracting, such as linking contract lines to specific projects and tasks, thereby enabling integrated project costing, billing, and deliverable tracking. The table is central to the contract line's lifecycle and integrates with numerous other OKE entities for comprehensive contract execution and administration.

Key Information Stored

While the full column list is not detailed in the provided metadata, the foreign key relationships and primary key structure reveal critical data points. The table's primary key is K_LINE_ID, which corresponds directly to the line ID in the base contract lines table (OKC_K_LINES_B). This establishes a one-to-one relationship for core line data. Essential project-related attributes include PROJECT_ID and TASK_ID, which link the contract line to a specific project and task within Oracle Projects (PA). The PARENT_LINE_ID column supports hierarchical line structures by creating a self-referential relationship within the same table, allowing for parent-child line groupings. Collectively, these columns transform a generic contract line into a project-contract line capable of supporting complex project billing and funding scenarios.

Common Use Cases and Queries

This table is fundamental for reporting and processes involving project contract lines. Common use cases include generating reports that join contract line details with project information, validating project and task assignments during contract authoring, and serving as the source for downstream billing and funding allocations. A typical query pattern retrieves extended line data for a specific contract header or project.

• Sample Query: Retrieve project contract lines for a specific project:
  SELECT okl.k_line_id, okl.project_id, ppa.segment1 project_number, pt.task_number, okb.line_number
FROM oke_k_lines okl,
pa_projects_all ppa,
pa_tasks pt,
okc_k_lines_b okb
WHERE okl.project_id = ppa.project_id
AND okl.task_id = pt.task_id (+)
AND okl.k_line_id = okb.id
AND okl.project_id = :p_project_id;
• Use Case: Identifying all contract lines associated with a parent line for roll-up reporting or summary billing.
• Use Case: Serving as the key driving table for extracting data related to billing events, deliverables, holds, and terms attached to a contract line.

Related Objects

The OKE_K_LINES table has extensive integration within the OKE module, as evidenced by its foreign key dependencies. It is a parent table to numerous critical transactional entities. Key related objects include:

• OKC_K_LINES_B: The foundational contract lines table upon which OKE_K_LINES extends.
• PA_PROJECTS_ALL / PA_TASKS: Oracle Projects tables for project and task master data.
• OKE_K_BILLING_EVENTS: Links billing events to a specific contract line (BILL_LINE_ID).
• OKE_K_DELIVERABLES_B: Stores deliverable information associated with a contract line.
• OKE_K_FUND_ALLOCATIONS: Holds funding details allocated against the contract line.
• OKE_K_TERMS: Contains contractual terms and conditions specific to the line.
• OKE_K_LINES_H: The history table that tracks changes to records in OKE_K_LINES.