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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.CZ_UI_CONT_TYPE_TEMPLS_VV

Object Details

Object Name:	CZ_UI_CONT_TYPE_TEMPLS_VV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CZ.CZ_UI_CONT_TYPE_TEMPLS_VV
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
UI_DEF_ID	NUMBER		Yes
MASTER_TEMPLATE_FLAG	VARCHAR2	(1)	Yes
TEMPLATE_FLAG_INFO	VARCHAR2	(28)
UI_DEF_NAME	VARCHAR2	(255)
CONTENT_TYPE	NUMBER		Yes
CONTENT_TYPE_NAME	VARCHAR2	(30)
CONTENT_TYPE_DESCR	VARCHAR2	(2000)
SEEDED_FLAG	VARCHAR2	(1)	Yes
DELETED_FLAG	VARCHAR2	(1)	Yes
TEMPLATE_ID	NUMBER		Yes
TEMPLATE_UI_DEF_ID	NUMBER		Yes
TEMPLATE_NAME	VARCHAR2	(255)
TEMPLATE_DESC	VARCHAR2	(2000)
TITLE_STRING	VARCHAR2	(2000)
MAIN_MESSAGE_TEXT	VARCHAR2	(2000)
LAYOUT_UI_STYLE_INFO	VARCHAR2	(15)
JRAD_DOC	VARCHAR2	(255)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT UI_DEF_ID
,      MASTER_TEMPLATE_FLAG
,      TEMPLATE_FLAG_INFO
,      UI_DEF_NAME
,      CONTENT_TYPE
,      CONTENT_TYPE_NAME
,      CONTENT_TYPE_DESCR
,      SEEDED_FLAG
,      DELETED_FLAG
,      TEMPLATE_ID
,      TEMPLATE_UI_DEF_ID
,      TEMPLATE_NAME
,      TEMPLATE_DESC
,      TITLE_STRING
,      MAIN_MESSAGE_TEXT
,      LAYOUT_UI_STYLE_INFO
,      JRAD_DOC
FROM APPS.CZ_UI_CONT_TYPE_TEMPLS_VV;

Dependencies

[top of page]

APPS.CZ_UI_CONT_TYPE_TEMPLS_VV references the following:

APPS: CZ_SIGNATURES; CZ_UI_CONT_TYPE_TEMPLS; CZ_UI_DEFS; CZ_UI_TEMPLATES_VV

APPS.CZ_UI_CONT_TYPE_TEMPLS_VV is not referenced by any database object