VIEW: APPS.AMS_EVENT_OFFERS_V

Source

View Text - Preformatted

SELECT EVO.ROW_ID, EVO.EVENT_TYPE_CODE, LKUP4.MEANING EVENT_TYPE, EVO.INBOUND_SCRIPT_NAME, EVO.REG_MINIMUM_CAPACITY, EVO.REG_MINIMUM_REQ_BY_DATE, EVO.ORGANIZATION_ID, EVO.INVENTORY_ITEM_ID, EVO.PRICELIST_HEADER_ID, EVO.PRICELIST_LINE_ID, EVO.WAITLIST_ACTION_TYPE_CODE, EVO.STREAM_TYPE_CODE, EVO.OWNER_USER_ID, EVO.EVENT_FULL_FLAG, EVO.EVENT_OFFER_ID, EVO.SETUP_TYPE_ID, EVO.LAST_UPDATE_DATE, EVO.LAST_UPDATED_BY, EVO.CREATION_DATE, EVO.CREATED_BY, EVO.LAST_UPDATE_LOGIN, EVO.OBJECT_VERSION_NUMBER, EVO.APPLICATION_ID, EVO.EVENT_HEADER_ID, EVH.EVENT_HEADER_NAME, EVO.PRIVATE_FLAG, EVO.ACTIVE_FLAG, EVO.SOURCE_CODE, EVO.EVENT_LEVEL, EVO.USER_STATUS_ID, AUS.NAME, EVO.LAST_STATUS_DATE, EVO.SYSTEM_STATUS_CODE, EVO.EVENT_DELIVERY_METHOD_ID, ADM.DELIVERY_MEDIA_TYPE_CODE, EVO.EVENT_REQUIRED_FLAG, EVO.EVENT_LANGUAGE_CODE, LANG.NLS_LANGUAGE, EVO.EVENT_VENUE_ID, AVN.VENUE_NAME, EVO.EVENT_LOCATION_ID, HZL.CITY||', '||HZL.STATE||', '||HZL.COUNTRY, HZL.CITY, HZL.STATE, HZL.PROVINCE, HZL.COUNTRY, EVO.OVERFLOW_FLAG, EVO.PARTNER_FLAG, EVO.EVENT_STANDALONE_FLAG, EVO.REG_FROZEN_FLAG, EVO.REG_REQUIRED_FLAG, EVO.REG_CHARGE_FLAG, EVO.REG_INVITED_ONLY_FLAG, EVO.REG_WAITLIST_ALLOWED_FLAG, EVO.REG_OVERBOOK_ALLOWED_FLAG, EVO.AUTO_REGISTER_FLAG, EVO.EVENT_DURATION, EVO.EVENT_DURATION_UOM_CODE, EVO.EVENT_START_DATE, EVO.EVENT_START_DATE_TIME, EVO.EVENT_END_DATE, EVO.EVENT_END_DATE_TIME, EVO.REG_START_DATE, EVO.REG_START_TIME, EVO.REG_END_DATE, EVO.REG_END_TIME, EVO.REG_MAXIMUM_CAPACITY, EVO.REG_OVERBOOK_PCT, EVO.REG_EFFECTIVE_CAPACITY, EVO.REG_WAITLIST_PCT, EVO.ACTUAL_REVENUE, EVO.FORECASTED_REVENUE, EVO.FORECASTED_COST, EVO.ACTUAL_COST, EVO.FUND_SOURCE_TYPE_CODE, EVO.FUND_SOURCE_ID, EVO.FUND_AMOUNT_TC, EVO.FUND_AMOUNT_FC, EVO.CURRENCY_CODE_TC, EVO.CURRENCY_CODE_FC, EVO.CERT_CREDIT_TYPE_CODE, EVO.CERTIFICATION_CREDITS, EVO.COORDINATOR_ID, EVO.PRIORITY_TYPE_CODE, EVO.URL, EVO.PHONE, EVO.EMAIL, EVO.TIMEZONE_ID, HTZ.NAME, EVO.EVENT_OFFER_NAME, EVO.EVENT_MKTG_MESSAGE, EVO.DESCRIPTION, EVO.COUNTRY_CODE, EVO.BUSINESS_UNIT_ID, EVO.ACCOUNTS_CLOSED_FLAG, EVO.EVENT_CALENDAR, EVO.START_PERIOD_NAME, EVO.END_PERIOD_NAME, EVO.GLOBAL_FLAG, EVO.TASK_ID, EVO.PARENT_TYPE, EVO.PARENT_ID, EVO.CREATE_ATTENDANT_LEAD_FLAG, EVO.CREATE_REGISTRANT_LEAD_FLAG, EVO.EVENT_PURPOSE_CODE from AMS_EVENT_OFFERS_VL EVO, AMS_EVENT_HEADERS_VL EVH, AMS_USER_STATUSES_VL AUS, FND_LANGUAGES_VL LANG, AMS_ACT_DELIVERY_METHODS_V ADM, HZ_TIMEZONES_VL HTZ, HZ_LOCATIONS HZL, AMS_VENUES_VL AVN, AMS_LOOKUPS LKUP4 WHERE EVO.EVENT_LEVEL='MAIN' AND EVO.EVENT_HEADER_ID=EVH.EVENT_HEADER_ID AND EVO.USER_STATUS_ID=AUS.USER_STATUS_ID AND EVO.EVENT_LANGUAGE_CODE=LANG.LANGUAGE_CODE(+) AND LKUP4.LOOKUP_TYPE(+)='AMS_EVENT_TYPE' AND LKUP4.LOOKUP_CODE(+)=EVO.EVENT_TYPE_CODE AND EVO.TIMEZONE_ID=HTZ.TIMEZONE_ID(+) AND EVO.EVENT_DELIVERY_METHOD_ID=ADM.ACTIVITY_DELIVERY_METHOD_ID(+) AND EVO.EVENT_LOCATION_ID=HZL.LOCATION_ID(+) AND EVO.EVENT_VENUE_ID=AVN.VENUE_ID(+)

