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: CZ.CZ_UI_TEMPLATES#

Object Details

Object Name:	CZ_UI_TEMPLATES#
Object Type:	VIEW
Owner:	CZ
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
TEMPLATE_ID	NUMBER		Yes
UI_DEF_ID	NUMBER		Yes
TEMPLATE_NAME	VARCHAR2	(255)	Yes
TEMPLATE_TYPE	NUMBER		Yes
TEMPLATE_DESC	VARCHAR2	(2000)
PARENT_CONTAINER_TYPE	NUMBER
JRAD_DOC	VARCHAR2	(255)
BUTTON_BAR_TEMPLATE_ID	NUMBER
MESSAGE_TYPE	NUMBER
MAIN_MESSAGE_ID	NUMBER
TITLE_ID	NUMBER
DELETED_FLAG	VARCHAR2	(1)	Yes
CREATED_BY	NUMBER		Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER
SEEDED_FLAG	VARCHAR2	(1)	Yes
LAYOUT_UI_STYLE	VARCHAR2	(1)
ROOT_REGION_TYPE	VARCHAR2	(255)	Yes
BUTTON_BAR_TEMPL_UIDEF_ID	NUMBER
ROOT_ELEMENT_SIGNATURE_ID	NUMBER		Yes
TEMPLATE_REV_NBR	NUMBER		Yes
TEMPLATE_USAGE	NUMBER		Yes
CHECKOUT_USER	VARCHAR2	(100)
CHECKOUT_TIME	DATE
AMN_USAGE	VARCHAR2	(1)
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT TEMPLATE_ID
,      UI_DEF_ID
,      TEMPLATE_NAME
,      TEMPLATE_TYPE
,      TEMPLATE_DESC
,      PARENT_CONTAINER_TYPE
,      JRAD_DOC
,      BUTTON_BAR_TEMPLATE_ID
,      MESSAGE_TYPE
,      MAIN_MESSAGE_ID
,      TITLE_ID
,      DELETED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SEEDED_FLAG
,      LAYOUT_UI_STYLE
,      ROOT_REGION_TYPE
,      BUTTON_BAR_TEMPL_UIDEF_ID
,      ROOT_ELEMENT_SIGNATURE_ID
,      TEMPLATE_REV_NBR
,      TEMPLATE_USAGE
,      CHECKOUT_USER
,      CHECKOUT_TIME
,      AMN_USAGE
,      ZD_EDITION_NAME
FROM CZ.CZ_UI_TEMPLATES#;

Dependencies

[top of page]

CZ.CZ_UI_TEMPLATES# references the following:

CZ: CZ_UI_TEMPLATES

CZ.CZ_UI_TEMPLATES# is referenced by following:

APPS: CZ_UI_TEMPLATES; CZ_UI_TEMPLATES+; CZ_UI_TEMPLATES_T1; CZ_UI_TEMPLATES_T2