Results for “ams_deliv_kit_items”

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

Overview

AMS_DELIV_KIT_ITEMS is a transactional table in the AMS (Marketing) product schema of Oracle E-Business Suite, present and valid in both 12.1.1 and 12.2.2. It stores the line-level detail of marketing deliverable kits — specifically, the individual collaterals and deliverables that are bundled into a kit. Where AMS_DELIVERABLES_ALL_B holds the deliverable and kit header definitions, AMS_DELIV_KIT_ITEMS serves as the intersection that records which deliverables belong to which kits, along with quantities.

Under a heuristic Data Vault classification mined from its foreign-key structure, this object is best modeled as a link table. It resolves a many-to-many association between deliverables and kits, both of which reside in AMS_DELIVERABLES_ALL_B, and incorporates an optional recursive-style reference back to the kit from which an included part originated. This classification is a modeling suggestion derived from the FK topology, not a declared property of the EBS object itself.

Key Information Stored

The table contains 28 documented columns. The most significant are:

• DELIVERABLE_KIT_ITEM_ID — surrogate primary key, enforced by index AMS_DELIV_KIT_ITEMS_PK. Uniquely identifies each kit-item association row.
• DELIVERABLE_KIT_ID — foreign key to AMS_DELIVERABLES_ALL_B identifying the parent kit.
• DELIVERABLE_KIT_PART_ID — foreign key to AMS_DELIVERABLES_ALL_B identifying the deliverable (part) included in the kit.
• KIT_PART_INCLUDED_FROM_KIT_ID — foreign key to AMS_DELIVERABLES_ALL_B identifying the kit from which the included part was sourced; supports kit composition and nested kit inheritance.
• QUANTITY — the number of units of the deliverable part contained within the kit.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enforcing Multi-Org / data security partitioning.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the EBS framework during concurrent updates.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard EBS descriptive flexfield (DFF) columns for extensibility.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — who-audit columns for change tracking.

Two unique indexes act as business-key candidates: AMS_DELIV_KIT_ITEMS_U1 on DELIVERABLE_KIT_ITEM_ID and AMS_DELIV_KIT_ITEMS_U2 on the composite (DELIVERABLE_KIT_ID, DELIVERABLE_KIT_PART_ID). The U2 constraint guarantees that a given deliverable appears at most once within a given kit.

Common Use Cases and Queries

Typical reporting scenarios include enumerating the collaterals belonging to a kit, quantifying kit contents, and tracing the origin of included parts. A representative join pattern:

• Listing kit contents: SELECT kit_item.DELIVERABLE_KIT_ID, kit_item.DELIVERABLE_KIT_PART_ID, kit_item.QUANTITY FROM AMS.AMS_DELIV_KIT_ITEMS kit_item WHERE kit_item.DELIVERABLE_KIT_ID = :kit_id;
• Resolving deliverable names via AMS_DELIVERABLES_ALL_B using DELIVERABLE_KIT_PART_ID.
• Detecting kits sourced from other kits via KIT_PART_INCLUDED_FROM_KIT_ID.
• Security-scoped reporting by filtering on SECURITY_GROUP_ID.

Related Objects

• AMS_DELIVERABLES_ALL_B — referenced three times via DELIVERABLE_KIT_ID, DELIVERABLE_KIT_PART_ID, and KIT_PART_INCLUDED_FROM_KIT_ID; the principal parent table.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID for Multi-Org security.
• AMS_DELIV_KIT_ITEMS_PK / U1 / U2 — primary and unique indexes enforcing identity and uniqueness.
• AMS_DELIVERABLES_ALL_TL — translation table generally consulted alongside AMS_DELIVERABLES_ALL_B for multilingual names.