Search Results okc_k_lines_b




Overview
Explore in AI Chat

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.

  • Table: OKC_K_LINES_B 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_LINES_B,  object_name:OKC_K_LINES_B,  status:VALID,  product: OKC - Contracts Core ,  description: Deliverable ITEMS grouped into a logical set usually defined by unitary price, delivery or some other classification. ,  implementation_dba_data: OKC.OKC_K_LINES_B , 

  • Table: OKC_K_LINES_B 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_LINES_B,  object_name:OKC_K_LINES_B,  status:VALID,  product: OKC - Contracts Core ,  description: Deliverable ITEMS grouped into a logical set usually defined by unitary price, delivery or some other classification. ,  implementation_dba_data: OKC.OKC_K_LINES_B , 

  • Table: OKC_ANCESTRYS 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_ANCESTRYS,  object_name:OKC_ANCESTRYS,  status:VALID,  product: OKC - Contracts Core ,  description: Holds ancestor Contract Lines for a Contract Line. ,  implementation_dba_data: OKC.OKC_ANCESTRYS , 

  • Table: OKC_ANCESTRYS 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_ANCESTRYS,  object_name:OKC_ANCESTRYS,  status:VALID,  product: OKC - Contracts Core ,  description: Holds ancestor Contract Lines for a Contract Line. ,  implementation_dba_data: OKC.OKC_ANCESTRYS , 

  • Table: OKC_GOVERNANCES 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_GOVERNANCES,  object_name:OKC_GOVERNANCES,  status:VALID,  product: OKC - Contracts Core ,  description: Intersection entity. ,  implementation_dba_data: OKC.OKC_GOVERNANCES , 

  • Table: OKC_GOVERNANCES 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_GOVERNANCES,  object_name:OKC_GOVERNANCES,  status:VALID,  product: OKC - Contracts Core ,  description: Intersection entity. ,  implementation_dba_data: OKC.OKC_GOVERNANCES , 

  • Table: OKC_K_ITEMS 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_ITEMS,  object_name:OKC_K_ITEMS,  status:VALID,  product: OKC - Contracts Core ,  description: Stores item attributes for Contract Lines. ,  implementation_dba_data: OKC.OKC_K_ITEMS , 

  • Table: OKC_K_ITEMS 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_ITEMS,  object_name:OKC_K_ITEMS,  status:VALID,  product: OKC - Contracts Core ,  description: Stores item attributes for Contract Lines. ,  implementation_dba_data: OKC.OKC_K_ITEMS , 

  • Table: OKC_OPERATION_LINES 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_OPERATION_LINES,  object_name:OKC_OPERATION_LINES,  status:VALID,  product: OKC - Contracts Core ,  description: The Operation Line provides additional information about what did happen or will happen for an Operation Instance. ,  implementation_dba_data: OKC.OKC_OPERATION_LINES , 

  • Table: OKC_OPERATION_LINES 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_OPERATION_LINES,  object_name:OKC_OPERATION_LINES,  status:VALID,  product: OKC - Contracts Core ,  description: The Operation Line provides additional information about what did happen or will happen for an Operation Instance. ,  implementation_dba_data: OKC.OKC_OPERATION_LINES , 

  • View: OKC_LAUNCH_KHIST_GRID_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:OKC.OKC_LAUNCH_KHIST_GRID_V,  object_name:OKC_LAUNCH_KHIST_GRID_V,  status:VALID,  product: OKC - Contracts Core ,  description: View for Launchpad overview tab - contract status change history ,  implementation_dba_data: APPS.OKC_LAUNCH_KHIST_GRID_V , 

  • Table: OKC_K_LINES_TL 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_LINES_TL,  object_name:OKC_K_LINES_TL,  status:VALID,  product: OKC - Contracts Core ,  description: Translatable columns from OKC_K_LINES_B, as per MLS standards. ,  implementation_dba_data: OKC.OKC_K_LINES_TL , 

  • Table: OKC_K_LINES_TL 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_LINES_TL,  object_name:OKC_K_LINES_TL,  status:VALID,  product: OKC - Contracts Core ,  description: Translatable columns from OKC_K_LINES_B, as per MLS standards. ,  implementation_dba_data: OKC.OKC_K_LINES_TL , 

  • Table: OKC_K_SALES_CREDITS_H 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_SALES_CREDITS_H,  object_name:OKC_K_SALES_CREDITS_H,  status:VALID,  product: OKC - Contracts Core ,  description: History table for OKC_K_SALES_CREDITS ,  implementation_dba_data: OKC.OKC_K_SALES_CREDITS_H , 

  • Table: OKC_K_LINES_BH 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_LINES_BH,  object_name:OKC_K_LINES_BH,  status:VALID,  product: OKC - Contracts Core ,  description: History table for OKC_K_LINES_B. ,  implementation_dba_data: OKC.OKC_K_LINES_BH , 

  • Table: OKC_PH_LINE_BREAKS 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_PH_LINE_BREAKS,  object_name:OKC_PH_LINE_BREAKS,  status:VALID,  product: OKC - Contracts Core ,  description: This table will store the information about line breaks on a price hold - Not Used ,  implementation_dba_data: OKC.OKC_PH_LINE_BREAKS , 

  • Table: OKC_ARTICLE_TRANS 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_ARTICLE_TRANS,  object_name:OKC_ARTICLE_TRANS,  status:VALID,  product: OKC - Contracts Core ,  description: Relationship between an Article and the Rules or Lines created from it. ,  implementation_dba_data: OKC.OKC_ARTICLE_TRANS , 

  • Table: OKC_PH_LINE_BREAKS 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_PH_LINE_BREAKS,  object_name:OKC_PH_LINE_BREAKS,  status:VALID,  product: OKC - Contracts Core ,  description: This table will store the information about line breaks on a price hold - Not Used ,  implementation_dba_data: OKC.OKC_PH_LINE_BREAKS , 

  • Table: OKC_ARTICLE_TRANS 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_ARTICLE_TRANS,  object_name:OKC_ARTICLE_TRANS,  status:VALID,  product: OKC - Contracts Core ,  description: Relationship between an Article and the Rules or Lines created from it. ,  implementation_dba_data: OKC.OKC_ARTICLE_TRANS , 

  • Table: OKC_K_REL_OBJS 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_REL_OBJS,  object_name:OKC_K_REL_OBJS,  status:VALID,  product: OKC - Contracts Core ,  description: An intersection entity which links a contract header or line to other objects in the schema in a predefined manner. ,  implementation_dba_data: OKC.OKC_K_REL_OBJS , 

  • Table: OKC_STATUSES_B 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_STATUSES_B,  object_name:OKC_STATUSES_B,  status:VALID,  product: OKC - Contracts Core ,  description: User defined values that define a contract's status. ,  implementation_dba_data: OKC.OKC_STATUSES_B , 

  • Table: OKC_SECTION_CONTENTS 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_SECTION_CONTENTS,  object_name:OKC_SECTION_CONTENTS,  status:VALID,  product: OKC - Contracts Core ,  description: This table holds the components of a section like a label or article ,  implementation_dba_data: OKC.OKC_SECTION_CONTENTS , 

  • Table: OKC_K_SALES_CREDITS 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_SALES_CREDITS,  object_name:OKC_K_SALES_CREDITS,  status:VALID,  product: OKC - Contracts Core ,  description: Records sales credits for the sale of services in a service contract. ,  implementation_dba_data: OKC.OKC_K_SALES_CREDITS , 

  • Table: OKC_K_SALES_CREDITS 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_SALES_CREDITS,  object_name:OKC_K_SALES_CREDITS,  status:VALID,  product: OKC - Contracts Core ,  description: Records sales credits for the sale of services in a service contract. ,  implementation_dba_data: OKC.OKC_K_SALES_CREDITS , 

  • Table: OKC_PH_LINE_BREAKS_H 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_PH_LINE_BREAKS_H,  object_name:OKC_PH_LINE_BREAKS_H,  status:VALID,  product: OKC - Contracts Core ,  description: This history table will store the information about line breaks on a price hold - Not Used ,  implementation_dba_data: OKC.OKC_PH_LINE_BREAKS_H , 

  • Table: OKC_PRICE_ATT_VALUES 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_PRICE_ATT_VALUES,  object_name:OKC_PRICE_ATT_VALUES,  status:VALID,  product: OKC - Contracts Core ,  description: Values of price attributes for an object to be used to derive the price for a contract header and contract line. ,  implementation_dba_data: OKC.OKC_PRICE_ATT_VALUES , 

  • Table: OKC_PH_LINE_BREAKS_H 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_PH_LINE_BREAKS_H,  object_name:OKC_PH_LINE_BREAKS_H,  status:VALID,  product: OKC - Contracts Core ,  description: This is a mirror image of base table OKC_PH_LINE_BREAKS, please refer to the base table for detailed column level information - Not Used ,  implementation_dba_data: OKC.OKC_PH_LINE_BREAKS_H , 

  • Table: OKC_K_HISTORY_B 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_HISTORY_B,  object_name:OKC_K_HISTORY_B,  status:VALID,  product: OKC - Contracts Core ,  description: Contract status change history and history for any actions during contract life cycle ,  implementation_dba_data: OKC.OKC_K_HISTORY_B , 

  • Table: OKC_STATUSES_B 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_STATUSES_B,  object_name:OKC_STATUSES_B,  status:VALID,  product: OKC - Contracts Core ,  description: User defined values that define a contract's status. ,  implementation_dba_data: OKC.OKC_STATUSES_B , 

  • Table: OKC_SECTION_CONTENTS 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_SECTION_CONTENTS,  object_name:OKC_SECTION_CONTENTS,  status:VALID,  product: OKC - Contracts Core ,  description: This table holds the components of a section like a label or article ,  implementation_dba_data: OKC.OKC_SECTION_CONTENTS , 

  • View: OKC_LINES_INDEX_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:OKC.OKC_LINES_INDEX_V,  object_name:OKC_LINES_INDEX_V,  status:VALID,  product: OKC - Contracts Core ,  description: Treewalk lines index view ,  implementation_dba_data: APPS.OKC_LINES_INDEX_V , 

  • Table: OKC_K_HISTORY_B 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_HISTORY_B,  object_name:OKC_K_HISTORY_B,  status:VALID,  product: OKC - Contracts Core ,  description: Contract status change history and history for any actions during contract life cycle ,  implementation_dba_data: OKC.OKC_K_HISTORY_B , 

  • Table: OKC_PRICE_ADJ_ASSOCS_H 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_PRICE_ADJ_ASSOCS_H,  object_name:OKC_PRICE_ADJ_ASSOCS_H,  status:VALID,  product: OKC - Contracts Core ,  description: Associates price adjustments to the object for which price has been adjusted. ,  implementation_dba_data: OKC.OKC_PRICE_ADJ_ASSOCS_H , 

  • View: OKC_LINES_INDEX_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:OKC.OKC_LINES_INDEX_V,  object_name:OKC_LINES_INDEX_V,  status:VALID,  product: OKC - Contracts Core ,  description: Treewalk lines index view ,  implementation_dba_data: APPS.OKC_LINES_INDEX_V , 

  • Table: OKC_PRICE_ADJ_ASSOCS 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_PRICE_ADJ_ASSOCS,  object_name:OKC_PRICE_ADJ_ASSOCS,  status:VALID,  product: OKC - Contracts Core ,  description: Associates price adjustments to the object for which price has been adjusted. ,  implementation_dba_data: OKC.OKC_PRICE_ADJ_ASSOCS , 

  • Table: OKC_PRICE_ADJUSTMENTS_H 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_PRICE_ADJUSTMENTS_H,  object_name:OKC_PRICE_ADJUSTMENTS_H,  status:VALID,  product: OKC - Contracts Core ,  description: Record of actual adjustments made to price based on price attribute values. ,  implementation_dba_data: OKC.OKC_PRICE_ADJUSTMENTS_H , 

  • Table: OKC_PRICE_ATT_VALUES_H 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_PRICE_ATT_VALUES_H,  object_name:OKC_PRICE_ATT_VALUES_H,  status:VALID,  product: OKC - Contracts Core ,  description: Values of price attributes for an object to be used to derive the price for a contract header and contract line. ,  implementation_dba_data: OKC.OKC_PRICE_ATT_VALUES_H , 

  • Table: OKC_K_SALES_CREDITS_H 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_SALES_CREDITS_H,  object_name:OKC_K_SALES_CREDITS_H,  status:VALID,  product: OKC - Contracts Core ,  description: This is a mirror image of base table OKC_K_SALES_CREDITS, please refer to the base table for detailed column level information ,  implementation_dba_data: OKC.OKC_K_SALES_CREDITS_H , 

  • Table: OKC_PRICE_ATT_VALUES 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_PRICE_ATT_VALUES,  object_name:OKC_PRICE_ATT_VALUES,  status:VALID,  product: OKC - Contracts Core ,  description: Values of price attributes for an object to be used to derive the price for a contract header and contract line ,  implementation_dba_data: OKC.OKC_PRICE_ATT_VALUES , 

  • Table: OKC_K_LINES_BH 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_LINES_BH,  object_name:OKC_K_LINES_BH,  status:VALID,  product: OKC - Contracts Core ,  description: This is a mirror image of base table OKC_K_LINES_B, please refer to the base table for detailed column level information. ,  implementation_dba_data: OKC.OKC_K_LINES_BH , 

  • Table: OKC_K_REL_OBJS 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_K_REL_OBJS,  object_name:OKC_K_REL_OBJS,  status:VALID,  product: OKC - Contracts Core ,  description: An intersection entity which links a contract header or line to other objects in the schema in a predefined manner. ,  implementation_dba_data: OKC.OKC_K_REL_OBJS , 

  • Table: OKC_PRICE_ATT_VALUES_H 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_PRICE_ATT_VALUES_H,  object_name:OKC_PRICE_ATT_VALUES_H,  status:VALID,  product: OKC - Contracts Core ,  description: Values of price attributes for an object to be used to derive the price for a contract header and contract line. ,  implementation_dba_data: OKC.OKC_PRICE_ATT_VALUES_H , 

  • Table: OKC_PRICE_ADJ_ASSOCS 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_PRICE_ADJ_ASSOCS,  object_name:OKC_PRICE_ADJ_ASSOCS,  status:VALID,  product: OKC - Contracts Core ,  description: Associates price adjustments to the object for which price has been adjusted. ,  implementation_dba_data: OKC.OKC_PRICE_ADJ_ASSOCS , 

  • Table: OKC_PRICE_ADJUSTMENTS_H 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_PRICE_ADJUSTMENTS_H,  object_name:OKC_PRICE_ADJUSTMENTS_H,  status:VALID,  product: OKC - Contracts Core ,  description: This is a mirror image of base table OKC_PRICE_ADJUSTMENTS, please refer to the base table for detailed column level information. ,  implementation_dba_data: OKC.OKC_PRICE_ADJUSTMENTS_H , 

  • Table: OKC_PRICE_ADJ_ASSOCS_H 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_PRICE_ADJ_ASSOCS_H,  object_name:OKC_PRICE_ADJ_ASSOCS_H,  status:VALID,  product: OKC - Contracts Core ,  description: This is a mirror image of base table OKC_PRICE_ADJ_ASSOCS, please refer to the base table for detailed column level information. ,  implementation_dba_data: OKC.OKC_PRICE_ADJ_ASSOCS_H , 

  • Table: OKC_LINE_STYLES_B 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_LINE_STYLES_B,  object_name:OKC_LINE_STYLES_B,  status:VALID,  product: OKC - Contracts Core ,  description: OKC_LINE_STYLES provides meta-data that governs how lines may be defined in a contract. ,  implementation_dba_data: OKC.OKC_LINE_STYLES_B , 

  • Table: OKC_RULE_GROUPS_B 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_RULE_GROUPS_B,  object_name:OKC_RULE_GROUPS_B,  status:VALID,  product: OKC - Contracts Core ,  description: Collection of RULES needed to inform an automated process about a business function. ,  implementation_dba_data: OKC.OKC_RULE_GROUPS_B , 

  • Table: OKC_RULE_GROUPS_B 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_RULE_GROUPS_B,  object_name:OKC_RULE_GROUPS_B,  status:VALID,  product: OKC - Contracts Core ,  description: Collection of RULES needed to inform an automated process about a business function. ,  implementation_dba_data: OKC.OKC_RULE_GROUPS_B , 

  • Table: OKC_LINE_STYLES_B 12.1.1

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_LINE_STYLES_B,  object_name:OKC_LINE_STYLES_B,  status:VALID,  product: OKC - Contracts Core ,  description: OKC_LINE_STYLES provides meta-data that governs how lines may be defined in a contract. ,  implementation_dba_data: OKC.OKC_LINE_STYLES_B , 

  • Table: OKC_PRICE_ADJUSTMENTS 12.2.2

    owner:OKC,  object_type:TABLE,  fnd_design_data:OKC.OKC_PRICE_ADJUSTMENTS,  object_name:OKC_PRICE_ADJUSTMENTS,  status:VALID,  product: OKC - Contracts Core ,  description: Record of actual adjustments made to price based on price attribute values. ,  implementation_dba_data: OKC.OKC_PRICE_ADJUSTMENTS ,