Product: | AMS - Marketing |
---|---|
Description: | This view returns the general information about marketing events (headers). |
Implementation/DBA Data: | APPS.AMS_EVENT_HEADERS_V |
SELECT EVH.ROW_ID
, EVH.EVENT_HEADER_ID
, EVH.EVENT_HEADER_NAME
, EVH.EVENT_MKTG_MESSAGE
, EVH.DESCRIPTION
, EVH.LAST_UPDATE_DATE
, EVH.LAST_UPDATED_BY
, EVH.CREATION_DATE
, EVH.CREATED_BY
, EVH.LAST_UPDATE_LOGIN
, EVH.OBJECT_VERSION_NUMBER
, EVH.EVENT_LEVEL
, EVH.APPLICATION_ID
, EVH.EVENT_TYPE_CODE
, LKUP1.MEANING EVENT_TYPE
, EVH.ACTIVE_FLAG
, EVH.PRIVATE_FLAG
, EVH.USER_STATUS_ID
, AUS.NAME
, EVH.SYSTEM_STATUS_CODE
, EVH.LAST_STATUS_DATE
, EVH.STREAM_TYPE_CODE
, EVH.SOURCE_CODE
, EVH.EVENT_STANDALONE_FLAG
, EVH.DAY_OF_EVENT
, EVH.AGENDA_START_TIME
, EVH.AGENDA_END_TIME
, EVH.REG_REQUIRED_FLAG
, EVH.FUND_SOURCE_TYPE_CODE
, EVH.FUND_SOURCE_ID
, EVH.FUND_SOURCE_TYPE_CODE FUND_SOURCE_NAME
, EVH.FUND_AMOUNT_TC
, EVH.FUND_AMOUNT_FC
, EVH.CURRENCY_CODE_TC
, EVH.CURRENCY_CODE_FC
, EVH.OWNER_USER_ID
, EVH.URL
, EVH.PHONE
, EVH.EMAIL
, EVH.PRIORITY_TYPE_CODE
, EVH.INBOUND_SCRIPT_NAME
, EVH.REG_INVITED_ONLY_FLAG
, EVH.PARTNER_FLAG
, EVH.OVERFLOW_FLAG
, EVH.DURATION
, EVH.DURATION_UOM_CODE
, EVH.ACTIVE_FROM_DATE
, EVH.ACTIVE_TO_DATE
, EVH.REG_MAXIMUM_CAPACITY
, EVH.REG_MINIMUM_CAPACITY
, EVH.MAIN_LANGUAGE_CODE
, LANG.NLS_LANGUAGE
, EVH.CERT_CREDIT_TYPE_CODE
, EVH.CERTIFICATION_CREDITS
, EVH.FORECASTED_REVENUE
, EVH.ACTUAL_REVENUE
, EVH.FORECASTED_COST
, EVH.ACTUAL_COST
, EVH.COORDINATOR_ID
, EVH.REG_CHARGE_FLAG
, EVH.CANCELLATION_REASON_CODE
, EVH.ORGANIZATION_ID
, EVH.INVENTORY_ITEM_ID
, EVH.COUNTRY_CODE
, EVH.BUSINESS_UNIT_ID
, EVH.ACCOUNTS_CLOSED_FLAG
, EVH.EVENT_CALENDAR
, EVH.START_PERIOD_NAME
, EVH.END_PERIOD_NAME
, EVH.GLOBAL_FLAG
, EVH.SETUP_TYPE_ID
, EVH.PROGRAM_ID
, EVH.TASK_ID
, EVH.CREATE_ATTENDANT_LEAD_FLAG
, EVH.CREATE_REGISTRANT_LEAD_FLAG
, EVH.EVENT_PURPOSE_CODE
FROM AMS_EVENT_HEADERS_VL EVH
, AMS_USER_STATUSES_VL AUS
, FND_LANGUAGES_VL LANG
, AMS_LOOKUPS LKUP1
WHERE EVH.EVENT_LEVEL='MAIN'
AND LKUP1.LOOKUP_TYPE(+)='AMS_EVENT_TYPE'
AND LKUP1.LOOKUP_CODE(+)=EVH.EVENT_TYPE_CODE
AND EVH.USER_STATUS_ID=AUS.USER_STATUS_ID
AND EVH.MAIN_LANGUAGE_CODE=LANG.LANGUAGE_CODE(+)