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.IEC_G_VOICE_MESSAGES_V

Object Details

Object Name:	IEC_G_VOICE_MESSAGES_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

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

view for voice message

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
VOICE_MESSAGE_ID	NUMBER	(15)	Yes	PK for iec_g_voice_messages
NAME	VARCHAR2	(32)	Yes	voice message name
DESCRIPTION	VARCHAR2	(240)		message description
VOICE_MESSAGE_TYPE	VARCHAR2	(30)	Yes	Message type. from IEC_VOICE_MSG
MESSAGE_FORMAT	VARCHAR2	(32)	Yes	message format
MESSAGE_BODY	BLOB	(4000)		message body

Query Text

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


SELECT VOICE_MESSAGE_ID
,      NAME
,      DESCRIPTION
,      VOICE_MESSAGE_TYPE
,      MESSAGE_FORMAT
,      MESSAGE_BODY
FROM APPS.IEC_G_VOICE_MESSAGES_V;

Dependencies

[top of page]

APPS.IEC_G_VOICE_MESSAGES_V references the following:

APPS: IEC_G_VOICE_MESSAGES

APPS.IEC_G_VOICE_MESSAGES_V is not referenced by any database object