View Text - HTML Formatted

SELECT EVO.ROW_ID
, EVO.EVENT_TYPE_CODE
, LKUP4.MEANING EVENT_TYPE
, EVO.INBOUND_SCRIPT_NAME
, EVO.REG_MINIMUM_CAPACITY
, EVO.REG_MINIMUM_REQ_BY_DATE
, EVO.ORGANIZATION_ID
, EVO.INVENTORY_ITEM_ID
, EVO.PRICELIST_HEADER_ID
, EVO.PRICELIST_LINE_ID
, EVO.WAITLIST_ACTION_TYPE_CODE
, EVO.STREAM_TYPE_CODE
, EVO.OWNER_USER_ID
, EVO.EVENT_FULL_FLAG
, EVO.EVENT_OFFER_ID
, EVO.SETUP_TYPE_ID
, EVO.LAST_UPDATE_DATE
, EVO.LAST_UPDATED_BY
, EVO.CREATION_DATE
, EVO.CREATED_BY
, EVO.LAST_UPDATE_LOGIN
, EVO.OBJECT_VERSION_NUMBER
, EVO.APPLICATION_ID
, EVO.EVENT_HEADER_ID
, EVH.EVENT_HEADER_NAME
, EVO.PRIVATE_FLAG
, EVO.ACTIVE_FLAG
, EVO.SOURCE_CODE
, EVO.EVENT_LEVEL
, EVO.USER_STATUS_ID
, AUS.NAME
, EVO.LAST_STATUS_DATE
, EVO.SYSTEM_STATUS_CODE
, EVO.EVENT_DELIVERY_METHOD_ID
, ADM.DELIVERY_MEDIA_TYPE_CODE
, EVO.EVENT_REQUIRED_FLAG
, EVO.EVENT_LANGUAGE_CODE
, LANG.NLS_LANGUAGE
, EVO.EVENT_VENUE_ID
, AVN.VENUE_NAME
, EVO.EVENT_LOCATION_ID
, HZL.CITY||'
, '||HZL.STATE||'
, '||HZL.COUNTRY
, HZL.CITY
, HZL.STATE
, HZL.PROVINCE
, HZL.COUNTRY
, EVO.OVERFLOW_FLAG
, EVO.PARTNER_FLAG
, EVO.EVENT_STANDALONE_FLAG
, EVO.REG_FROZEN_FLAG
, EVO.REG_REQUIRED_FLAG
, EVO.REG_CHARGE_FLAG
, EVO.REG_INVITED_ONLY_FLAG
, EVO.REG_WAITLIST_ALLOWED_FLAG
, EVO.REG_OVERBOOK_ALLOWED_FLAG
, EVO.AUTO_REGISTER_FLAG
, EVO.EVENT_DURATION
, EVO.EVENT_DURATION_UOM_CODE
, EVO.EVENT_START_DATE
, EVO.EVENT_START_DATE_TIME
, EVO.EVENT_END_DATE
, EVO.EVENT_END_DATE_TIME
, EVO.REG_START_DATE
, EVO.REG_START_TIME
, EVO.REG_END_DATE
, EVO.REG_END_TIME
, EVO.REG_MAXIMUM_CAPACITY
, EVO.REG_OVERBOOK_PCT
, EVO.REG_EFFECTIVE_CAPACITY
, EVO.REG_WAITLIST_PCT
, EVO.ACTUAL_REVENUE
, EVO.FORECASTED_REVENUE
, EVO.FORECASTED_COST
, EVO.ACTUAL_COST
, EVO.FUND_SOURCE_TYPE_CODE
, EVO.FUND_SOURCE_ID
, EVO.FUND_AMOUNT_TC
, EVO.FUND_AMOUNT_FC
, EVO.CURRENCY_CODE_TC
, EVO.CURRENCY_CODE_FC
, EVO.CERT_CREDIT_TYPE_CODE
, EVO.CERTIFICATION_CREDITS
, EVO.COORDINATOR_ID
, EVO.PRIORITY_TYPE_CODE
, EVO.URL
, EVO.PHONE
, EVO.EMAIL
, EVO.TIMEZONE_ID
, HTZ.NAME
, EVO.EVENT_OFFER_NAME
, EVO.EVENT_MKTG_MESSAGE
, EVO.DESCRIPTION
, EVO.COUNTRY_CODE
, EVO.BUSINESS_UNIT_ID
, EVO.ACCOUNTS_CLOSED_FLAG
, EVO.EVENT_CALENDAR
, EVO.START_PERIOD_NAME
, EVO.END_PERIOD_NAME
, EVO.GLOBAL_FLAG
, EVO.TASK_ID
, EVO.PARENT_TYPE
, EVO.PARENT_ID
, EVO.CREATE_ATTENDANT_LEAD_FLAG
, EVO.CREATE_REGISTRANT_LEAD_FLAG
, EVO.EVENT_PURPOSE_CODE
FROM AMS_EVENT_OFFERS_VL EVO
, AMS_EVENT_HEADERS_VL EVH
, AMS_USER_STATUSES_VL AUS
, FND_LANGUAGES_VL LANG
, AMS_ACT_DELIVERY_METHODS_V ADM
, HZ_TIMEZONES_VL HTZ
, HZ_LOCATIONS HZL
, AMS_VENUES_VL AVN
, AMS_LOOKUPS LKUP4
WHERE EVO.EVENT_LEVEL='MAIN'
AND EVO.EVENT_HEADER_ID=EVH.EVENT_HEADER_ID
AND EVO.USER_STATUS_ID=AUS.USER_STATUS_ID
AND EVO.EVENT_LANGUAGE_CODE=LANG.LANGUAGE_CODE(+)
AND LKUP4.LOOKUP_TYPE(+)='AMS_EVENT_TYPE'
AND LKUP4.LOOKUP_CODE(+)=EVO.EVENT_TYPE_CODE
AND EVO.TIMEZONE_ID=HTZ.TIMEZONE_ID(+)
AND EVO.EVENT_DELIVERY_METHOD_ID=ADM.ACTIVITY_DELIVERY_METHOD_ID(+)
AND EVO.EVENT_LOCATION_ID=HZL.LOCATION_ID(+)
AND EVO.EVENT_VENUE_ID=AVN.VENUE_ID(+)