Search Results ibe_dsp_msite_sct_items




Overview
Explore in AI Chat

Overview

The table IBE_DSP_MSITE_SCT_ITEMS is a core data object within the Oracle E-Business Suite (EBS) iStore (IBE) module. It functions as a junction table, establishing and storing the many-to-many associations between mini-sites and specific catalog items. A mini-site is a targeted, branded web storefront within the iStore framework, often used for specific marketing campaigns, partner channels, or customer segments. This table's primary role is to manage the content of these mini-sites by defining which catalog items are available for display and purchase within each one, thereby enabling controlled and segmented product merchandising.

Key Information Stored

The table's structure is designed to capture the essential linkage between a mini-site and an item. The critical columns are the foreign keys that form the association and the primary key that uniquely identifies each record. The MINI_SITE_ID column references a specific mini-site defined in the IBE_MSITES_B table. The SECTION_ITEM_ID column references a specific catalog item configuration defined in the IBE_DSP_SECTION_ITEMS table, which itself points to an inventory item. The table's primary identifier is the surrogate key MINI_SITE_SECTION_ITEM_ID, which is the primary key column for the IBE_DSP_MSITE_SCT_ITEMS_PK constraint. Furthermore, a unique constraint (IBE_DSP_MSITE_SCT_ITEMS_UK1) exists on the combination of MINI_SITE_ID and SECTION_ITEM_ID, ensuring that a specific item cannot be associated more than once to the same mini-site.

Common Use Cases and Queries

This table is central to operations involving the population and auditing of mini-site catalogs. Common use cases include generating a list of all items assigned to a particular mini-site for promotional validation, identifying all mini-sites where a specific discontinued or new item is featured, and loading item associations during mini-site setup via data migration scripts. A typical reporting query would join this table to its referenced master tables to produce a human-readable report.

Sample Query: To retrieve all items associated with a specific mini-site (e.g., ID 1000), including item details:

SELECT msite.mini_site_id,
       si.inventory_item_id,
       si.organization_id,
       msite_sct.mini_site_section_item_id
FROM   ibe_dsp_msite_sct_items msite_sct,
       ibe_msites_b msite,
       ibe_dsp_section_items si
WHERE  msite_sct.mini_site_id = msite.mini_site_id
AND    msite_sct.section_item_id = si.section_item_id
AND    msite.mini_site_id = 1000;

Related Objects

The functionality of IBE_DSP_MSITE_SCT_ITEMS is intrinsically linked to two primary master tables via foreign key relationships, as documented in the ETRM metadata.

  • IBE_MSITES_B: This is the base table for mini-site definitions. The foreign key relationship is defined on the column IBE_DSP_MSITE_SCT_ITEMS.MINI_SITE_ID referencing IBE_MSITES_B. This ensures every association in the junction table points to a valid, existing mini-site.
  • IBE_DSP_SECTION_ITEMS: This table stores the master list of catalog items available for assignment. The foreign key relationship is defined on the column IBE_DSP_MSITE_SCT_ITEMS.SECTION_ITEM_ID referencing IBE_DSP_SECTION_ITEMS. This ensures every associated item is a valid, configured catalog entry.

These relationships enforce data integrity and are essential for any join operation to retrieve descriptive information about the linked mini-sites and items.