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: APPS.CZ_CONFIG_MESSAGES_V

Object Details

Object Name:	CZ_CONFIG_MESSAGES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CZ.CZ_CONFIG_MESSAGES_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

CZ_CONFIG_MESSAGES provides a filtered view of configuration messages to external applications and custom software.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
MESSAGE_SEQ	NUMBER		Yes	Primary key of this table
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
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 MESSAGE_SEQ
,      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
,      CONFIG_ITEM_ID
,      INSTANCE_HDR_ID
,      INSTANCE_REV_NBR
FROM APPS.CZ_CONFIG_MESSAGES_V;

Dependencies

[top of page]

APPS.CZ_CONFIG_MESSAGES_V references the following:

APPS: CZ_CONFIG_MESSAGES

APPS.CZ_CONFIG_MESSAGES_V is not referenced by any database object