VIEW: APPS.CZ_RULETYPE_IMAGES_V

Source

View Text - Preformatted

SELECT rtimg.IMAGE_USAGE_CODE, rtimg.ENTITY_CODE, DECODE (rtimg.IMAGE_USAGE_CODE, 20, '0', 21, '1' ) as referenced_usage_flag, rtimg.IMAGE_FILE, rtylv.data_value, rtylv.value_label, rtylv.value_description as alt_text, rtimg.FULL_IMAGE_PATH FROM cz_ui_pathed_images_v rtimg, cz_detailedruletypes_lkv rtylv WHERE rtimg.ui_def_id = 0 and rtimg.image_usage_code in (20, 21) and rtimg.deleted_flag = '0' and rtylv.numeric_id_value(+) = rtimg.entity_code

View Text - HTML Formatted

SELECT RTIMG.IMAGE_USAGE_CODE
, RTIMG.ENTITY_CODE
, DECODE (RTIMG.IMAGE_USAGE_CODE
, 20
, '0'
, 21
, '1' ) AS REFERENCED_USAGE_FLAG
, RTIMG.IMAGE_FILE
, RTYLV.DATA_VALUE
, RTYLV.VALUE_LABEL
, RTYLV.VALUE_DESCRIPTION AS ALT_TEXT
, RTIMG.FULL_IMAGE_PATH
FROM CZ_UI_PATHED_IMAGES_V RTIMG
, CZ_DETAILEDRULETYPES_LKV RTYLV
WHERE RTIMG.UI_DEF_ID = 0
AND RTIMG.IMAGE_USAGE_CODE IN (20
, 21)
AND RTIMG.DELETED_FLAG = '0'
AND RTYLV.NUMERIC_ID_VALUE(+) = RTIMG.ENTITY_CODE