Search Results okc_contract_groups_b

Overview

OKC_K_GROUPS_V is a validity-checked (VALID) Oracle EBS view owned by the APPS schema and defined within the OKC – Contracts Core product. Its documented purpose is to expose a flattened, language-resolved representation of the OKC_CONTRACT_GROUPS_B table by joining it to its translation table. In Oracle E-Business Suite 12.1.1 and 12.2.2, contract groups are the logical containers used to organize contract documents for reporting, security, and categorization. This view serves as the read interface over that grouping data, presenting the base entity attributes together with the translated descriptive text for the session's active language. Because it combines the base table and the translation table and filters the translation by USERENV('LANG'), it is the appropriate object for reporting, concurrent programs, and outbound integrations that must display group names and short descriptions in the user's own language without performing an explicit language join. It is a read-only view and does not itself support DML; inserts or updates against the grouping entity are performed through the underlying base tables or the corresponding Contracts Core APIs.

Underlying Base Objects

The view is defined over two documented base objects, both referenced as synonyms from APPS: OKC_K_GROUPS_B, the base (non-translated) table holding the group's identifying, ownership, and descriptive-flexfield columns, and OKC_K_GROUPS_TL, the translation table holding the language-specific NAME and SHORT_DESCRIPTION. The join is established on CGPB.ID = CGPT.ID, and the translation side is restricted by CGPT.LANGUAGE = USERENV('LANG'), so that each base row appears once, resolved to the current session language. Users of the OKC_K_GROUPS_V view are, in practice, reading through OKC_K_GROUPS_B, whose ROWID is projected as ROW_ID, while the translated text originates from OKC_K_GROUPS_TL.

Key Columns

• ROW_ID: the ROWID of the underlying OKC_K_GROUPS_B row, providing a direct pointer to the base record.
• ID: the primary identifier of the contract group, shared between the base and translation tables.
• NAME and SHORT_DESCRIPTION: the translated group name and brief description, sourced from OKC_K_GROUPS_TL.
• USER_ID: identifies the user associated with the group record.
• PUBLIC_YN: indicates whether the group is publicly available for general use or restricted.
• SFWT_FLAG: a translation-table flag associated with the group's descriptive text.
• OBJECT_VERSION_NUMBER: the optimistic-locking version column used by the Contracts Core framework for concurrent update control.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15: the descriptive flexfield key and segments for capturing client-specific group attributes.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN: standard EBS who-columns recording audit and last-touch information.

Common Use Cases and Queries

The view is commonly employed in contract reporting, where group names must be presented in the operator's language, and in integrations that map contract documents to their organizing groups. A typical query retrieves the group identity and translated text:

• SELECT id, name, short_description, public_yn FROM apps.okc_k_groups_v WHERE id = :p_group_id;
• SELECT id, name, public_yn FROM apps.okc_k_groups_v WHERE public_yn = 'Y' ORDER BY name;

For audit or version-awareness purposes, the OBJECT_VERSION_NUMBER and who-columns allow reporting on recency and concurrency. Because the view filters on USERENV('LANG'), query results automatically reflect the language of the connected session; callers requiring multilingual output across all installed languages must query OKC_K_GROUPS_TL directly rather than this view.