Results for “okl_ctxprms_serch_uv”

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

Overview

OKL_CTXPRMS_SERCH_UV is a read-only database view owned by the APPS schema within the Oracle Leasing and Finance Management (OKL) module. It presents a consolidated, language-aware listing of the parameters that belong to context groups defined in Oracle Contracts Core (OKC/OKL context framework). The view is primarily used to drive the Context Parameters search and list-of-values screens within the OKL leasing application, where an end user can search for the parameters associated with a particular context group, or work backwards from a parameter to identify the context groups that reference it. Its name — the "SERCH" (search) suffix — reflects this query-oriented purpose. Because the view joins the base and translation tables and resolves the language from USERENV('LANG'), it returns parameter names and descriptions displayed in the session's current language. For reporting and integration purposes, the view supplies a single denormalized source that exposes the association between context groups (CGR_ID), parameters (PMR_ID), and the descriptive text needed for human-readable output.

Underlying Base Objects

The view is defined over four documented base objects, each accessed through an APPS synonym:

• OKL_CONTEXT_GROUPS_B — the base table holding context group definitions (aliased CGRB). It supplies the context group identity that the parameter assignments are anchored to.
• OKL_CNTX_GRP_PRMTRS — the intersection table (aliased CGMB) that maps context groups to parameters. Each row represents one parameter assigned to one context group and carries the CGR_ID and PMR_ID foreign keys.
• OKL_PARAMETERS_B — the base parameter definitions table (aliased PMRB), providing the parameter name and its datatype.
• OKL_PARAMETERS_TL — the translated (TL) parameter table (aliased PMRTL), providing the language-specific description.

The joins are: CGRB.ID = CGMB.CGR_ID, CGMB.PMR_ID = PMRB.ID, PMRB.ID = PMRTL.ID, and PMRTL.LANGUAGE = USERENV('LANG'). The join to the TL table is inner, so a parameter row appears only where a translation exists for the current session language.

Key Columns

• ID — the identifier from the context-group/parameter intersection table (CGMB.ID); unique per assignment row.
• NAME — the parameter name from OKL_PARAMETERS_B.
• DESCRIPTION — the language-specific description from OKL_PARAMETERS_TL.
• CGR_ID — the context group identifier; the value most frequently searched for. It links back to OKL_CONTEXT_GROUPS_B.ID.
• PMR_ID — the parameter identifier, linking to OKL_PARAMETERS_B.ID.
• DATATYPE — the data type of the parameter (e.g. text, number, date), used by the UI to render or validate the parameter value.

Common Use Cases and Queries

Typical uses include populating context parameter search pages, resolving parameter descriptions for a given context group, and identifying all context groups that reference a given parameter. A common lookup by cgr_id is shown below:

SELECT id, name, description, cgr_id, pmr_id, datatype
FROM apps.okl_ctxprms_serch_uv
WHERE cgr_id = :p_cgr_id
ORDER BY name;

To locate every context group that uses a specific parameter, filter on PMR_ID or NAME instead. Because the view is language-sensitive, run it under the appropriate session language to obtain the desired DESCRIPTION text; if a parameter has no translation for the session language, it will not appear. As a view, it supports only SELECT operations and should not be used for DML.