DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.MSD_AUDIT_SQL_STATEMENTS_V

Object Details
Object Name: MSD_AUDIT_SQL_STATEMENTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMSD.MSD_AUDIT_SQL_STATEMENTS_V
Subobject Name:
Status: VALID

View Type

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


This view is used by the MSDAUDIT form for validation rules.


[View Source]

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
REPORT_NAME VARCHAR2 (80) Yes Name of audit report
FUNCTION VARCHAR2 (40) Yes Function
APPLICATION_CODE VARCHAR2 (10) Yes Application code eg MSD
APPLICATION_NAME VARCHAR2 (240) Yes Application name
TRANSLATE VARCHAR2 (1)
Should messages be translated Y/N
COLUMN1 VARCHAR2 (200) Yes Column of select query
COLUMN2 VARCHAR2 (200)
Column of select query
COLUMN3 VARCHAR2 (200)
Column of select query
COLUMN4 VARCHAR2 (200)
Column of select query
COLUMN5 VARCHAR2 (200)
Column of select query
COLUMN6 VARCHAR2 (200)
Column of select query
COLUMN7 VARCHAR2 (200)
Column of select query
COLUMN8 VARCHAR2 (200)
Column of select query
COLUMN9 VARCHAR2 (200)
Column of select query
COLUMN10 VARCHAR2 (200)
Column of select query
COLUMN11 VARCHAR2 (200)
Column of select query
DESCRIPTION1 VARCHAR2 (50)
Column header
DESCRIPTION2 VARCHAR2 (50)
Column header
DESCRIPTION3 VARCHAR2 (50)
Column header
DESCRIPTION4 VARCHAR2 (50)
Column header
DESCRIPTION5 VARCHAR2 (50)
Column header
DESCRIPTION6 VARCHAR2 (50)
Column header
DESCRIPTION7 VARCHAR2 (50)
Column header
DESCRIPTION8 VARCHAR2 (50)
Column header
DESCRIPTION9 VARCHAR2 (50)
Column header
DESCRIPTION10 VARCHAR2 (50)
Column header
DESCRIPTION11 VARCHAR2 (50)
Column header
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 error
SUMMARY_MESSAGE_ONLY VARCHAR2 (1)
Show only 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)
Query Text

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


SELECT STATEMENT_ID
,      STATEMENT_NAME
,      STATEMENT_DESCRIPTION
,      REPORT_NAME
,      FUNCTION
,      APPLICATION_CODE
,      APPLICATION_NAME
,      TRANSLATE
,      COLUMN1
,      COLUMN2
,      COLUMN3
,      COLUMN4
,      COLUMN5
,      COLUMN6
,      COLUMN7
,      COLUMN8
,      COLUMN9
,      COLUMN10
,      COLUMN11
,      DESCRIPTION1
,      DESCRIPTION2
,      DESCRIPTION3
,      DESCRIPTION4
,      DESCRIPTION5
,      DESCRIPTION6
,      DESCRIPTION7
,      DESCRIPTION8
,      DESCRIPTION9
,      DESCRIPTION10
,      DESCRIPTION11
,      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
FROM APPS.MSD_AUDIT_SQL_STATEMENTS_V;

Dependencies

[top of page]

APPS.MSD_AUDIT_SQL_STATEMENTS_V references the following:

SchemaAPPS
ViewFND_APPLICATION_VL
ViewFND_LOOKUP_VALUES_VL
SynonymMSD_AUDIT_SQL_STATEMENTS

APPS.MSD_AUDIT_SQL_STATEMENTS_V is not referenced by any database object