View: CZ_UI_CONT_TYPE_TEMPLS_VV

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

View Text

SELECT UTT.UI_DEF_ID
, UTT.MASTER_TEMPLATE_FLAG
, DECODE (UTT.MASTER_TEMPLATE_FLAG
, '0'
, 'USER INTERFACE'
, '1'
, 'UI MASTER TEMPLATE'
, 'B'
, 'FRAGMENT - BOM SETTINGS'
, 'P'
, 'FRAGMENT - PAGINATION'
, 'N'
, 'FRAGMENT - NON-BOM SETTINGS'
, NULL
, 'NULL VALUE ERROR'
, 'UNRECOGNIZED MASTER FLAG "' || UTT.MASTER_TEMPLATE_FLAG || '"') AS TEMPLATE_FLAG_INFO
, UDF.NAME AS UI_DEF_NAME
, UTT.CONTENT_TYPE
, SIG.NAME AS CONTENT_TYPE_NAME
, SIG.DESCRIPTION AS CONTENT_TYPE_DESCR
, UTT.SEEDED_FLAG
, UTT.DELETED_FLAG
, UTT.TEMPLATE_ID
, UTT.TEMPLATE_UI_DEF_ID
, TPLV.TEMPLATE_NAME
, TPLV.TEMPLATE_DESC
, TPLV.TITLE_STRING
, TPLV.MAIN_MESSAGE_TEXT
, TPLV.LAYOUT_UI_STYLE_INFO
, TPLV.JRAD_DOC
FROM CZ_UI_CONT_TYPE_TEMPLS UTT
, CZ_UI_DEFS UDF
, CZ_SIGNATURES SIG
, CZ_UI_TEMPLATES_VV TPLV
WHERE UTT.TEMPLATE_ID = TPLV.TEMPLATE_ID(+)
AND UTT.TEMPLATE_UI_DEF_ID = TPLV.UI_DEF_ID(+)
AND '0' = TPLV.DELETED_FLAG (+)
AND UTT.CONTENT_TYPE = SIG.SIGNATURE_ID (+)
AND '0' = SIG.DELETED_FLAG (+)
AND UTT.UI_DEF_ID = UDF.UI_DEF_ID(+)
AND '0' = UDF.DELETED_FLAG (+)

Columns