Search Results ibe_msites_b

Overview

The IBE_MSITES_B table is a core data object within the Oracle E-Business Suite iStore module (IBE). It serves as the master repository for Mini Site, or Specialty Store, configurations. In the context of Oracle EBS 12.1.1 and 12.2.2, a Mini Site represents a specialized, branded storefront that operates within a larger primary iStore instance. This enables organizations to create targeted, segmented shopping experiences for different brands, product lines, or customer groups under a single EBS installation. The table's role is to store the fundamental administrative and structural definitions for each such storefront.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the foreign key relationships and table description clearly indicate the nature of the critical data stored. The primary identifier is the MSITE_ID (Primary Key). Essential configuration attributes linked via foreign keys include the DEFAULT_LANGUAGE_CODE (from FND_LANGUAGES) and DEFAULT_CURRENCY_CODE (from FND_CURRENCIES), establishing the base locale for the Mini Site. A pivotal structural element is the MSITE_ROOT_SECTION_ID, which references IBE_DSP_SECTIONS_B to define the root navigation section for the store's catalog hierarchy. The table also maintains a link to a parent STORE_ID, indicating its relationship to a broader iStore setup.

Common Use Cases and Queries

This table is central to operations involving multi-brand storefront management. Common use cases include generating a list of all active Mini Sites for administrative reporting, determining the configuration of a specific storefront for session initialization, and tracing the origin of orders or quotes back to their source Mini Site for analytical reporting. A typical query would join IBE_MSITES_B with its translated descriptive data in IBE_MSITES_TL and related configuration tables.

SELECT b.msite_id, tl.name, b.default_language_code, b.default_currency_code
FROM ibe_msites_b b,
     ibe_msites_tl tl
WHERE b.msite_id = tl.msite_id
  AND tl.language = USERENV('LANG')
  AND b.store_id = :p_parent_store_id;

Another critical reporting pattern involves joining to order lines to analyze sales performance by Mini Site:

SELECT msite.name, SUM(oline.ordered_quantity)
FROM oe_order_lines_all oline,
     ibe_msites_b msite
WHERE oline.minisite_id = msite.msite_id
GROUP BY msite.name;

Related Objects

The IBE_MSITES_B table is a central hub with extensive relationships across the iStore and Order Management schemas. As per the metadata, key related objects include:

Translations: IBE_MSITES_TL holds the translated names and descriptions.
Configuration: IBE_MSITE_INFORMATION, IBE_MSITE_CURRENCIES, IBE_MSITE_LANGUAGES, IBE_MSITE_ORGS, and IBE_MSITE_PRTY_ACCSS store extended setup data.
Navigation & Display: IBE_DSP_MSITE_SCT_SECTS, IBE_DSP_MSITE_SCT_ITEMS, and IBE_DSP_LGL_PHYS_MAP manage the catalog and page rendering.
Transactional Data: OE_ORDER_LINES_ALL, OE_ORDER_HEADER_HISTORY, IBE_ECR_ORDERS_FACT, and IBE_ECR_QUOTES_FACT reference the MSITE_ID to track the originating storefront for sales and quotes.
Security: IBE_MSITE_RESPS_B links Mini Sites to responsibilities.

