Product: | MSD - Demand Planning |
---|---|
Description: | This view is used by the MSDAUDIT form for validation rules. |
Implementation/DBA Data: | APPS.MSD_AUDIT_SQL_STATEMENTS_V |
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.DESCRIPTION1
, AD.DESCRIPTION2
, AD.DESCRIPTION3
, AD.DESCRIPTION4
, AD.DESCRIPTION5
, AD.DESCRIPTION6
, AD.DESCRIPTION7
, AD.DESCRIPTION8
, AD.DESCRIPTION9
, AD.DESCRIPTION10
, 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'