VIEW: APPS.CZ_ITEM_ITEMVAL_POP_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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