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: MSD.MSD_AUDIT_SQL_STATEMENTS#

Object Details

Object Name:	MSD_AUDIT_SQL_STATEMENTS#
Object Type:	VIEW
Owner:	MSD
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
STATEMENT_ID	NUMBER		Yes
STATEMENT_NAME	VARCHAR2	(50)
STATEMENT_DESCRIPTION	VARCHAR2	(240)	Yes
APPLICATION_CODE	VARCHAR2	(10)	Yes
FUNCTION	VARCHAR2	(40)	Yes
TRANSLATE	VARCHAR2	(1)
COLUMN1	VARCHAR2	(200)	Yes
COLUMN2	VARCHAR2	(200)
COLUMN3	VARCHAR2	(200)
COLUMN4	VARCHAR2	(200)
COLUMN5	VARCHAR2	(200)
COLUMN6	VARCHAR2	(200)
COLUMN7	VARCHAR2	(200)
COLUMN8	VARCHAR2	(200)
COLUMN9	VARCHAR2	(200)
COLUMN10	VARCHAR2	(200)
DESCRIPTION1	VARCHAR2	(50)
DESCRIPTION2	VARCHAR2	(50)
DESCRIPTION3	VARCHAR2	(50)
DESCRIPTION4	VARCHAR2	(50)
DESCRIPTION5	VARCHAR2	(50)
DESCRIPTION6	VARCHAR2	(50)
DESCRIPTION7	VARCHAR2	(50)
DESCRIPTION8	VARCHAR2	(50)
DESCRIPTION9	VARCHAR2	(50)
DESCRIPTION10	VARCHAR2	(50)
FROM_CLAUSE	VARCHAR2	(4000)	Yes
WHERE_CLAUSE	VARCHAR2	(4000)
ERROR_MESSAGE	VARCHAR2	(40)
SUMMARY_MESSAGE_ONLY	VARCHAR2	(1)
SUMMARY_MESSAGE	VARCHAR2	(40)
SUMMARY_TOKEN1	VARCHAR2	(40)
SUMMARY_TOKEN2	VARCHAR2	(40)
SUMMARY_TOKEN3	VARCHAR2	(40)
SUMMARY_TOKEN1_VALUE	VARCHAR2	(200)
SUMMARY_TOKEN2_VALUE	VARCHAR2	(200)
SUMMARY_TOKEN3_VALUE	VARCHAR2	(200)
ENABLED	VARCHAR2	(1)
COLUMN11	VARCHAR2	(200)
DESCRIPTION11	VARCHAR2	(50)

Query Text

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


SELECT STATEMENT_ID
,      STATEMENT_NAME
,      STATEMENT_DESCRIPTION
,      APPLICATION_CODE
,      FUNCTION
,      TRANSLATE
,      COLUMN1
,      COLUMN2
,      COLUMN3
,      COLUMN4
,      COLUMN5
,      COLUMN6
,      COLUMN7
,      COLUMN8
,      COLUMN9
,      COLUMN10
,      DESCRIPTION1
,      DESCRIPTION2
,      DESCRIPTION3
,      DESCRIPTION4
,      DESCRIPTION5
,      DESCRIPTION6
,      DESCRIPTION7
,      DESCRIPTION8
,      DESCRIPTION9
,      DESCRIPTION10
,      FROM_CLAUSE
,      WHERE_CLAUSE
,      ERROR_MESSAGE
,      SUMMARY_MESSAGE_ONLY
,      SUMMARY_MESSAGE
,      SUMMARY_TOKEN1
,      SUMMARY_TOKEN2
,      SUMMARY_TOKEN3
,      SUMMARY_TOKEN1_VALUE
,      SUMMARY_TOKEN2_VALUE
,      SUMMARY_TOKEN3_VALUE
,      ENABLED
,      COLUMN11
,      DESCRIPTION11
FROM MSD.MSD_AUDIT_SQL_STATEMENTS#;

Dependencies

[top of page]

MSD.MSD_AUDIT_SQL_STATEMENTS# references the following:

MSD: MSD_AUDIT_SQL_STATEMENTS

MSD.MSD_AUDIT_SQL_STATEMENTS# is referenced by following:

APPS: MSD_AUDIT_SQL_STATEMENTS