Search Results okc_line_style_b

Overview

APPS.OKL_LSE_SCS_RULES_V is a public Oracle EBS view in the Oracle Lease and Finance Management (OLFM) module, owned by the APPS schema and registered under FND Design Data as OKL.OKL_LSE_SCS_RULES_V. Its status is VALID across EBS 12.1.1 and 12.2.2. The view exposes the rule configuration associated with lease line styles, returning the rule group, subclass, and individual rule codes that govern contract and asset line behavior. It is primarily intended as a reporting and integration surface, allowing custom reports, conversions, and setup validation queries to retrieve seeded and user-defined rule information without navigating the underlying normalized rule tables.

The view is relevant to the search term okc_line_style_b because OKC_LINE_STYLES_B is one of its foundational source objects; the view joins line style header data to the subclass rule group definitions and rule registrations that apply to each line style.

Underlying Base Objects

The documented view definition is based on the following objects:

• OKC_LSE_RULE_GROUPS LRG — provides the rule group categories.
• OKC_SUBCLASS_RG_DEFS SRD — maps subclasses to rule group definitions.
• OKC_RG_DEF_RULES RGR — holds the individual rule definitions tied to each rule group.
• OKC_LINE_STYLES_B LSEB — the base table holding line style IDs, names, types, and parent relationships.
• OKC_LINE_STYLES_TL LSET — the translation table supplying the language-specific line style name and meaning.

The ETRM 12.2.2 metadata lists the referenced base objects as OKC_RG_DEF_RULES (SYNONYM), OKC_SUBCLASS_RG_DEFS (SYNONYM), and the OKL_ACCOUNTING_UTIL package. The view is referenced by OLFM setup private APIs including OKL_SETUPOPTIONS_PVT, OKL_SETUPOPTRULES_PVT, and OKL_SETUPOPTVALUES_PVT, confirming its role in setup option resolution.

Key Columns

• LSE_ID (VARCHAR2) — Identifier of the line style.
• LINE_STYLE (VARCHAR2) — Name of the line style.
• LINE_TYPE (VARCHAR2) — Indicates whether the line is an asset line or a contract line.
• PARENT_ID (VARCHAR2) — Foreign key to OKC_LINE_STYLES_B, linking to the parent line style.
• SRD_ID (NUMBER) — Foreign key to OKC_SUBCLASS_RG_DEFS.
• SUBCLASS (VARCHAR2 30) — Subclass associated with the rule group.
• RULE_GROUP (VARCHAR2 30) — Category used to group rules.
• RULE (VARCHAR2 30) — Rule code for seeded rules.
• CONCATENATED_RULE (VARCHAR2 92) — Concatenation of rule, subclass, line style, and rule group.
• START_DATE / END_DATE (DATE) — Effective date range for the rule.
• MEANING (VARCHAR2 4000) — Descriptive meaning of the rule.

Common Use Cases and Queries

Typical scenarios include auditing which rules apply to a given line style, validating setup during implementation, and driving custom reporting on rule coverage.

SELECT LSE_ID
     , LINE_STYLE
     , LINE_TYPE
     , PARENT_ID
     , SRD_ID
     , SUBCLASS
     , RULE_GROUP
     , RULE
     , CONCATENATED_RULE
     , START_DATE
     , END_DATE
     , MEANING
FROM APPS.OKL_LSE_SCS_RULES_V;

To list rules for a specific line style:

SELECT RULE_GROUP, RULE, SUBCLASS, MEANING
FROM APPS.OKL_LSE_SCS_RULES_V
WHERE LINE_STYLE = :p_line_style
ORDER BY RULE_GROUP, RULE;

Because the view is a public reporting view, it is suitable for read-only custom queries, but it should not be used for direct DML. For current rules, filter on START_DATE and END_DATE relative to SYSDATE.