Results for “rgp_id”

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

Overview

OKL_FUNDING_CRD_CHECKLISTS_UV is a UI-support view owned by the APPS schema in Oracle E-Business Suite, belonging to the OKL (Leasing and Finance Management) product family. It exposes credit checklist line items that must be satisfied before a funding request can be processed against a credit line contract. The view consolidates checklist data from OKL_CREDIT_CHECKLISTS_UV with contract header and governance information, presenting a denormalized, presentation-ready result set for the Funding Credit Checklist user interface. It is registered in ETRM as a VALID object in both 12.1.1 and 12.2.2.

Underlying Base Objects

The view text joins three principal sources. OKL_CREDIT_CHECKLISTS_UV supplies the checklist line items (ID, RGP_ID, TODO_ITEM_CODE, TODO_ITEM_MEANING, MANDATORY_FLAG, CHECK_OFF, NOTE). OKC_K_HEADERS_B supplies the contract header row; the join is on CLT.KHR_ID = KHR.ID, and the view filters to KHR.STS_CODE = 'ACTIVE' and KHR.SCS_CODE = 'CREDITLINE_CONTRACT'. OKC_GOVERNANCES is joined via KHR.ID = GOV.CHR_ID_REFERRED, supplying the DNZ_CHR_ID column aliased as KHR_ID. The ETRM metadata additionally lists FND_GLOBAL and FND_PROFILE as referenced objects, indicating that the view or its dependent views rely on session context and profile option values (for example for org or user context). All base objects are accessed through APPS synonyms.

Key Columns

• ID — Unique identifier of the checklist line item, sourced from OKL_CREDIT_CHECKLISTS_UV.
• RGP_ID — Identifier of the associated resource group or program record carried from the checklist view.
• KHR_ID — Contract header identifier; note it is mapped from GOV.DNZ_CHR_ID (the governance reference), not directly from the header.
• TODO_ITEM_CODE / TODO_ITEM_MEANING — Code and descriptive text for the checklist action item.
• MANDATORY_FLAG / MANDATORY_FLAG_MEANING — Indicates whether the checklist item is required, with its display meaning.
• CHECK_OFF / CHECK_OFF_MEANING — Completion status of the item and its display meaning.
• NOTE — Free-text note attached to the checklist line.

Because KHR_ID derives from OKC_GOVERNANCES, consumers should treat it as the governance contract header reference when correlating to other contract-based views.

Common Use Cases and Queries

The primary use case is populating the credit checklist region of the funding UI, determining which mandatory items remain outstanding. A typical query lists outstanding mandatory items for active credit line contracts:

• SELECT khr_id, todo_item_code, todo_item_meaning, check_off, note FROM okl_funding_crd_checklists_uv WHERE mandatory_flag = 'Y' AND check_off = 'N' ORDER BY khr_id, todo_item_code;
• SELECT khr_id, COUNT(*) total_items, SUM(CASE WHEN check_off = 'Y' THEN 1 ELSE 0 END) completed_items FROM okl_funding_crd_checklists_uv GROUP BY khr_id;
• SELECT c.id, c.todo_item_code, c.check_off_meaning FROM okl_funding_crd_checklists_uv c, okc_k_headers_b h WHERE c.khr_id = h.id AND h.scs_code = 'CREDITLINE_CONTRACT' AND h.sts_code = 'ACTIVE';

These patterns support funding approval gating, exception reporting, and integration feeds that must confirm checklist completion prior to releasing funds. Note the user's search term "okc_governances" aligns with the OKC_GOVERNANCES base table referenced by this view.