[Home] [Help] [Dependency Information]
Object Name: | MSD_AUDIT_SQL_STATEMENTS# |
---|---|
Object Type: | VIEW |
Owner: | MSD |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
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#;
|
|
|