[Home] [Help]
View: CZ_RULETYPE_IMAGES_V
View Text
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
Columns
| Name |
| IMAGE_USAGE_CODE |
| ENTITY_CODE |
| REFERENCED_USAGE_FLAG |
| IMAGE_FILE |
| DATA_VALUE |
| VALUE_LABEL |
| ALT_TEXT |
| FULL_IMAGE_PATH |
APPS.CZ_RULETYPE_IMAGES_V