Search Results jtf_dsp_msite_sct_items




Overview
Explore in AI Chat

Overview

The JTF_DSP_MSITE_SCT_ITEMS table is a core data object within the Oracle E-Business Suite CRM Foundation (JTF) module, specifically for releases 12.1.1 and 12.2.2. It functions as a junction or association table, establishing and storing the many-to-many relationships between mini-sites and section items. Mini-sites are configurable web storefronts within the E-Business Suite, and section items represent the discrete pieces of content or products displayed within those storefronts. The table's primary role is to manage the content layout and composition of these digital storefronts, enabling administrators to define which items appear in which mini-site sections.

Key Information Stored

The table's structure is designed to capture the essential identifiers for the association. The primary unique identifier for each association record is the MINI_SITE_SECTION_ITEM_ID, a system-generated sequence number. The two critical foreign key columns are MINI_SITE_ID, which references a specific storefront defined in JTF_MSITES_B, and SECTION_ITEM_ID, which references a content item defined in JTF_DSP_SECTION_ITEMS. A unique key constraint on the combination of MINI_SITE_ID and SECTION_ITEM_ID ensures that the same item cannot be redundantly associated with the same mini-site.

Common Use Cases and Queries

This table is central to content management and reporting for E-Business Suite storefronts. Common operational use cases include querying all items assigned to a specific mini-site for auditing purposes, or identifying all mini-sites where a particular product or content item is featured. A typical reporting query would join this table to its parent tables to generate a readable list of associations.

Sample SQL to retrieve all items for a specific mini-site (ID 1000):

  • SELECT msit.MINI_SITE_NAME, sit.ITEM_NAME
  • FROM JTF_DSP_MSITE_SCT_ITEMS assoc,
  • JTF_MSITES_B msit,
  • JTF_DSP_SECTION_ITEMS sit
  • WHERE assoc.MINI_SITE_ID = msit.MINI_SITE_ID
  • AND assoc.SECTION_ITEM_ID = sit.SECTION_ITEM_ID
  • AND assoc.MINI_SITE_ID = 1000;

Related Objects

The JTF_DSP_MSITE_SCT_ITEMS table is a dependent entity with defined foreign key relationships to two master tables, as documented in the ETRM metadata.

  • JTF_MSITES_B: This table stores the definition and header information for mini-sites. The relationship is maintained via the MINI_SITE_ID column in JTF_DSP_MSITE_SCT_ITEMS.
  • JTF_DSP_SECTION_ITEMS: This table is the master repository for all available section items (content or products). The relationship is maintained via the SECTION_ITEM_ID column in JTF_DSP_MSITE_SCT_ITEMS.

These relationships enforce referential integrity, ensuring that an association record cannot exist without valid parent records in both the mini-site and section item master tables.