VIEW: APPS.CZ_ITEM_ITEMTYPE_POP_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'