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_PAGE_ELEMENTS

Object Details

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

CZ_UI_PAGE_ELEMENTS describes the contents of a UI page in a parent/child hierarchy of element types.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_UI_PAGE_ELEMENTS_PK	NORMAL	UNIQUE	APPS_TS_SEED	UI_DEF_ID PAGE_ID ELEMENT_ID
CZ_UI_PAGE_ELEMENTS_N10	NORMAL	NONUNIQUE	APPS_TS_SEED	DELETED_FLAG UI_DEF_ID PERSISTENT_NODE_ID
CZ_UI_PAGE_ELEMENTS_N11	NORMAL	NONUNIQUE	APPS_TS_SEED	CTRL_TEMPLATE_ID CTRL_TEMPLATE_UI_DEF_ID
CZ_UI_PAGE_ELEMENTS_N12	NORMAL	NONUNIQUE	APPS_TS_SEED	TARGET_PAGE_UI_DEF_ID TARGET_PAGE_ID DELETED_FLAG
CZ_UI_PAGE_ELEMENTS_N3	NORMAL	NONUNIQUE	APPS_TS_SEED	UI_DEF_ID PARENT_ELEMENT_ID DELETED_FLAG
CZ_UI_PAGE_ELEMENTS_N4	NORMAL	NONUNIQUE	APPS_TS_SEED	UI_DEF_ID PAGE_ID DELETED_FLAG
CZ_UI_PAGE_ELEMENTS_N5	NORMAL	NONUNIQUE	APPS_TS_SEED	UI_DEF_ID DELETED_FLAG
CZ_UI_PAGE_ELEMENTS_N6	NORMAL	NONUNIQUE	APPS_TS_SEED	UI_DEF_ID PERSISTENT_NODE_ID DELETED_FLAG
CZ_UI_PAGE_ELEMENTS_N7	NORMAL	NONUNIQUE	APPS_TS_SEED	UI_DEF_ID PARENT_ELEMENT_ID SEQ_NBR ELEMENT_TYPE
CZ_UI_PAGE_ELEMENTS_N8	NORMAL	NONUNIQUE	APPS_TS_SEED	UI_DEF_ID PARENT_PERSISTENT_NODE_ID PERSISTENT_NODE_ID DELETED_FLAG
CZ_UI_PAGE_ELEMENTS_N9	NORMAL	NONUNIQUE	APPS_TS_SEED	UI_DEF_ID ELEMENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
UI_DEF_ID	NUMBER		Yes	identifies UI (PK)
PAGE_ID	NUMBER		Yes	identifies base page (PK)-- > CZ_UI_PAGES.page_id
PERSISTENT_NODE_ID	NUMBER
ELEMENT_ID	VARCHAR2	(255)	Yes	identifies element on the page - this is value of XML attribute "id"
PARENT_PERSISTENT_NODE_ID	NUMBER
REGION_PERSISTENT_NODE_ID	NUMBER		Yes	dentifies persistent_node_id of the nearest region
PAGEBASE_PERSISTENT_NODE_ID	NUMBER		Yes	identifies persistent_node_id of the nearest base page
CTRL_TEMPLATE_ID	NUMBER			identifies UI template for this UI node-> CZ_UI_TEMPLATES.template_id
BASE_PAGE_FLAG	NUMBER			NULL/'0' or '1'
INSTANTIABLE_FLAG	VARCHAR2	(1)		Denormalization from CZ_PS_NODES.INSTANTIABLE_FLAG for element's Associated Model Node. INSTANTIABLE_FLAG records the user's intended instantiation behavior for Component and Reference structure nodes. '1' indicates an Optional node (minimum 0 instances, maximum 1 instance); '2' indicates a Mandatory or Single instance (1, 1) node; '4' indicates a Multiply-Instantiable node, allowing a maximum of two or more instances. Also, the value '3' is used for Connectors.
SEQ_NBR	NUMBER		Yes
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
CTRL_TEMPLATE_UI_DEF_ID	NUMBER
MODEL_REF_EXPL_ID	NUMBER			Explosion ID of associated model node, if any.
SUPPRESS_REFRESH_FLAG	VARCHAR2	(1)		'1' if element can be updated by UI refresh, '0' if not.
PARENT_ELEMENT_ID	VARCHAR2	(255)		ELEMENT_ID of parent page element.
ELEMENT_TYPE	NUMBER			Type of UI element (520 - page, 521 - region, 522 - generic (not page, region, or special control), 523 - drilldown control, 524 - add non-BOM instance management control, 525 - add BOM instance management control, 526 - delete instance management control). FK to CZ_SIGNATURES
NAME	VARCHAR2	(255)		None
ELEMENT_SIGNATURE_ID	NUMBER			Signature ID that corresponds to the OA element type. FK to CZ_SIGNATURES.
TARGET_PAGE_UI_DEF_ID	NUMBER			UI Def Id of target UI page
TARGET_PAGE_ID	NUMBER			Page Id of target UI page

Query Text

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


SELECT UI_DEF_ID
,      PAGE_ID
,      PERSISTENT_NODE_ID
,      ELEMENT_ID
,      PARENT_PERSISTENT_NODE_ID
,      REGION_PERSISTENT_NODE_ID
,      PAGEBASE_PERSISTENT_NODE_ID
,      CTRL_TEMPLATE_ID
,      BASE_PAGE_FLAG
,      INSTANTIABLE_FLAG
,      SEQ_NBR
,      DELETED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CTRL_TEMPLATE_UI_DEF_ID
,      MODEL_REF_EXPL_ID
,      SUPPRESS_REFRESH_FLAG
,      PARENT_ELEMENT_ID
,      ELEMENT_TYPE
,      NAME
,      ELEMENT_SIGNATURE_ID
,      TARGET_PAGE_UI_DEF_ID
,      TARGET_PAGE_ID
FROM CZ.CZ_UI_PAGE_ELEMENTS;

Dependencies

[top of page]

CZ.CZ_UI_PAGE_ELEMENTS does not reference any database object

CZ.CZ_UI_PAGE_ELEMENTS is referenced by following:

CZ: CZ_UI_PAGE_ELEMENTS#