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]

VIEW: CZ.CZ_UI_DEFS#

Object Details

Object Name:	CZ_UI_DEFS#
Object Type:	VIEW
Owner:	CZ
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
LAST_UPDATE_LOGIN	NUMBER	(15)
UI_DEF_ID	NUMBER	(9)	Yes
DESC_TEXT	VARCHAR2	(2000)
NAME	VARCHAR2	(255)	Yes
DEVL_PROJECT_ID	NUMBER	(15)	Yes
COMPONENT_ID	NUMBER	(15)
TREE_SEQ	NUMBER	(9)
CREATION_DATE	DATE		Yes
LAST_UPDATE_DATE	DATE		Yes
DELETED_FLAG	VARCHAR2	(1)	Yes
EFF_FROM	DATE
EFF_TO	DATE
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
SECURITY_MASK	VARCHAR2	(40)
EFF_MASK	VARCHAR2	(40)
CHECKOUT_USER	VARCHAR2	(100)
UI_STYLE	VARCHAR2	(3)	Yes
GEN_VERSION	VARCHAR2	(25)	Yes
TREENODE_DISPLAY_SOURCE	VARCHAR2	(1)	Yes
GEN_HEADER	VARCHAR2	(100)
CONTROLS_PER_SCREEN	NUMBER
LOOK_AND_FEEL	VARCHAR2	(20)
PERSISTENT_UI_DEF_ID	NUMBER
MASTER_TEMPLATE_FLAG	VARCHAR2	(1)	Yes
SEEDED_FLAG	VARCHAR2	(1)
BOMQTYINPUTCTRLS	NUMBER
BOMUI_LAYOUT	NUMBER
CONTROL_LAYOUT	NUMBER
CTRLTEMPLATEUSE_BUTTONBAR	VARCHAR2	(1)	Yes
CTRLTEMPLATEUSE_UTILITYPAGE	VARCHAR2	(1)	Yes
CTRLTEMPLUSE_BOM	NUMBER
CTRLTEMPLUSE_COMMON	NUMBER
CTRLTEMPLUSE_NONBOM	NUMBER
CTRLTEMPLUSE_OPTMSG	NUMBER
CTRLTEMPLUSE_REQDMSG	NUMBER
DRILLDOWN_CONTROL_TEXT_ID	NUMBER
DRILLDOWN_IMAGE_URL	VARCHAR2	(255)
EMPTY_UI_FLAG	VARCHAR2	(1)
ERR_RUN_ID	NUMBER
FROM_MASTER_TEMPLATE_ID	NUMBER
MENU_CAPTION_RULE_ID	NUMBER
MODEL_TIMESTAMP	DATE
NONBOM_UILAYOUT	NUMBER
OPTION_SORT_METHOD	NUMBER
OPTION_SORT_ORDER	NUMBER
OPTION_SORT_PROPERTY_ID	NUMBER
OPTION_SORT_SELECT_FIRST	NUMBER
OUTER_TEMPLATE_USAGE	VARCHAR2	(3)
PAGE_CAPTION_RULE_ID	NUMBER
PAGE_LAYOUT	VARCHAR2	(2000)
PAGE_SET_ID	NUMBER
PAGINATION_SLOT	NUMBER
PAGIN_BOMOC	NUMBER
PAGIN_DRILLDOWNCTRL	NUMBER
PAGIN_MAXCONTROLS	NUMBER
PAGIN_NONINST	NUMBER
PAGIN_NONINST_REFCOMP	NUMBER
PRESERVE_MODEL_HIERARCHY	VARCHAR2	(1)
PRICE_DISPLAY	NUMBER
PRICE_UPDATE	NUMBER
PRIMARY_NAVIGATION	NUMBER
ROWS_PER_TABLE	NUMBER
SHOW_TRAIN	VARCHAR2	(1)
START_PAGE_ID	NUMBER
START_URL	VARCHAR2	(2000)
UI_STATUS	VARCHAR2	(255)
SHOW_ALL_NODES_FLAG	VARCHAR2	(1)
PAGE_STATUS_TEMPLATE_USAGE	NUMBER
SUPPRESS_REFRESH_FLAG	VARCHAR2	(1)
UI_TIMESTAMP_REFRESH	DATE
DRILLDOWN_TX_TYPE	NUMBER
CONTENT_LAST_UPDATE_DATE	DATE
DISABLE_AUTOOVERRIDE_FLAG	VARCHAR2	(1)
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT LAST_UPDATE_LOGIN
,      UI_DEF_ID
,      DESC_TEXT
,      NAME
,      DEVL_PROJECT_ID
,      COMPONENT_ID
,      TREE_SEQ
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      DELETED_FLAG
,      EFF_FROM
,      EFF_TO
,      CREATED_BY
,      LAST_UPDATED_BY
,      SECURITY_MASK
,      EFF_MASK
,      CHECKOUT_USER
,      UI_STYLE
,      GEN_VERSION
,      TREENODE_DISPLAY_SOURCE
,      GEN_HEADER
,      CONTROLS_PER_SCREEN
,      LOOK_AND_FEEL
,      PERSISTENT_UI_DEF_ID
,      MASTER_TEMPLATE_FLAG
,      SEEDED_FLAG
,      BOMQTYINPUTCTRLS
,      BOMUI_LAYOUT
,      CONTROL_LAYOUT
,      CTRLTEMPLATEUSE_BUTTONBAR
,      CTRLTEMPLATEUSE_UTILITYPAGE
,      CTRLTEMPLUSE_BOM
,      CTRLTEMPLUSE_COMMON
,      CTRLTEMPLUSE_NONBOM
,      CTRLTEMPLUSE_OPTMSG
,      CTRLTEMPLUSE_REQDMSG
,      DRILLDOWN_CONTROL_TEXT_ID
,      DRILLDOWN_IMAGE_URL
,      EMPTY_UI_FLAG
,      ERR_RUN_ID
,      FROM_MASTER_TEMPLATE_ID
,      MENU_CAPTION_RULE_ID
,      MODEL_TIMESTAMP
,      NONBOM_UILAYOUT
,      OPTION_SORT_METHOD
,      OPTION_SORT_ORDER
,      OPTION_SORT_PROPERTY_ID
,      OPTION_SORT_SELECT_FIRST
,      OUTER_TEMPLATE_USAGE
,      PAGE_CAPTION_RULE_ID
,      PAGE_LAYOUT
,      PAGE_SET_ID
,      PAGINATION_SLOT
,      PAGIN_BOMOC
,      PAGIN_DRILLDOWNCTRL
,      PAGIN_MAXCONTROLS
,      PAGIN_NONINST
,      PAGIN_NONINST_REFCOMP
,      PRESERVE_MODEL_HIERARCHY
,      PRICE_DISPLAY
,      PRICE_UPDATE
,      PRIMARY_NAVIGATION
,      ROWS_PER_TABLE
,      SHOW_TRAIN
,      START_PAGE_ID
,      START_URL
,      UI_STATUS
,      SHOW_ALL_NODES_FLAG
,      PAGE_STATUS_TEMPLATE_USAGE
,      SUPPRESS_REFRESH_FLAG
,      UI_TIMESTAMP_REFRESH
,      DRILLDOWN_TX_TYPE
,      CONTENT_LAST_UPDATE_DATE
,      DISABLE_AUTOOVERRIDE_FLAG
,      ZD_EDITION_NAME
FROM CZ.CZ_UI_DEFS#;

Dependencies

[top of page]

CZ.CZ_UI_DEFS# references the following:

CZ: CZ_UI_DEFS

CZ.CZ_UI_DEFS# is referenced by following:

APPS: CZ_UI_DEFS; CZ_UI_DEFS+; CZ_UI_DEFS_T1; CZ_UI_DEFS_T2; CZ_UI_DEFS_T3