Search Results ams_venues_b_pk

Overview

The AMS_VENUES_B table is a core data object within the Oracle E-Business Suite Marketing (AMS) module. It functions as the base table for storing master information about venues, which are defined as physical places or locations that can be utilized to hold marketing events. As a foundational transactional table, it supports the planning and execution of events by providing a centralized repository for venue details. Its role is critical for associating specific events with their logistical locations, enabling resource scheduling, capacity planning, and cost management within the marketing domain of Oracle EBS releases 12.1.1 and 12.2.2.

Key Information Stored

The table's primary identifier is the VENUE_ID column, which is the primary key (AMS_VENUES_B_PK). The structure supports hierarchical relationships, as indicated by the self-referencing foreign key on PARENT_VENUE_ID, allowing for the modeling of complex venue structures (e.g., a convention center containing multiple halls). Key relational columns integrate the venue with other EBS entities: LOCATION_ID links to the HZ_LOCATIONS table in the Trading Community Architecture (TCA) for standardized address data, and PARTY_ID links to HZ_PARTIES to associate the venue with a specific organization or person within the TCA model. Other typical columns, inferred from standard EBS design patterns, would include descriptive fields, active/inactive status, creation and last update dates, and related audit information.

Common Use Cases and Queries

Primary use cases involve event setup, reporting, and venue management. Common operational queries include retrieving all active venues for a specific location, listing venues available for a given date range, or finding venues with a specific capacity. A typical reporting query might join AMS_VENUES_B with the event table (AMS_EVENT_OFFERS_ALL_B) to analyze event frequency by venue. For hierarchical navigation, a recursive query using the PARENT_VENUE_ID is essential. Sample SQL to find venues for events in a specific city would involve joining with HZ_LOCATIONS:

• SELECT v.VENUE_ID, tl.VENUE_NAME FROM AMS_VENUES_B v, AMS_VENUES_TL tl, HZ_LOCATIONS loc WHERE v.VENUE_ID = tl.VENUE_ID AND v.LOCATION_ID = loc.LOCATION_ID AND loc.CITY = 'LONDON' AND v.ENABLED_FLAG = 'Y';

Related Objects

The ETRM metadata specifies several key dependencies. The table has a translated descriptive flexfield (TL) table, AMS_VENUES_TL, which stores multilingual venue names. It is referenced by major transactional tables: AMS_EVENT_OFFERS_ALL_B (for the primary event venue), AMS_AGENDAS_B (for specific rooms), and AMS_VENUE_RATES_B (for associated pricing). The defined foreign keys establish critical relationships with the Trading Community Architecture (HZ_LOCATIONS, HZ_PARTIES). The self-referencing foreign key on PARENT_VENUE_ID indicates a hierarchical relationship within the table itself, supporting venue complexes or subdivisions.