[Home] [Help] [Dependency Information]
Object Name: | AMS_EVENT_OFFERS_ONLY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_EVENT_OFFERS_ONLY_V |
Subobject Name: | |
Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
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_TYPE_CODE | VARCHAR2 | (30) | Unique code | |
EVENT_TYPE | VARCHAR2 | (80) | Quick code meaning | |
INBOUND_SCRIPT_NAME | VARCHAR2 | (240) | INBOUND Script Name | |
REG_MINIMUM_CAPACITY | NUMBER | (15) | Minimum capacity for registering this event | |
REG_MINIMUM_REQ_BY_DATE | DATE | Date by which the minimum quantity for registration should be obtained | ||
ORGANIZATION_ID | NUMBER | (32) | Organization id | |
INVENTORY_ITEM_ID | NUMBER | (38) | Inventory Item Id | |
PRICELIST_HEADER_ID | NUMBER | Price list header id | ||
PRICELIST_LINE_ID | NUMBER | Price list line id | ||
WAITLIST_ACTION_TYPE_CODE | VARCHAR2 | (30) | holds code for wait list action type | |
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 | The person who took the registration. This is the user ID of the person who recorded the registration in the System. | |
EVENT_FULL_FLAG | VARCHAR2 | (1) | Flag to indicate that Event is full. | |
EVENT_OFFER_ID | NUMBER | Yes | Event Offer Id | |
SETUP_TYPE_ID | NUMBER | Custom setup id | ||
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 | |
APPLICATION_ID | NUMBER | (15) | Yes | Application Id |
EVENT_HEADER_ID | NUMBER | Event Header id | ||
PRIVATE_FLAG | VARCHAR2 | (1) | Yes | Indicates if the event is confidential |
ACTIVE_FLAG | VARCHAR2 | (1) | Yes | Indicates the state of the event |
SOURCE_CODE | VARCHAR2 | (30) | Unique code identifying event source | |
EVENT_LEVEL | VARCHAR2 | (30) | Yes | Event Level |
USER_STATUS_ID | NUMBER | Yes | User Status id | |
USER_STATUS | VARCHAR2 | (120) | Name of the user status | |
LAST_STATUS_DATE | DATE | Yes | Date When User status Changed | |
SYSTEM_STATUS_CODE | VARCHAR2 | (30) | Yes | System Status Code |
EVENT_DELIVERY_METHOD_ID | NUMBER | Event Delivery method Id | ||
EVENT_DELIVERY_METHOD_CODE | VARCHAR2 | (30) | Unique type used across the system for delivery media type | |
EVENT_REQUIRED_FLAG | VARCHAR2 | (1) | Event Required flag | |
EVENT_LANGUAGE_CODE | VARCHAR2 | (30) | Event's Language code | |
EVENT_LANGUAGE | VARCHAR2 | (30) | Event 's language | |
EVENT_VENUE_ID | NUMBER | Venue Id where Event held | ||
EVENT_VENUE_NAME | VARCHAR2 | (120) | Venue Name where event held | |
EVENT_LOCATION_ID | NUMBER | Location id | ||
EVENT_LOCATION | VARCHAR2 | (184) | Location Name | |
CITY | VARCHAR2 | (60) | city name | |
STATE | VARCHAR2 | (60) | State Name | |
PROVINCE | VARCHAR2 | (60) | Province Name | |
COUNTRY | VARCHAR2 | (60) | Country Name | |
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. | |
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. | |
ACTUAL_REVENUE | NUMBER | (15) | Actual Revenue for this Event Offering. | |
FORECASTED_REVENUE | NUMBER | (15) | Forecasted 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. | |
CERTIFICATION_CREDIT_TYPE | VARCHAR2 | (30) | 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. | |
CERTIFICATION_CREDITS | NUMBER | (15) | If this Event Offering is part of one of the Certification Programs, this field denotes the Caertification Credit Type for 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_CODE | VARCHAR2 | (30) | Priority of the Event Offering. This value is just recorded. There is no business logic arround it. | |
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) | Timezone under which the Event Offering location falls in. | |
TIMEZONE_NAME | VARCHAR2 | (80) | Name of the Time zone under which the Event Offering location falls in. | |
EVENT_OFFER_NAME | VARCHAR2 | (240) | Yes | Event Schedule name |
EVENT_MKTG_MESSAGE | VARCHAR2 | (4000) | Message Associated with Event Schedule | |
DESCRIPTION | VARCHAR2 | (4000) | Description of the Event Schedule | |
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 indicate whether the Account for this Event Schedule is closed | |
EVENT_CALENDAR | VARCHAR2 | (15) | Calendar Name for this Event Schedule | |
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_PURPOSE_CODE | VARCHAR2 | (30) | Objective of the event schedule |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, EVENT_TYPE_CODE
, EVENT_TYPE
, INBOUND_SCRIPT_NAME
, REG_MINIMUM_CAPACITY
, REG_MINIMUM_REQ_BY_DATE
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
, PRICELIST_HEADER_ID
, PRICELIST_LINE_ID
, WAITLIST_ACTION_TYPE_CODE
, STREAM_TYPE_CODE
, OWNER_USER_ID
, EVENT_FULL_FLAG
, 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
, USER_STATUS_ID
, USER_STATUS
, LAST_STATUS_DATE
, SYSTEM_STATUS_CODE
, EVENT_DELIVERY_METHOD_ID
, EVENT_DELIVERY_METHOD_CODE
, EVENT_REQUIRED_FLAG
, EVENT_LANGUAGE_CODE
, EVENT_LANGUAGE
, EVENT_VENUE_ID
, EVENT_VENUE_NAME
, EVENT_LOCATION_ID
, EVENT_LOCATION
, CITY
, STATE
, PROVINCE
, COUNTRY
, 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
, 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
, ACTUAL_REVENUE
, FORECASTED_REVENUE
, FORECASTED_COST
, ACTUAL_COST
, FUND_SOURCE_TYPE_CODE
, FUND_SOURCE_ID
, FUND_AMOUNT_TC
, FUND_AMOUNT_FC
, CURRENCY_CODE_TC
, CURRENCY_CODE_FC
, CERTIFICATION_CREDIT_TYPE
, CERTIFICATION_CREDITS
, COORDINATOR_ID
, PRIORITY_CODE
, URL
, PHONE
, EMAIL
, TIMEZONE_ID
, TIMEZONE_NAME
, EVENT_OFFER_NAME
, EVENT_MKTG_MESSAGE
, DESCRIPTION
, 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_PURPOSE_CODE
FROM APPS.AMS_EVENT_OFFERS_ONLY_V;
|
|
|