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

Object Details

Object Name:	MSD_AUDIT_SQL_STATEMENTS
Object Type:	TABLE
Owner:	MSD
FND Design Data:	MSD.MSD_AUDIT_SQL_STATEMENTS
Subobject Name:
Status:	VALID

This table forms the basis for the Validation Rules architecture. Each row can be interpreted as a valid sql query. A concurrent program picks up selective queries from this table (based on FUNCTION and APPLICATION_CODE), runs them, and leaves HTML output in the output file of the reqest.
The FUNCTION column allows for the grouping of validation queries to define a complete audit report.
The COLUMN columns may contain function calls or HTML tags to format the output. The description columns contain the column header - HTML tags are allowed, if the user wishes to see formatted column headers.
The FROM and WHERE columns contain the FROM and WHERE clauses of the query.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSD_AUDIT_SQL_STATEMENTS_U1	NORMAL	NONUNIQUE	APPS_TS_SEED	STATEMENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
STATEMENT_ID	NUMBER		Yes	Statement id
STATEMENT_NAME	VARCHAR2	(50)		Name of statement
STATEMENT_DESCRIPTION	VARCHAR2	(240)	Yes	Statement description - this will be written to the log file when this validation query is run
APPLICATION_CODE	VARCHAR2	(10)	Yes	Application code for this query (eg MSD)
FUNCTION	VARCHAR2	(40)	Yes	Key to group queries by function (eg FACT_DATA for fact data validation)
TRANSLATE	VARCHAR2	(1)		Translate column headers, statement message
COLUMN1	VARCHAR2	(200)	Yes	column for select query - may include function calls, HTML tags etc.
COLUMN2	VARCHAR2	(200)		column for select query - may include function calls, HTML tags etc.
COLUMN3	VARCHAR2	(200)		column for select query - may include function calls, HTML tags etc.
COLUMN4	VARCHAR2	(200)		column for select query - may include function calls, HTML tags etc.
COLUMN5	VARCHAR2	(200)		column for select query - may include function calls, HTML tags etc.
COLUMN6	VARCHAR2	(200)		column for select query - may include function calls, HTML tags etc.
COLUMN7	VARCHAR2	(200)		column for select query - may include function calls, HTML tags etc.
COLUMN8	VARCHAR2	(200)		column for select query - may include function calls, HTML tags etc.
COLUMN9	VARCHAR2	(200)		column for select query - may include function calls, HTML tags etc.
COLUMN10	VARCHAR2	(200)		column for select query - may include function calls, HTML tags etc.
DESCRIPTION1	VARCHAR2	(50)		Column heading
DESCRIPTION2	VARCHAR2	(50)		Column heading
DESCRIPTION3	VARCHAR2	(50)		Column heading
DESCRIPTION4	VARCHAR2	(50)		Column heading
DESCRIPTION5	VARCHAR2	(50)		Column heading
DESCRIPTION6	VARCHAR2	(50)		Column heading
DESCRIPTION7	VARCHAR2	(50)		Column heading
DESCRIPTION8	VARCHAR2	(50)		Column heading
DESCRIPTION9	VARCHAR2	(50)		Column heading
DESCRIPTION10	VARCHAR2	(50)		Column heading
FROM_CLAUSE	VARCHAR2	(4000)	Yes	FROM clause of SELECT query
WHERE_CLAUSE	VARCHAR2	(4000)		WHERE clause of select query
ERROR_MESSAGE	VARCHAR2	(40)		FND message for the error statement.
SUMMARY_MESSAGE_ONLY	VARCHAR2	(1)		Should output be just the summary message? Y/N
SUMMARY_MESSAGE	VARCHAR2	(40)		FND message for summary
SUMMARY_TOKEN1	VARCHAR2	(40)		Token for summary message
SUMMARY_TOKEN2	VARCHAR2	(40)		Token for summary message
SUMMARY_TOKEN3	VARCHAR2	(40)		Token for summary message
SUMMARY_TOKEN1_VALUE	VARCHAR2	(200)		Token 1 value
SUMMARY_TOKEN2_VALUE	VARCHAR2	(200)		Token 2 value
SUMMARY_TOKEN3_VALUE	VARCHAR2	(200)		Token 3 value
ENABLED	VARCHAR2	(1)		Is this statement enabled? (Y/N)
COLUMN11	VARCHAR2	(200)		column for select query - may include function calls, HTML tags etc.
DESCRIPTION11	VARCHAR2	(50)		Column heading

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 does not reference any database object

MSD.MSD_AUDIT_SQL_STATEMENTS is referenced by following:

MSD: MSD_AUDIT_SQL_STATEMENTS#