VIEW: APPS.CCT_MEDIA_CLASS_VALUES_V

Source

View Text - Preformatted

SELECT mmap.media_type_uuid, cval.classification_value from cct_classification_mt_map mmap, cct_classifications class, cct_classification_values cval WHERE mmap.classification_id = class.classification_id and class.classification_Value_id = cval.classification_value_id

View Text - HTML Formatted

SELECT MMAP.MEDIA_TYPE_UUID
, CVAL.CLASSIFICATION_VALUE
FROM CCT_CLASSIFICATION_MT_MAP MMAP
, CCT_CLASSIFICATIONS CLASS
, CCT_CLASSIFICATION_VALUES CVAL
WHERE MMAP.CLASSIFICATION_ID = CLASS.CLASSIFICATION_ID
AND CLASS.CLASSIFICATION_VALUE_ID = CVAL.CLASSIFICATION_VALUE_ID