Search Results obj_lgl_ctnt_id




Overview
Explore in AI Chat

Overview

The JTF_DSP_OBJ_LGL_CTNT table is a core data structure within the Oracle E-Business Suite CRM Foundation (JTF) module. It functions as a mapping and configuration table that defines default logical items for specific display contexts and objects. In essence, it governs how certain data elements, particularly within the CRM user interface, are presented or associated based on a given context, such as a category or a section. This table is integral to the display and personalization layers of the application, ensuring that the correct logical components are rendered for different objects across various contexts in releases 12.1.1 and 12.2.2.

Key Information Stored

The table's primary purpose is to store association records. Its key columns, as indicated by its foreign key relationships, are the identifiers that create these mappings. The primary key is OBJ_LGL_CTNT_ID, a unique system-generated identifier for each mapping record. The CONTEXT_ID column references a specific display context defined in JTF_DSP_CONTEXT_B. The OBJECT_ID can reference either an inventory category (MTL_CATEGORIES_B) or a display section (JTF_DSP_SECTIONS_B), indicating the object type for which the logical item is defined. Finally, the ITEM_ID column points to a logical item definition in the JTF_AMV_ITEMS_B table, specifying the default item to be used for the given context and object combination.

Common Use Cases and Queries

A primary use case involves troubleshooting or customizing the default display logic for categorized items or application sections. For instance, an administrator may need to identify which logical item is presented for all objects within a specific display context. A common reporting query would join this table to its referenced master tables to make the codes and names readable.

Sample Query:
SELECT dsp.obj_lgl_ctnt_id,
ctx.context_name,
cat.segment1 category,
item.item_title
FROM jtf_dsp_obj_lgl_ctnt dsp,
jtf_dsp_context_b ctx,
mtl_categories_b cat,
jtf_amv_items_b item
WHERE dsp.context_id = ctx.context_id
AND dsp.object_id = cat.category_id
AND dsp.item_id = item.item_id
AND ctx.context_code = 'MY_CONTEXT';

Related Objects

The JTF_DSP_OBJ_LGL_CTNT table maintains documented foreign key relationships with several master tables, forming the basis of its configuration logic.

  • JTF_DSP_CONTEXT_B: Joined via CONTEXT_ID. This table defines the available display contexts.
  • JTF_AMV_ITEMS_B: Joined via ITEM_ID. This table stores the definition of the logical items (e.g., reports, links) that can be assigned as defaults.
  • MTL_CATEGORIES_B: Joined via OBJECT_ID. This table holds inventory item categories, one type of object for which a default logical item can be specified.
  • JTF_DSP_SECTIONS_B: Joined via OBJECT_ID. This table defines display sections, representing another object type for configuration.

The table is centrally referenced by its primary key constraint, JTF_DSP_OBJ_LGL_CTNT_PK.