VIEW: APPS.MSD_AUDIT_SQL_STATEMENTS_V

Source

View Text - Preformatted

SELECT ad.statement_id, ad.statement_name, ad.statement_description, flv.meaning, ad.function, ad.application_code, app.application_name, ad.translate, ad.column1, ad.column2, ad.column3, ad.column4, ad.column5, ad.column6, ad.column7, ad.column8, ad.column9, ad.column10, ad.column11, ad.description1, ad.description2, ad.description3, ad.description4, ad.description5, ad.description6, ad.description7, ad.description8, ad.description9, ad.description10, ad.description11, ad.from_clause, ad.where_clause, ad.error_message, ad.summary_message_only, ad.summary_message, ad.summary_token1, ad.summary_token2, ad.summary_token3, ad.summary_token1_value, ad.summary_token2_value, ad.summary_token3_value, ad.enabled FROM msd_audit_sql_statements ad, fnd_application_vl app, fnd_lookup_values_vl flv WHERE ad.application_code = app.APPLICATION_SHORT_NAME and ad.function = flv.lookup_code and flv.lookup_type = 'MSD_AUDIT_REPORT'

View Text - HTML Formatted

SELECT AD.STATEMENT_ID
, AD.STATEMENT_NAME
, AD.STATEMENT_DESCRIPTION
, FLV.MEANING
, AD.FUNCTION
, AD.APPLICATION_CODE
, APP.APPLICATION_NAME
, AD.TRANSLATE
, AD.COLUMN1
, AD.COLUMN2
, AD.COLUMN3
, AD.COLUMN4
, AD.COLUMN5
, AD.COLUMN6
, AD.COLUMN7
, AD.COLUMN8
, AD.COLUMN9
, AD.COLUMN10
, AD.COLUMN11
, AD.DESCRIPTION1
, AD.DESCRIPTION2
, AD.DESCRIPTION3
, AD.DESCRIPTION4
, AD.DESCRIPTION5
, AD.DESCRIPTION6
, AD.DESCRIPTION7
, AD.DESCRIPTION8
, AD.DESCRIPTION9
, AD.DESCRIPTION10
, AD.DESCRIPTION11
, AD.FROM_CLAUSE
, AD.WHERE_CLAUSE
, AD.ERROR_MESSAGE
, AD.SUMMARY_MESSAGE_ONLY
, AD.SUMMARY_MESSAGE
, AD.SUMMARY_TOKEN1
, AD.SUMMARY_TOKEN2
, AD.SUMMARY_TOKEN3
, AD.SUMMARY_TOKEN1_VALUE
, AD.SUMMARY_TOKEN2_VALUE
, AD.SUMMARY_TOKEN3_VALUE
, AD.ENABLED
FROM MSD_AUDIT_SQL_STATEMENTS AD
, FND_APPLICATION_VL APP
, FND_LOOKUP_VALUES_VL FLV
WHERE AD.APPLICATION_CODE = APP.APPLICATION_SHORT_NAME
AND AD.FUNCTION = FLV.LOOKUP_CODE
AND FLV.LOOKUP_TYPE = 'MSD_AUDIT_REPORT'