Results for “subclass_code”

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

Overview

OKL_RELATED_CONTRACT_ALL_UV is a database view owned by the APPS schema within Oracle Lease and Finance Management (OKL). It exposes a "List of Related Contracts," presenting contracts that have been grouped together through the contract grouping mechanism defined by the OKC (Contracts Core) data model. Rather than returning a single flat list of contract headers, the view flattens the parent-to-child relationship captured by OKC_K_GRPINGS, allowing reporting and integration consumers to retrieve a contract alongside the identifier of the group to which it belongs.

The view is a multi-source UNION ALL construct. It joins contract header base rows against language-specific translation tables for status and subclass meaning, and against contract grouping rows. Its design makes it a convenient reporting layer for questions such as "which contracts are related to a given parent contract group?" without requiring callers to reassemble the grouping, translation, and header joins themselves.

Underlying Base Objects

The documented base objects are predominantly OKC synonyms, supplemented by JTF resource and FND infrastructure objects. The core contract data flows from OKC_K_HEADERS_ALL_B (the base contract header table, alias CHRB) and OKC_K_HEADERS_TL (its translation table, alias CHRT). The grouping relationship is drawn from OKC_K_GRPINGS (alias CGP), where CGP.INCLUDED_CHR_ID = CHRB.ID links each included contract to its parent group.

Decoded meanings are sourced from OKC_STATUSES_TL and OKC_SUBCLASSES_TL, both joined on language via USERENV('LANG') so that status and subclass descriptions return in the session language. Security and responsibility context is supplied through OKC_K_ACCESSES and OKC_APP_FUNCTION_ACCESSES. The JTF resource objects — JTF_RS_ROLES_B, JTF_RS_ROLE_RELATIONS, JTF_RS_RESOURCE_EXTNS, JTF_RS_GROUP_MEMBERS, and JTF_RS_GROUPS_DENORM — support the resource and role dimension. Critically for the searched term, OKC_SUBCLASS_RESPS is a documented base object, meaning the view relates subclass responsibilities to the returned contract rows. FND_GLOBAL supplies session context such as organization and user identifiers.

Key Columns

The view exposes columns that closely mirror the physical header and grouping tables. Grouping context is provided by PARENT_GROUP_ID (from CGP.CGP_PARENT_ID) and ROW_ID. Contract identity columns include CONTRACT_ID, CONTRACT_NUMBER, CONTRACT_NUMBER_MODIFIER, and OBJECT_VERSION_NUMBER for optimistic locking.

Status and classification are represented by STATUS_CODE and STATUS_MEANING, and by SUBCLASS_CODE and SUBCLASS_MEANING. Descriptive attributes include SHORT_DESCRIPTION, DESCRIPTION, COMMENTS, and KNOWN_AS (from the COGNOMEN column). Financial and term attributes include CONTRACT_AMOUNT (ESTIMATED_AMOUNT), CURRENCY_CODE, START_DATE, END_DATE, DATE_SIGNED, DATE_APPROVED, DATE_TERMINATED, and DATE_RENEWED. Flags such as TEMPLATE_YN, TEMPLATE_USED, CUST_PO_NUMBER_REQ_YN, and PRE_PAY_REQ_YN indicate behavioral characteristics. Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) are also exposed.

Common Use Cases and Queries

The view is typically consumed for contract hierarchy reporting, dashboards, and interface extracts where related contracts must be enumerated by parent group. A representative query retrieving related contracts for a specific parent group:

• SELECT contract_id, contract_number, parent_group_id, status_meaning, subclass_meaning, contract_amount, start_date, end_date FROM okl_related_contract_all_uv WHERE parent_group_id = :p_group_id;
• Filtering by subclass responsibility or subclass code to isolate contracts of a specific type: SELECT contract_number, subclass_meaning FROM okl_related_contract_all_uv WHERE subclass_code = :p_subclass;
• Listing active, non-template contracts within a date window: SELECT contract_number, status_meaning, start_date, end_date FROM okl_related_contract_all_uv WHERE template_yn = 'N' AND start_date BETWEEN :p_from AND :p_to ORDER BY start_date;
• Joining the view to contract access or responsibility tables to constrain results to contracts the current responsibility may view.

Because the view performs language-dependent translation joins, callers should set NLS_LANGUAGE appropriately to obtain meaningful status and subclass text rather than raw codes.