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_REFS

Object Details

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

CZ_UI_PAGE_REFS enumerates the UI pages in a page set along with their menu/flow caption, condition for display, model association, and such.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: CZ_UI_PAGE_REFS_PK

PAGE_SET_ID
UI_DEF_ID
PAGE_REF_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_UI_PAGE_REFS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	PARENT_PAGE_REF_ID PAGE_REF_ID UI_DEF_ID
CZ_UI_PAGE_REFS_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	UI_DEF_ID TARGET_PAGE_ID DELETED_FLAG
CZ_UI_PAGE_REFS_N3	NORMAL	NONUNIQUE	APPS_TS_SEED	UI_DEF_ID DELETED_FLAG
CZ_UI_PAGE_REFS_N4	NORMAL	NONUNIQUE	APPS_TS_SEED	UI_DEF_ID TARGET_PERSISTENT_NODE_ID DELETED_FLAG
CZ_UI_PAGE_REFS_N5	NORMAL	NONUNIQUE	APPS_TS_SEED	UI_DEF_ID PAGE_SET_ID PAGE_REF_ID DELETED_FLAG
CZ_UI_PAGE_REFS_N6	NORMAL	NONUNIQUE	APPS_TS_SEED	UI_DEF_ID PAGE_SET_ID PARENT_PAGE_REF_ID DELETED_FLAG
CZ_UI_PAGE_REFS_N7	NORMAL	NONUNIQUE	APPS_TS_SEED	UI_DEF_ID PAGE_SET_ID SEQ_NBR DELETED_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
PAGE_SET_ID	NUMBER		Yes	identifies Page Set ( PK)
UI_DEF_ID	NUMBER		Yes	identifies UI (PK)
PAGE_REF_ID	NUMBER		Yes	Identifies node (PK)
PARENT_PAGE_REF_ID	NUMBER			pecifies enclosing page reference in hierarchical menu
SEQ_NBR	NUMBER		Yes	Page number in Page Flow
NODE_DEPTH	NUMBER		Yes	node_depth for hierarchical menu (1 if not a hierarchical menu)
PAGE_REF_TYPE	NUMBER			node_depth for hierarchical menu (1 if not a hierarchical menu)
CONDITION_ID	NUMBER			stores reference to predefined conditions
NAME	VARCHAR2	(255)		Node name in case of Navigation style = Menu
CAPTION_SOURCE	NUMBER			5- NAME
CAPTION_TEXT_ID	NUMBER			identifies caption string in CZ_LOCALIZED_TEXTS table
PERSISTENT_CAPTION_TEXT_ID	NUMBER			Persistent text ID of caption
PROPERTY_ID	NUMBER			identifies property in case when option "labeled by property name" is used
TARGET_PERSISTENT_NODE_ID	NUMBER			specifies node that is the target of this reference
TARGET_PATH	VARCHAR2	(4000)		provides a path for resolving the target node in this reference
TARGET_UI_DEF_ID	NUMBER			UI DEF that is the target of this page reference
TARGET_PAGE_SET_ID	NUMBER			Page set that is the target of this reference;
TARGET_PAGE_ID	NUMBER			Page that is the target of this reference.
MODIFIED_FLAGS	NUMBER			>0 if node is customized
PATH_TO_PREV_PAGE	VARCHAR2	(4000)		path to the previous page in Page Flow
PATH_TO_NEXT_PAGE	VARCHAR2	(4000)		path to the next page in Page Flow
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 c
CREATION_DATE	DATE		Yes
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
CAPTION_RULE_ID	NUMBER			Reference a caption rule ID for this page reference (menu/page-flow entry).
TARGET_EXPL_NODE_ID	NUMBER			Explosion ID of model node associated with target page.
EMPTY_PAGE_FLAG	VARCHAR2	(1)

Query Text

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


SELECT PAGE_SET_ID
,      UI_DEF_ID
,      PAGE_REF_ID
,      PARENT_PAGE_REF_ID
,      SEQ_NBR
,      NODE_DEPTH
,      PAGE_REF_TYPE
,      CONDITION_ID
,      NAME
,      CAPTION_SOURCE
,      CAPTION_TEXT_ID
,      PERSISTENT_CAPTION_TEXT_ID
,      PROPERTY_ID
,      TARGET_PERSISTENT_NODE_ID
,      TARGET_PATH
,      TARGET_UI_DEF_ID
,      TARGET_PAGE_SET_ID
,      TARGET_PAGE_ID
,      MODIFIED_FLAGS
,      PATH_TO_PREV_PAGE
,      PATH_TO_NEXT_PAGE
,      DELETED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CAPTION_RULE_ID
,      TARGET_EXPL_NODE_ID
,      EMPTY_PAGE_FLAG
FROM CZ.CZ_UI_PAGE_REFS;

Dependencies

[top of page]

CZ.CZ_UI_PAGE_REFS does not reference any database object

CZ.CZ_UI_PAGE_REFS is referenced by following:

APPS: CZ_UI_PAGE_REFS; CZ_UI_PAGE_REFS_T1; CZ_UI_PAGE_REFS_T2