VIEW: APPS.CZ_UI_CONT_TYPE_TEMPLS_VV

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)