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_CONFIG_MESSAGES

Object Details

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

CZ_CONFIG_MESSAGES contains information about configuration error and warning messages.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: CZ_CONFIG_MESSAGES_PK

MESSAGE_SEQ

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_CONFIG_MESSAGES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	MESSAGE_SEQ
CZ_CONFIG_MESSAGES_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONFIG_HDR_ID CONFIG_REV_NBR DELETED_FLAG MESSAGE_SEQ

Columns

Name	Datatype	Length	Mandatory	Comments
CONFIG_HDR_ID	NUMBER		Yes	Configuration header identifier
CONFIG_REV_NBR	NUMBER		Yes	Configuration revision number
CONSTRAINT_TYPE	VARCHAR2	(16)	Yes	Constraint type of the message. Constraint type values are: contradiction, error, warning, other.
MESSAGE	VARCHAR2	(2000)		Message text.
OVERRIDE	VARCHAR2	(1)		Flag indicating if the user can override this message
RULE_ID	VARCHAR2	(40)		Identifier of the rule that is the source for the message
PS_NODE_ID	NUMBER			Project structure node identifier.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
SECURITY_MASK	VARCHAR2	(40)		Not currently used
EFF_MASK	VARCHAR2	(40)		Not currently used
CHECKOUT_USER	VARCHAR2	(40)		Not currently used
DELETED_FLAG	VARCHAR2	(1)	Yes	Flag indicating if record was deleted by the user. If deleted_flag=1 the record will be purged.
EFF_FROM	DATE			Not currently used
EFF_TO	DATE			Not currently used
MESSAGE_SEQ	NUMBER		Yes	Primary key of this table
CONFIG_ITEM_ID	NUMBER			Specifies the configuration Item (if any) to which this message pertains.
INSTANCE_HDR_ID	NUMBER			Specifies the configuration-network instance to which this message applies.
INSTANCE_REV_NBR	NUMBER			Specifies configuration-network revision if applicable

Query Text

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


SELECT CONFIG_HDR_ID
,      CONFIG_REV_NBR
,      CONSTRAINT_TYPE
,      MESSAGE
,      OVERRIDE
,      RULE_ID
,      PS_NODE_ID
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      SECURITY_MASK
,      EFF_MASK
,      CHECKOUT_USER
,      DELETED_FLAG
,      EFF_FROM
,      EFF_TO
,      MESSAGE_SEQ
,      CONFIG_ITEM_ID
,      INSTANCE_HDR_ID
,      INSTANCE_REV_NBR
FROM CZ.CZ_CONFIG_MESSAGES;

Dependencies

[top of page]

CZ.CZ_CONFIG_MESSAGES does not reference any database object

CZ.CZ_CONFIG_MESSAGES is referenced by following:

APPS: CZ_CONFIG_MESSAGES; CZ_CONFIG_MESSAGES_T1