Results for “item_type_name”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
CZ_ITEM_PROPERTY_POP_V is a reporting view owned by the APPS schema within the Oracle E-Business Suite Configurator (CZ) module. The object name suffix "POP" identifies it as a populator view — a purpose-built relational source used to drive Populator-style concurrent or UI processes that enumerate model item types alongside the properties assignable to them. It exposes a denormalized, human-readable combination of item type identifiers, item type names, property identifiers, and property names drawn from the Configurator property and item type model tables.
The view is documented as VALID status in both EBS 12.1.1 and 12.2.2 lineages, and the ETRM metadata records it as a standard APPS-owned view with no editioning or multi-tenant variation. Because it is a view rather than a table, it carries no storage of its own and reflects the current committed state of the underlying Configurator definition tables at query time.
Underlying Base Objects
The view text is defined over three synonyms, each resolving to a Configurator base table in the APPS schema:
- CZ_ITEM_TYPES — the item type definition table, supplying ITEM_TYPE_ID and the descriptive NAME that the view aliases as ITEM_TYPE_NAME.
- CZ_ITEM_TYPE_PROPERTIES — the intersection table that associates properties with item types; it contributes the join keys and the soft-delete flag used for filtering.
- CZ_PROPERTIES — the property master table, supplying PROPERTY_ID, NAME, and DESC_TEXT.
All three joins are implemented as outer joins (via the legacy (+) operator), with CZ_PROPERTIES as the driving table. This means every non-deleted property is returned even when no item type assignment exists, in which case the item type columns are null. The view applies an NVL-based soft-delete filter to all three sources, excluding rows where DELETED_FLAG equals '1' but retaining rows where the flag is null.
Key Columns
- ITEM_TYPE_ID — numeric identifier of the associated Configurator item type; null when the property is unassigned.
- ITEM_ID — always TO_NUMBER(NULL); a placeholder column included for interface compatibility with companion populator views.
- PROPERTY_ID — identifier of the property from CZ_PROPERTIES.
- ITEM_TYPE_NAME — the item type's display name, the column most often searched as "item_type_name".
- ITEM_MASTER_NAME — always TO_CHAR(NULL); reserved placeholder.
- PROPERTY_NAME / NAME — the property name, exposed twice under different aliases to satisfy differing consumer expectations.
- DESC_TEXT — the descriptive text maintained against the property.
- QUOTEABLE_FLAG / PRIMARY_UOM_CODE — both always null placeholders, present so the view's column list matches a common populator interface.
Common Use Cases and Queries
The view is typically used to report which properties are available per item type, to validate Configurator setup before deployment, and to feed populator logic that requires a flat property list. A representative query filtering on the searched term follows:
SELECT ITEM_TYPE_NAME, PROPERTY_NAME, DESC_TEXT FROM CZ_ITEM_PROPERTY_POP_V WHERE ITEM_TYPE_NAME = '&item_type_name';SELECT ITEM_TYPE_ID, PROPERTY_ID, PROPERTY_NAME FROM CZ_ITEM_PROPERTY_POP_V WHERE ITEM_TYPE_ID IS NOT NULL ORDER BY ITEM_TYPE_ID, PROPERTY_NAME;SELECT PROPERTY_NAME FROM CZ_ITEM_PROPERTY_POP_V WHERE ITEM_TYPE_ID IS NULL;— identifies properties not yet assigned to any item type.
Because soft-deleted rows are filtered internally, no additional DELETED_FLAG predicate is required by callers.
-
View: CZ_ITEM_PROPERTY_POP_V 12.1.1
Populator view - from Properties
APPS.CZ_ITEM_PROPERTY_POP_V·↳ CZ_ITEM_TYPES·↳ CZ_ITEM_TYPE_PROPERTIES·↳ CZ_PROPERTIES·Explore CZ module →
-
View: CZ_ITEM_ITEMPROPVALS_V 12.1.1
Property values attached to items
APPS.CZ_ITEM_ITEMPROPVALS_V·↳ CZ_ITEM_MASTERS·↳ CZ_ITEM_PROPERTY_VALUES·↳ CZ_ITEM_TYPES·Explore CZ module →
-
View: CZ_ITEM_PROPERTY_POP_V 12.2.2
Populator view - from Properties
APPS.CZ_ITEM_PROPERTY_POP_V·↳ CZ_ITEM_TYPES·↳ CZ_ITEM_TYPE_PROPERTIES·↳ CZ_PROPERTIES·Explore CZ module →
-
View: CZ_ITEM_ITEMVAL_POP_V 12.2.2
Populator view - from Property Values
APPS.CZ_ITEM_ITEMVAL_POP_V·↳ CZ_ITEM_ITEMPROPVALS_V·↳ CZ_LOCALIZED_TEXTS·↳ FND_LANGUAGES·Explore CZ module →
-
View: CZ_ITEM_ITEM_POP_V 12.1.1
Populator view - from Items
APPS.CZ_ITEM_ITEM_POP_V·↳ CZ_ITEM_MASTERS·↳ CZ_ITEM_TYPES·Explore CZ module →
-
View: CZ_ITEM_ITEMTYPE_POP_V 12.1.1
Populator view - from Item Types
APPS.CZ_ITEM_ITEMTYPE_POP_V·↳ CZ_ITEM_TYPES·Explore CZ module →
-
View: CZ_ITEM_ITEMVAL_POP_V 12.1.1
Populator view - from Property Values
APPS.CZ_ITEM_ITEMVAL_POP_V·↳ CZ_ITEM_ITEMPROPVALS_V·↳ CZ_LOCALIZED_TEXTS·↳ FND_LANGUAGES·Explore CZ module →
-
View: CZ_ITEM_ITEMTYPE_POP_V 12.2.2
Populator view - from Item Types
APPS.CZ_ITEM_ITEMTYPE_POP_V·↳ CZ_ITEM_TYPES·Explore CZ module →
-
APPS.CST_MATERIAL_OVHD_RULES_V·↳ CST_COST_TYPES·↳ CST_MATERIAL_OVHD_RULES·↳ MFG_LOOKUPS·Explore BOM module →
-
Resolves all foreign key references for the table CST_ITEM_OVERHEAD_DEFAULTS
APPS.CST_ITEM_OVERHEAD_DEFAULTS_V·↳ BOM_RESOURCES·↳ CST_ACTIVITIES·↳ CST_ITEM_OVERHEAD_DEFAULTS·Explore BOM module →
-
Mass change components
APPS.BOM_INV_COMPS_INTERFACE_V·↳ BOM_INVENTORY_COMPS_INTERFACE·↳ BOM_ITEM_CURRENT_REV_VIEW·↳ ENG_REVISED_ITEMS_INTERFACE·Explore BOM module →
-
Mass change details
APPS.ENG_REVISED_ITEMS_INTERFACE_V·↳ ENG_REVISED_ITEMS_INTERFACE·↳ FND_COMMON_LOOKUPS·↳ FND_GLOBAL·Explore ENG module →
-
View: CZ_ITEM_ITEM_POP_V 12.2.2
Populator view - from Items
APPS.CZ_ITEM_ITEM_POP_V·↳ CZ_ITEM_MASTERS·↳ CZ_ITEM_TYPES·Explore CZ module →
-
This view shows information about the selection criteria for WMS Rules
APPS.WMS_SELECTION_CRITERIA_TXN_V·↳ WMS_RULES_B·↳ WMS_RULES_WORKBENCH_PVT·↳ WMS_SELECTION_CRITERIA_TXN·Explore WMS module →
-
View: CZ_ITEM_ITEMPROPVALS_V 12.2.2
Property values attached to items
APPS.CZ_ITEM_ITEMPROPVALS_V·↳ CZ_ITEM_MASTERS·↳ CZ_ITEM_PROPERTY_VALUES·↳ CZ_ITEM_TYPES·Explore CZ module →
-
APPS.WMS_SELECTION_CRITERIA_TXN_V·↳ WMS_RULES_B·↳ WMS_RULES_WORKBENCH_PVT·↳ WMS_SELECTION_CRITERIA_TXN·Explore WMS module →
-
Mass change components
APPS.BOM_INV_COMPS_INTERFACE_V·↳ BOM_INVENTORY_COMPS_INTERFACE·↳ BOM_ITEM_CURRENT_REV_VIEW·↳ ENG_REVISED_ITEMS_INTERFACE·Explore BOM module →
-
Resolves all foreign key references for the table CST_ITEM_OVERHEAD_DEFAULTS
APPS.CST_ITEM_OVERHEAD_DEFAULTS_V·↳ BOM_RESOURCES·↳ CST_ACTIVITIES·↳ CST_ITEM_OVERHEAD_DEFAULTS·Explore BOM module →
-
APPS.CST_MATERIAL_OVHD_RULES_V·↳ CST_COST_TYPES·↳ CST_MATERIAL_OVHD_RULES·↳ MFG_LOOKUPS·Explore BOM module →
-
APPS.INVFV_ORGANIZATION_ITEMS·↳ CS_COVERAGES_ACTIVE_V·↳ FA_CATEGORIES·↳ FND_COMMON_LOOKUPS·Explore INV module →
-
Mass change details
APPS.ENG_REVISED_ITEMS_INTERFACE_V·↳ ENG_REVISED_ITEMS_INTERFACE·↳ FND_COMMON_LOOKUPS·↳ FND_GLOBAL·Explore ENG module →
-
Mass change components
APPS.BOM_INV_COMPS_INTERFACE_ERV·↳ BOM_INVENTORY_COMPS_INTERFACE·↳ BOM_ITEM_CURRENT_REV_VIEW·↳ ENG_REVISED_ITEMS_INTERFACE·Explore BOM module →
-
Mass change components
APPS.BOM_INV_COMPS_INTERFACE_ERV·↳ BOM_INVENTORY_COMPS_INTERFACE·↳ BOM_ITEM_CURRENT_REV_VIEW·↳ ENG_REVISED_ITEMS_INTERFACE·Explore BOM module →
-
APPS.INVFV_ORGANIZATION_ITEMS·↳ CS_COVERAGES_ACTIVE_V·↳ FA_CATEGORIES·↳ FND_COMMON_LOOKUPS·Explore INV module →
-
View: INVFV_ITEMS 12.1.1
APPS.INVFV_ITEMS·↳ CS_COVERAGES_ACTIVE_V·↳ FA_CATEGORIES·↳ FND_COMMON_LOOKUPS·Explore INV module →
-
View: INVFV_ITEMS 12.2.2
APPS.INVFV_ITEMS·↳ CS_COVERAGES_ACTIVE_V·↳ FA_CATEGORIES·↳ FND_COMMON_LOOKUPS·Explore INV module →
-
View: XNC_ITEM_TYPE_V 12.1.1
XNC_ITEM_TYPE_V retrieves the Communications item type and other item details for an Inventory Item and Organization.
Not implemented in this database·Explore XNC module →
-
View: XNC_ITEM_TYPE_V 12.2.2
XNC_ITEM_TYPE_V retrieves the Communications item type and other item details for an Inventory Item and Organization.
Not implemented in this database·Explore XNC module →