Product: | AS - Sales Foundation |
---|---|
Description: | Events view |
Implementation/DBA Data: | Not implemented in this database |
SELECT PROM.ROWID
, PROM.PROMOTION_ID
, PROM.CODE
, PROM.LAST_UPDATE_DATE
, PROM.LAST_UPDATED_BY
, PROM.CREATION_DATE
, PROM.CREATED_BY
, PROM.LAST_UPDATE_LOGIN
, PROM.NAME
, PROM.TYPE
, PROM.STATUS
, PROM.LANGUAGE
, PROM.ENABLED_FLAG
, PROM.CURRENCY_CODE
, PROM.EXPECTED_PROMOTION_COST
, PROM.ACTUAL_PROMOTION_COST
, PROM.EXPECTED_NUM_OF_RESPONSES
, PROM.OWNER_PERSON_ID
, PROM.EVENT_COORDIN_PERSON_ID
, PROM.EVENT_FACILITY_ID
, PROM.EVENT_FAC_STAFF_ID
, PROM.EVENT_FAC_STAFF_LAST
, PROM.EVENT_FAC_STAFF_FIRST
, PROM.EVENT_FAC_STAFF_ACODE
, PROM.EVENT_FAC_STAFF_PHONE
, PROM.EVENT_FAC_STAFF_EXT
, PROM.EVENT_FAC_ROOM_ID
, PROM.EVENT_FAC_ROOM_NAME
, PROM.EVENT_NAME_ID
, PROM.EVENT_START_DATE
, PROM.EVENT_END_DATE
, PROM.EVENT_START_TIME
, PROM.EVENT_END_TIME
, PROM.EVENT_REG_TIME
, PROM.EVENT_ENROLLMENT_FEE
, PROM.EVENT_ENROLLMENT_FROZEN_FLAG
, PROM.EVENT_MAX_ATTENDEES
, PROM.EVENT_OVERBOOK_PERCENT
, PROM.EVENT_NUM_REGISTERED
, PROM.EVENT_FOOD_AVAILABLE_FLAG
, PROM.EVENT_SCRIPT_ID
, PROM.EVENT_MAILBLITZ_ID
, PROM.LONG_DESCRIPTION
, PROM.COMMENTS
, PROM.ATTRIBUTE_CATEGORY
, PROM.ATTRIBUTE1
, PROM.ATTRIBUTE2
, PROM.ATTRIBUTE3
, PROM.ATTRIBUTE4
, PROM.ATTRIBUTE5
, PROM.ATTRIBUTE6
, PROM.ATTRIBUTE7
, PROM.ATTRIBUTE8
, PROM.ATTRIBUTE9
, PROM.ATTRIBUTE10
, PROM.ATTRIBUTE11
, PROM.ATTRIBUTE12
, PROM.ATTRIBUTE13
, PROM.ATTRIBUTE14
, PROM.ATTRIBUTE15
, ASLKP1.MEANING
, ASLKP2.MEANING
, OWNER_PER.FIRST_NAME
, OWNER_PER.LAST_NAME
, COORD_PER.FIRST_NAME
, COORD_PER.LAST_NAME
, EVNTFAC.CODE
, EVNTFAC.NAME
, EVNTFAC.CITY
, EVNTFAC.STATE
, EVNTFAC.ADDRESS1
, EVNTFAC.ADDRESS2
, EVNTFAC.ADDRESS3
, EVNTFAC.ADDRESS4
, EVNTFAC.POSTAL_CODE
, EVNTFAC.PROVINCE
, EVNTFAC.COUNTY
, FNDTERR.TERRITORY_SHORT_NAME
, EVNTFAC.COUNTRY_CODE
, EVNTFAC.AREA_CODE
, EVNTFAC.PHONE_NUMBER
, EVNTFAC.EXTENSION
, EVNTFAC.DIRECTIONS
, EVNTNAM.NAME
, EVNTNAM.DESCRIPTION
, PROM_SCR.CODE
, PROM_SCR.NAME
, PROM_MAILB.CODE
, PROM_MAILB.NAME
FROM AS_LOOKUPS ASLKP1
, AS_LOOKUPS ASLKP2
, AS_PROMOTIONS PROM
, PER_ALL_PEOPLE_F OWNER_PER
, PER_ALL_PEOPLE_F COORD_PER
, AS_EVENT_FACILITIES EVNTFAC
, AS_EVENT_NAMES EVNTNAM
, AS_PROMOTIONS PROM_SCR
, AS_PROMOTIONS PROM_MAILB
, FND_TERRITORIES_TL FNDTERR
WHERE PROM.TYPE = 'E'
AND PROM.STATUS = ASLKP1.LOOKUP_CODE(+)
AND ASLKP1.LOOKUP_TYPE(+) = 'EVENT_STATUS'
AND PROM.LANGUAGE = ASLKP2.LOOKUP_CODE(+)
AND ASLKP2.LOOKUP_TYPE(+) = 'LANGUAGE'
AND PROM.OWNER_PERSON_ID = OWNER_PER.PERSON_ID(+)
AND TRUNC(SYSDATE) BETWEEN OWNER_PER.EFFECTIVE_START_DATE(+)
AND OWNER_PER.EFFECTIVE_END_DATE(+)
AND PROM.EVENT_COORDIN_PERSON_ID = COORD_PER.PERSON_ID(+)
AND TRUNC(SYSDATE) BETWEEN COORD_PER.EFFECTIVE_START_DATE(+)
AND COORD_PER.EFFECTIVE_END_DATE(+)
AND PROM.EVENT_FACILITY_ID = EVNTFAC.EVENT_FACILITY_ID(+)
AND PROM.EVENT_NAME_ID = EVNTNAM.EVENT_NAME_ID(+)
AND PROM.EVENT_SCRIPT_ID = PROM_SCR.PROMOTION_ID(+)
AND PROM.EVENT_MAILBLITZ_ID = PROM_MAILB.PROMOTION_ID(+)
AND (EVNTFAC.COUNTRY_CODE = FNDTERR.TERRITORY_CODE(+) AND FNDTERR.LANGUAGE(+) = USERENV('LANG'))