Product: | AMS - Marketing |
---|---|
Description: | This view returns the general information about marketing event headers agenda. |
Implementation/DBA Data: | APPS.AMS_EVENT_HEADERS_AGENDA_V |
SELECT EVH.ROW_ID
, EVH.EVENT_HEADER_ID
, EVH.EVENT_HEADER_NAME
, EVH.DESCRIPTION
, EVH.PARENT_EVENT_HEADER_ID
, PEVH.EVENT_HEADER_NAME
, PEVH.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.ACTIVE_FLAG
, EVH.PRIVATE_FLAG
, EVH.USER_STATUS_ID
, AUS.NAME
, EVH.SYSTEM_STATUS_CODE
, EVH.LAST_STATUS_DATE
, EVH.STREAM_TYPE_CODE
, EVH.EVENT_STANDALONE_FLAG
, EVH.DAY_OF_EVENT
, EVH.AGENDA_START_TIME
, EVH.AGENDA_END_TIME
, EVH.REG_REQUIRED_FLAG
, EVH.OWNER_USER_ID
, EVH.URL
, EVH.PHONE
, EVH.EMAIL
, EVH.INBOUND_SCRIPT_NAME
, EVH.REG_INVITED_ONLY_FLAG
, EVH.PARTNER_FLAG
, 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.COORDINATOR_ID
, EVH.REG_CHARGE_FLAG
, EVH.CANCELLATION_REASON_CODE
FROM AMS_EVENT_HEADERS_VL EVH
, AMS_EVENT_HEADERS_VL PEVH
, AMS_USER_STATUSES_VL AUS
, FND_LANGUAGES_VL LANG
WHERE EVH.EVENT_LEVEL='SUB'
AND EVH.PARENT_EVENT_HEADER_ID = PEVH.EVENT_HEADER_ID(+)
AND EVH.USER_STATUS_ID=AUS.USER_STATUS_ID
AND EVH.MAIN_LANGUAGE_CODE=LANG.LANGUAGE_CODE(+)