Product: | AS - Sales Foundation |
---|---|
Description: | Event letters view |
Implementation/DBA Data: | Not implemented in this database |
SELECT EVNTLET.ROWID
, EVNTLET.EVENT_LETTER_ID
, EVNTLET.LAST_UPDATE_DATE
, EVNTLET.LAST_UPDATED_BY
, EVNTLET.CREATION_DATE
, EVNTLET.CREATED_BY
, EVNTLET.LAST_UPDATE_LOGIN
, EVNTLET.REQUEST_ID
, EVNTLET.PROGRAM_APPLICATION_ID
, EVNTLET.PROGRAM_ID
, EVNTLET.PROGRAM_UPDATE_DATE
, EVNTLET.EVENT_ID
, EVNTLET.LETTER_ID
, EVNTLET.TYPE_CODE
, EVNTLET.ENROLLMENT_STATUS_CODE
, EVNTLET.COMPLETED_FLAG
, EVNTLET.MAIL_DATE
, EVNTLET.ATTRIBUTE_CATEGORY
, EVNTLET.ATTRIBUTE1
, EVNTLET.ATTRIBUTE2
, EVNTLET.ATTRIBUTE3
, EVNTLET.ATTRIBUTE4
, EVNTLET.ATTRIBUTE5
, EVNTLET.ATTRIBUTE6
, EVNTLET.ATTRIBUTE7
, EVNTLET.ATTRIBUTE8
, EVNTLET.ATTRIBUTE9
, EVNTLET.ATTRIBUTE10
, EVNTLET.ATTRIBUTE11
, EVNTLET.ATTRIBUTE12
, EVNTLET.ATTRIBUTE13
, EVNTLET.ATTRIBUTE14
, EVNTLET.ATTRIBUTE15
, PROM.NAME
, PROM.CODE
, ASLKP1.MEANING
, ASLKP2.MEANING
FROM AS_EVENT_LETTERS EVNTLET
, AS_PROMOTIONS PROM
, AS_LOOKUPS ASLKP1
, AS_LOOKUPS ASLKP2
WHERE EVNTLET.LETTER_ID = PROM.PROMOTION_ID
AND PROM.TYPE = 'L'
AND EVNTLET.TYPE_CODE = ASLKP1.LOOKUP_CODE
AND ASLKP1.LOOKUP_TYPE = 'EVENT_LETTER_TYPE'
AND EVNTLET.ENROLLMENT_STATUS_CODE = ASLKP2.LOOKUP_CODE
AND ASLKP2.LOOKUP_TYPE = 'EVENT_ENROLLMENT_STATUS'