Results for “cz_property_picker_v”

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

Overview

CZ_PROPERTY_PICKER_V is a Configurator (CZ) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is a public, non-seeded, VALID dictionary object that exposes Configurator model properties together with their type, default value, source reference, and associated UI imagery. Functionally, the view is an optimized lookup source that populates the property picker list presented to a user or application when browsing and selecting properties within Configurator runtime or administrative screens.

The view returns a single row per non-deleted property entry (OBJECT_TYPE = 'PRP') that satisfies the image and lookup joins defined in the union. It is designed primarily for runtime presentation rather than bulk extraction, and therefore the driving filter CZRPENTRIESEO.DELETED_FLAG = '0' restricts its output to active properties only.

Underlying Base Objects

The documented base objects referenced by CZ_PROPERTY_PICKER_V are:

• CZ_RP_ENTRIES (synonym) — the registry of repository entries, including object type, enclosing folder, name, notes and delete/seed flags.
• CZ_PROPERTIES (synonym) — property definitions, including data type, default value (DEF_VALUE), default numeric value and source application.
• CZ_RPOBJECTTYPES_LKV (view) — a lookup view providing DATA_VALUE, VALUE_DESCRIPTION and NUMERIC_ID_VALUE for repository object types.
• CZ_UI_PATHED_IMAGES_V (view) — a UI image lookup returning IMAGE_FILE and FULL_IMAGE_PATH for a given entity, seeded flag, UI definition, and image usage.
• CZ_INTL_TEXTS (synonym) — the translatable text repository consumed by related property views (in particular the DEF_TRANSLATABLE_TEXT path).

The two SELECT branches are combined with UNION ALL: the first branch joins non-text properties (DATA_TYPE <> 8) to the object-type lookup and the seeded UI image definition (UI_DEF_ID = 0, IMAGE_USAGE_CODE = 30), while the second branch handles later property representations with a NULL-supplied number conversion.

Key Columns

• OBJECT_ID / OBJECT_TYPE — identity of the Configurator entry; the picker filters to OBJECT_TYPE = 'PRP'.
• ENCLOSING_FOLDER / NAME / NOTES — navigation and descriptive metadata for the property row.
• PROPERTY_DATA_TYPE — numeric data type of the property (8 denotes translatable text properties, which are excluded from the primary branch).
• DEF_VALUE, DEF_NUM_VALUE — the default value of a property in character and numeric form respectively. DEF_VALUE is the column users typically search for via the "def_value" term.
• DEF_TRANSLATABLE_TEXT — reserved for translatable default text (NULL in the presented branch).
• ORIG_SYS_REF / SRC_APPLICATION_ID — origin system reference and source application identifier used in cross-application integration.
• DESC_TEXT / ALT_TEXT / OBJECT_TYPE_DESC — extended and localized descriptions.
• IMAGE_FILE / FULL_IMAGE_PATH — UI imagery associated with the object type, resolved through CZ_UI_PATHED_IMAGES_V.

Common Use Cases and Queries

Typical scenarios include verifying property defaults before runtime execution, driving a Configurator property selection list, and diagnosing why a property is not offered in the picker. A representative query for a single property is:

• SELECT object_id, name, property_data_type, def_value, def_num_value, desc_text FROM cz_property_picker_v WHERE object_id = :property_id;
• SELECT name, def_value, def_num_value FROM cz_property_picker_v WHERE deleted_flag = '0' AND property_data_type <> 8 ORDER BY name;
• SELECT czp.name, czp.def_value, czp.src_application_id FROM cz_property_picker_v czp WHERE czp.orig_sys_ref IS NOT NULL;

Because the view enforces the seeded image join and the object-type lookup join, it returns only properties that satisfy both conditions; if a property is missing from the output, the cause is usually a missing CZ_UI_PATHED_IMAGES_V image entry or a mismatched CZ_RPOBJECTTYPES_LKV value. This makes the view useful both as a presentation source and as a diagnostic tool for Configurator repository integrity.