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_NODES

Object Details

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

This table contains the data describing each individual component of an Oracle Configurator user interface - pages, controls, labels, buttons, etc.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: CZ_UI_NODES_PK

UI_NODE_ID
UI_DEF_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_UI_NODES_PK	NORMAL	UNIQUE	APPS_TS_SEED	UI_NODE_ID UI_DEF_ID
CZ_UI_NODES_U2	NORMAL	UNIQUE	APPS_TS_SEED	PARENT_ID UI_DEF_ID UI_NODE_ID
CZ_UI_NODES_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	UI_DEF_ID UI_NODE_REF_ID
CZ_UI_NODES_N10	NORMAL	NONUNIQUE	APPS_TS_SEED	UI_DEF_ID DELETED_FLAG UI_NODE_TYPE
CZ_UI_NODES_N11	NORMAL	NONUNIQUE	APPS_TS_SEED	UI_DEF_ID UI_DEF_REF_ID UI_NODE_TYPE DELETED_FLAG
CZ_UI_NODES_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	TOOL_TIP_ID
CZ_UI_NODES_N3	NORMAL	NONUNIQUE	APPS_TS_SEED	FUNC_COMP_ID
CZ_UI_NODES_N4	NORMAL	NONUNIQUE	APPS_TS_SEED	PS_NODE_ID
CZ_UI_NODES_N5	NORMAL	NONUNIQUE	APPS_TS_SEED	CONTAINER_ID
CZ_UI_NODES_N6	NORMAL	NONUNIQUE	APPS_TS_SEED	COMPONENT_ID
CZ_UI_NODES_N7	NORMAL	NONUNIQUE	APPS_TS_SEED	CAPTION_ID
CZ_UI_NODES_N9	NORMAL	NONUNIQUE	APPS_TS_SEED	UI_DEF_ID PARENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
UI_NODE_ID	NUMBER	(9)	Yes	Identity of the user-interface node. Conventionally this value is unique in the table, but the PK also includes the UI_DEF_ID.
UI_DEF_ID	NUMBER	(9)	Yes	Identifies the User Interface of which this record is a part
FUNC_COMP_ID	NUMBER	(9)		Associates a functional companion with this UI component
REL_TOP_POS	NUMBER	(9)		Top (vertical) position of this UI component relative to its parent/container
UI_NODE_SUBTYPE	NUMBER	(15)		UNUSED
WIDTH	NUMBER	(9)		Width of this UI component
HEIGHT	NUMBER	(9)		Screen height of this UI component
PARENT_ID	NUMBER	(10)		Identifies the parent record of this one to implement a data hierarchy
REL_LEFT_POS	NUMBER	(9)		Left (horizontal) position of this UI component relative to its parent/container
COMPONENT_ID	NUMBER	(15)		ID of the component psnode to which this UI object refers
CONTAINER_ID	NUMBER	(15)		UNUSED
CAPTION_ID	NUMBER	(15)		Identifies a caption to be used for this UI object by reference to the CZ_INTL_TEXTS table
UI_NODE_TYPE	NUMBER	(9)	Yes	Type of UI node: 41 - Screen; 42 - Frame; 43 - Group; 44 - Control; 51 - User Interface; 61 - Quote Item; 71 - Mktg Package; 100 - Child Of Control; 101 - Picture; 102 - Label; 103 - Text Box; 104 - Tree Node; 105 - State Box; 106 - Quantity; 107 - Combo Box; 108 - Command Button; 109 - Display List; 110 - Display Total; 111 - Menu Item; 112 - Set Manager; 115 - Textbox Integer; 116 - Textbox Float; 117 - Textbox String; 118 - Textbox Boolean; 119 - Option Countbox; 140 - UI Root; 141 - UI Definition; 142 - UI Section; 143 - Components Tree; 144 - Screen Link; 145 - Feature Option; 146 - UI Screen; 147 - Component Setmanager; 148 - Feature Control; 149 - Value Display; 150 - Button; 151 - Image; 152 - Text; 153 - Status Bar; 154 - UI Bom Item; 155 - UI Frameset; 156 - UI Frame; 157 - UI Model Tree; 158 - UI Dataset Link; 159 - UI Grid; 160 - UI Column; 161 - UI Dataset List; 162 - UI Dataset; 163 - UI Data Descriptor; 164 - UI Find Control; 165 - UI Panel; 166 - UI Tagged Value Display; 168 - connector; 169 - connector list box; 190 - instantiable BOM control
PS_NODE_ID	NUMBER	(15)		Associates this record with a Model structure node ('psnode')
NAME	VARCHAR2	(255)		The name of this object
BACKGROUND_COLOR	NUMBER	(10)		Specifies a background color for this UI object (MS OLE_COLOR format)
LCE_IDENTIFIER	VARCHAR2	(80)		Associates this UI component with a compiled logic object through the identifier assigned to it. Format is "P_n" where 'n' is the ps_node_id of the source psnode, e.g., "P_44341"
DESC_TEXT	VARCHAR2	(2000)		Description of this ui node
TREE_SEQ	NUMBER	(9)		Provides an ordering among records that are under the same parent in a data hierarchy
TREE_DISPLAY_FLAG	VARCHAR2	(1)		'1' indicates this node should be included in the tree display.
MODIFIED_FLAGS	NUMBER	(9)		Bit map of attributes on this UI component that have been customized. Meaning of each bit position: Name - 1; Caption - 2; Height - 3; Control_Type - 4; Width - 5
TAB_ORDER	NUMBER	(9)		Tab order of this UI component within a screen
DEFAULT_FONT_FLAG	VARCHAR2	(1)		'1' indicates this UI object should carry the default font, otherwise '0'
TOOL_TIP_ID	NUMBER	(15)		Refers to an INTL_TEXT record that holds the text for a 'tool tip' describing this ui component
UI_NODE_REF_ID	NUMBER	(9)		This refers to a successor control to which the UI traverses from this UI node; applies to screen links, UI screens, feature controls, value displays, and UI dataset links
DEFAULT_BKGRND_COLOR_FLAG	VARCHAR2	(1)		'1' indicates this UI object should carry the default background color, otherwise '0'
DEFAULT_BKGRND_PICTURE_FLAG	VARCHAR2	(1)		'1' indicates this UI object should carry the default background picture, otherwise '0'
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	(40)		UNUSED
LAST_UPDATE_LOGIN	NUMBER	(15)		Records the login ID under which this record was last updated
MODEL_REF_EXPL_ID	NUMBER	(9)		Associates this record with a model-reference explosion node in the current model
UI_DEF_REF_ID	NUMBER	(9)		For UI nodes attached to Reference psnodes, this identifies the child user interface to use on this reference from the parent model to the child model
FONTBOLD	VARCHAR2	(1)		'1' indicates this ui object is to be rendered with bold font, '0' if not
FONTCOLOR	NUMBER	(9)		OLE_COLOR indicating the color in which this object's text is to be rendered
FONTITALIC	VARCHAR2	(1)		'1' indicates this ui object's text should be italicized, '0' if not
FONTUNDERLINE	VARCHAR2	(1)		'1' indicates this ui object's text should be underlined, '0' if not
FONTSIZE	NUMBER	(9)		Size in which to render text for this UI object
FONTNAME	VARCHAR2	(255)		Name of the font to render in this UI object
BACKGROUNDSTYLE	VARCHAR2	(1)		Defines a style for the background of this UI object: 0 = Transparent, 1 = Opaque
CONTROLTYPE	NUMBER	(9)		Type of UI control described by the record: 0 = option buttons, 1 = dropdown list, 2 = standard list, 3 = checkboxes, 4 = numeric edit (integer), 5 = numeric edit (decimal), 6 = general edit control, 7 = resource, 8 = total, 9 = BOM (non-mutex), 10 = BOM (mutex), 11 = radio button, 12 = integer edit box with spin buttons, 13 = count edit, 14 = count edit with spin, 15 = currency edit, -1 = nothing
BACKGROUNDPICTURE	VARCHAR2	(255)		File or path name for a graphic to be used as a background picture for this UI object
BORDERS	VARCHAR2	(1)		Indicates whether this UI object should have a border, and of what type: 0 = None, 1 = Fix Single
PICTURENAME	VARCHAR2	(255)		Holds file name for a picture. Usually redundant with Pictureproperty, may be dropped.
PROPERTY_ID	NUMBER			Identifies a TEXT Property under which to take a URL for a launch-URL text link.
PAGE_NUMBER	NUMBER			Sequential number for a page of BOM node children; used to subdivide UI pages for BOM nodes with numerous children in order to improve performance and limit page scrolling.
OPTION_SORT_SELECT_FIRST	NUMBER			Specifies whether the nodes should be sorted with selectable options first; this is an additional sort 'key'. 0: do not sort selectable first; 1: sort selectable nodes first; -1: default to parent/ui setting.
OPTION_SORT_ORDER	NUMBER			Determines whether the sort is descending (value 0), ascending (1), or defaulted to parent/ui (-1)
OPTION_SORT_PROPERTY	NUMBER			Specifies a property on the basis of whose value the runtime should sort nodes in the UI
OPTION_SORT_METHOD	NUMBER			Specifies the method (sort field) for option sorting. Values: -1: OS_METHOD_DEFAULT (used only at feature level) defaults to UI-global sort; 0: OS_METHOD_MODEL - same order as nodes in the configuration model; 1: OS_METHOD_LABEL, sort by label (localized label); 2: OS_METHOD_PROPERTY_VALUE, sort by the node's value for the property identified by OPTION_SORT_PROPERTY.
PERSISTENT_UI_NODE_ID	NUMBER		Yes	Records the value for this UI node at its original creation. Persists through copies and Publication.
CX_COMMAND_NAME	VARCHAR2	(40)

