eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CZ_ITEM_ITEMPROPVALS_V

Source

View Text - Preformatted


SELECT cz_item_masters.item_type_id, cz_item_types.desc_text AS ITEM_TYPE_DESC_TEXT, cz_item_types.name AS ITEM_TYPE_NAME, cz_properties.property_id, cz_properties.property_unit, cz_properties.desc_text AS PROPERTY_DESC_TEXT, cz_properties.name AS PROPERTY_NAME, cz_properties.data_type AS DATA_TYPE, cz_item_property_values.property_value AS PROPERTY_VALUE, cz_item_property_values.property_num_value AS PROPERTY_NUM_VALUE, cz_item_masters.item_id AS ITEM_ID FROM cz_item_types, cz_item_masters, cz_item_property_values, cz_properties WHERE cz_item_types.item_type_id =cz_item_masters.item_type_id AND cz_item_masters.deleted_flag = '0' and cz_item_types.deleted_flag = '0' and cz_item_property_values.item_id = cz_item_masters.item_id and cz_item_property_values.deleted_flag = '0' and cz_properties.property_id =cz_item_property_values.property_id and cz_properties.deleted_flag = '0' and (cz_item_property_values.property_value IS NOT NULL OR cz_item_property_values.property_num_value IS NOT NULL)

View Text - HTML Formatted

SELECT CZ_ITEM_MASTERS.ITEM_TYPE_ID
, CZ_ITEM_TYPES.DESC_TEXT AS ITEM_TYPE_DESC_TEXT
, CZ_ITEM_TYPES.NAME AS ITEM_TYPE_NAME
, CZ_PROPERTIES.PROPERTY_ID
, CZ_PROPERTIES.PROPERTY_UNIT
, CZ_PROPERTIES.DESC_TEXT AS PROPERTY_DESC_TEXT
, CZ_PROPERTIES.NAME AS PROPERTY_NAME
, CZ_PROPERTIES.DATA_TYPE AS DATA_TYPE
, CZ_ITEM_PROPERTY_VALUES.PROPERTY_VALUE AS PROPERTY_VALUE
, CZ_ITEM_PROPERTY_VALUES.PROPERTY_NUM_VALUE AS PROPERTY_NUM_VALUE
, CZ_ITEM_MASTERS.ITEM_ID AS ITEM_ID
FROM CZ_ITEM_TYPES
, CZ_ITEM_MASTERS
, CZ_ITEM_PROPERTY_VALUES
, CZ_PROPERTIES
WHERE CZ_ITEM_TYPES.ITEM_TYPE_ID =CZ_ITEM_MASTERS.ITEM_TYPE_ID
AND CZ_ITEM_MASTERS.DELETED_FLAG = '0'
AND CZ_ITEM_TYPES.DELETED_FLAG = '0'
AND CZ_ITEM_PROPERTY_VALUES.ITEM_ID = CZ_ITEM_MASTERS.ITEM_ID
AND CZ_ITEM_PROPERTY_VALUES.DELETED_FLAG = '0'
AND CZ_PROPERTIES.PROPERTY_ID =CZ_ITEM_PROPERTY_VALUES.PROPERTY_ID
AND CZ_PROPERTIES.DELETED_FLAG = '0'
AND (CZ_ITEM_PROPERTY_VALUES.PROPERTY_VALUE IS NOT NULL OR CZ_ITEM_PROPERTY_VALUES.PROPERTY_NUM_VALUE IS NOT NULL)