Product: | ICX - Oracle iProcurement |
---|---|
Description: | Enrolled Attendees View |
Implementation/DBA Data: | Not implemented in this database |
SELECT EVNTENR.ROWID
, EVNTENR.EVENT_ENROLLMENT_ID
, EVNTENR.LAST_UPDATE_DATE
, EVNTENR.LAST_UPDATED_BY
, EVNTENR.CREATION_DATE
, EVNTENR.CREATED_BY
, EVNTENR.LAST_UPDATE_LOGIN
, EVNTENR.REQUEST_ID
, EVNTENR.PROGRAM_APPLICATION_ID
, EVNTENR.PROGRAM_ID
, EVNTENR.PROGRAM_UPDATE_DATE
, EVNTENR.CUSTOMER_ID
, EVNTENR.ADDRESS_ID
, EVNTENR.CONTACT_ID
, EVNTENR.EVENT_ID
, EVNTENR.STATUS_CODE
, EVNTENR.NUM_ENROLLED
, EVNTENR.CONFIRMED_FLAG
, EVNTENR.STATUS_CHANGE_FLAG
, EVNTENR.PAYMENT_AMOUNT
, EVNTENR.NUM_ATTENDED
, EVNTENR.SOURCE_PROMOTION_ID
, EVNTENR.ATTRIBUTE_CATEGORY
, EVNTENR.ATTRIBUTE1
, EVNTENR.ATTRIBUTE2
, EVNTENR.ATTRIBUTE3
, EVNTENR.ATTRIBUTE4
, EVNTENR.ATTRIBUTE5
, EVNTENR.ATTRIBUTE6
, EVNTENR.ATTRIBUTE7
, EVNTENR.ATTRIBUTE8
, EVNTENR.ATTRIBUTE9
, EVNTENR.ATTRIBUTE10
, EVNTENR.ATTRIBUTE11
, EVNTENR.ATTRIBUTE12
, EVNTENR.ATTRIBUTE13
, EVNTENR.ATTRIBUTE14
, EVNTENR.ATTRIBUTE15
, CUST.CUSTOMER_NAME
, CONT.LAST_NAME
, CONT.FIRST_NAME
, CONT.JOB_TITLE
, ASLKP1.MEANING
, PHON.PHONE_ID
, PHON.PHONE_NUMBER
, PHON.AREA_CODE
, PHON.EXTENSION
FROM AS_EVENT_ENROLLMENTS EVNTENR
, AS_LOOKUPS ASLKP1
, RA_CUSTOMERS CUST
, RA_CONTACTS CONT
, RA_PHONES PHON
WHERE EVNTENR.STATUS_CODE = ASLKP1.LOOKUP_CODE
AND ASLKP1.LOOKUP_TYPE = 'EVENT_ENROLLMENT_STATUS'
AND EVNTENR.CUSTOMER_ID = CUST.CUSTOMER_ID
AND EVNTENR.CONTACT_ID = CONT.CONTACT_ID
AND EVNTENR.CONTACT_ID = PHON.CONTACT_ID(+)
AND PHON.PRIMARY_FLAG(+) = 'Y'
AND PHON.STATUS(+) = 'A'