eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AMS_EVENT_HEADERS_VL

Product:	AMS - Marketing
Description:	This view returns the general information about marketing events (headers).
Implementation/DBA Data:	APPS.AMS_EVENT_HEADERS_VL

View Text

SELECT B.ROWID ROW_ID
, B.EVENT_HEADER_ID
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
, B.EVENT_LEVEL
, B.APPLICATION_ID
, B.EVENT_TYPE_CODE
, B.ACTIVE_FLAG
, B.PRIVATE_FLAG
, B.USER_STATUS_ID
, B.SYSTEM_STATUS_CODE
, B.LAST_STATUS_DATE
, B.STREAM_TYPE_CODE
, B.SOURCE_CODE
, B.EVENT_STANDALONE_FLAG
, B.DAY_OF_EVENT
, B.AGENDA_START_TIME
, B.AGENDA_END_TIME
, B.REG_REQUIRED_FLAG
, B.REG_CHARGE_FLAG
, B.REG_INVITED_ONLY_FLAG
, B.PARTNER_FLAG
, B.OVERFLOW_FLAG
, B.PARENT_EVENT_HEADER_ID
, B.DURATION
, B.DURATION_UOM_CODE
, B.ACTIVE_FROM_DATE
, B.ACTIVE_TO_DATE
, B.REG_MAXIMUM_CAPACITY
, B.REG_MINIMUM_CAPACITY
, B.MAIN_LANGUAGE_CODE
, B.CERT_CREDIT_TYPE_CODE
, B.CERTIFICATION_CREDITS
, B.ORGANIZATION_ID
, B.INVENTORY_ITEM_ID
, B.ORG_ID
, B.FORECASTED_REVENUE
, B.ACTUAL_REVENUE
, B.FORECASTED_COST
, B.ACTUAL_COST
, B.COORDINATOR_ID
, B.FUND_SOURCE_TYPE_CODE
, B.FUND_SOURCE_ID
, B.FUND_AMOUNT_TC
, B.FUND_AMOUNT_FC
, B.CURRENCY_CODE_TC
, B.CURRENCY_CODE_FC
, B.OWNER_USER_ID
, B.URL
, B.PHONE
, B.EMAIL
, B.PRIORITY_TYPE_CODE
, B.CANCELLATION_REASON_CODE
, B.INBOUND_SCRIPT_NAME
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, T.EVENT_HEADER_NAME
, T.EVENT_MKTG_MESSAGE
, T.DESCRIPTION
, B.COUNTRY_CODE
, B.BUSINESS_UNIT_ID
, B.ACCOUNTS_CLOSED_FLAG
, B.EVENT_CALENDAR
, B.START_PERIOD_NAME
, B.END_PERIOD_NAME
, B.GLOBAL_FLAG
, B.SETUP_TYPE_ID
, B.PROGRAM_ID
, B.TASK_ID
, B.CREATE_ATTENDANT_LEAD_FLAG
, B.CREATE_REGISTRANT_LEAD_FLAG
, B.EVENT_PURPOSE_CODE
FROM AMS_EVENT_HEADERS_ALL_B B
, AMS_EVENT_HEADERS_ALL_TL T
WHERE B.EVENT_HEADER_ID=T.EVENT_HEADER_ID
AND T.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
EVENT_HEADER_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
EVENT_LEVEL
APPLICATION_ID
EVENT_TYPE_CODE
ACTIVE_FLAG
PRIVATE_FLAG
USER_STATUS_ID
SYSTEM_STATUS_CODE
LAST_STATUS_DATE
STREAM_TYPE_CODE
SOURCE_CODE
EVENT_STANDALONE_FLAG
DAY_OF_EVENT
AGENDA_START_TIME
AGENDA_END_TIME
REG_REQUIRED_FLAG
REG_CHARGE_FLAG
REG_INVITED_ONLY_FLAG
PARTNER_FLAG
OVERFLOW_FLAG
PARENT_EVENT_HEADER_ID
DURATION
DURATION_UOM_CODE
ACTIVE_FROM_DATE
ACTIVE_TO_DATE
REG_MAXIMUM_CAPACITY
REG_MINIMUM_CAPACITY
MAIN_LANGUAGE_CODE
CERT_CREDIT_TYPE_CODE
CERTIFICATION_CREDITS
ORGANIZATION_ID
INVENTORY_ITEM_ID
ORG_ID
FORECASTED_REVENUE
ACTUAL_REVENUE
FORECASTED_COST
ACTUAL_COST
COORDINATOR_ID
FUND_SOURCE_TYPE_CODE
FUND_SOURCE_ID
FUND_AMOUNT_TC
FUND_AMOUNT_FC
CURRENCY_CODE_TC
CURRENCY_CODE_FC
OWNER_USER_ID
URL
PHONE
EMAIL
PRIORITY_TYPE_CODE
CANCELLATION_REASON_CODE
INBOUND_SCRIPT_NAME
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
EVENT_HEADER_NAME
EVENT_MKTG_MESSAGE
DESCRIPTION
COUNTRY_CODE
BUSINESS_UNIT_ID
ACCOUNTS_CLOSED_FLAG
EVENT_CALENDAR
START_PERIOD_NAME
END_PERIOD_NAME
GLOBAL_FLAG
SETUP_TYPE_ID
PROGRAM_ID
TASK_ID
CREATE_ATTENDANT_LEAD_FLAG
CREATE_REGISTRANT_LEAD_FLAG
EVENT_PURPOSE_CODE