Table: IBE_MSITES_B 12.1.1
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_MSITES_B, object_name:IBE_MSITES_B, status:VALID, product: IBE - iStore , description: Stores Mini Site (Specialty Stores) Information. , implementation_dba_data: IBE.IBE_MSITES_B ,
Table: IBE_MSITES_B 12.2.2
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_MSITES_B, object_name:IBE_MSITES_B, status:VALID, product: IBE - iStore , description: Stores Mini Site (Specialty Stores) Information. , implementation_dba_data: IBE.IBE_MSITES_B ,
Table: IBE_MSITES_TL 12.1.1
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_MSITES_TL, object_name:IBE_MSITES_TL, status:VALID, product: IBE - iStore , description: Translations for IBE_MSITES_B , implementation_dba_data: IBE.IBE_MSITES_TL ,
Table: IBE_MSITES_TL 12.2.2
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_MSITES_TL, object_name:IBE_MSITES_TL, status:VALID, product: IBE - iStore , description: Translations for IBE_MSITES_B , implementation_dba_data: IBE.IBE_MSITES_TL ,
Table: IBE_ECR_ORDERS_FACT 12.2.2
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_ECR_ORDERS_FACT, object_name:IBE_ECR_ORDERS_FACT, status:VALID, product: IBE - iStore , description: Granular aggregate information of Orders for a given period. , implementation_dba_data: IBE.IBE_ECR_ORDERS_FACT ,
Table: IBE_MSITE_ORGS 12.2.2
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_MSITE_ORGS, object_name:IBE_MSITE_ORGS, status:VALID, product: IBE - iStore , description: Define the organizations supported by the mini-sites , implementation_dba_data: IBE.IBE_MSITE_ORGS ,
Table: IBE_WF_NOTIF_MSG_MAPS 12.1.1
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_WF_NOTIF_MSG_MAPS, object_name:IBE_WF_NOTIF_MSG_MAPS, status:VALID, product: IBE - iStore , description: This table contains information about message mappings for each notification. , implementation_dba_data: IBE.IBE_WF_NOTIF_MSG_MAPS ,
Table: IBE_DSP_MSITE_SCT_SECTS 12.1.1
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_DSP_MSITE_SCT_SECTS, object_name:IBE_DSP_MSITE_SCT_SECTS, status:VALID, product: IBE - iStore , description: This table stores the association between mini-site and sections. , implementation_dba_data: IBE.IBE_DSP_MSITE_SCT_SECTS ,
Table: IBE_MSITE_LANGUAGES 12.1.1
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_MSITE_LANGUAGES, object_name:IBE_MSITE_LANGUAGES, status:VALID, product: IBE - iStore , description: Stores the languages supported by the mini-sites , implementation_dba_data: IBE.IBE_MSITE_LANGUAGES ,
Table: IBE_ECR_QUOTES_FACT 12.2.2
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_ECR_QUOTES_FACT, object_name:IBE_ECR_QUOTES_FACT, status:VALID, product: IBE - iStore , description: Granular aggregate information about quotes for a given period. , implementation_dba_data: IBE.IBE_ECR_QUOTES_FACT ,
Table: IBE_DSP_LGL_PHYS_MAP 12.2.2
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_DSP_LGL_PHYS_MAP, object_name:IBE_DSP_LGL_PHYS_MAP, status:VALID, product: IBE - iStore , description: Stores the logical to physical media mapping based on site and language , implementation_dba_data: IBE.IBE_DSP_LGL_PHYS_MAP ,
Table: IBE_ECR_QUOTES_FACT 12.1.1
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_ECR_QUOTES_FACT, object_name:IBE_ECR_QUOTES_FACT, status:VALID, product: IBE - iStore , description: Granular aggregate information about quotes for a given period. , implementation_dba_data: IBE.IBE_ECR_QUOTES_FACT ,
Table: IBE_MSITE_CURRENCIES 12.2.2
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_MSITE_CURRENCIES, object_name:IBE_MSITE_CURRENCIES, status:VALID, product: IBE - iStore , description: Stores the currencies supported by the mini-sites , implementation_dba_data: IBE.IBE_MSITE_CURRENCIES ,
Table: IBE_MSITE_INFORMATION 12.2.2
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_MSITE_INFORMATION, object_name:IBE_MSITE_INFORMATION, status:VALID, product: IBE - iStore , description: This Table Stores Additional Information about Specialty Stores , implementation_dba_data: IBE.IBE_MSITE_INFORMATION ,
Table: IBE_MSITE_INFORMATION 12.1.1
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_MSITE_INFORMATION, object_name:IBE_MSITE_INFORMATION, status:VALID, product: IBE - iStore , description: This Table Stores Additional Information about Specialty Stores , implementation_dba_data: IBE.IBE_MSITE_INFORMATION ,
Table: IBE_DSP_MSITE_SCT_ITEMS 12.2.2
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_DSP_MSITE_SCT_ITEMS, object_name:IBE_DSP_MSITE_SCT_ITEMS, status:VALID, product: IBE - iStore , description: This table stores the assocation between mini-site and items. , implementation_dba_data: IBE.IBE_DSP_MSITE_SCT_ITEMS ,
Table: IBE_MSITE_RESPS_B 12.1.1
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_MSITE_RESPS_B, object_name:IBE_MSITE_RESPS_B, status:VALID, product: IBE - iStore , description: Defines the responsibilities supported by the Specialty Store. , implementation_dba_data: IBE.IBE_MSITE_RESPS_B ,
Table: IBE_SECTION_SEARCH 12.1.1
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_SECTION_SEARCH, object_name:IBE_SECTION_SEARCH, status:VALID, product: IBE - iStore , description: The search table for restricting search to section(s). , implementation_dba_data: IBE.IBE_SECTION_SEARCH ,
Table: IBE_SECTION_SEARCH 12.2.2
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_SECTION_SEARCH, object_name:IBE_SECTION_SEARCH, status:VALID, product: IBE - iStore , description: The search table for restricting search to section(s). , implementation_dba_data: IBE.IBE_SECTION_SEARCH ,
Table: IBE_ECR_ORDERS_FACT 12.1.1
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_ECR_ORDERS_FACT, object_name:IBE_ECR_ORDERS_FACT, status:VALID, product: IBE - iStore , description: Granular aggregate information of Orders for a given period. , implementation_dba_data: IBE.IBE_ECR_ORDERS_FACT ,
Table: IBE_MSITE_ORGS 12.1.1
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_MSITE_ORGS, object_name:IBE_MSITE_ORGS, status:VALID, product: IBE - iStore , description: Define the organizations supported by the mini-sites , implementation_dba_data: IBE.IBE_MSITE_ORGS ,
Table: IBE_MSITE_CURRENCIES 12.1.1
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_MSITE_CURRENCIES, object_name:IBE_MSITE_CURRENCIES, status:VALID, product: IBE - iStore , description: Stores the currencies supported by the mini-sites , implementation_dba_data: IBE.IBE_MSITE_CURRENCIES ,
Table: IBE_MSITE_PRTY_ACCSS 12.1.1
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_MSITE_PRTY_ACCSS, object_name:IBE_MSITE_PRTY_ACCSS, status:VALID, product: IBE - iStore , description: Defines the parties supported by the Specialty Stores , implementation_dba_data: IBE.IBE_MSITE_PRTY_ACCSS ,
Table: IBE_WF_NOTIF_MSG_MAPS 12.2.2
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_WF_NOTIF_MSG_MAPS, object_name:IBE_WF_NOTIF_MSG_MAPS, status:VALID, product: IBE - iStore , description: This table contains information about message mappings for each notification. , implementation_dba_data: IBE.IBE_WF_NOTIF_MSG_MAPS ,
Table: IBE_MSITE_LANGUAGES 12.2.2
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_MSITE_LANGUAGES, object_name:IBE_MSITE_LANGUAGES, status:VALID, product: IBE - iStore , description: Stores the languages supported by the mini-sites , implementation_dba_data: IBE.IBE_MSITE_LANGUAGES ,
Table: IBE_MSITE_PRTY_ACCSS 12.2.2
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_MSITE_PRTY_ACCSS, object_name:IBE_MSITE_PRTY_ACCSS, status:VALID, product: IBE - iStore , description: Defines the parties supported by the Specialty Stores , implementation_dba_data: IBE.IBE_MSITE_PRTY_ACCSS ,
Table: IBE_DSP_MSITE_SCT_SECTS 12.2.2
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_DSP_MSITE_SCT_SECTS, object_name:IBE_DSP_MSITE_SCT_SECTS, status:VALID, product: IBE - iStore , description: This table stores the association between mini-site and sections. , implementation_dba_data: IBE.IBE_DSP_MSITE_SCT_SECTS ,
Table: IBE_DSP_MSITE_SCT_ITEMS 12.1.1
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_DSP_MSITE_SCT_ITEMS, object_name:IBE_DSP_MSITE_SCT_ITEMS, status:VALID, product: IBE - iStore , description: This table stores the assocation between mini-site and items. , implementation_dba_data: IBE.IBE_DSP_MSITE_SCT_ITEMS ,
Table: IBE_DSP_LGL_PHYS_MAP 12.1.1
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_DSP_LGL_PHYS_MAP, object_name:IBE_DSP_LGL_PHYS_MAP, status:VALID, product: IBE - iStore , description: Stores the logical to physical media mapping based on site and language , implementation_dba_data: IBE.IBE_DSP_LGL_PHYS_MAP ,
Table: IBE_MSITE_RESPS_B 12.2.2
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_MSITE_RESPS_B, object_name:IBE_MSITE_RESPS_B, status:VALID, product: IBE - iStore , description: Defines the responsibilities supported by the Specialty Store. , implementation_dba_data: IBE.IBE_MSITE_RESPS_B ,
Table: IBE_DSP_SECTIONS_B 12.2.2
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_DSP_SECTIONS_B, object_name:IBE_DSP_SECTIONS_B, status:VALID, product: IBE - iStore , description: This table stores information about the sections. , implementation_dba_data: IBE.IBE_DSP_SECTIONS_B ,
Table: IBE_DSP_SECTIONS_B 12.1.1
owner:IBE, object_type:TABLE, fnd_design_data:IBE.IBE_DSP_SECTIONS_B, object_name:IBE_DSP_SECTIONS_B, status:VALID, product: IBE - iStore , description: This table stores information about the sections. , implementation_dba_data: IBE.IBE_DSP_SECTIONS_B ,
View: IBE_MSITES_VL 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IBE.IBE_MSITES_VL, object_name:IBE_MSITES_VL, status:VALID, product: IBE - iStore , implementation_dba_data: APPS.IBE_MSITES_VL ,
View: IBE_MSITES_VL 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:IBE.IBE_MSITES_VL, object_name:IBE_MSITES_VL, status:VALID, product: IBE - iStore , implementation_dba_data: APPS.IBE_MSITES_VL ,