View: CZ_ITEM_PROPERTY_POP_V

Product:	CZ - Configurator
Description:	Populator view - from Properties
Implementation/DBA Data:	APPS.CZ_ITEM_PROPERTY_POP_V

View Text

SELECT CZ_ITEM_TYPES.ITEM_TYPE_ID AS ITEM_TYPE_ID
, TO_NUMBER(NULL) AS ITEM_ID
, CZ_PROPERTIES.PROPERTY_ID AS PROPERTY_ID
, CZ_ITEM_TYPES.NAME AS ITEM_TYPE_NAME
, TO_CHAR(NULL) AS ITEM_MASTER_NAME
, CZ_PROPERTIES.NAME AS PROPERTY_NAME
, CZ_PROPERTIES.NAME AS NAME
, CZ_PROPERTIES.DESC_TEXT AS DESC_TEXT
, TO_CHAR(NULL) AS QUOTEABLE_FLAG
, TO_CHAR(NULL) AS PRIMARY_UOM_CODE
FROM CZ_PROPERTIES
, CZ_ITEM_TYPE_PROPERTIES
, CZ_ITEM_TYPES
WHERE (CZ_PROPERTIES.PROPERTY_ID =CZ_ITEM_TYPE_PROPERTIES.PROPERTY_ID(+))
AND (CZ_ITEM_TYPE_PROPERTIES.ITEM_TYPE_ID =CZ_ITEM_TYPES.ITEM_TYPE_ID(+))
AND NVL (CZ_PROPERTIES.DELETED_FLAG
, '0') <> '1'
AND NVL (CZ_ITEM_TYPE_PROPERTIES.DELETED_FLAG
, '0') <> '1'
AND NVL (CZ_ITEM_TYPES.DELETED_FLAG
, '0') <> '1'

Columns