Search Results small_business_flag

Overview

OKC_K_PARTY_ROLES_V is an APPS-owned reporting view within the OKC – Contracts Core product of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It presents the party-role assignments that link external and internal parties (customers, suppliers, employees, organizations) to contract headers and lines in Oracle Contracts, supplying the descriptive context—role name, party cognomen, alias, and diversity classifications—that is otherwise spread across base and translation tables.

The view is documented as a view for the table OKC_CONTRACT_PARTY_ROLES_B, which is the base transactional table for contract party roles. By joining the base table to its translation table and to FND_LOOKUPS, the view delivers role descriptions resolved to the session language and lookup meaning, making it a convenient reporting and integration source. It is widely used in contract reporting, supplier-diversity reporting, and interfaces that need to identify the parties on a contract together with their assigned roles.

Underlying Base Objects

The documented base objects referenced by the view are OKC_K_PARTY_ROLES_B (exposed in the view definition through a synonym), OKC_K_PARTY_ROLES_TL (also through a synonym), the FND_LOOKUPS view, and the FND_GLOBAL package. Two joins drive the view:

• CPLB.ID = CPLT.ID and CPLT.LANGUAGE = USERENV('LANG'), resolving translated descriptive attributes (SFWT_FLAG, COGNOMEN, ALIAS) from OKC_K_PARTY_ROLES_TL. USERENV('LANG') draws on the session context maintained through FND_GLOBAL.
• FNDV.LOOKUP_TYPE = 'OKC_ROLE' and CPLB.RLE_CODE = FNDV.LOOKUP_CODE, resolving the ROLE column as the FND_LOOKUPS.MEANING for the party role lookup code.

Because OKC_K_PARTY_ROLES_B carries the role assignment itself while the TL table carries language-dependent text, and FND_LOOKUPS carries the role meaning, the view behaves as a denormalized, language-aware projection of contract party role data.

Key Columns

• ROW_ID, ID, OBJECT_VERSION_NUMBER — the row identifier, surrogate primary key, and optimistic-locking version of the underlying OKC_K_PARTY_ROLES_B record.
• CHR_ID, CPL_ID, CLE_ID, DNZ_CHR_ID — contract header, party-role line, contract line, and related header/line identifiers that anchor the role to a contract structure.
• RLE_CODE, ROLE — the stored role lookup code and its translated FND_LOOKUPS meaning (the human-readable role).
• SMALL_BUSINESS_FLAG, WOMEN_OWNED_FLAG, MINORITY_GROUP_LOOKUP_CODE, FACILITY — supplier-diversity and classification attributes recorded against the party role. SMALL_BUSINESS_FLAG is the column most directly relevant to small-business reporting and eligibility determinations.
• COGNOMEN, ALIAS, SFWT_FLAG — translated party name/identifier and alias information from the TL table.
• PRIMARY_YN — indicates whether the party role is the primary role for the record.
• CUST_ACCT_ID, BILL_TO_SITE_USE_ID — customer account and bill-to site context for the assigned party.
• ATTRIBUTE_CATEGORY through ATTRIBUTE15 — the standard DFF flexfield columns for client-specific extensions.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Typical scenarios include listing all parties on a contract with role names, auditing primary party assignments, and identifying contracts awarded to small businesses for diversity or procurement reporting.

• Parties and roles for a contract: SELECT id, chr_id, cle_id, role, cognomen, alias, primary_yn FROM okc_k_party_roles_v WHERE chr_id = :p_chr_id;
• Small-business party roles: SELECT chr_id, role, cognomen, small_business_flag, women_owned_flag, minority_group_lookup_code FROM okc_k_party_roles_v WHERE small_business_flag = 'Y';
• Primary contracting party per contract: SELECT chr_id, role, cognomen, primary_yn FROM okc_k_party_roles_v WHERE primary_yn = 'Y' AND rle_code = :p_role_code;

Because the view resolves ROLE through FND_LOOKUPS, role meanings appear in the session language, which simplifies localization of reports and interfaces that consume contract party data.