Results for “okc_line_styles_b”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKC_LINE_STYLES_B is a core configuration table in the Oracle Contracts (OKC) module of Oracle E-Business Suite, holding the metadata that governs how lines may be defined within a contract. Rather than storing transactional contract content, this table defines the reusable "line styles" — the templates and rules that determine whether a contract line is priced, whether it is protected, which roles and sources apply, and how child lines relate to parent lines. It is present and valid in both EBS 12.1.1 and 12.2.2, owned by the OKC schema.

From a Data Vault modeling perspective, the mined foreign-key structure classifies this table as hub-leaning. The stable business identifier is the surrogate ID, and the surrounding descriptive attributes (pricing flags, access level, enabled indicators) behave more like satellite context than a true transactional hub. Modelers should treat OKC_LINE_STYLES_B as a reference/definition hub with associated descriptive satellites rather than as an event or link table.

Key Information Stored

The table contains 36 documented columns. The most significant are:

• ID — the surrogate primary key (OKC_LINE_STYLES_B_PK), uniquely identifying each line style definition.
• LTY_CODE — the line style type code, distinguishing between the various kinds of line styles supported.
• LSE_PARENT_ID — self-referencing foreign key establishing the parent/child hierarchy among line styles, enabling nested line definitions.
• LSE_TYPE — the classification of the line style itself.
• PRICED_YN — indicates whether lines of this style carry pricing.
• PROTECTED_YN — controls whether the line style is protected from user modification.
• RECURSIVE_YN — governs whether the line style may be applied recursively to child lines.
• ITEM_TO_PRICE_YN and PRICE_BASIS_YN — determine pricing behavior for items associated with the line style.
• SERVICE_ITEM_YN — flags whether the line style applies to service items.
• ACCESS_LEVEL — controls visibility and security tiering of the line style.
• SECURITY_GROUP_ID — the operating unit / security group reference (foreign key to FND_SECURITY_GROUPS).
• APPLICATION_ID — the owning application identifier.
• ZD_EDITION_NAME — the editioning column supporting online patching in 12.2.
• Standard WHO audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

The unique business-key candidate is OKC_LINE_STYLE_B_U1, defined on (ID, ZD_EDITION_NAME). OBJECT_VERSION_NUMBER supports optimistic locking. Fifteen generic ATTRIBUTE1–15 columns provide the standard Oracle attribute flexfield extension area.

Common Use Cases and Queries

Typical uses include reporting on which line styles are available for a given contract type, auditing pricing and protection behavior across line style definitions, and validating hierarchy structures. A query to list all active priced line styles for a security group might resemble:

SELECT ID, LTY_CODE, LSE_PARENT_ID, LSE_TYPE, PRICED_YN, PROTECTED_YN, ACCESS_LEVEL FROM OKC_LINE_STYLES_B WHERE PRICED_YN = 'Y' AND SECURITY_GROUP_ID = :p_security_group;

A hierarchical query resolving parent-child relationships uses the self-referencing key: SELECT ID, LTY_CODE, LSE_PARENT_ID FROM OKC_LINE_STYLES_B START WITH LSE_PARENT_ID IS NULL CONNECT BY PRIOR ID = LSE_PARENT_ID;

A join to contract lines shows how each actual line maps to its governing style: SELECT l.ID, l.LSE_ID, s.LTY_CODE FROM OKC_K_LINES_B l, OKC_LINE_STYLES_B s WHERE l.LSE_ID = s.ID;

Related Objects

OKC_LINE_STYLES_B participates in a rich web of relationships:

• OKC_K_LINES_B — contract lines reference the line style via LSE_ID, the primary consumer of this table.
• OKC_LINE_STYLE_ROLES — assigns roles to line styles, joined on LSE_ID.
• OKC_LINE_STYLE_SOURCES — defines data sources for line styles, joined on LSE_ID.
• OKC_LSE_RULE_GROUPS — groups validation rules by line style via LSE_ID.
• OKC_VAL_LINE_OPERATIONS — valid line operations keyed to the line style.
• OKC_SUBCLASS_TOP_LINE — maps subclasses to top lines by LSE_ID.
• OKL_CRTRN_LNSTYLS — lease criterion line styles referencing this table.
• OKC_LINE_STYLES_B (self) — the LSE_PARENT_ID recursive relationship to FND_SECURITY_GROUPS via SECURITY_GROUP_ID round out the dependency set.