VIEW: APPS.AMS_EVENT_HEADERS_AGENDA_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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