Search Results ams_event_offers_all_b




Overview
Explore in AI Chat

Overview

The AMS_EVENT_OFFERS_ALL_B table is a core data object within the Oracle E-Business Suite (EBS) Marketing (AMS) module. It serves as the primary repository for information pertaining to Event Offerings, which represent specific, schedulable instances of a marketing event. An event offering defines the logistical and commercial details for a single occurrence, such as a particular date, time, venue, and pricing. Crucially, the table also stores data for all Agenda Items associated with those offerings, linking the event schedule to its master definition. Its role is central to the management, tracking, and execution of marketing events across operating units, as indicated by the '_ALL_' suffix in its name.

Key Information Stored

The table's structure is defined by its primary and foreign keys, which highlight the critical data points it manages. The primary identifier is the EVENT_OFFER_ID. The table maintains a relationship to its parent event definition via EVENT_HEADER_ID, linking to AMS_EVENT_HEADERS_ALL_B. Key logistical attributes include EVENT_VENUE_ID (linked to AMS_VENUES_B), EVENT_LOCATION_ID (linked to HZ_LOCATIONS), and TIMEZONE_ID. Commercial details are captured through links to pricing lists (PRICELIST_HEADER_ID, PRICELIST_LINE_ID). Operational data includes the event's USER_STATUS_ID, COORDINATOR_ID, OWNER_USER_ID, and funding source (FUND_SOURCE_ID). The PARENT_EVENT_OFFER_ID column supports hierarchical relationships between offerings.

Common Use Cases and Queries

This table is fundamental for operational reporting and process integration in marketing campaigns. Common use cases include generating event schedules, analyzing offering performance, managing resource allocation for coordinators, and integrating event data with financial systems for fund tracking. A typical query might join to related tables to create a comprehensive event offering report:

  • Listing all offerings for a specific event header with venue and status details.
  • Identifying offerings managed by a specific coordinator within a date range.
  • Reporting on offerings linked to a particular price list for revenue analysis.
  • Querying agenda items (stored within this table) for a specific EVENT_OFFER_ID to build session schedules.

A sample SQL pattern to retrieve basic offering information would involve joins to AMS_EVENT_HEADERS_ALL_B for the event name and AMS_USER_STATUSES_B for the status meaning.

Related Objects

