eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CZ_GLOBAL_CAPTION_PROPERTIES_V

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'