Search Results check_off




Overview
Explore in AI Chat

Overview

APPS.OKL_FUNDING_CRD_CHECKLISTS_UV is a supplementary Oracle E-Business Suite view owned by the APPS schema that supports the funding credit checklist functionality within the Oracle Lease and Finance Management (OKL) and Oracle Contracts (OKC) modules. It is registered in FND Design Data as OKL.OKL_FUNDING_CRD_CHECKLISTS_UV and is classified as a user-facing simplification view whose purpose is to flatten coded lookup values into readable meanings for use by Oracle Forms. The view surfaces contract funding checklists together with their to-do items, mandatory flags, and checked-off status, and translates the underlying code columns into descriptive meaning columns (such as TODO_ITEM_MEANING, MANDATORY_FLAG_MEANING, and CHECK_OFF_MEANING).

Oracle explicitly warns that this is a "supplementary view used to simplify forms coding" and that customers should not query or alter data through it, since its definition may change dramatically in subsequent minor or major releases. It should therefore be treated as an internal Forms-support object rather than a supported integration or reporting interface.

Underlying Base Objects

The view is derived from a small set of documented objects:

  • OKC_GOVERNANCES — the Contracts governance entity, providing the rule group (RGP) context.
  • OKC_K_HEADERS_B — the Contracts header base table, supplying the contract header identifier (KHR_ID).
  • OKL_CREDIT_CHECKLISTS_UV — the credit checklist view that supplies the checklist to-do items; the funding view is essentially a filtered variant of this source.
  • FND_GLOBAL and FND_PROFILE — standard EBS packages used to resolve the current user, responsibility, and profile-option context at runtime.

The view is not referenced by any other database object, so it sits at the top of its dependency chain and is consumed only through the Forms layer.

Key Columns

  • ID (NUMBER) — unique identifier of the checklist row.
  • RGP_ID (NUMBER) — rule group identifier linking the checklist to a governance/rule group.
  • KHR_ID (NUMBER) — contract header identifier; the funding credit checklist belongs to a specific contract.
  • TODO_ITEM_CODE / TODO_ITEM_MEANING — the checklist action item and its decoded description.
  • MANDATORY_FLAG / MANDATORY_FLAG_MEANING — indicates whether the item is required, with the meaning form of the flag.
  • CHECK_OFF / CHECK_OFF_MEANING — the checked-off (completion) code and its decoded meaning; this is the column pair the search term "check_off_meaning" refers to.
  • NOTE — free-text note attached to the checklist item.

Common Use Cases and Queries

The view is primarily consumed by Oracle Forms when displaying or validating funding credit checklists. Typical ad-hoc use retrieves the checklist for a given contract header:

  • Listing all to-do items for a contract: SELECT TODO_ITEM_MEANING, MANDATORY_FLAG_MEANING, CHECK_OFF_MEANING FROM APPS.OKL_FUNDING_CRD_CHECKLISTS_UV WHERE KHR_ID = :p_khr_id;
  • Identifying open (unchecked) mandatory items: filter on CHECK_OFF_MEANING IS NULL or the equivalent code value.
  • Auditing which funding pre-requisites were completed before disbursement.

Because the view is undocumented for direct querying and depends on session context via FND_GLOBAL and FND_PROFILE, joins from custom code should be avoided in favour of the supported OKC/OKL APIs.