Search Results as_promotions_all




Overview
Explore in AI Chat

Overview

The AS_PROMOTIONS_ALL table is a core data object within the Oracle E-Business Suite (EBS) Sales Foundation (AS) module. It serves as the master repository for defining and storing all promotional campaigns and marketing activities. A promotion in this context is a structured marketing initiative used to generate leads, support events, manage collateral distribution, or drive sales. The table's multi-organization enabled structure, denoted by the "_ALL" suffix, allows it to store data partitioned by operating unit, making it central to the application's security and data access model. Its extensive network of foreign key relationships underscores its pivotal role as a hub connecting promotions to related entities like events, collateral, scripts, and lists.

Key Information Stored

The table's primary identifier is the PROMOTION_ID, which is the system-generated primary key for all related transactions. Critical business columns include CODE and NAME for unique identification and description of the promotion, and TYPE for classifying the promotion's nature. The table also stores financial and logistical details, such as CURRENCY_CODE for the promotion's budget and COLLATERAL_INVENTORY_ITEM_ID along with COLLATERAL_ORGANIZATION_ID to link to specific inventory items used as promotional materials. The EVENT_FACILITY_ID column ties the promotion to a physical event location, integrating campaign management with event planning.

Common Use Cases and Queries

This table is fundamental for reporting on promotional effectiveness, managing campaign hierarchies, and auditing marketing activities. Common operational queries include retrieving all active promotions for a specific operating unit or listing promotions of a certain type. A typical reporting query might join with currency and item tables to analyze promotion budgets and associated collateral.

  • Sample Query for Promotion List: SELECT promotion_id, code, name, type, currency_code FROM as_promotions_all WHERE org_id = :p_org_id ORDER BY creation_date DESC;
  • Use Case - Campaign Hierarchy: The AS_PROMOTION_RELATIONSHIPS table uses PARENT_PROMOTION_ID and CHILD_PROMOTION_ID to link promotions, enabling the modeling of complex, multi-tiered marketing campaigns.
  • Use Case - Event Integration: Promotions are linked to event enrollments and facilities, allowing analysis of which promotions drove event attendance and resource allocation.

Related Objects

AS_PROMOTIONS_ALL has a wide array of dependencies, as documented by its foreign keys. Key related objects include: