View: CZ_ITEM_ITEMTYPE_POP_V

Product:	CZ - Configurator
Description:	Populator view - from Item Types
Implementation/DBA Data:	APPS.CZ_ITEM_ITEMTYPE_POP_V

View Text

SELECT CZ_ITEM_TYPES.ITEM_TYPE_ID AS ITEM_TYPE_ID
, TO_NUMBER(NULL) AS ITEM_ID
, TO_NUMBER(NULL) AS PROPERTY_ID
, CZ_ITEM_TYPES.NAME AS ITEM_TYPE_NAME
, TO_CHAR(NULL) AS ITEM_MASTER_NAME
, TO_CHAR(NULL) AS PROPERTY_NAME
, CZ_ITEM_TYPES.NAME AS NAME
, CZ_ITEM_TYPES.DESC_TEXT AS DESC_TEXT
, TO_CHAR(NULL) AS QUOTEABLE_FLAG
, TO_CHAR(NULL) AS PRIMARY_UOM_CODE
FROM CZ_ITEM_TYPES
WHERE CZ_ITEM_TYPES.DELETED_FLAG='0'

Columns