VIEW: APPS.CZ_ITEM_MASTER_TYPE_PROPS_V

Source

View Text - Preformatted

SELECT item_id,cz_item_masters.item_type_id, property_id, decode(cz_item_masters.deleted_flag|| cz_item_type_properties.deleted_flag, '00', '0', '1') as deleted_flag from cz_item_masters,cz_item_type_properties WHERE cz_item_masters.item_type_id =cz_item_type_properties.item_type_id

View Text - HTML Formatted

SELECT ITEM_ID
, CZ_ITEM_MASTERS.ITEM_TYPE_ID
, PROPERTY_ID
, DECODE(CZ_ITEM_MASTERS.DELETED_FLAG|| CZ_ITEM_TYPE_PROPERTIES.DELETED_FLAG
, '00'
, '0'
, '1') AS DELETED_FLAG
FROM CZ_ITEM_MASTERS
, CZ_ITEM_TYPE_PROPERTIES
WHERE CZ_ITEM_MASTERS.ITEM_TYPE_ID =CZ_ITEM_TYPE_PROPERTIES.ITEM_TYPE_ID