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_ACTIONS

Object Details

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

CZ_UI_ACTIONS records the specifications for actions to be taken within a UI page in response to a user gesture, in particular, clicking a button or a link.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: CZ_UI_ACTIONS_PK

UI_ACTION_ID
UI_DEF_ID
SOURCE_PAGE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_UI_ACTIONS_PK	NORMAL	UNIQUE	APPS_TS_SEED	UI_ACTION_ID UI_DEF_ID SOURCE_PAGE_ID
CZ_UI_ACTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	UI_DEF_ID TARGET_PERSISTENT_NODE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
UI_ACTION_ID	NUMBER		Yes	one-up enumeration of the actions on this page ( PK )
UI_DEF_ID	NUMBER		Yes	identifies UI ( PK)
SOURCE_PAGE_ID	NUMBER		Yes	Page in which this UI action is bound ( PK)
CONTEXT_COMPONENT_ID	NUMBER			Is this a denormalization from the Page?
ELEMENT_ID	VARCHAR2	(255)		XML id of element associated with this action_id
RENDER_CONDITION_ID	NUMBER			FK to cz_ui_conditions.condition_id or cz_rules.rule_id (TBD).
UI_ACTION_TYPE	NUMBER		Yes	Enumeration of all the action types in the UI Actions spec
TARGET_UI_DEF_ID	NUMBER			UI DEF that is the target of this page reference
TARGET_PERSISTENT_NODE_ID	NUMBER			Specifies node that is the target of this reference
TARGET_NODE_PATH	VARCHAR2	(4000)
TARGET_PAGE_SET_ID	NUMBER
TARGET_PAGE_ID	NUMBER
TARGET_URL	VARCHAR2	(4000)
FRAME_NAME	VARCHAR2	(255)
TARGET_ANCHOR	VARCHAR2	(255)
DELETED_FLAG	VARCHAR2	(1)	Yes	0 - not deleted; 1 - deleted (Standard)
CREATED_BY	NUMBER		Yes	Standard field recording the ID of the user that created this record
CREATION_DATE	DATE		Yes	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	Date this record was last updated
LAST_UPDATE_LOGIN	NUMBER			Standard footprint field. Login identity of user that last updated this record.
SEEDED_FLAG	VARCHAR2	(1)	Yes	'1' indicates this is a seeded expr node
CX_COMMAND_NAME	VARCHAR2	(255)
WINDOW_PARAMETERS	VARCHAR2	(255)		Carries Javascript window controls e.g. 'toolbar=no, location=no, directories=no, status=no, menubar=no, scrollbars=no, resizable=yes, width=200, height=300'
TARGET_WINDOW_TYPE	NUMBER			0 = Main window1 = Child window, non-modal2 = Child window, modal
TARGET_WINDOW_NAME	VARCHAR2	(255)		Used to specify a name for target window in Javascript logic.
TARGET_EXPL_NODE_ID	NUMBER			Specifies the explosion ID of the target node for command events, select/deselect, etc. Used with TARGET_PERSISTENT_NODE_ID.
URL_PROPERTY_ID	NUMBER			ID of property used as source for "open url" action.
PROCESSING_PAGE_TEMPL_ID	NUMBER
PROC_PAGE_TEMPL_UI_DEF_ID	NUMBER
PAGE_TITLE_TEXT_ID	NUMBER
MAIN_MESSAGE_TEXT_ID	NUMBER
PROCESSING_CAPTION_TEXT_ID	NUMBER

Query Text

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


SELECT UI_ACTION_ID
,      UI_DEF_ID
,      SOURCE_PAGE_ID
,      CONTEXT_COMPONENT_ID
,      ELEMENT_ID
,      RENDER_CONDITION_ID
,      UI_ACTION_TYPE
,      TARGET_UI_DEF_ID
,      TARGET_PERSISTENT_NODE_ID
,      TARGET_NODE_PATH
,      TARGET_PAGE_SET_ID
,      TARGET_PAGE_ID
,      TARGET_URL
,      FRAME_NAME
,      TARGET_ANCHOR
,      DELETED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SEEDED_FLAG
,      CX_COMMAND_NAME
,      WINDOW_PARAMETERS
,      TARGET_WINDOW_TYPE
,      TARGET_WINDOW_NAME
,      TARGET_EXPL_NODE_ID
,      URL_PROPERTY_ID
,      PROCESSING_PAGE_TEMPL_ID
,      PROC_PAGE_TEMPL_UI_DEF_ID
,      PAGE_TITLE_TEXT_ID
,      MAIN_MESSAGE_TEXT_ID
,      PROCESSING_CAPTION_TEXT_ID
FROM CZ.CZ_UI_ACTIONS;

Dependencies

[top of page]

CZ.CZ_UI_ACTIONS does not reference any database object

CZ.CZ_UI_ACTIONS is referenced by following:

APPS: CZ_UI_ACTIONS; CZ_UI_ACTIONS_T1; CZ_UI_ACTIONS_T2