View: CZ_ITEM_ITEMPROPVALS_V

Product:	CZ - Configurator
Description:	Property values attached to items
Implementation/DBA Data:	APPS.CZ_ITEM_ITEMPROPVALS_V

View Text

SELECT CZ_ITEM_MASTERS.ITEM_TYPE_ID
, CZ_ITEM_TYPES.DESC_TEXT AS ITEM_TYPE_DESC_TEXT
, CZ_ITEM_TYPES.NAME AS ITEM_TYPE_NAME
, CZ_PROPERTIES.PROPERTY_ID
, CZ_PROPERTIES.PROPERTY_UNIT
, CZ_PROPERTIES.DESC_TEXT AS PROPERTY_DESC_TEXT
, CZ_PROPERTIES.NAME AS PROPERTY_NAME
, CZ_PROPERTIES.DATA_TYPE AS DATA_TYPE
, CZ_ITEM_PROPERTY_VALUES.PROPERTY_VALUE AS PROPERTY_VALUE
, CZ_ITEM_PROPERTY_VALUES.PROPERTY_NUM_VALUE AS PROPERTY_NUM_VALUE
, CZ_ITEM_MASTERS.ITEM_ID AS ITEM_ID
FROM CZ_ITEM_TYPES
, CZ_ITEM_MASTERS
, CZ_ITEM_PROPERTY_VALUES
, CZ_PROPERTIES
WHERE CZ_ITEM_TYPES.ITEM_TYPE_ID =CZ_ITEM_MASTERS.ITEM_TYPE_ID
AND CZ_ITEM_MASTERS.DELETED_FLAG = '0'
AND CZ_ITEM_TYPES.DELETED_FLAG = '0'
AND CZ_ITEM_PROPERTY_VALUES.ITEM_ID = CZ_ITEM_MASTERS.ITEM_ID
AND CZ_ITEM_PROPERTY_VALUES.DELETED_FLAG = '0'
AND CZ_PROPERTIES.PROPERTY_ID =CZ_ITEM_PROPERTY_VALUES.PROPERTY_ID
AND CZ_PROPERTIES.DELETED_FLAG = '0'
AND (CZ_ITEM_PROPERTY_VALUES.PROPERTY_VALUE IS NOT NULL OR CZ_ITEM_PROPERTY_VALUES.PROPERTY_NUM_VALUE IS NOT NULL)

Columns