Search Results psn_creation_date




Overview
Explore in AI Chat

Overview

APPS.CZ_EXPLNODES_VALUES_EFF_CV is a configuration view in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 environments, owned by the APPS schema with FND Design Data reference CZ.CZ_EXPLNODES_VALUES_EFF_CV. Its name follows Oracle's Developer/Configurator conventions: "CV" denotes a configuration view, "EFF" indicates effectivity handling, and "EXPLNODES" reflects its role over the CZ_EXPL structure. The view exposes the flattened, effectivity-filtered result set of model explosion nodes together with their associated property values, presentation attributes, and system property metadata.

Functionally, this object presents a denormalized projection suitable for reporting, concurrent processing, and integration against the Oracle Configurator and generic configuration model data. It joins node-level definitions with property value records and image references so that callers can retrieve a single row per effective node-value combination without navigating the base CZ tables directly. Because it is a view rather than a table, it carries no independent data of its own and reflects the current state of the underlying CZ_ objects at query time.

Underlying Base Objects

The documented dependency list identifies the principal objects the view resolves against:

Effectivity filtering is applied through EFFECTIVITY_FILTER, EFFECTIVE_FROM, EFFECTIVE_UNTIL, EFFECTIVE_USAGE_MASK, and EFFECTIVITY_SET_ID, which enforce the effective-dated visibility of nodes and values.

Key Columns

The view exposes a broad set of columns:

Common Use Cases and Queries

Typical uses include auditing node creation timelines, extracting effective property values for a model, and generating integration feeds of configurable node data.

To retrieve nodes by creation date:

  • SELECT PS_NODE_ID, NAME, PSN_CREATION_DATE FROM APPS.CZ_EXPLNODES_VALUES_EFF_CV WHERE PSN_CREATION_DATE >= SYSDATE - 30;

To list effective values for a specific model:

  • SELECT NODE_DEPTH, NAME, INITIAL_VALUE, EFFECTIVE_FROM, EFFECTIVE_UNTIL FROM APPS.CZ_EXPLNODES_VALUES_EFF_CV WHERE MODEL_ID = :model_id ORDER BY TREE_SEQ;

To identify disabled or omitted nodes:

  • SELECT PS_NODE_ID, NAME, NODE_DISABLED_FLAG FROM APPS.CZ_EXPLNODES_VALUES_EFF_CV WHERE NODE_DISABLED_FLAG = 1 OR UI_OMIT = 'Y';

Because the view depends on PL/SQL functions and nested views, queries should be filtered on indexed identifiers such as MODEL_ID or PS_NODE_ID to limit cost.