Search Results amv_i_item_perspectives




Overview
Explore in AI Chat

Overview

AMV_I_ITEM_PERSPECTIVES is a transactional table in the AMV schema, the Marketing Encyclopedia System module of Oracle E-Business Suite. It stores the perspective attributes associated with an item, allowing items to be categorized and presented through multiple marketing or merchandising perspectives. In Oracle EBS 12.1.1 and 12.2.2 this table acts as the association layer between item master records and the perspective definitions used by the Marketing Encyclopedia System to drive catalog, storefront, and content presentation.

From a Data Vault modeling standpoint, the mined foreign-key structure suggests a link classification. The table resolves a many-to-many relationship between items and perspectives, and its natural business key is the combination of ITEM_ID and PERSPECTIVE_ID. This classification is a heuristic suggestion derived from the relationship data rather than a documented Oracle designation.

Key Information Stored

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

Common Use Cases and Queries

Typical usage revolves around reporting which perspectives are attached to which items, and validating that perspective assignments exist for catalog or storefront publishing. A common query joins the association table back to the item base table:

  • Listing perspectives for a given item: SELECT perspective_id FROM amv.amv_i_item_perspectives WHERE item_id = :item_id;
  • Counting items per perspective for merchandising analysis: SELECT perspective_id, COUNT(*) FROM amv.amv_i_item_perspectives GROUP BY perspective_id;
  • Audit and change tracking: filtering on LAST_UPDATE_DATE and LAST_UPDATED_BY to identify recently re-perspectived items.
  • Security-scoped extracts: constraining by SECURITY_GROUP_ID for multi-org deployments.

Because OBJECT_VERSION_NUMBER is present, any programmatic insert or update should populate or increment it to remain compatible with OAF-based maintenance screens.

Related Objects

  • JTF_AMV_ITEMS_B — joined on AMV_I_ITEM_PERSPECTIVES.ITEM_ID = JTF_AMV_ITEMS_B.ITEM_ID; the parent item base table.
  • FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID for data-security resolution.
  • Perspective definition tables in the AMV schema — referenced through PERSPECTIVE_ID, supplying the perspective metadata displayed alongside items.
  • AMV_I_ITEM_PERSPECTIVES_PK / _U1 / _U2 — the primary key and unique indexes enforcing row identity and the ITEM_ID + PERSPECTIVE_ID business key.

Together these objects form the linkage that the Marketing Encyclopedia System uses to relate item master data to its presentation perspectives.