View: CZ_GLOBAL_CAPTION_PROPERTIES_V

Product:	CZ - Configurator
Description:
Implementation/DBA Data:	APPS.CZ_GLOBAL_CAPTION_PROPERTIES_V

View Text

SELECT DISTINCT MAINPROP.PROPERTY_ID
, MAINPROP.PROPERTY_NAME
, CONCAT(MAINPROP.PROPERTY_TOKEN
, (SELECT ' [' || SIG.NAME || ']'
FROM CZ_DATA_TYPES_V SIG
WHERE EXISTS ( SELECT 1
FROM CZ_GLOBAL_PROPERTIES_V DUPPROP
WHERE SIG.SIGNATURE_ID = MAINPROP.DATA_TYPE
AND DUPPROP.PROPERTY_NAME = MAINPROP.PROPERTY_NAME
AND DUPPROP.PROPERTY_ID != MAINPROP.PROPERTY_ID
AND DUPPROP.SYSTEM_PROPERTY_TYPE = 'CAP' ) ) ) AS NAME
, MAINPROP.DATA_TYPE
, MAINPROP.ATTACHED_TO_NODE_TYPE
, MAINPROP.MUTABLE_FLAG
, MAINPROP.COLLECTION_FLAG
, MAINPROP.SEQ_NBR
FROM CZ_GLOBAL_PROPERTIES_V MAINPROP
WHERE MAINPROP.SYSTEM_PROPERTY_TYPE = 'CAP'

Columns