[Home] [Help] [Dependency Information]
Object Name: | AMS_EVENT_OFFERS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_EVENT_OFFERS_VL |
Subobject Name: | |
Status: | VALID |
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 offerings.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Unique identifier generated by database | |
EVENT_OFFER_ID | NUMBER | Yes | Unique Identifier. | |
SETUP_TYPE_ID | NUMBER | This field identifies the setup type for this Event. | ||
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) | This column is used for locking purposes. A way to implement Optimistic | |
APPLICATION_ID | NUMBER | (15) | Yes | Application Identifier. |
EVENT_HEADER_ID | NUMBER | This Event Header ID is of that Master Event on which this Event Offering Row is based on. | ||
PRIVATE_FLAG | VARCHAR2 | (1) | Yes | This flag is used for security. The owner can mark this Event Offering as private and then no one else can see the details. |
ACTIVE_FLAG | VARCHAR2 | (1) | Yes | Used for soft-deletes. The Delete will make this flag as 'N'. The Select statement will pull only those rows for which this flag is 'Y' |
SOURCE_CODE | VARCHAR2 | (30) | Event Offering Source Code. This is mainly to track Responses to the Source. The Responses for this Event Offering will specify this Source Code. | |
EVENT_LEVEL | VARCHAR2 | (30) | Yes | 'MAIN' for the Event Offering rows. 'SUB' for the Event Offering Agenda Rows. |
EVENT_TYPE_CODE | VARCHAR2 | (30) | Type of the Event. For example, Seminar / Exhibition / Trade Show. These values are seeded. This value gets copied from the corresponding Master Event. The Marketer can change it. | |
USER_STATUS_ID | NUMBER | Yes | This field keeps track of the System Status for this Event. This field gets updated as and when the Event proceeds in the approval chain. | |
LAST_STATUS_DATE | DATE | Yes | This field ties in with USER_STATUS_ID. This date is the date when the USER_STATUS_ID was last changed. | |
SYSTEM_STATUS_CODE | VARCHAR2 | (30) | Yes | This field ties in with the USER_STATUS_ID. Added to this table for ease of reporting. |
EVENT_DELIVERY_METHOD_ID | NUMBER | Channel which is same as the 'Delivery Method' through which this Event Offering is to be delivered to the customers. | ||
EVENT_REQUIRED_FLAG | VARCHAR2 | (1) | This field is not currently in use. | |
EVENT_LANGUAGE_CODE | VARCHAR2 | (30) | Main language for this Event Offering. | |
EVENT_VENUE_ID | NUMBER | This is used mainly for the Agenda Items for the Event Offering. This field points to the Venue for the Agenda Item. | ||
EVENT_LOCATION_ID | NUMBER | Location for the Event Offering. | ||
OVERFLOW_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether it is OK to allow more registrations than the number of currently available seats. This flag allows Marketer to schedule another offering if Overflow is allowed. |
PARTNER_FLAG | VARCHAR2 | (1) | Yes | This field is not used in this release. This is for the future use. |
EVENT_STANDALONE_FLAG | VARCHAR2 | (1) | Yes | This flag indicates whether this is Standalone which means a One-time Only Event. For a Standalone Event, the marketer will not see any difference between the Master Event and the corresponding Event Offering. |
REG_FROZEN_FLAG | VARCHAR2 | (1) | Yes | Indicates whether registration for this Event Offering is frozen. If this flag is 'Y', no more registration will be allowed. |
REG_REQUIRED_FLAG | VARCHAR2 | (1) | Yes | Marks whether Registration is required for this Event Offering. For Open-door, walk-in events. This flag will be equal to 'N'. |
REG_CHARGE_FLAG | VARCHAR2 | (1) | Yes | This flag indicates whether the Registrant / Attendee needs to pay for the Event. |
REG_INVITED_ONLY_FLAG | VARCHAR2 | (1) | Yes | This flag indicates whether the Registration is open for only those on the Invitee List. |
REG_WAITLIST_ALLOWED_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate whether Wait-list is allowed for this Event Offering. |
REG_OVERBOOK_ALLOWED_FLAG | VARCHAR2 | (1) | Yes | Tells whether it is OK to overbook this Event Offering. |
AUTO_REGISTER_FLAG | VARCHAR2 | (1) | Indicates whether it is OK to move the registrant from the waitlist and register him / her automatically for the Event Offering. If this flag is 'N', the registrant will get a notification requesting him / her to register for the Event Offering since he / she has now a seat available for the event. | |
PARENT_EVENT_OFFER_ID | NUMBER | This field is used only for the Agenda Item Rows. This field is the EVENT_OFFER_ID of the parent Event Offering for this Agenda Item Row. | ||
EVENT_DURATION | NUMBER | (15) | Event Offering Duration. This is just a number. It makes sense when it is tied with the EVENT_DURATION_UOM_CODE. | |
EVENT_DURATION_UOM_CODE | VARCHAR2 | (3) | Ties in with the EVENT_ DURATION_UOM. This is the Unit of Measure for the Duration of the Event Offering. | |
EVENT_START_DATE | DATE | Start Date of this Event Offering. | ||
EVENT_START_DATE_TIME | DATE | This is mainly used for the Agenda Item Rows. This is the Start Time for the Agenda Item. | ||
EVENT_END_DATE | DATE | End Date of the Event Offering. | ||
EVENT_END_DATE_TIME | DATE | This is used mainly for the Agenda Item Rows. This is the End Time of the Agenda Item. | ||
REG_START_DATE | DATE | Date when the Registrations Can start for this Event Offering. | ||
REG_START_TIME | DATE | The time on the Registration Start Date, when the Registration can start. | ||
REG_END_DATE | DATE | The Date when the Registration must stop. | ||
REG_END_TIME | DATE | The Time on the REG_END_DATE when the Registration should stop. | ||
REG_MAXIMUM_CAPACITY | NUMBER | (15) | Registration Maximum Capacity for this Event Offeringl. This field gets copied from the corresponding Master Event. The Marketer will be able to change it. | |
REG_OVERBOOK_PCT | NUMBER | (15) | If REG_OVERBOOK_ALLOWED_FLAG is 'Y'. This field defines the percentage of allowed Overbooking. | |
REG_EFFECTIVE_CAPACITY | NUMBER | (15) | This is a derived field. It tells the Effective Capacity, after looking at the REG_MAXIMUM_CAPACITY, REG_OVERBOOK_ALLOWED_FLAG and REG_OVERBOOK_PCT. | |
REG_WAITLIST_PCT | NUMBER | (15) | If REG_WAITLIST_ALLOWED_FLAG is 'Y', this field defines what is the percentage of entries allowed in the waitlist. This percentage is with respect to the REG_MAXIMUM_CAPACITY. | |
REG_MINIMUM_CAPACITY | NUMBER | (15) | Registration Minimum Capacity defined at the Event Offering level. This field gets copied from the corresponding Master Event. The Marketer will be able to change it. | |
REG_MINIMUM_REQ_BY_DATE | DATE | Date by which the Minimum Registration Capacity must be filled. | ||
ORGANIZATION_ID | NUMBER | (32) | Ties in with the Inventory Item ID. | |
INVENTORY_ITEM_ID | NUMBER | (38) | This is the Inventory Item ID for the Event Offering when this Event Offering is charged for and the orders will then come against this Inventory Item ID. This is part of the Order Capture Integration. | |
PRICELIST_HEADER_ID | NUMBER | Pricelist Header ID of the Base Pricelist generated for this Event Offering. | ||
PRICELIST_LINE_ID | NUMBER | Ties in with the Pricelist Header ID. | ||
ORG_ID | NUMBER | (32) | This is for the multi-org. Organization Identifier. | |
WAITLIST_ACTION_TYPE_CODE | VARCHAR2 | (30) | Action Type to be used when the Waitlist is prioritized. For example, it could be First-come-First-served. | |
STREAM_TYPE_CODE | VARCHAR2 | (30) | Used only for Agenda Rows where EVENT_LEVEL is 'SUB'. This field marks the Agenda Item Stream Code. | |
OWNER_USER_ID | NUMBER | Yes | User ID of the Owner of the Event Offering. | |
EVENT_FULL_FLAG | VARCHAR2 | (1) | Indicates whether the Event is filled to the capacity. | |
FORECASTED_REVENUE | NUMBER | (15) | Forecasted Revenue for this Event Offering. | |
ACTUAL_REVENUE | NUMBER | (15) | Actual Revenue for this Event Offering. | |
FORECASTED_COST | NUMBER | (15) | Forecasted Cost for this Event Offering. | |
ACTUAL_COST | NUMBER | (15) | Actual Cost for this Event Offering. | |
FUND_SOURCE_TYPE_CODE | VARCHAR2 | (30) | Indicates what type of object is funding this Event Offering. It could be a Budget Fund, Campaign or the Master Event. | |
FUND_SOURCE_ID | NUMBER | Ties in with the FUND_SOURCE_TYPE_CODE. This will be the Source Code of the entity that funds this Event Offering. | ||
FUND_AMOUNT_TC | NUMBER | Fund Amount in Transactional Currency. | ||
FUND_AMOUNT_FC | NUMBER | Fund amount in Functional Currency. | ||
CURRENCY_CODE_TC | VARCHAR2 | (15) | Transactional Currency Code. | |
CURRENCY_CODE_FC | VARCHAR2 | (15) | Functional Currency Code. | |
CERT_CREDIT_TYPE_CODE | VARCHAR2 | (30) | If this Event Offering is part of one of the Certification Programs, this field denotes the Certification Credit Type for this event offering. | |
CERTIFICATION_CREDITS | NUMBER | (15) | If this Event Offering is part of one of the Certification Programs, this field denotes the number of Certification Credits the attendee will get after completely attending this Event Offering. | |
COORDINATOR_ID | NUMBER | This field is used mainly for Agenda Item rows. This field holds the user id of the Coordinator for this Agenda Item. | ||
PRIORITY_TYPE_CODE | VARCHAR2 | (30) | Priority of the Event Offering. This value is just recorded. There is no business logic around it. | |
CANCELLATION_REASON_CODE | VARCHAR2 | (30) | If this Event Offering is cancelled for some reason, the cancellation reason is recorded here. The values are seeded. | |
URL | VARCHAR2 | (4000) | URL associated with the Event Offering. This could be for the web site created for this Event Offering. This field gets copied from the corresponding Master Event. The Marketer can change it. | |
PHONE | VARCHAR2 | (25) | Phone number for the customers to call in for this Event Offering. This field gets copied from the corresponding Master Event. The Marketer can change it. | |
VARCHAR2 | (120) | email ID associated with this Event Offering. Customers can send emails to this email address to gain more information about the Event Offering. This field gets copied from the corresponding Master Event. The Marketer can change it. | ||
TIMEZONE_ID | NUMBER | (15) | Time zone under which the Event Offering location falls in. | |
INBOUND_SCRIPT_NAME | VARCHAR2 | (240) | The name of the questionnaire, which must be filled up by the call center when a customer calls in for this Event Offering. This field gets copied from the corresponding Master Event. The Marketer can change it. | |
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_OFFER_NAME | VARCHAR2 | (240) | Yes | Name of the event offer |
DESCRIPTION | VARCHAR2 | (4000) | Description of the event | |
EVENT_MKTG_MESSAGE | VARCHAR2 | (4000) | The marketing message associated with this event | |
COUNTRY_CODE | VARCHAR2 | (30) | Country code | |
BUSINESS_UNIT_ID | NUMBER | Identifier of the Business Unit this campaign belongs to | ||
ACCOUNTS_CLOSED_FLAG | VARCHAR2 | (1) | Flag to indicate whether the Account for this event offer is closed | |
EVENT_CALENDAR | VARCHAR2 | (15) | Calendar Name | |
START_PERIOD_NAME | VARCHAR2 | (15) | Starting period name within the Event calendar | |
END_PERIOD_NAME | VARCHAR2 | (15) | Ending period name within the Event calendar | |
GLOBAL_FLAG | VARCHAR2 | (1) | Is it a global Event Offer | |
TASK_ID | NUMBER | Task ID | ||
PARENT_TYPE | VARCHAR2 | (30) | Parent for One off event | |
PARENT_ID | NUMBER | Parent ID of one off event | ||
CREATE_ATTENDANT_LEAD_FLAG | VARCHAR2 | (1) | Create the Event attendee as a Lead | |
CREATE_REGISTRANT_LEAD_FLAG | VARCHAR2 | (1) | Create Registrant as Lead | |
EVENT_OBJECT_TYPE | VARCHAR2 | (30) | Hold Object type code of the event | |
REG_TIMEZONE_ID | NUMBER | Time Zone ID | ||
EVENT_PASSWORD | VARCHAR2 | (120) | This field holds password for Web based events, if the Event require any login | |
RECORD_EVENT_FLAG | VARCHAR2 | (1) | Flag to indicate whether it is OK to Record the Event. | |
ALLOW_REGISTER_IN_MIDDLE_FLAG | VARCHAR2 | (1) | Flag to Allow User to Flag to indicate whether it is OK to Register a person in the middle of the event | |
PUBLISH_ATTENDEES_FLAG | VARCHAR2 | (1) | Flag to indicate whether it is OK to Publish the Attendees list | |
DIRECT_JOIN_FLAG | VARCHAR2 | (1) | Flag to indicate whether it is OK to Join the event without registration | |
EVENT_NOTIFICATION_METHOD | VARCHAR2 | (30) | This fleld will tell what type of notification to be sent out | |
ACTUAL_START_TIME | DATE | Start time of the Web based event | ||
ACTUAL_END_TIME | DATE | End time of the Web based event | ||
SERVER_ID | NUMBER | Sever where the event is conducted. This field used for WEB based events | ||
OWNER_FND_USER_ID | NUMBER | Login User id for the session | ||
MEETING_DIAL_IN_INFO | VARCHAR2 | (4000) | Dial in information of the event | |
MEETING_EMAIL_SUBJECT | VARCHAR2 | (4000) | If the Notification of the Event is through Email then this filed holds the text of the Subject field | |
MEETING_SCHEDULE_TYPE | VARCHAR2 | (30) | Meeting Schedule type | |
MEETING_STATUS | VARCHAR2 | (30) | Status of the meeting | |
PUBLISH_FLAG | VARCHAR2 | (1) | Flag to indicate whether it is OK to publish the event for public | |
MEETING_ENCRYPTION_KEY_CODE | VARCHAR2 | (150) | Encryption Key code for the password | |
MEETING_MISC_INFO | VARCHAR2 | (4000) | Other information | |
NUMBER_OF_ATTENDEES | NUMBER | (15) | Number of Attendees | |
EVENT_PURPOSE_CODE | VARCHAR2 | (30) | Objective of the event schedule |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, EVENT_OFFER_ID
, SETUP_TYPE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, APPLICATION_ID
, EVENT_HEADER_ID
, PRIVATE_FLAG
, ACTIVE_FLAG
, SOURCE_CODE
, EVENT_LEVEL
, EVENT_TYPE_CODE
, USER_STATUS_ID
, LAST_STATUS_DATE
, SYSTEM_STATUS_CODE
, EVENT_DELIVERY_METHOD_ID
, EVENT_REQUIRED_FLAG
, EVENT_LANGUAGE_CODE
, EVENT_VENUE_ID
, EVENT_LOCATION_ID
, OVERFLOW_FLAG
, PARTNER_FLAG
, EVENT_STANDALONE_FLAG
, REG_FROZEN_FLAG
, REG_REQUIRED_FLAG
, REG_CHARGE_FLAG
, REG_INVITED_ONLY_FLAG
, REG_WAITLIST_ALLOWED_FLAG
, REG_OVERBOOK_ALLOWED_FLAG
, AUTO_REGISTER_FLAG
, PARENT_EVENT_OFFER_ID
, EVENT_DURATION
, EVENT_DURATION_UOM_CODE
, EVENT_START_DATE
, EVENT_START_DATE_TIME
, EVENT_END_DATE
, EVENT_END_DATE_TIME
, REG_START_DATE
, REG_START_TIME
, REG_END_DATE
, REG_END_TIME
, REG_MAXIMUM_CAPACITY
, REG_OVERBOOK_PCT
, REG_EFFECTIVE_CAPACITY
, REG_WAITLIST_PCT
, REG_MINIMUM_CAPACITY
, REG_MINIMUM_REQ_BY_DATE
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
, PRICELIST_HEADER_ID
, PRICELIST_LINE_ID
, ORG_ID
, WAITLIST_ACTION_TYPE_CODE
, STREAM_TYPE_CODE
, OWNER_USER_ID
, EVENT_FULL_FLAG
, FORECASTED_REVENUE
, ACTUAL_REVENUE
, FORECASTED_COST
, ACTUAL_COST
, FUND_SOURCE_TYPE_CODE
, FUND_SOURCE_ID
, FUND_AMOUNT_TC
, FUND_AMOUNT_FC
, CURRENCY_CODE_TC
, CURRENCY_CODE_FC
, CERT_CREDIT_TYPE_CODE
, CERTIFICATION_CREDITS
, COORDINATOR_ID
, PRIORITY_TYPE_CODE
, CANCELLATION_REASON_CODE
, URL
, PHONE
, EMAIL
, TIMEZONE_ID
, INBOUND_SCRIPT_NAME
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, EVENT_OFFER_NAME
, DESCRIPTION
, EVENT_MKTG_MESSAGE
, COUNTRY_CODE
, BUSINESS_UNIT_ID
, ACCOUNTS_CLOSED_FLAG
, EVENT_CALENDAR
, START_PERIOD_NAME
, END_PERIOD_NAME
, GLOBAL_FLAG
, TASK_ID
, PARENT_TYPE
, PARENT_ID
, CREATE_ATTENDANT_LEAD_FLAG
, CREATE_REGISTRANT_LEAD_FLAG
, EVENT_OBJECT_TYPE
, REG_TIMEZONE_ID
, EVENT_PASSWORD
, RECORD_EVENT_FLAG
, ALLOW_REGISTER_IN_MIDDLE_FLAG
, PUBLISH_ATTENDEES_FLAG
, DIRECT_JOIN_FLAG
, EVENT_NOTIFICATION_METHOD
, ACTUAL_START_TIME
, ACTUAL_END_TIME
, SERVER_ID
, OWNER_FND_USER_ID
, MEETING_DIAL_IN_INFO
, MEETING_EMAIL_SUBJECT
, MEETING_SCHEDULE_TYPE
, MEETING_STATUS
, PUBLISH_FLAG
, MEETING_ENCRYPTION_KEY_CODE
, MEETING_MISC_INFO
, NUMBER_OF_ATTENDEES
, EVENT_PURPOSE_CODE
FROM APPS.AMS_EVENT_OFFERS_VL;
|
|
|