[Home] [Help]
View: CZ_UIELEMENT_IMAGES_V
View Text
SELECT IMG.IMAGE_USAGE_CODE
, IMG.ENTITY_CODE AS ELEMENT_SIGNATURE_ID
, IMG.IMAGE_FILE
, USIG.NAME AS ELEMENT_TYPE_NAME
, USIG.DESCRIPTION AS ALT_TEXT
, IMG.UI_DEF_ID
, IMG.FULL_IMAGE_PATH
FROM CZ_UI_PATHED_IMAGES_V IMG
, CZ_SIGNATURES USIG
WHERE USIG.SIGNATURE_ID = IMG.ENTITY_CODE
AND IMG.UI_DEF_ID = 0
AND IMG.DELETED_FLAG = '0'
AND IMG.IMAGE_USAGE_CODE = 40
Columns
Name |
IMAGE_USAGE_CODE |
ELEMENT_SIGNATURE_ID |
IMAGE_FILE |
ELEMENT_TYPE_NAME |
ALT_TEXT |
UI_DEF_ID |
FULL_IMAGE_PATH |