VIEW: APPS.AMS_MESSAGES_V

Source

View Text - Preformatted

SELECT AMSG.MESSAGE_ID, AMSG.LAST_UPDATE_DATE, AMSG.LAST_UPDATED_BY, AMSG.CREATION_DATE, AMSG.CREATED_BY, AMSG.LAST_UPDATE_LOGIN, AMSG.OBJECT_VERSION_NUMBER, AMSG.DATE_EFFECTIVE_FROM, AMSG.DATE_EFFECTIVE_TO, AMSG.ACTIVE_FLAG, AMSG.MESSAGE_TYPE_CODE, LKUP1.meaning, AMSG.OWNER_USER_ID, ERSC.FULL_NAME, AMSG.MESSAGE_NAME, AMSG.DESCRIPTION, AMSG.COUNTRY_ID, AMSG.CUSTOM_SETUP_ID, AMSG.ATTRIBUTE_CATEGORY, AMSG.ATTRIBUTE1, AMSG.ATTRIBUTE2, AMSG.ATTRIBUTE3, AMSG.ATTRIBUTE4, AMSG.ATTRIBUTE5, AMSG.ATTRIBUTE6, AMSG.ATTRIBUTE7, AMSG.ATTRIBUTE8, AMSG.ATTRIBUTE9, AMSG.ATTRIBUTE10, AMSG.ATTRIBUTE11, AMSG.ATTRIBUTE12, AMSG.ATTRIBUTE13, AMSG.ATTRIBUTE14, AMSG.ATTRIBUTE15 from AMS_MESSAGES_VL AMSG, AMS_JTF_RS_EMP_V ERSC, AMS_LOOKUPS LKUP1 WHERE AMSG.OWNER_USER_ID = ERSC.RESOURCE_ID AND LKUP1.LOOKUP_TYPE = 'AMS_MESSAGE_TYPE' AND LKUP1.LOOKUP_CODE = AMSG.MESSAGE_TYPE_CODE

View Text - HTML Formatted

SELECT AMSG.MESSAGE_ID
, AMSG.LAST_UPDATE_DATE
, AMSG.LAST_UPDATED_BY
, AMSG.CREATION_DATE
, AMSG.CREATED_BY
, AMSG.LAST_UPDATE_LOGIN
, AMSG.OBJECT_VERSION_NUMBER
, AMSG.DATE_EFFECTIVE_FROM
, AMSG.DATE_EFFECTIVE_TO
, AMSG.ACTIVE_FLAG
, AMSG.MESSAGE_TYPE_CODE
, LKUP1.MEANING
, AMSG.OWNER_USER_ID
, ERSC.FULL_NAME
, AMSG.MESSAGE_NAME
, AMSG.DESCRIPTION
, AMSG.COUNTRY_ID
, AMSG.CUSTOM_SETUP_ID
, AMSG.ATTRIBUTE_CATEGORY
, AMSG.ATTRIBUTE1
, AMSG.ATTRIBUTE2
, AMSG.ATTRIBUTE3
, AMSG.ATTRIBUTE4
, AMSG.ATTRIBUTE5
, AMSG.ATTRIBUTE6
, AMSG.ATTRIBUTE7
, AMSG.ATTRIBUTE8
, AMSG.ATTRIBUTE9
, AMSG.ATTRIBUTE10
, AMSG.ATTRIBUTE11
, AMSG.ATTRIBUTE12
, AMSG.ATTRIBUTE13
, AMSG.ATTRIBUTE14
, AMSG.ATTRIBUTE15
FROM AMS_MESSAGES_VL AMSG
, AMS_JTF_RS_EMP_V ERSC
, AMS_LOOKUPS LKUP1
WHERE AMSG.OWNER_USER_ID = ERSC.RESOURCE_ID
AND LKUP1.LOOKUP_TYPE = 'AMS_MESSAGE_TYPE'
AND LKUP1.LOOKUP_CODE = AMSG.MESSAGE_TYPE_CODE