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: ECX.ECX_OXTA_LOGMSG#

Object Details

Object Name:	ECX_OXTA_LOGMSG#
Object Type:	VIEW
Owner:	ECX
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
SENDER_MESSAGE_ID	VARCHAR2	(50)	Yes
DIRECTION	VARCHAR2	(3)	Yes
STATUS	VARCHAR2	(15)	Yes
BEGIN_DATE	DATE		Yes
REQUEST_TYPE	VARCHAR2	(15)	Yes
CONTENT_LENGTH	NUMBER
TRANSACTION_TYPE	VARCHAR2	(30)
USERNAME	VARCHAR2	(500)
IP_ADDRESS	VARCHAR2	(15)
PROTOCOL_TYPE	VARCHAR2	(80)
PROTOCOL_ADDRESS	VARCHAR2	(500)
RESULT_CODE	VARCHAR2	(4)
RESULT_TEXT	VARCHAR2	(2000)
RECEIPT_MESSAGE_ID	VARCHAR2	(50)
COMPLETED_DATE	DATE
EXCEPTION_TEXT	VARCHAR2	(2000)

Query Text

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


SELECT SENDER_MESSAGE_ID
,      DIRECTION
,      STATUS
,      BEGIN_DATE
,      REQUEST_TYPE
,      CONTENT_LENGTH
,      TRANSACTION_TYPE
,      USERNAME
,      IP_ADDRESS
,      PROTOCOL_TYPE
,      PROTOCOL_ADDRESS
,      RESULT_CODE
,      RESULT_TEXT
,      RECEIPT_MESSAGE_ID
,      COMPLETED_DATE
,      EXCEPTION_TEXT
FROM ECX.ECX_OXTA_LOGMSG#;

Dependencies

[top of page]

ECX.ECX_OXTA_LOGMSG# references the following:

ECX: ECX_OXTA_LOGMSG

ECX.ECX_OXTA_LOGMSG# is referenced by following:

APPS: ECX_OXTA_LOGMSG