Results for “okl_cntx_grp_prmtrs_v”

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

Overview

OKL_CNTX_GRP_PRMTRS_V is a reporting view owned by the APPS schema within the Oracle Lease and Finance Management (OKL) product family. It exposes the association between context groups and the parameters that they reference, providing a query-friendly projection of the underlying intersection data. In Oracle EBS 12.1.1 and 12.2.2, this view is registered in the ETRM (E-Business Tables and Relationships Model) repository with a status of VALID, confirming that it is a supported, documented database object suitable for reporting and integration purposes.

The view's documented description — "Association of Parameters for the Context Group" — indicates that it functions as a bridging construct. Each row represents a single parameter linked to a context group, and the view is typically used when building lease parameter configuration reports, extracting setup metadata for migration, or joining context group definitions to their constituent parameters in downstream applications.

Underlying Base Objects

The view is defined over a single referenced base object: OKL_CNTX_GRP_PRMTRS, which is accessed through a SYNONYM in the APPS schema. The view text performs a direct column projection from this base table (aliased as CGMB) with no joins, filters, or aggregation:

• OKL_CNTX_GRP_PRMTRS — the physical table storing context group to parameter associations. The view selects all documented columns directly from it.

Because the view is a straight projection, it preserves the row identity of the base table. The ROW_ID column is populated using CGMB.ROWID, exposing the physical row address of the underlying OKL_CNTX_GRP_PRMTRS record. This design makes the view read-only-safe for reporting while retaining the ability to correlate back to the base row for auditing.

Key Columns

The view exposes ten columns mirroring the base table structure:

• ROW_ID — the physical ROWID of the underlying OKL_CNTX_GRP_PRMTRS row; useful for row-level identification and diagnostics.
• ID — the unique primary identifier for the association record.
• OBJECT_VERSION_NUMBER — the optimistic locking version counter used by the EBS framework for concurrent update control.
• CGR_ID — the context group identifier. This is the column most frequently used as a search key (the user search term "cgr_id" maps directly here) and is the foreign key linking to the context group definition.
• PMR_ID — the parameter identifier, linking to the parameter master record.
• CREATED_BY, CREATION_DATE — standard audit columns recording the user and timestamp of row creation.
• LAST_UPDATED_BY, LAST_UPDATE_DATE — audit columns recording the most recent modification.
• LAST_UPDATE_LOGIN — the login identifier of the session that last modified the row.

Common Use Cases and Queries

Typical usage involves retrieving all parameters configured for a given context group, or auditing the setup for a specific parameter across groups. The CGR_ID column is the primary access path:

• Listing parameters by context group: SELECT ID, CGR_ID, PMR_ID, LAST_UPDATE_DATE FROM OKL_CNTX_GRP_PRMTRS_V WHERE CGR_ID = :p_cgr_id;
• Finding all context groups that reference a parameter: SELECT CGR_ID, PMR_ID FROM OKL_CNTX_GRP_PRMTRS_V WHERE PMR_ID = :p_pmr_id;
• Audit extraction of recent changes: SELECT ID, CGR_ID, PMR_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM OKL_CNTX_GRP_PRMTRS_V WHERE LAST_UPDATE_DATE >= :p_since_date ORDER BY LAST_UPDATE_DATE DESC;

Because the view does not resolve CGR_ID or PMR_ID to their descriptive names, report authors typically join it to context group and parameter definition views to produce human-readable output. All queries should be executed against the APPS schema with appropriate OKL responsibility access.