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_PAGES

Object Details

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

CZ_UI_PAGES records each page in a Configurator JRAD-based user interface.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: CZ_UI_PAGES_PK

PAGE_ID
UI_DEF_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_UI_PAGES_PK	NORMAL	UNIQUE	APPS_TS_SEED	PAGE_ID UI_DEF_ID
CZ_UI_PAGES_U1	NORMAL	UNIQUE	APPS_TS_SEED	JRAD_DOC
CZ_UI_PAGES_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	UI_DEF_ID PERSISTENT_NODE_ID
CZ_UI_PAGES_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	UI_DEF_ID DELETED_FLAG
CZ_UI_PAGES_N3	NORMAL	NONUNIQUE	APPS_TS_SEED	PERSISTENT_NODE_ID
CZ_UI_PAGES_N4	NORMAL	NONUNIQUE	APPS_TS_SEED	DELETED_FLAG PERSISTENT_NODE_ID UI_DEF_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PAGE_ID	NUMBER		Yes	identifies UI Page (PK)
UI_DEF_ID	NUMBER		Yes	identifies UI (PK)
PERSISTENT_NODE_ID	NUMBER			identifies persistent_node_id of UI Page
JRAD_DOC	VARCHAR2	(255)	Yes	full JRAD document name
PAGEBASE_PATH	VARCHAR2	(4000)	Yes	stores model path from the root to the current page
PAGE_SET_ID	NUMBER			In case of Menu navigation style
SPLIT_SEQ_NBR	NUMBER		Yes	identifies sequence number of page in the chain of splitted pages
CAPTION_SOURCE	NUMBER		Yes	1- 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
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	'1' indicates this is a seeded
PAGEBASE_EXPL_NODE_ID	NUMBER			No Comment
SUPPRESS_REFRESH_FLAG	VARCHAR2	(1)		'1' if page can be updated by UI refresh, '0' if not.
PAGE_REV_NBR	NUMBER		Yes	Used for MDS decaching. Runtime will cache rev nbr for document and later compare the database value against the cached value to determine if the document has changed and must be decached.
NAME	VARCHAR2	(255)		Name of page
DESC_TEXT	VARCHAR2	(2000)		Description of page
PAGE_STATUS_TEMPLATE_ID	NUMBER			FK to CZ_UI_TEMPLATES.
PAGE_STATUS_TEMPL_UIDEF_ID	NUMBER			Along with PAGE_STATUS_TEMPLATE_ID, FK to CZ_UI_TEMPLATES.
CAPTION_RULE_ID	NUMBER			FK to cz_rules.
PAGE_STATUS_TEMPLATE_USAGE	NUMBER		Yes	Values:0 - Use setting from cz_ui_defs.page_status_template_usage.1 - Override with 'None' 2 - Override with specified template
OUTER_TEMPLATE_USAGE	NUMBER		Yes
OUTER_PAGE_TEMPLATE_ID	NUMBER
OUTER_PAGE_TEMPL_UIDEF_ID	NUMBER
DISPLAY_CONDITION_ID	NUMBER			FK to CZ_RULES.rule_id. Display condition rule ID for the page.
DISPLAY_CONDITION_COMP	VARCHAR2	(255)		FK to cz_lookup_values.data_value. Comparison operator for the display condition. Allowable values are 'IS' and 'IS_NOT' (from cz_x_lkv).
DISPLAY_CONDITION_VALUE	VARCHAR2	(255)		FK to cz_lookup_values.data_value.
ENABLED_CONDITION_ID	NUMBER			FK to CZ_RULES.rule_id. Enabled condition rule ID for the page
ENABLED_CONDITION_COMP	VARCHAR2	(255)		FK to cz_lookup_values.data_value. Comparison operator for the display condition. Allowable values are 'IS' and 'IS_NOT' (from cz_x_lkv).
ENABLED_CONDITION_VALUE	VARCHAR2	(255)		FK to cz_lookup_values.data_value.
EMPTY_PAGE_FLAG	VARCHAR2	(1)
MODIFIED_FLAGS	NUMBER			Value will be > 0 when the page has been customized.

Query Text

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


SELECT PAGE_ID
,      UI_DEF_ID
,      PERSISTENT_NODE_ID
,      JRAD_DOC
,      PAGEBASE_PATH
,      PAGE_SET_ID
,      SPLIT_SEQ_NBR
,      CAPTION_SOURCE
,      CAPTION_TEXT_ID
,      PERSISTENT_CAPTION_TEXT_ID
,      PROPERTY_ID
,      DELETED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SEEDED_FLAG
,      PAGEBASE_EXPL_NODE_ID
,      SUPPRESS_REFRESH_FLAG
,      PAGE_REV_NBR
,      NAME
,      DESC_TEXT
,      PAGE_STATUS_TEMPLATE_ID
,      PAGE_STATUS_TEMPL_UIDEF_ID
,      CAPTION_RULE_ID
,      PAGE_STATUS_TEMPLATE_USAGE
,      OUTER_TEMPLATE_USAGE
,      OUTER_PAGE_TEMPLATE_ID
,      OUTER_PAGE_TEMPL_UIDEF_ID
,      DISPLAY_CONDITION_ID
,      DISPLAY_CONDITION_COMP
,      DISPLAY_CONDITION_VALUE
,      ENABLED_CONDITION_ID
,      ENABLED_CONDITION_COMP
,      ENABLED_CONDITION_VALUE
,      EMPTY_PAGE_FLAG
,      MODIFIED_FLAGS
FROM CZ.CZ_UI_PAGES;

Dependencies

[top of page]

CZ.CZ_UI_PAGES does not reference any database object

CZ.CZ_UI_PAGES is referenced by following:

APPS: CZ_UI_PAGES; CZ_UI_PAGES_T1; CZ_UI_PAGES_T2