Search Results jtf_stores_b




Overview
Explore in AI Chat

Overview

The JTF_STORES_B table is a core data object within the Oracle E-Business Suite CRM Foundation (JTF) module. It serves as the primary repository for storing the master details of a web store, which is a fundamental entity in the E-Business Suite's e-commerce and channel management architecture. This table holds the transactional, non-translatable attributes that define a store's operational and structural properties. Its role is critical for enabling storefront functionality, managing customer access points, and integrating with other CRM and order management components.

Key Information Stored

As the base table for store entities, JTF_STORES_B contains columns that define the store's identity, status, and configuration. The primary key, STORE_ID, uniquely identifies each store record. While the provided metadata does not list all columns, typical columns in such a base table include creation and last update dates (CREATION_DATE, LAST_UPDATE_DATE), the user IDs responsible for these actions (CREATED_BY, LAST_UPDATED_BY), and version control (OBJECT_VERSION_NUMBER). It would also store critical attributes such as the store's active status flag, associated inventory organization, default currency, and potentially references to operational templates or security profiles that govern the store's behavior and presentation.

Common Use Cases and Queries

This table is central to operations involving web store configuration and data retrieval. Common use cases include administering the list of available storefronts, associating stores with specific marketing sites or content, and driving the product catalog presentation for a given channel. A fundamental query involves joining the table with its descriptive translation table, JTF_STORES_TL, to retrieve a store's name and description in a desired language. For reporting, one might query all active stores to analyze channel setup.

  • Sample Query: Retrieving active store details with English descriptions.
    SELECT b.STORE_ID, tl.STORE_NAME, b.CREATION_DATE
    FROM JTF.JTF_STORES_B b, JTF.JTF_STORES_TL tl
    WHERE b.STORE_ID = tl.STORE_ID
    AND tl.LANGUAGE = 'US'
    AND b.STATUS = 'A';

Related Objects

The JTF_STORES_B table maintains defined relationships with several other key CRM objects, as documented in the metadata. It is the parent table in these relationships, with its primary key referenced as a foreign key elsewhere.

  • JTF_STORES_TL: This is the translation table that stores language-specific descriptive information (like STORE_NAME and DESCRIPTION) for the records in JTF_STORES_B. They are joined on the STORE_ID column.
  • JTF_MSITES_B: This table, which stores details about marketing sites, references JTF_STORES_B. The foreign key JTF_MSITES_B.STORE_ID links a marketing site to a specific web store, defining the storefront associated with that site.