VIEW: APPS.CZ_UI_TEMPLATES_VV

Source

View Text - Preformatted

SELECT UCT.TEMPLATE_ID, UCT.TEMPLATE_NAME, UCT.UI_DEF_ID, UDF.MASTER_TEMPLATE_FLAG, UDF.NAME AS UI_DEF_NAME, UCT.TEMPLATE_TYPE, TSIG.NAME AS TEMPLATE_TYPE_NAME, UCT.TEMPLATE_DESC, UCT.PARENT_CONTAINER_TYPE, decode (UCT.PARENT_CONTAINER_TYPE, null, 'No container type', 10, 'General Layout', 11, 'OA Message Box', 12, 'OA Dialog Page', 'Cannot recognize container type (' || to_char (UCT.PARENT_CONTAINER_TYPE) || ')') as parent_container_type_name, UCT.TITLE_ID, TILTX.TEXT_STR AS TITLE_STRING, UCT.BUTTON_BAR_TEMPLATE_ID, bbtpl.template_name as button_bar_template_name, UCT.MESSAGE_TYPE, decode (UCT.MESSAGE_TYPE, null, 'No Message Type', 20, 'Processing', 21, 'Confirmation', 22, 'Information', 23, 'Warning', 24, 'Error', 'Unknown message type (' || to_char (uct.message_type) || ')') as message_type_name, UCT.LAYOUT_UI_STYLE, DECODE (UCT.LAYOUT_UI_STYLE, null, '', 1, 'Label-Data pair', 2, 'Table-row Style', 3, 'Table Style', 'Other (' || to_char (UCT.LAYOUT_UI_STYLE) || ')') as layout_ui_style_info, UCT.DELETED_FLAG, UCT.SEEDED_FLAG, UCT.JRAD_DOC, UCT.MAIN_MESSAGE_ID, MMLTX.TEXT_STR AS MAIN_MESSAGE_TEXT FROM CZ_UI_TEMPLATES UCT, CZ_UI_DEFS UDF, CZ_SIGNATURES TSIG, CZ_LOCALIZED_TEXTS_VL TILTX, cz_ui_templates bbtpl, CZ_LOCALIZED_TEXTS_VL MMLTX WHERE 0 = bbtpl.UI_DEF_ID(+) and uct.button_bar_template_id = bbtpl.template_id (+) and '0' = bbtpl.deleted_flag and UCT.UI_DEF_ID = UDF.UI_DEF_ID (+) AND '0' = UDF.DELETED_FLAG(+) AND UCT.TEMPLATE_TYPE = TSIG.SIGNATURE_ID (+) AND '0' = TSIG.DELETED_FLAG (+) AND UCT.TITLE_ID = TILTX.INTL_TEXT_ID (+) AND '0' = TILTX.DELETED_FLAG (+)AND UCT.MAIN_MESSAGE_ID = MMLTX.INTL_TEXT_ID (+) AND '0' = MMLTX.DELETED_FLAG (+) order by template_id, ui_def_id

View Text - HTML Formatted

SELECT UCT.TEMPLATE_ID
, UCT.TEMPLATE_NAME
, UCT.UI_DEF_ID
, UDF.MASTER_TEMPLATE_FLAG
, UDF.NAME AS UI_DEF_NAME
, UCT.TEMPLATE_TYPE
, TSIG.NAME AS TEMPLATE_TYPE_NAME
, UCT.TEMPLATE_DESC
, UCT.PARENT_CONTAINER_TYPE
, DECODE (UCT.PARENT_CONTAINER_TYPE
, NULL
, 'NO CONTAINER TYPE'
, 10
, 'GENERAL LAYOUT'
, 11
, 'OA MESSAGE BOX'
, 12
, 'OA DIALOG PAGE'
, 'CANNOT RECOGNIZE CONTAINER TYPE (' || TO_CHAR (UCT.PARENT_CONTAINER_TYPE) || ')') AS PARENT_CONTAINER_TYPE_NAME
, UCT.TITLE_ID
, TILTX.TEXT_STR AS TITLE_STRING
, UCT.BUTTON_BAR_TEMPLATE_ID
, BBTPL.TEMPLATE_NAME AS BUTTON_BAR_TEMPLATE_NAME
, UCT.MESSAGE_TYPE
, DECODE (UCT.MESSAGE_TYPE
, NULL
, 'NO MESSAGE TYPE'
, 20
, 'PROCESSING'
, 21
, 'CONFIRMATION'
, 22
, 'INFORMATION'
, 23
, 'WARNING'
, 24
, 'ERROR'
, 'UNKNOWN MESSAGE TYPE (' || TO_CHAR (UCT.MESSAGE_TYPE) || ')') AS MESSAGE_TYPE_NAME
, UCT.LAYOUT_UI_STYLE
, DECODE (UCT.LAYOUT_UI_STYLE
, NULL
, ''
, 1
, 'LABEL-DATA PAIR'
, 2
, 'TABLE-ROW STYLE'
, 3
, 'TABLE STYLE'
, 'OTHER (' || TO_CHAR (UCT.LAYOUT_UI_STYLE) || ')') AS LAYOUT_UI_STYLE_INFO
, UCT.DELETED_FLAG
, UCT.SEEDED_FLAG
, UCT.JRAD_DOC
, UCT.MAIN_MESSAGE_ID
, MMLTX.TEXT_STR AS MAIN_MESSAGE_TEXT
FROM CZ_UI_TEMPLATES UCT
, CZ_UI_DEFS UDF
, CZ_SIGNATURES TSIG
, CZ_LOCALIZED_TEXTS_VL TILTX
, CZ_UI_TEMPLATES BBTPL
, CZ_LOCALIZED_TEXTS_VL MMLTX
WHERE 0 = BBTPL.UI_DEF_ID(+)
AND UCT.BUTTON_BAR_TEMPLATE_ID = BBTPL.TEMPLATE_ID (+)
AND '0' = BBTPL.DELETED_FLAG
AND UCT.UI_DEF_ID = UDF.UI_DEF_ID (+)
AND '0' = UDF.DELETED_FLAG(+)
AND UCT.TEMPLATE_TYPE = TSIG.SIGNATURE_ID (+)
AND '0' = TSIG.DELETED_FLAG (+)
AND UCT.TITLE_ID = TILTX.INTL_TEXT_ID (+)
AND '0' = TILTX.DELETED_FLAG (+)AND UCT.MAIN_MESSAGE_ID = MMLTX.INTL_TEXT_ID (+)
AND '0' = MMLTX.DELETED_FLAG (+) ORDER BY TEMPLATE_ID
, UI_DEF_ID