DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.AMS_EVENT_HEADERS_VL

Object Details
Object Name: AMS_EVENT_HEADERS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_EVENT_HEADERS_VL
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view is created for the general information about marketing event headers.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Unique identifier generated by the database
EVENT_HEADER_ID NUMBER
Yes Unique identifier.
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
CREATED_BY NUMBER (15) Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
OBJECT_VERSION_NUMBER NUMBER (9)
Unique number used for locking purposes
EVENT_LEVEL VARCHAR2 (30) Yes Level of the event
APPLICATION_ID NUMBER (15) Yes Unique identifier
EVENT_TYPE_CODE VARCHAR2 (30)
Unique code
ACTIVE_FLAG VARCHAR2 (1)
Indicates the state of the event
PRIVATE_FLAG VARCHAR2 (1)
Indicates if the event is confidential
USER_STATUS_ID NUMBER
Yes Unique identifier
SYSTEM_STATUS_CODE VARCHAR2 (30) Yes Unique code used across systems
LAST_STATUS_DATE DATE
Yes Date of last user status
STREAM_TYPE_CODE VARCHAR2 (30)
Unique code used across systems
SOURCE_CODE VARCHAR2 (30)
Unique code identifying event source
EVENT_STANDALONE_FLAG VARCHAR2 (1)
Indicates if the event is standalone.
DAY_OF_EVENT VARCHAR2 (30)
Day the event takes place
AGENDA_START_TIME DATE

Start time of the event agenda.
AGENDA_END_TIME DATE

Time the event agenda ends.
REG_REQUIRED_FLAG VARCHAR2 (1) Yes Indicates if registration is mandatory for this event
REG_CHARGE_FLAG VARCHAR2 (1) Yes Indicates the charge applicable for the event.
REG_INVITED_ONLY_FLAG VARCHAR2 (1) Yes Indicates if the event is invitational
PARTNER_FLAG VARCHAR2 (1) Yes Indicates partner involvement in the event.
OVERFLOW_FLAG VARCHAR2 (1)
Indicates if registration overflow is allowed on this event.
PARENT_EVENT_HEADER_ID NUMBER

Unique identifier
DURATION NUMBER (15)
Duration of the event
DURATION_UOM_CODE VARCHAR2 (3)
Unique code
ACTIVE_FROM_DATE DATE

Date the event is active from.
ACTIVE_TO_DATE DATE

Date the event is active to.
REG_MAXIMUM_CAPACITY NUMBER (15)
Maximum registration capacity for this event.
REG_MINIMUM_CAPACITY NUMBER (15)
Minimum registration capacity for the event.
MAIN_LANGUAGE_CODE VARCHAR2 (4)
Identifies the event language code.
CERT_CREDIT_TYPE_CODE VARCHAR2 (30)
Identifies the certification credit type.
CERTIFICATION_CREDITS NUMBER (15)
Number of certification credits applicable.
ORGANIZATION_ID NUMBER (32)
Operating unit identifier.
INVENTORY_ITEM_ID NUMBER (38)
Operating inventory item identifier
ORG_ID NUMBER (32)
Operating unit identifier.
FORECASTED_REVENUE NUMBER (15)
Forecasted revenue
ACTUAL_REVENUE NUMBER (15)
Actual revenue
FORECASTED_COST NUMBER (15)
Forecasted cost
ACTUAL_COST NUMBER (15)
Actual cost
COORDINATOR_ID NUMBER

Coordinator unique identifier
FUND_SOURCE_TYPE_CODE VARCHAR2 (30)
Unique code to identify event fund source
FUND_SOURCE_ID NUMBER

Unique identifier
FUND_AMOUNT_TC NUMBER

Transactional fund amount
FUND_AMOUNT_FC NUMBER

Functional fund amount
CURRENCY_CODE_TC VARCHAR2 (15)
Transactional currency code
CURRENCY_CODE_FC VARCHAR2 (15)
Functional currency code
OWNER_USER_ID NUMBER
Yes Unique identifier
URL VARCHAR2 (4000)
Internet address of the event
PHONE VARCHAR2 (25)
Contact phone
EMAIL VARCHAR2 (120)
Contact electronic mail
PRIORITY_TYPE_CODE VARCHAR2 (30)
Unique code identifying event priority.
CANCELLATION_REASON_CODE VARCHAR2 (30)
Unique code identifying the cancellation reason.
INBOUND_SCRIPT_NAME VARCHAR2 (240)
Inbound script name
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfiled structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
EVENT_HEADER_NAME VARCHAR2 (240) Yes Name Of the Event
EVENT_MKTG_MESSAGE VARCHAR2 (4000)
Marketing message associated with the event
DESCRIPTION VARCHAR2 (4000)
Description of the event.
COUNTRY_CODE VARCHAR2 (30)
Country Code
BUSINESS_UNIT_ID NUMBER

