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]

TABLE: CZ.CZ_UI_TEMPLATES

Object Details

Object Name:	CZ_UI_TEMPLATES
Object Type:	TABLE
Owner:	CZ
FND Design Data:	CZ.CZ_UI_TEMPLATES
Subobject Name:
Status:	VALID

CZ_UI_TEMPLATES is used to describe a UI content template. Each has a specific type of data that it is able to render in a runtime JRAD-based UI.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: CZ_UI_TEMPLATES_PK

TEMPLATE_ID
UI_DEF_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_UI_TEMPLATES_PK	NORMAL	UNIQUE	APPS_TS_SEED	TEMPLATE_ID UI_DEF_ID
CZ_UI_TEMPLATES_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	UI_DEF_ID DELETED_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
TEMPLATE_ID	NUMBER		Yes	identifies UI Template ( PK)
UI_DEF_ID	NUMBER		Yes	identifies UI (not null if template is local, null if template is global)
TEMPLATE_NAME	VARCHAR2	(255)	Yes	name of UI Template
TEMPLATE_TYPE	NUMBER		Yes	Specifies the data type of the content that can be rendered in this template. FK reference to CZ_SIGNATURES.
TEMPLATE_DESC	VARCHAR2	(2000)		description
PARENT_CONTAINER_TYPE	NUMBER			when the template is an inner template, this indicates
JRAD_DOC	VARCHAR2	(255)		a reference name in the JRAD repository for content
BUTTON_BAR_TEMPLATE_ID	NUMBER			a reference to the template which contains
MESSAGE_TYPE	NUMBER			If the template is used for displaying messages in OA
MAIN_MESSAGE_ID	NUMBER			identifies the message text which would be
TITLE_ID	NUMBER			identifies the title text which can be used for
DELETED_FLAG	VARCHAR2	(1)	Yes	Standard flag; '0' indicates the record is active, '1' means deleted. Other values are reserved
CREATED_BY	NUMBER		Yes	Standard field recording the ID of the user that created this record
CREATION_DATE	DATE		Yes	Standard field recording the date this record was created
LAST_UPDATED_BY	NUMBER		Yes	Standard field recording the ID of the user that last updated this record
LAST_UPDATE_DATE	DATE		Yes	Standard field recording the date/time this record was last updated
LAST_UPDATE_LOGIN	NUMBER			Records the login ID under which this record was last updated
SEEDED_FLAG	VARCHAR2	(1)	Yes
LAYOUT_UI_STYLE	VARCHAR2	(1)		1 - Label-data Row Layout; 2 - Multi-column Row Layout; 3 - Other
ROOT_REGION_TYPE	VARCHAR2	(255)	Yes	JRAD tag name of the root layout region of the Template, e.g. "stackLayout". Set on creation and used when creating a Template Reference.
BUTTON_BAR_TEMPL_UIDEF_ID	NUMBER			Specifies the data type of the content that can be rendered in this template. FK reference to CZ_SIGNATURES.
ROOT_ELEMENT_SIGNATURE_ID	NUMBER		Yes	Signature ID that corresponds to the ROOT_REGION_TYPE. FK to CZ_SIGNATURES.
TEMPLATE_REV_NBR	NUMBER		Yes
TEMPLATE_USAGE	NUMBER		Yes	Allowable values: 0 - control template, 1 - binding template (used to specify tags and attribute sets for binding runtime info to UI elements)
CHECKOUT_USER	VARCHAR2	(100)		Column stores the username of the user who locked the template.
CHECKOUT_TIME	DATE			This column is populated with the SYSDATE when the column checkout user is populated with the username at the time of locking a template.
AMN_USAGE	VARCHAR2	(1)

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
FROM CZ.CZ_UI_TEMPLATES;

Dependencies

[top of page]

CZ.CZ_UI_TEMPLATES does not reference any database object

CZ.CZ_UI_TEMPLATES is referenced by following:

APPS: CZ_PB_MGR - show dependent code; CZ_UI_TEMPLATES; CZ_UI_TEMPLATES_T1; CZ_UI_TEMPLATES_T2