Search Results ibe_dsp_msite_sct_sects

Overview

The table IBE_DSP_MSITE_SCT_SECTS is a core data object within the Oracle E-Business Suite iStore (IBE) module, specifically for releases 12.1.1 and 12.2.2. It functions as a junction or association table, defining the structural hierarchy of content sections within the context of a mini-site. In iStore, mini-sites are specialized, targeted storefronts, and sections are used to organize and display catalog content. This table is essential for establishing and managing the parent-child relationships between sections that are assigned to a specific mini-site, thereby controlling the navigational and merchandising layout presented to end-users.

Key Information Stored

The table's primary purpose is to store foreign key references that link three critical entities: a mini-site, a parent section, and a child section. Its structure is defined by its primary and foreign key constraints. The primary key, IBE_DSP_MSITE_SCT_SECTS_PK, is based on the column MINI_SITE_SECTION_SECTION_ID, which serves as a unique identifier for each association record. The table's relational integrity is maintained through three foreign keys: one linking MINI_SITE_ID to IBE_MSITES_B (the master table for mini-sites), and two linking PARENT_SECTION_ID and CHILD_SECTION_ID to IBE_DSP_SECTIONS_B (the master table for sections). This design allows for the creation of multi-level section hierarchies scoped to individual mini-sites.

Common Use Cases and Queries

A primary use case is querying the complete navigational tree for a specific mini-site to render the storefront or for administrative review. Developers and administrators also use this table to manage section assignments, such as adding a new child section to an existing hierarchy or removing sections from a mini-site. Common reporting needs include listing all sections associated with a mini-site or identifying sections that are not linked to any parent (potential root sections). A typical query pattern involves joining with IBE_MSITES_B and IBE_DSP_SECTIONS_B to resolve IDs to meaningful names.

SELECT ms.MINI_SITE_NAME,
       ps.SECTION_NAME AS PARENT_SECTION,
       cs.SECTION_NAME AS CHILD_SECTION
FROM IBE_DSP_MSITE_SCT_SECTS mss,
     IBE_MSITES_B ms,
     IBE_DSP_SECTIONS_B ps,
     IBE_DSP_SECTIONS_B cs
WHERE mss.MINI_SITE_ID = ms.MINI_SITE_ID
  AND mss.PARENT_SECTION_ID = ps.SECTION_ID(+)
  AND mss.CHILD_SECTION_ID = cs.SECTION_ID
  AND ms.MINI_SITE_ID = :p_mini_site_id;

Related Objects

The IBE_DSP_MSITE_SCT_SECTS table has direct dependencies on two fundamental master tables, as defined by its foreign keys. The table IBE_MSITES_B provides the valid list of mini-sites, while IBE_DSP_SECTIONS_B provides the valid list of content sections. This table is a critical component in the data model that supports the iStore user interface and content management logic. Consequently, it is likely referenced by various iStore application programming interfaces (APIs), seed data scripts, and potentially by views that aggregate display logic, though specific view names are not detailed in the provided metadata.