VIEW: APPS.CZ_ITEM_PROPERTY_POP_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'