Business Unit ID
ACCOUNTS_CLOSED_FLAG VARCHAR2 (1)
Are Accounts closed for this event?
EVENT_CALENDAR VARCHAR2 (15)
Event Calender Name
START_PERIOD_NAME VARCHAR2 (15)
Start Period Name
END_PERIOD_NAME VARCHAR2 (15)
End Period name
GLOBAL_FLAG VARCHAR2 (1)
Flag to indicate if the Event is run globally.
SETUP_TYPE_ID NUMBER

Custom Setup Id
PROGRAM_ID NUMBER

Program id
TASK_ID NUMBER

Task Id
CREATE_ATTENDANT_LEAD_FLAG VARCHAR2 (1)
Flag to indicate take Attendee as lead
CREATE_REGISTRANT_LEAD_FLAG VARCHAR2 (1)
Flag to indicate take registrant as lead
EVENT_PURPOSE_CODE VARCHAR2 (30)
Purpose of the event.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM APPS.AMS_EVENT_HEADERS_VL;

Dependencies

[top of page]

APPS.AMS_EVENT_HEADERS_VL references the following:

SchemaAPPS
SynonymAMS_EVENT_HEADERS_ALL_B
SynonymAMS_EVENT_HEADERS_ALL_TL
APPS.AMS_EVENT_HEADERS_VL is referenced by following:

SchemaAPPS
Package BodyAMS_APPROVAL_PVT - show dependent code
Package BodyAMS_APPROVAL_SUBMIT_PVT - show dependent code
Package BodyAMS_APPROVAL_UTIL_PVT - show dependent code
Package BodyAMS_CAMPAIGNRULES_PVT - show dependent code
Package BodyAMS_COPYACTIVITIES_PVT - show dependent code
Package BodyAMS_CPYUTILITY_PVT - show dependent code
Package BodyAMS_DELIVERABLE_PVT - show dependent code
Package BodyAMS_EVENTHEADER_PVT - show dependent code
Package BodyAMS_EVENTOFFER_PVT - show dependent code
ViewAMS_EVENT_HEADERS_AGENDA_V
ViewAMS_EVENT_HEADERS_V
Package BodyAMS_EVENT_OBJECTS_COPY_PVT - show dependent code
ViewAMS_EVENT_OFFERS_AGENDA_V
ViewAMS_EVENT_OFFERS_OV_V
ViewAMS_EVENT_OFFERS_V
Package BodyAMS_EVHRULES_PVT - show dependent code
ViewAMS_PROGRAM_COMPONENTS_V
ViewAMS_P_EVENT_CAMPAIGNS_V
ViewAMS_P_OSO_SOURCE_CODES_V
ViewAMS_P_SOURCE_CODES_V
Package BodyAMS_SOURCECODE_PVT - show dependent code
ViewAMS_SOURCE_CODES_DETAILS_V
Package BodyAMS_UTILITY_PVT - show dependent code
Package BodyAMS_WFCMPAPR_PVT - show dependent code
Package BodyAMS_WFTRIG_PVT - show dependent code
Package BodyAST_AMS_SOURCE_PKG - show dependent code
ViewAST_LM_EVENTS_SRC_V
ViewAST_LM_EVENTS_V
ViewAST_SOURCE_ONLY_V
ViewBIM_DIMV_CHANNELS
ViewBIM_DIMV_EVENT_HEADERS
ViewBIM_DIMV_EVENT_HIER
ViewBIM_DIMV_MEDIA_CHANNELS
Package BodyOZF_ACTBUDGETRULES_PVT - show dependent code
Package BodyOZF_ACTBUDGETS_PVT - show dependent code
ViewOZF_FUND_CHECKBOOK_V
Package BodyOZF_FUND_EXTENSION_PVT - show dependent code
Package BodyOZF_FUND_RECONCILE_PVT - show dependent code
Package BodyOZF_FUND_UTILIZED_PUB - show dependent code
Package BodyOZF_MULTI_CURR_MIG_PVT - show dependent code
Package BodyOZF_UTILITY_PVT - show dependent code