SUS_ACT_VALIDATION_MESSAGES_V

Details

• Schema: FUSION

• Object owner: SUS

• Object type: VIEW

Columns

Name
VALIDATION_MESSAGE_ID ACTIVITY_ID MESSAGE_LEVEL_CODE MESSAGE_LEVEL MESSAGE_SUMMARY_CODE MESSAGE_SUMMARY MESSAGE_CODE EMISSION_TYPE_CODE EMISSION_TYPE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT SAVM.VALIDATION_MESSAGE_ID, SAVM.ACTIVITY_ID, SAVM.MESSAGE_LEVEL_CODE, (select meaning from fnd_lookup_values_vl where lookup_type = 'ORA_SUS_MSG_LEVEL_CODE' and lookup_code = SAVM.MESSAGE_LEVEL_CODE) as MESSAGE_LEVEL, SAVM.MESSAGE_SUMMARY_CODE, (select meaning from fnd_lookup_values_vl where lookup_type = 'ORA_SUS_MSG_SUM_CODE' and lookup_code = SAVM.MESSAGE_SUMMARY_CODE) as MESSAGE_SUMMARY, SAVM.MESSAGE_CODE, SAVM.EMISSION_TYPE_CODE, (select meaning from fnd_lookup_values_vl where lookup_type = 'ORA_SUS_EMISSION_TYPES' and lookup_code = SAVM.EMISSION_TYPE_CODE) as EMISSION_TYPE, SAVM.CREATED_BY, SAVM.CREATION_DATE, SAVM.LAST_UPDATED_BY, SAVM.LAST_UPDATE_DATE, SAVM.LAST_UPDATE_LOGIN, SAVM.OBJECT_VERSION_NUMBER FROM SUS_ACT_VALIDATION_MESSAGES SAVM