View: CZ_UI_TEMPLATES_VV

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

View Text

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

Columns