View: CZ_PSNODETYPE_IMAGES_V

Product:	CZ - Configurator
Description:	CZ_PSNODETYPE_IMAGES_V is used to associate every specific type of psnode with the icon used to depict it.
Implementation/DBA Data:	APPS.CZ_PSNODETYPE_IMAGES_V

View Text

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'

Columns