Product: | ICX - Oracle iProcurement |
---|---|
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
, TO_CHAR(PROM.EVENT_ENROLLMENT_FEE
, FND_CURRENCY.SAFE_GET_FORMAT_MASK( PROM.CURRENCY_CODE
, 30))
, 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_PROMOTIONS PROM
, AS_LOOKUPS ASLKP1
, AS_LOOKUPS ASLKP2
, PER_PEOPLE_X OWNER_PER
, PER_PEOPLE_X COORD_PER
, AS_EVENT_FACILITIES EVNTFAC
, AS_EVENT_NAMES EVNTNAM
, AS_PROMOTIONS PROM_SCR
, AS_PROMOTIONS PROM_MAILB
, FND_TERRITORIES_VL 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 PROM.EVENT_COORDIN_PERSON_ID = COORD_PER.PERSON_ID(+)
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(+))