Results for “jtf_dsp_section_items”

50+ results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

JTF_DSP_SECTION_ITEMS is a CRM Foundation (JTF) transactional table within the Oracle E-Business Suite 12.1.1 and 12.2.2 data model. It stores the association between display sections and the inventory items assigned to those sections. The table is owned by the JTF schema and holds a VALID status in the documented environment. Its practical role is to resolve a many-to-many relationship: a section defined in JTF_DSP_SECTIONS_B can be linked to one or more inventory items, and each linkage is materialized as a discrete row carrying its own effective-dating and sequencing attributes.

From a Data Vault modeling perspective, the mined foreign key structure classifies this object as satellite-leaning. The presence of START_DATE_ACTIVE and END_DATE_ACTIVE, together with AUDIT columns and a SORT_ORDER attribute, indicates that rows describe the changing state of a parent entity rather than a pure hub or a pure link. Analysts designing a Data Vault or dimensional layer should treat JTF_DSP_SECTION_ITEMS as a time-variant satellite attached to the section entity defined in JTF_DSP_SECTIONS_B, with the item and organization identifiers acting as descriptive context.

Key Information Stored

The table's documented physical schema contains fifteen columns. The most significant of these fall into three groups.

Common Use Cases and Queries

Typical reporting scenarios include retrieving the active items for a given section, reproducing the historical state of a section as of a past date, and auditing item assignments by organization. Effective-dating predicates are essential because multiple rows for the same section and item may exist across different active windows.

  • Active items for a section: SELECT INVENTORY_ITEM_ID, ORGANIZATION_ID, SORT_ORDER FROM JTF.JTF_DSP_SECTION_ITEMS WHERE SECTION_ID = :section_id AND SYSDATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, SYSDATE) ORDER BY SORT_ORDER;
  • Sections containing a specific item: SELECT SECTION_ID FROM JTF.JTF_DSP_SECTION_ITEMS WHERE INVENTORY_ITEM_ID = :item_id AND ORGANIZATION_ID = :org_id;
  • Change audit by user: filter on LAST_UPDATED_BY and LAST_UPDATE_DATE to report recent assignments.
  • Security-scoped extracts: join to FND_SECURITY_GROUPS through SECURITY_GROUP_ID when building access-filtered reporting extracts.

Related Objects

The following objects are the most significant dependents and references of JTF_DSP_SECTION_ITEMS.

  • JTF_DSP_SECTIONS_B — parent table; joined on JTF_DSP_SECTION_ITEMS.SECTION_ID = JTF_DSP_SECTIONS_B.SECTION_ID.
  • JTF_DSP_MSITE_SCT_ITEMS — child table; references this object through SECTION_ITEM_ID and extends the association to mobile-site contexts.
  • FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID to enforce row-level security.
  • MTL_SYSTEM_ITEMS_B — the conventional source of descriptive item attributes for INVENTORY_ITEM_ID and ORGANIZATION_ID values.
  • JTF_DSP_SECTION_ITEMS_PK / _U1 / _U2 — the primary key and unique index constraints that define row identity and the natural business key.