VIEW: APPS.AMS_EVENT_HEADERS_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)