Search Results cls_cls_uk

Overview

The table OKL_CRTRN_LNSTYLS is a core data object within the Oracle E-Business Suite (EBS) Leasing and Finance Management (OKL) module. It functions as a junction or intersection table, establishing a many-to-many relationship between business criteria and line styles. Its primary role is to define and store the specific line styles (e.g., payment, funding, tax lines) where a particular business rule or criterion is applicable within the leasing contract lifecycle. This configuration enables the flexible application of complex business logic across different types of transaction lines in agreements.

Key Information Stored

The table's structure centers on two key foreign key columns that link to master data tables, along with a unique identifier. The primary data points stored are:

• ID: Serves as the unique primary key (OKL_CRTRN_LNSTYLS_PK) for each record in this intersection table.
• CRN_ID: Foreign key referencing the OKL_CRITERIA_B table. This column identifies the specific business criterion or rule being applied.
• LSE_ID: Foreign key referencing the OKC_LINE_STYLES_B table. This column identifies the line style to which the criterion is relevant.

A unique constraint (CLS_CLS_UK) on the combination of CRN_ID and LSE_ID ensures that a given criterion cannot be assigned to the same line style more than once.

Common Use Cases and Queries

This table is primarily used for configuration and validation during the setup of leasing products and the processing of contract lines. A common operational use case is determining all the business rules that must be evaluated when generating a specific type of line, such as a lease payment, for a contract. Conversely, it is used to validate which line styles a newly created criterion can be attached to within the application's setup forms. A typical reporting query would join this table to its referenced master tables to produce a list of all configured criterion-to-line-style mappings for audit or analysis purposes.

Sample Query:
SELECT cls.id, crn.name AS criterion_name, lse.name AS line_style_name
FROM okl_crtrn_lnstyls cls,
okl_criteria_b crn,
okc_line_styles_b lse
WHERE cls.crn_id = crn.id
AND cls.lse_id = lse.id
ORDER BY crn.name, lse.name;

Related Objects

OKL_CRTRN_LNSTYLS is a dependent object with defined relationships to two key master tables in the EBS data model:

• OKL_CRITERIA_B: This is the main criteria table. The foreign key relationship is defined on the column OKL_CRTRN_LNSTYLS.CRN_ID referencing OKL_CRITERIA_B. This links a line style assignment to a specific business rule.
• OKC_LINE_STYLES_B: This is the core Oracle Contracts table for line style definitions. The foreign key relationship is defined on the column OKL_CRTRN_LNSTYLS.LSE_ID referencing OKC_LINE_STYLES_B. This links a criterion assignment to a specific transaction line type.

These relationships are critical for maintaining data integrity and are essential for any joins performed in custom reports, interfaces, or extensions that need to understand the full context of a criterion's application.