View: CZ_ITEM_ITEMVAL_POP_V

Product:	CZ - Configurator
Description:	Populator view - from Property Values
Implementation/DBA Data:	APPS.CZ_ITEM_ITEMVAL_POP_V

View Text

SELECT CZ_ITEM_ITEMPROPVALS_V.ITEM_TYPE_ID AS ITEM_TYPE_ID
, CZ_ITEM_ITEMPROPVALS_V.ITEM_ID AS ITEM_ID
, CZ_ITEM_ITEMPROPVALS_V.PROPERTY_ID AS PROPERTY_ID
, CZ_ITEM_ITEMPROPVALS_V.ITEM_TYPE_NAME AS ITEM_TYPE_NAME
, TO_CHAR(NULL) AS ITEM_MASTER_NAME
, CZ_ITEM_ITEMPROPVALS_V.PROPERTY_NAME AS PROPERTY_NAME
, DECODE(CZ_ITEM_ITEMPROPVALS_V.DATA_TYPE
, 1
, TO_CHAR (CZ_ITEM_ITEMPROPVALS_V.PROPERTY_NUM_VALUE)
, 2
, TO_CHAR(CZ_ITEM_ITEMPROPVALS_V.PROPERTY_NUM_VALUE)
, 3
, TO_CHAR(CZ_ITEM_ITEMPROPVALS_V.PROPERTY_NUM_VALUE)
, 4
, CZ_ITEM_ITEMPROPVALS_V.PROPERTY_VALUE
, 8
, (SELECT LOCALIZED_STR
FROM CZ_LOCALIZED_TEXTS
WHERE INTL_TEXT_ID=CZ_ITEM_ITEMPROPVALS_V.PROPERTY_NUM_VALUE
AND LANGUAGE=(SELECT UPPER(LANGUAGE_CODE)
FROM FND_LANGUAGES
WHERE INSTALLED_FLAG IN ('B')))
, CZ_ITEM_ITEMPROPVALS_V.PROPERTY_VALUE) AS NAME
, CZ_ITEM_ITEMPROPVALS_V.PROPERTY_DESC_TEXT AS DESC_TEXT
, TO_CHAR(NULL) AS QUOTEABLE_FLAG
, TO_CHAR(NULL) AS PRIMARY_UOM_CODE
FROM CZ_ITEM_ITEMPROPVALS_V

Columns