VIEW: APPS.CZ_UIELEMENT_IMAGES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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