Search Results okc_subclass_top_line

Overview

The OKC_SUBCLASS_TOP_LINE table is a core data structure within the Oracle E-Business Suite Contracts Core (OKC) module, specifically for versions 12.1.1 and 12.2.2. It functions as a mapping or association table within the complex line style hierarchy of Oracle Contracts. Its primary role is to define the permissible relationships between contract line subclasses and the top-level line styles. This table essentially governs which specific line subclasses (detailed line types) can be used under a given high-level line style, enforcing business rules and data integrity for contract line creation and management. By maintaining these associations, it ensures that contract lines are structured correctly according to the configured style hierarchy.

Key Information Stored

The table is defined by a concise two-column composite primary key, which stores the essential linkage data. The SCS_CODE column stores the unique identifier for a contract line subclass, as defined in the OKC_SUBCLASSES_B table. The LSE_ID column stores the unique identifier for a top-level line style, as defined in the OKC_LINE_STYLES_B table. Each record in this table represents a single, valid association where the specified subclass (SCS_CODE) is allowed to be used under the specified top line style (LSE_ID). The existence of a record is the authorization for that relationship.

Common Use Cases and Queries

This table is central to configuration and validation processes. A primary use case is during the setup of line styles and subclasses, where administrators define which subclasses roll up to which top styles. For reporting and analysis, it is used to understand the structure of the line style hierarchy. Common queries involve joining to the related master tables to get descriptive information. For instance, to list all subclasses allowed for a specific top line style named 'SERVICE', one might use:

• SELECT ssc.NAME SUBCLASS_NAME, lsb.NAME TOP_LINE_STYLE_NAME
• FROM okc_subclass_top_line stl,
• okc_subclasses_b ssc,
• okc_line_styles_b lsb
• WHERE stl.scs_code = ssc.scs_code
• AND stl.lse_id = lsb.id
• AND lsb.NAME = 'SERVICE';

Another critical use is programmatic validation within custom extensions or integrations to check if a proposed line subclass is valid for a given contract's line style before creating a line.

Related Objects

The OKC_SUBCLASS_TOP_LINE table maintains documented foreign key relationships with two key foundation tables, as per the provided metadata:

• OKC_LINE_STYLES_B: The foreign key from column OKC_SUBCLASS_TOP_LINE.LSE_ID references this table. It ensures that every top line style ID in the association table corresponds to a valid, existing line style definition.
• OKC_SUBCLASSES_B: The foreign key from column OKC_SUBCLASS_TOP_LINE.SCS_CODE references this table. It ensures that every subclass code in the association table corresponds to a valid, existing subclass definition.

These relationships are fundamental, making OKC_SUBCLASS_TOP_LINE the central junction table that connects the master definitions of line styles (OKC_LINE_STYLES_B) and subclasses (OKC_SUBCLASSES_B) within the Contracts Core hierarchy.