VIEW: APPS.CZ_PSNODETYPE_IMAGES_V

Source

View Text - Preformatted

SELECT img.IMAGE_USAGE_CODE, decode (img.image_usage_code, 10, '0', 11, '1') as referenced_usage_flag, img.ENTITY_CODE as psnodetype_id, isig.name as psnodetype_name, img.IMAGE_FILE, isig.description as alt_text, cnv.object_type as sub_nodetype_id, img.ui_def_id, img.FULL_IMAGE_PATH, attsig.description as attach_nodetype_alt_text from cz_ui_pathed_images_v img, cz_type_relationships cnv, cz_signatures isig, cz_signatures attsig WHERE attsig.signature_id = img.entity_code and attsig.deleted_flag = '0' and isig.signature_id = cnv.object_type and img.ui_def_id = 0 and img.deleted_flag = '0' and img.image_usage_code in (10, 11) and img.entity_code = cnv.subject_type and cnv.deleted_flag = '0' and cnv.rel_type_code = 'CNV'

View Text - HTML Formatted

SELECT IMG.IMAGE_USAGE_CODE
, DECODE (IMG.IMAGE_USAGE_CODE
, 10
, '0'
, 11
, '1') AS REFERENCED_USAGE_FLAG
, IMG.ENTITY_CODE AS PSNODETYPE_ID
, ISIG.NAME AS PSNODETYPE_NAME
, IMG.IMAGE_FILE
, ISIG.DESCRIPTION AS ALT_TEXT
, CNV.OBJECT_TYPE AS SUB_NODETYPE_ID
, IMG.UI_DEF_ID
, IMG.FULL_IMAGE_PATH
, ATTSIG.DESCRIPTION AS ATTACH_NODETYPE_ALT_TEXT
FROM CZ_UI_PATHED_IMAGES_V IMG
, CZ_TYPE_RELATIONSHIPS CNV
, CZ_SIGNATURES ISIG
, CZ_SIGNATURES ATTSIG
WHERE ATTSIG.SIGNATURE_ID = IMG.ENTITY_CODE
AND ATTSIG.DELETED_FLAG = '0'
AND ISIG.SIGNATURE_ID = CNV.OBJECT_TYPE
AND IMG.UI_DEF_ID = 0
AND IMG.DELETED_FLAG = '0'
AND IMG.IMAGE_USAGE_CODE IN (10
, 11)
AND IMG.ENTITY_CODE = CNV.SUBJECT_TYPE
AND CNV.DELETED_FLAG = '0'
AND CNV.REL_TYPE_CODE = 'CNV'