[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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) |
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;
CZ.CZ_UI_TEMPLATES does not reference any database object
CZ.CZ_UI_TEMPLATES is referenced by following:
|
|
|