Search Results ams_venue_rates_b




Overview
Explore in AI Chat

Overview

The AMS_VENUE_RATES_B table is a core data object within the Oracle E-Business Suite (EBS) Marketing (AMS) module, specifically for versions 12.1.1 and 12.2.2. As indicated by its description, it serves as the primary repository for storing rate information associated with venues. In the context of marketing campaigns and events, a venue is a physical location, and this table holds the associated cost or pricing data for utilizing that location. The '_B' suffix denotes it as a base table, meaning it stores the fundamental transactional data. This table is critical for the financial planning and budgeting aspects of marketing events, enabling users to define, track, and report on venue-related expenses.

Key Information Stored

While the provided metadata does not list specific columns beyond the primary and foreign keys, the structure reveals the essential data relationships. The table's primary key is the RATE_ID column, which uniquely identifies each venue rate record. A critical foreign key is the VENUE_ID column, which establishes a mandatory link to the AMS_VENUES_B table, ensuring that every rate is associated with a defined venue. Typical data stored in such a table would include the rate amount, currency, effective start and end dates for the rate, rate type (e.g., daily, hourly, flat fee), and any applicable conditions or modifiers. The existence of a related translation table (AMS_VENUE_RATES_TL) suggests that descriptive attributes of the rate may be stored in a multilingual format.

Common Use Cases and Queries

This table is central to operations involving the costing of marketing events. Common use cases include generating cost estimates for proposed events, creating budgets, and performing actual cost analysis post-event. A frequent reporting requirement is to list all active rates for a specific venue or a set of venues. A sample query pattern to achieve this would join the venue rates to the venue master table and potentially its descriptive translations.

  • Fetching Active Rates for a Venue: SELECT rate_id, rate_amount, currency_code FROM ams_venue_rates_b WHERE venue_id = :p_venue_id AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);
  • Joining with Venue Details: SELECT v.venue_name, r.rate_amount, r.currency_code FROM ams_venues_b v, ams_venue_rates_b r WHERE v.venue_id = r.venue_id ORDER BY v.venue_name;

Related Objects

The AMS_VENUE_RATES_B table exists within a defined relational schema. Its primary relationships, as per the metadata, are:

  • AMS_VENUES_B: The parent table. The VENUE_ID foreign key in AMS_VENUE_RATES_B references the primary key of this table, enforcing that a rate cannot exist without a valid venue.
  • AMS_VENUE_RATES_TL: A child translation table. It holds multilingual descriptions for the rates defined in the base table, linked via the RATE_ID foreign key. This allows the system to present rate descriptions in the user's session language.
  • AMS_VENUES_B_PK1: The primary key constraint on the RATE_ID column, ensuring data integrity and uniqueness for each rate record.

This table is likely referenced by various AMS forms, reports, and APIs responsible for event management and financial processing within the Marketing module.