Product: | AMS - Marketing |
---|---|
Description: | This view returns details of marketing messages. |
Implementation/DBA Data: | APPS.AMS_MESSAGES_V |
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