Search Results jtf_dsp_tpl_ctg




Overview
Explore in AI Chat

Overview

JTF_DSP_TPL_CTG is a CRM Foundation (JTF) table that stores category-to-logical-template mappings. In the Oracle E-Business Suite 12.1.1 and 12.2.2 data model, it functions as a cross-reference or association entity within the JTF display/template subsystem, allowing administrators and applications to associate an Abstract Model View (AMV) item — the logical template — with a standard inventory category. This linkage enables category-driven behavior such as conditional template rendering, personalized dashboard or folder content selection, and dynamic presentation logic that varies by product classification.

Based on the documented foreign key topology, the heuristic Data Vault classification for this object is link. The table's defining columns are two foreign keys (ITEM_ID and CATEGORY_ID) that reference independent parent hubs, which is the classic signature of a link table resolving a many-to-many relationship between a template item and a category. Modelers should treat this as a modeling suggestion rather than a prescribed design; the presence of audit columns and a surrogate key is also compatible with a satellite-style treatment of descriptive attributes, but the association role dominates.

Key Information Stored

The documented physical schema contains eleven columns. The most significant are:

  • TPL_CTG_ID — Surrogate primary key, enforced by the JTF_DSP_TPL_CTG_PK constraint. It uniquely identifies each category-to-template mapping row.
  • ITEM_ID — Foreign key to JTF_AMV_ITEMS_B, identifying the logical template (AMV item) being mapped. This is a business-key candidate within the unique constraint JTF_DSP_TPL_CTG_UK1.
  • CATEGORY_ID — Foreign key to MTL_CATEGORIES_B, identifying the inventory category to which the template applies. This is the second business-key candidate in JTF_DSP_TPL_CTG_UK1.
  • SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, supporting multi-organization and data-security partitioning of the mapping.
  • SECURITY_GROUP — Denormalized or text representation of the security grouping used by the JTF security model.
  • OBJECT_VERSION_NUMBER — Optimistic locking column used by the framework to detect concurrent updates.
  • CREATED_BY, CREATION_DATE — Standard WHO audit columns recording row creation.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns recording the most recent modification and the login that performed it.

The unique index JTF_DSP_TPL_CTG_UK1 on (ITEM_ID, CATEGORY_ID) enforces that a given template item may be associated with a given category only once, making the pair the natural business key while TPL_CTG_ID remains the technical primary key.

Common Use Cases and Queries

Typical scenarios include diagnosing why a template does or does not appear for a category, auditing category-template assignments after a category hierarchy change, and migrating template mappings between environments.

  • Resolve all templates for a category, joining to JTF_AMV_ITEMS_B for template names.
  • Find categories without any template mapping to identify configuration gaps.
  • Audit recent changes using LAST_UPDATE_DATE and LAST_UPDATED_BY.
  • Extract a full mapping report joining MTL_CATEGORIES_B for category segment values.

A representative query pattern:

SELECT c.tpl_ctg_id, i.item_name, m.category_name, c.last_update_date
FROM jtf.jtf_dsp_tpl_ctg c,
     jtf.jtf_amv_items_b i,
     mtl.mtl_categories_b m
WHERE c.item_id = i.item_id
  AND c.category_id = m.category_id
  AND c.category_id = :category_id;

Because SECURITY_GROUP_ID participates in the mapping, reports should generally be filtered or partitioned by security group to respect the CRM Foundation access model.

Related Objects

  • JTF_AMV_ITEMS_B — Parent table of logical templates, joined via JTF_DSP_TPL_CTG.ITEM_ID; supplies template metadata such as name and type.
  • MTL_CATEGORIES_B — Parent table of inventory categories, joined via JTF_DSP_TPL_CTG.CATEGORY_ID; supplies category definitions.
  • FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID; governs visibility and organization-level partitioning.
  • JTF_DSP_TPL_CTG_PK / JTF_DSP_TPL_CTG_UK1 — The primary key and unique index constraints that define row identity and business-key uniqueness.
  • JTF_AMV_ITEMS_TL — Translation table for AMV item names, commonly joined alongside JTF_AMV_ITEMS_B in multilingual reporting.
  • MTL_CATEGORIES_TL — Translation table for category descriptions, used with MTL_CATEGORIES_B when rendering user-facing labels.

Together these relationships place JTF_DSP_TPL_CTG at the intersection of the CRM Foundation template framework and the inventory category model, making it a small but operationally meaningful mapping table in Oracle EBS.