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.
- Surrogate primary key: SECTION_ITEM_ID, enforced by the JTF_DSP_SECTION_ITEMS_PK constraint. This value uniquely identifies each section-to-item association row.
- Business-key candidates: The unique index JTF_DSP_SECTION_ITEMS_U2 covers SECTION_ID, INVENTORY_ITEM_ID, and ORGANIZATION_ID, making this composite the natural business key of the association. A second unique index, JTF_DSP_SECTION_ITEMS_U1, is defined on SECTION_ITEM_ID alone.
- Foreign-key and context columns: SECTION_ID references the section header in JTF_DSP_SECTIONS_B. INVENTORY_ITEM_ID and ORGANIZATION_ID identify the item being assigned and the inventory organization that owns it. SECURITY_GROUP_ID references FND_SECURITY_GROUPS and governs row-level access.
- Effective-dating and ordering: START_DATE_ACTIVE and END_DATE_ACTIVE define the active window of the association, while SORT_ORDER controls the display sequence of items within a section. ASSOCIATION_REASON_CODE captures the rationale for the linkage.
- Audit and concurrency columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and OBJECT_VERSION_NUMBER provide standard EBS auditability and optimistic locking support.
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.
-
This table stores the association between sections and items.
-
This table stores the association between sections and items.
-
APPS.JTF_DSP_FEATURED_MEDIA_V·↳ FND_PROFILE·↳ JTF_AMV_ITEMS_VL·↳ JTF_DSP_CONTEXT_B·Explore JTF module →
-
APPS.JTF_DSP_FEATURED_MEDIA_V·↳ FND_PROFILE·↳ JTF_AMV_ITEMS_VL·↳ JTF_DSP_CONTEXT_B·Explore JTF module →
-
This table stores the assocation between mini-site and items.
-
This table stores the assocation between mini-site and items.