Query Text

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


SELECT UI_NODE_ID
,      UI_DEF_ID
,      FUNC_COMP_ID
,      REL_TOP_POS
,      UI_NODE_SUBTYPE
,      WIDTH
,      HEIGHT
,      PARENT_ID
,      REL_LEFT_POS
,      COMPONENT_ID
,      CONTAINER_ID
,      CAPTION_ID
,      UI_NODE_TYPE
,      PS_NODE_ID
,      NAME
,      BACKGROUND_COLOR
,      LCE_IDENTIFIER
,      DESC_TEXT
,      TREE_SEQ
,      TREE_DISPLAY_FLAG
,      MODIFIED_FLAGS
,      TAB_ORDER
,      DEFAULT_FONT_FLAG
,      TOOL_TIP_ID
,      UI_NODE_REF_ID
,      DEFAULT_BKGRND_COLOR_FLAG
,      DEFAULT_BKGRND_PICTURE_FLAG
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      DELETED_FLAG
,      EFF_FROM
,      EFF_TO
,      CREATED_BY
,      LAST_UPDATED_BY
,      SECURITY_MASK
,      EFF_MASK
,      CHECKOUT_USER
,      LAST_UPDATE_LOGIN
,      MODEL_REF_EXPL_ID
,      UI_DEF_REF_ID
,      FONTBOLD
,      FONTCOLOR
,      FONTITALIC
,      FONTUNDERLINE
,      FONTSIZE
,      FONTNAME
,      BACKGROUNDSTYLE
,      CONTROLTYPE
,      BACKGROUNDPICTURE
,      BORDERS
,      PICTURENAME
,      PROPERTY_ID
,      PAGE_NUMBER
,      OPTION_SORT_SELECT_FIRST
,      OPTION_SORT_ORDER
,      OPTION_SORT_PROPERTY
,      OPTION_SORT_METHOD
,      PERSISTENT_UI_NODE_ID
,      CX_COMMAND_NAME
FROM CZ.CZ_UI_NODES;

Dependencies

[top of page]

CZ.CZ_UI_NODES does not reference any database object

CZ.CZ_UI_NODES is referenced by following:

APPS: CZ_UI_NODES; CZ_UI_NODES_T1; CZ_UI_NODES_T2; CZ_UI_NODES_TP1