The table has extensive relationships with other EBS objects, as documented by its foreign keys. Key dependencies include:

  • Table: AMS_EVENT_OFFERS_ALL_B 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_EVENT_OFFERS_ALL_B,  object_name:AMS_EVENT_OFFERS_ALL_B,  status:VALID,  product: AMS - Marketing ,  description: Stores information about an Event Offering. .This table also holds the data for all the Agenda Items for the Event Offerings. ,  implementation_dba_data: AMS.AMS_EVENT_OFFERS_ALL_B , 

  • Table: AMS_EVENT_OFFERS_ALL_B 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_EVENT_OFFERS_ALL_B,  object_name:AMS_EVENT_OFFERS_ALL_B,  status:VALID,  product: AMS - Marketing ,  description: Stores information about an Event Offering. .This table also holds the data for all the Agenda Items for the Event Offerings. ,  implementation_dba_data: AMS.AMS_EVENT_OFFERS_ALL_B , 

  • Table: AMS_OBJECT_ASSOCIATIONS 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_OBJECT_ASSOCIATIONS,  object_name:AMS_OBJECT_ASSOCIATIONS,  status:VALID,  product: AMS - Marketing ,  description: AMS_OBJECT_ASSOCIATIONS is the cross reference between the Campaigns or Events or Creatives the that are running. ,  implementation_dba_data: AMS.AMS_OBJECT_ASSOCIATIONS , 

  • Table: AMS_OBJECT_ASSOCIATIONS 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_OBJECT_ASSOCIATIONS,  object_name:AMS_OBJECT_ASSOCIATIONS,  status:VALID,  product: AMS - Marketing ,  description: AMS_OBJECT_ASSOCIATIONS is the cross reference between the Campaigns or Events or Creatives the that are running. ,  implementation_dba_data: AMS.AMS_OBJECT_ASSOCIATIONS , 

  • Table: AMS_USER_STATUSES_B 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_USER_STATUSES_B,  object_name:AMS_USER_STATUSES_B,  status:VALID,  product: AMS - Marketing ,  description: Stores User status information ,  implementation_dba_data: AMS.AMS_USER_STATUSES_B , 

  • Table: AMS_USER_STATUSES_B 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_USER_STATUSES_B,  object_name:AMS_USER_STATUSES_B,  status:VALID,  product: AMS - Marketing ,  description: Stores User status information ,  implementation_dba_data: AMS.AMS_USER_STATUSES_B , 

  • Table: AMS_EVENT_HEADERS_ALL_B 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_EVENT_HEADERS_ALL_B,  object_name:AMS_EVENT_HEADERS_ALL_B,  status:VALID,  product: AMS - Marketing ,  description: Stores the definition of a Marketing Event. (Master Event or Event Template) ,  implementation_dba_data: AMS.AMS_EVENT_HEADERS_ALL_B , 

  • Table: AMS_EVENT_HEADERS_ALL_B 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_EVENT_HEADERS_ALL_B,  object_name:AMS_EVENT_HEADERS_ALL_B,  status:VALID,  product: AMS - Marketing ,  description: Stores the definition of a Marketing Event. (Master Event or Event Template) ,  implementation_dba_data: AMS.AMS_EVENT_HEADERS_ALL_B , 

  • Table: AMS_CAMPAIGNS_ALL_B 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_CAMPAIGNS_ALL_B,  object_name:AMS_CAMPAIGNS_ALL_B,  status:VALID,  product: AMS - Marketing ,  description: Base table to store the details of a campaign. ,  implementation_dba_data: AMS.AMS_CAMPAIGNS_ALL_B , 

  • Table: AMS_CAMPAIGNS_ALL_B 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_CAMPAIGNS_ALL_B,  object_name:AMS_CAMPAIGNS_ALL_B,  status:VALID,  product: AMS - Marketing ,  description: Base table to store the details of a campaign. ,  implementation_dba_data: AMS.AMS_CAMPAIGNS_ALL_B , 

  • Table: AMS_EVENT_OFFERS_ALL_TL 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_EVENT_OFFERS_ALL_TL,  object_name:AMS_EVENT_OFFERS_ALL_TL,  status:VALID,  product: AMS - Marketing ,  description: Stores all translated columns. ,  implementation_dba_data: AMS.AMS_EVENT_OFFERS_ALL_TL , 

  • Table: AMS_ACT_PERSONS 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_PERSONS,  object_name:AMS_ACT_PERSONS,  status:VALID,  product: AMS - Marketing ,  description: Stores information about the staff working at a venue. ,  implementation_dba_data: AMS.AMS_ACT_PERSONS , 

  • Table: AMS_ACT_SKILLS 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_SKILLS,  object_name:AMS_ACT_SKILLS,  status:VALID,  product: AMS - Marketing ,  description: Stores pre-requisite and archived skills for an event ,  implementation_dba_data: AMS.AMS_ACT_SKILLS , 

  • Table: AMS_ACT_PERSONS 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_PERSONS,  object_name:AMS_ACT_PERSONS,  status:VALID,  product: AMS - Marketing ,  description: Stores information about the staff working at a venue. ,  implementation_dba_data: AMS.AMS_ACT_PERSONS , 

  • Table: AMS_ACT_DELIVERY_METHODS 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_DELIVERY_METHODS,  object_name:AMS_ACT_DELIVERY_METHODS,  status:VALID,  product: AMS - Marketing ,  description: Stores information for the various activity delivery methods ,  implementation_dba_data: AMS.AMS_ACT_DELIVERY_METHODS , 

  • Table: AMS_EVENT_OFFERS_ALL_TL 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_EVENT_OFFERS_ALL_TL,  object_name:AMS_EVENT_OFFERS_ALL_TL,  status:VALID,  product: AMS - Marketing ,  description: Stores all translated columns. ,  implementation_dba_data: AMS.AMS_EVENT_OFFERS_ALL_TL , 

  • Table: AMS_ACT_DELIVERY_METHODS 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_DELIVERY_METHODS,  object_name:AMS_ACT_DELIVERY_METHODS,  status:VALID,  product: AMS - Marketing ,  description: Stores information for the various activity delivery methods ,  implementation_dba_data: AMS.AMS_ACT_DELIVERY_METHODS , 

  • Table: AMS_OBJECT_ATTRIBUTES 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_OBJECT_ATTRIBUTES,  object_name:AMS_OBJECT_ATTRIBUTES,  status:VALID,  product: AMS - Marketing ,  description: This table is obsoleted and no longer in use. ,  implementation_dba_data: AMS.AMS_OBJECT_ATTRIBUTES , 

  • Table: AMS_ACT_MARKET_SEGMENTS 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_MARKET_SEGMENTS,  object_name:AMS_ACT_MARKET_SEGMENTS,  status:VALID,  product: AMS - Marketing ,  description: Stores what Market Segment are used by what Activity. ,  implementation_dba_data: AMS.AMS_ACT_MARKET_SEGMENTS , 

  • Table: AMS_AGENDAS_B 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_AGENDAS_B,  object_name:AMS_AGENDAS_B,  status:VALID,  product: AMS - Marketing ,  description: Stores all the agenda information contains track and sessions. ,  implementation_dba_data: AMS.AMS_AGENDAS_B , 

  • Table: AMS_ACT_MESSAGES 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_MESSAGES,  object_name:AMS_ACT_MESSAGES,  status:VALID,  product: AMS - Marketing ,  description: Association table for messages to a campaign/event. ,  implementation_dba_data: AMS.AMS_ACT_MESSAGES , 

  • Table: AMS_OBJECT_ATTRIBUTES 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_OBJECT_ATTRIBUTES,  object_name:AMS_OBJECT_ATTRIBUTES,  status:VALID,  product: AMS - Marketing ,  description: This table is obsoleted and no longer in use. ,  implementation_dba_data: AMS.AMS_OBJECT_ATTRIBUTES , 

  • Table: AMS_ACT_PARTNERS 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_PARTNERS,  object_name:AMS_ACT_PARTNERS,  status:VALID,  product: AMS - Marketing ,  description: Holds the information about the participating partners for a marketing activity. ,  implementation_dba_data: AMS.AMS_ACT_PARTNERS , 

  • Table: AMS_ACT_OBJECTIVES 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_OBJECTIVES,  object_name:AMS_ACT_OBJECTIVES,  status:VALID,  product: AMS - Marketing ,  description: Stores objectives for a specific activity (e.g. Promotion, Media, Event). ,  implementation_dba_data: AMS.AMS_ACT_OBJECTIVES , 

  • Table: AMS_AGENDAS_B 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_AGENDAS_B,  object_name:AMS_AGENDAS_B,  status:VALID,  product: AMS - Marketing ,  description: Stores all the agenda information contains track and sessions. ,  implementation_dba_data: AMS.AMS_AGENDAS_B , 

  • Table: AMS_ACT_SKILLS 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_SKILLS,  object_name:AMS_ACT_SKILLS,  status:VALID,  product: AMS - Marketing ,  description: Stores pre-requisite and archived skills for an event ,  implementation_dba_data: AMS.AMS_ACT_SKILLS , 

  • Table: AMS_ACT_OBJECTIVES 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_OBJECTIVES,  object_name:AMS_ACT_OBJECTIVES,  status:VALID,  product: AMS - Marketing ,  description: Stores objectives for a specific activity (e.g. Promotion, Media, Event). ,  implementation_dba_data: AMS.AMS_ACT_OBJECTIVES , 

  • Table: AMS_ACT_PARTNERS 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_PARTNERS,  object_name:AMS_ACT_PARTNERS,  status:VALID,  product: AMS - Marketing ,  description: Holds the information about the participating partners for a marketing activity. ,  implementation_dba_data: AMS.AMS_ACT_PARTNERS , 

  • Table: AMS_ACT_PROGRAMS 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_PROGRAMS,  object_name:AMS_ACT_PROGRAMS,  status:VALID,  product: AMS - Marketing ,  description: Stores programs for a specific activity such as an event. ,  implementation_dba_data: AMS.AMS_ACT_PROGRAMS , 

  • Table: AMS_ACT_RESOURCES 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_RESOURCES,  object_name:AMS_ACT_RESOURCES,  status:VALID,  product: AMS - Marketing ,  description: Stores business parties for a specific activity such as an event. ,  implementation_dba_data: AMS.AMS_ACT_RESOURCES , 

  • Table: AMS_ACT_PROGRAMS 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_PROGRAMS,  object_name:AMS_ACT_PROGRAMS,  status:VALID,  product: AMS - Marketing ,  description: Stores programs for a specific activity such as an event. ,  implementation_dba_data: AMS.AMS_ACT_PROGRAMS , 

  • Table: AMS_ACT_MARKET_SEGMENTS 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_MARKET_SEGMENTS,  object_name:AMS_ACT_MARKET_SEGMENTS,  status:VALID,  product: AMS - Marketing ,  description: Stores what Market Segment are used by what Activity. ,  implementation_dba_data: AMS.AMS_ACT_MARKET_SEGMENTS , 

  • Table: AMS_ACT_MESSAGES 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_MESSAGES,  object_name:AMS_ACT_MESSAGES,  status:VALID,  product: AMS - Marketing ,  description: Association table for messages to a campaign/event. ,  implementation_dba_data: AMS.AMS_ACT_MESSAGES , 

  • Table: AMS_ACT_LISTS 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_LISTS,  object_name:AMS_ACT_LISTS,  status:VALID,  product: AMS - Marketing ,  description: This Table Stores the information of Target Group/Invite Lists and its lists ,  implementation_dba_data: AMS.AMS_ACT_LISTS , 

  • Table: AMS_ACT_RESOURCES 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_RESOURCES,  object_name:AMS_ACT_RESOURCES,  status:VALID,  product: AMS - Marketing ,  description: Stores business parties for a specific activity such as an event. ,  implementation_dba_data: AMS.AMS_ACT_RESOURCES , 

  • Table: AMS_VENUES_B 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_VENUES_B,  object_name:AMS_VENUES_B,  status:VALID,  product: AMS - Marketing ,  description: Stores places that can be used to hold an event at. ,  implementation_dba_data: AMS.AMS_VENUES_B , 

  • Table: AMS_ACT_LISTS 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_LISTS,  object_name:AMS_ACT_LISTS,  status:VALID,  product: AMS - Marketing ,  description: This Table Stores the information of Target Group/Invite Lists and its lists ,  implementation_dba_data: AMS.AMS_ACT_LISTS , 

  • Table: AMS_ACT_ACCESS 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_ACCESS,  object_name:AMS_ACT_ACCESS,  status:VALID,  product: AMS - Marketing ,  description: Holds access information for all marketing objects. ,  implementation_dba_data: AMS.AMS_ACT_ACCESS , 

  • Table: AMS_ACT_CATEGORIES 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_CATEGORIES,  object_name:AMS_ACT_CATEGORIES,  status:VALID,  product: AMS - Marketing ,  description: Generic category table used to hold categories an acticity can belong to, for reporting and search capability. ,  implementation_dba_data: AMS.AMS_ACT_CATEGORIES , 

  • Table: AMS_ACT_ACCESS 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_ACCESS,  object_name:AMS_ACT_ACCESS,  status:VALID,  product: AMS - Marketing ,  description: Holds access information for all marketing objects. ,  implementation_dba_data: AMS.AMS_ACT_ACCESS , 

  • Table: AMS_VENUES_B 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_VENUES_B,  object_name:AMS_VENUES_B,  status:VALID,  product: AMS - Marketing ,  description: Stores places that can be used to hold an event at. ,  implementation_dba_data: AMS.AMS_VENUES_B , 

  • Table: AMS_ACT_PRODUCTS 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_PRODUCTS,  object_name:AMS_ACT_PRODUCTS,  status:VALID,  product: AMS - Marketing ,  description: Stores information about the products that are promoted as part of a promotion event. ,  implementation_dba_data: AMS.AMS_ACT_PRODUCTS , 

  • Table: AMS_ACT_CATEGORIES 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_CATEGORIES,  object_name:AMS_ACT_CATEGORIES,  status:VALID,  product: AMS - Marketing ,  description: Generic category table used to hold categories an acticity can belong to, for reporting and search capability. ,  implementation_dba_data: AMS.AMS_ACT_CATEGORIES , 

  • Table: AMS_ACT_PRODUCTS 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_ACT_PRODUCTS,  object_name:AMS_ACT_PRODUCTS,  status:VALID,  product: AMS - Marketing ,  description: Stores information about the products that are promoted as part of a promotion event. ,  implementation_dba_data: AMS.AMS_ACT_PRODUCTS , 

  • Table: AMS_CUSTOM_SETUPS_B 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_CUSTOM_SETUPS_B,  object_name:AMS_CUSTOM_SETUPS_B,  status:VALID,  product: AMS - Marketing ,  description: Stores all the custom setups. ,  implementation_dba_data: AMS.AMS_CUSTOM_SETUPS_B , 

  • Table: AMS_CUSTOM_SETUPS_B 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_CUSTOM_SETUPS_B,  object_name:AMS_CUSTOM_SETUPS_B,  status:VALID,  product: AMS - Marketing ,  description: Stores all the custom setups. ,  implementation_dba_data: AMS.AMS_CUSTOM_SETUPS_B , 

  • Table: AMS_LIST_HEADERS_ALL 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_LIST_HEADERS_ALL,  object_name:AMS_LIST_HEADERS_ALL,  status:VALID,  product: AMS - Marketing ,  description: This table stores the name and other details about a target list. ,  implementation_dba_data: AMS.AMS_LIST_HEADERS_ALL , 

  • Table: AMS_EVENT_REGISTRATIONS 12.1.1

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_EVENT_REGISTRATIONS,  object_name:AMS_EVENT_REGISTRATIONS,  status:VALID,  product: AMS - Marketing ,  description: Stores all enrollment information for an event, who got registered, who will be attending and their status. ,  implementation_dba_data: AMS.AMS_EVENT_REGISTRATIONS , 

  • Table: AMS_LIST_HEADERS_ALL 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_LIST_HEADERS_ALL,  object_name:AMS_LIST_HEADERS_ALL,  status:VALID,  product: AMS - Marketing ,  description: This table stores the name and other details about a target list. ,  implementation_dba_data: AMS.AMS_LIST_HEADERS_ALL , 

  • Table: AMS_EVENT_REGISTRATIONS 12.2.2

    owner:AMS,  object_type:TABLE,  fnd_design_data:AMS.AMS_EVENT_REGISTRATIONS,  object_name:AMS_EVENT_REGISTRATIONS,  status:VALID,  product: AMS - Marketing ,  description: Stores all enrollment information for an event, who got registered, who will be attending and their status. ,  implementation_dba_data: AMS.AMS_EVENT_REGISTRATIONS ,