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_DEFS

Object Details

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

This table is the header table for defining Oracle Configurator user interfaces.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_UI_DEFS_UPK	NORMAL	UNIQUE	APPS_TS_SEED	UI_DEF_ID ZD_EDITION_NAME
CZ_UI_DEFS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	COMPONENT_ID
CZ_UI_DEFS_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	DELETED_FLAG DEVL_PROJECT_ID UI_DEF_ID
CZ_UI_DEFS_N3	NORMAL	NONUNIQUE	APPS_TS_SEED	DELETED_FLAG UI_DEF_ID COMPONENT_ID
CZ_UI_DEFS_N5	NORMAL	NONUNIQUE	APPS_TS_SEED	DEVL_PROJECT_ID DELETED_FLAG NAME UI_DEF_ID
CZ_UI_DEFS_N6	NORMAL	NONUNIQUE	APPS_TS_SEED	FROM_MASTER_TEMPLATE_ID DELETED_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
LAST_UPDATE_LOGIN	NUMBER	(15)		Records the login ID under which this record was last updated
UI_DEF_ID	NUMBER	(9)	Yes	Identifies a User Interface for this record
DESC_TEXT	VARCHAR2	(2000)		Description for this UI, Master Template, or Template Fragment
NAME	VARCHAR2	(255)	Yes	The name of this User Interface or Master Template
DEVL_PROJECT_ID	NUMBER	(15)	Yes	Identifies the project/model associated with this record
COMPONENT_ID	NUMBER	(15)		Associates this user interface with a Component psnode
TREE_SEQ	NUMBER	(9)		Provides an ordering among the User Interfaces for this project
CREATION_DATE	DATE		Yes	Standard field recording the date this record was created
LAST_UPDATE_DATE	DATE		Yes	Standard field recording the date/time this record was last updated
DELETED_FLAG	VARCHAR2	(1)	Yes	Standard flag; '0' indicates the record is active, '1' means deleted. Other values are reserved
EFF_FROM	DATE			UNUSED
EFF_TO	DATE			UNUSED
CREATED_BY	NUMBER	(15)	Yes	Standard field recording the ID of the user that created this record
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard field recording the ID of the user that last updated this record
SECURITY_MASK	VARCHAR2	(40)		UNUSED
EFF_MASK	VARCHAR2	(40)		UNUSED
CHECKOUT_USER	VARCHAR2	(100)		Carries the ID of the user who has locked this UI record.
UI_STYLE	VARCHAR2	(3)	Yes	Specifies the style of this user interface: 0 - Components Tree (default); 1 - Navigation Tree; 2 - Wizard; 3 - Model Tree;
GEN_VERSION	VARCHAR2	(25)	Yes	Identifies the version or format of the generated User Interface
TREENODE_DISPLAY_SOURCE	VARCHAR2	(1)	Yes	Code specifying which field is used for displaying model nodes in the tree panel. N - Name; D - Description; B - both
GEN_HEADER	VARCHAR2	(100)		Exact point revision of UI generator used to generate/refresh this User Interface
CONTROLS_PER_SCREEN	NUMBER			Specifies the maximum number of controls to be generated on an option-class screen in UI generate/refresh.
LOOK_AND_FEEL	VARCHAR2	(20)		Contains a tag overriding the default look-and-feel for component-style UI (i.e., when UI_STYLE =0). Known tag: form/blaf
PERSISTENT_UI_DEF_ID	NUMBER			The "persistent" ID for this UI, preserved through copying and publishing.
MASTER_TEMPLATE_FLAG	VARCHAR2	(1)	Yes	Flag indicates template usage of this record:0 - User interface;1 - Master Template; - template fragment
SEEDED_FLAG	VARCHAR2	(1)		Standard flag: '0' indicates the record was created by customer, '1' indicates the record was seeded with the Configurator installation.
BOMQTYINPUTCTRLS	NUMBER			Flag indicates whether a BOM content control is to be rendered with a quantity-input: 1 - Only when required (i.e, max quantity > 1); 2 - Always; 3 - Never
BOMUI_LAYOUT	NUMBER			Field specifies to UI Generation which form of layout to use in creating pages for BOM structure: 1- Compact Layout 1; 2 - Compact Layout 2; 3 - Expanded Layout 1; 4 - Expanded Layout 2; 5 - Expanded Layout 3; 6 - Custom Settings
CONTROL_LAYOUT	NUMBER			Specifies how controls are to be generated onto pages: 1 - single column; 2 - two columns; 3 - three columns
CTRLTEMPLATEUSE_BUTTONBAR	VARCHAR2	(1)	Yes	Specifies to UI Generation how to attach the button-bar Template to this UI: 1 - copy to UI as page content; 2 - Copy to UI as Local Template; 3 - Incorporate by Reference.
CTRLTEMPLATEUSE_UTILITYPAGE	VARCHAR2	(1)	Yes	Specifies to UI Generation how to attach the utility-page Template to this UI: 1 - copy to UI as page content; 2 - Copy to UI as Local Template; 3 - Incorporate by Reference.
CTRLTEMPLUSE_BOM	NUMBER			Specifies to UI Generation how to attach BOM Templates to this UI: 1 - copy to UI as page content; 2 - Copy to UI as Local Template; 3 - Incorporate by Reference.
CTRLTEMPLUSE_COMMON	NUMBER			Specifies to UI Generation how to attach common Templates to this UI: 1 - copy to UI as page content; 2 - Copy to UI as Local Template; 3 - Incorporate by Reference.
CTRLTEMPLUSE_NONBOM	NUMBER			Specifies to UI Generation how to attach non-BOM Templates to this UI: 1 - copy to UI as page content; 2 - Copy to UI as Local Template; 3 - Incorporate by Reference.
CTRLTEMPLUSE_OPTMSG	NUMBER			Specifies to UI Generation how to attach Optional Message Templates to this UI: 1 - copy to UI as page content; 2 - Copy to UI as Local Template; 3 - Incorporate by Reference.
CTRLTEMPLUSE_REQDMSG	NUMBER			Specifies to UI Generation how to attach Required Message Templates to this UI: 1 - copy to UI as page content; 2 - Copy to UI as Local Template; 3 - Incorporate by Reference.
DRILLDOWN_CONTROL_TEXT_ID	NUMBER			Specifies the Text ID to use for labels on Drill-down controls. This text can contain substitution tokens such as "&NAME".
DRILLDOWN_IMAGE_URL	VARCHAR2	(255)		Specifies an image file URL to be used in rendering a Drill-down Control
EMPTY_UI_FLAG	VARCHAR2	(1)		Will be '1' for empty JRAD UIs, which UI refresh will ignore.
ERR_RUN_ID	NUMBER			On failure of UI Generation or Refresh for this UI, this column will store the failed RUN_ID so that the Configurator log table (CZ_DB_LOGS) can be interrogated for the causes of failure.
FROM_MASTER_TEMPLATE_ID	NUMBER			Identifies the Master Template from which this user interface was created.
MENU_CAPTION_RULE_ID	NUMBER			Default caption rule ID for menu item captions.
MODEL_TIMESTAMP	DATE			Stores CZ_PS_NODES.last_struct_update from the last time this UI was Generated or Refreshed; used to determine whether this UI is up-to-date with respect to the Model.
NONBOM_UILAYOUT	NUMBER			Field specifies to UI Generation which form of layout to use in creating pages for non-BOM structure: 1- Compact Layout 1; 2 - Expanded Layout 1; 3 - Expanded Layout 2; 4 - Custom Settings
OPTION_SORT_METHOD	NUMBER			Specifies the structure data to use to sort the options in a list: -1 - take from enclosing UI or structure; 0 - sort by position in model structure; 1 - sort by label (displayname) ; 2 - sort by property (see OPTION_SORT_PROPERTY_ID field)
OPTION_SORT_ORDER	NUMBER			Specifies in which direction option sorts should go: -1 - take from enclosing UI/structure; 0 - Ascending; 1 - Descending
OPTION_SORT_PROPERTY_ID	NUMBER			Specifies a the ID of a model-node property whose value is to be used for sorting options in a list
OPTION_SORT_SELECT_FIRST	NUMBER			Flag indicates whether selection state is to be used in sorting options: -1 - take setting from enclosing UI/structure; 0 - do not use selection state in sorting; 1 - sort list with selected options first
OUTER_TEMPLATE_USAGE	VARCHAR2	(3)		Specifies to UI Generation how to attach the Outer Template to this UI: 1 - copy to UI as page content; 2 - Copy to UI as Local Template; 3 - Incorporate by Reference. ORIGINAL VALUES SPEC'D; 0 - none; 1 - Default Outer Template - Embedded Page; 2 - Default Outer Template - Standalone Page
PAGE_CAPTION_RULE_ID	NUMBER			Default caption rule ID for page titles.
PAGE_LAYOUT	VARCHAR2	(2000)		Specifies a main page for laying out this User Interface (default /oracle/apps/cz/runtime/oa/webui/pages/CZMainPage)
PAGE_SET_ID	NUMBER			Identifies Start Page Flow (Page Set of type page-flow)
PAGINATION_SLOT	NUMBER			FK to the UI-template 'Pagination' fragment defining the pagination settings for this UI or Master Template
PAGIN_BOMOC	NUMBER			Specifies to UI Generation how to paginate controls for BOM Option Classes: 1 - Subsections of Parent Page; 2 - New Pages in Primary Navigation; 3 - New Drilldown Pages
PAGIN_DRILLDOWNCTRL	NUMBER			Specifies to UI Generation how to render a Drill-down: 1 - Button; 2 - Text Link; 3 - Image
PAGIN_MAXCONTROLS	NUMBER			Specifies the maximum number of controls to be laid out on a page by UI Generation/Refresh
PAGIN_NONINST	NUMBER			Specifies to UI Generation how to paginate controls for non-BOM Components (Mandatory or Optional, not instantiable): 1 - Subsections of Parent Page; 2 - New Pages in Primary Navigation; 3 - New Drilldown Pages
PAGIN_NONINST_REFCOMP	NUMBER			Specifies to UI Generation how to paginate controls for non-BOM Model References (Mandatory or Optional, not instantiable): 1 - Subsections of Parent Page; 2 - New Pages in Primary Navigation; 3 - New Drilldown Pages
PRESERVE_MODEL_HIERARCHY	VARCHAR2	(1)		Directs UI Refresh to reflect the hierarchical structure of the model when refreshing this UI
PRICE_DISPLAY	NUMBER			Specifies what prices to display at run time for this UI: 0 - none; 1 - list price; 2 - selling price; 3 - list price and selling price.
PRICE_UPDATE	NUMBER			Specifies when item prices should be updated to reflect configuration changes: 0 - update always; 1 - update on demand; 2 - update on page load
PRIMARY_NAVIGATION	NUMBER			Specifies the primary navigation mechanism for this user interface: 0 - none (created by customizations); 1 - Step-by-Step Flow (Wizard-style); 2 - Single-Level Side Menu; 3 - Multi-Level Side Menu; 4 - Dynamic Model Tree; 5 - Subtabs
ROWS_PER_TABLE	NUMBER			Specifies the number of rows to be rendered in any Table control when the UI is rendered.
SHOW_TRAIN	VARCHAR2	(1)		Indicates whether the UI should be rendered with a Train for flows of three or more pages.
START_PAGE_ID	NUMBER			identifies the first page in a Page Flow associated with this UI
START_URL	VARCHAR2	(2000)		Specifies a JavaServerPage URL for starting this User Interface
UI_STATUS	VARCHAR2	(255)		This column is added to support batch-mode generation/refresh; 'NEW' - new UI Definition created; 'REFRESH' - UI will be refreshed; 'RUNNING' - generation or refresh is running; 'SUCCESS' - generation/refresh completed successfully; 'ERROR' - generation/refresh failed.
SHOW_ALL_NODES_FLAG	VARCHAR2	(1)		Formerly a property in CZ_UI_PROPERTIES with key_str = 'ShowAllNodes'. '1' if all model nodes should be displayed in UI, '0' if ui_omit will be used to determine if a node is displayed.
PAGE_STATUS_TEMPLATE_USAGE	NUMBER			Values are from CZ_UI_MSTTMP_TMPUSG_MSGUTL_LKV.
SUPPRESS_REFRESH_FLAG	VARCHAR2	(1)
UI_TIMESTAMP_REFRESH	DATE			Timestamp of last UI Generation or Refresh.
DRILLDOWN_TX_TYPE	NUMBER
CONTENT_LAST_UPDATE_DATE	DATE			Records the most recent date and time when a content detail record attached to this user interface was added, modified, or deleted. This is distinct from LAST_UPDATE_DATE which only refers to updates on the header record. This column is intrinsically an aggregate from other UI records.
DISABLE_AUTOOVERRIDE_FLAG	VARCHAR2	(1)
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT LAST_UPDATE_LOGIN
,      UI_DEF_ID
,      DESC_TEXT
,      NAME
,      DEVL_PROJECT_ID
,      COMPONENT_ID
,      TREE_SEQ
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      DELETED_FLAG
,      EFF_FROM
,      EFF_TO
,      CREATED_BY
,      LAST_UPDATED_BY
,      SECURITY_MASK
,      EFF_MASK
,      CHECKOUT_USER
,      UI_STYLE
,      GEN_VERSION
,      TREENODE_DISPLAY_SOURCE
,      GEN_HEADER
,      CONTROLS_PER_SCREEN
,      LOOK_AND_FEEL
,      PERSISTENT_UI_DEF_ID
,      MASTER_TEMPLATE_FLAG
,      SEEDED_FLAG
,      BOMQTYINPUTCTRLS
,      BOMUI_LAYOUT
,      CONTROL_LAYOUT
,      CTRLTEMPLATEUSE_BUTTONBAR
,      CTRLTEMPLATEUSE_UTILITYPAGE
,      CTRLTEMPLUSE_BOM
,      CTRLTEMPLUSE_COMMON
,      CTRLTEMPLUSE_NONBOM
,      CTRLTEMPLUSE_OPTMSG
,      CTRLTEMPLUSE_REQDMSG
,      DRILLDOWN_CONTROL_TEXT_ID
,      DRILLDOWN_IMAGE_URL
,      EMPTY_UI_FLAG
,      ERR_RUN_ID
,      FROM_MASTER_TEMPLATE_ID
,      MENU_CAPTION_RULE_ID
,      MODEL_TIMESTAMP
,      NONBOM_UILAYOUT
,      OPTION_SORT_METHOD
,      OPTION_SORT_ORDER
,      OPTION_SORT_PROPERTY_ID
,      OPTION_SORT_SELECT_FIRST
,      OUTER_TEMPLATE_USAGE
,      PAGE_CAPTION_RULE_ID
,      PAGE_LAYOUT
,      PAGE_SET_ID
,      PAGINATION_SLOT
,      PAGIN_BOMOC
,      PAGIN_DRILLDOWNCTRL
,      PAGIN_MAXCONTROLS
,      PAGIN_NONINST
,      PAGIN_NONINST_REFCOMP
,      PRESERVE_MODEL_HIERARCHY
,      PRICE_DISPLAY
,      PRICE_UPDATE
,      PRIMARY_NAVIGATION
,      ROWS_PER_TABLE
,      SHOW_TRAIN
,      START_PAGE_ID
,      START_URL
,      UI_STATUS
,      SHOW_ALL_NODES_FLAG
,      PAGE_STATUS_TEMPLATE_USAGE
,      SUPPRESS_REFRESH_FLAG
,      UI_TIMESTAMP_REFRESH
,      DRILLDOWN_TX_TYPE
,      CONTENT_LAST_UPDATE_DATE
,      DISABLE_AUTOOVERRIDE_FLAG
,      ZD_EDITION_NAME
FROM CZ.CZ_UI_DEFS;

Dependencies

[top of page]

CZ.CZ_UI_DEFS does not reference any database object

CZ.CZ_UI_DEFS is referenced by following:

CZ: CZ_UI_DEFS#