[Home] [Help] [Dependency Information]
Object Name: | MSD_AUDIT_SQL_STATEMENTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MSD.MSD_AUDIT_SQL_STATEMENTS_V |
Subobject Name: | |
Status: | VALID |
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.
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) |
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;
APPS.MSD_AUDIT_SQL_STATEMENTS_V is not referenced by any database object
|
|
|