Search Results effective_until




Overview
Explore in AI Chat

Overview

CZ_MODELRULEFOLDER_IMAGES_V is an APPS-owned, VALID database view in the Oracle Configurator (CZ) module, available in EBS 12.1.1 and 12.2.2. It presents model rule folder records enriched with associated rule type image metadata, providing a reporting and integration layer over the model rule folder hierarchy. The view combines hierarchical rule folder attributes (parent/child relationships, tree sequencing, folder type) with presentation attributes such as image file, data value, value label, alternate text, and full image path, so that consumers can render or extract configuration rule nodes together with their visual representation.

Underlying Base Objects

The view text is a UNION ALL of two similar queries, each joining CZ_MODEL_ALL_RULEFOLDERS_V (aliased MRFL) to CZ_RULETYPE_IMAGES_V (aliased RTIMG) as an outer join. The documented ETRM dependencies are CZ_EFFECTIVITY_SETS (synonym), CZ_MODEL_ALL_RULEFOLDERS_V (view), CZ_RULETYPE_IMAGES_V (view), and FND_PROFILE (package).

The first branch excludes DETAILED_RULE_TYPE values 33, 34, 400, 500, 501, 502, and 700, while the UNION ALL adds remaining rows. A literal EFFECTIVITY_FILTER column ('N' in the first branch) distinguishes the branches.

Key Columns

Common Use Cases and Queries

Typical uses include reporting rule folder hierarchies with images, verifying effectivity windows, and exporting folder definitions for integration. A query listing folders and their effective end date:

  • SELECT MODEL_ID, RULE_FOLDER_ID, NAME, EFFECTIVE_FROM, EFFECTIVE_UNTIL FROM CZ_MODELRULEFOLDER_IMAGES_V WHERE MODEL_ID = :p_model_id AND NVL(DELETED_FLAG,'N') = 'N';
  • SELECT RULE_FOLDER_ID, NAME, IMAGE_FILE, FULL_IMAGE_PATH FROM CZ_MODELRULEFOLDER_IMAGES_V WHERE EFFECTIVE_UNTIL IS NULL OR EFFECTIVE_UNTIL > SYSDATE;
  • SELECT DISTINCT EFFECTIVITY_SET_ID, EFFECTIVE_USAGE_MASK FROM CZ_MODELRULEFOLDER_IMAGES_V WHERE MODEL_ID = :p_model_id;

Queries filtering on EFFECTIVE_UNTIL should account for NULL values, which generally indicate the folder has no defined expiry and remains effective.