Search Results amv_i_content_types_b




Overview
Explore in AI Chat

Overview

AMV_I_CONTENT_TYPES_B is the base table of the Marketing Encyclopedia System (AMV) product in Oracle E-Business Suite, holding the master definition of content types that may be associated with an item or a channel. It functions as a reference and classification entity: item records and channel configurations draw their allowed content-type values from this table, enabling the AMV content repository to categorize, search, and present rich media such as images, documents, and web assets. The table is owned by the AMV schema and is marked VALID in the ETRM data dictionary for 12.1.1 and 12.2.2.

From a Data Vault modeling perspective, the mined relationships suggest a hub-leaning classification. The table carries its own surrogate identity and participates in downward referencing relationships, which is characteristic of a hub entity around which descriptive translations and transactional item associations are organized. This is a heuristic suggestion rather than a documented physical design; implementers should treat it as guidance when mapping AMV data into analytical or warehouse models.

Key Information Stored

The documented physical schema for release 12.2.2 contains nine columns, centered on the surrogate key and standard EBS audit and multi-tenancy attributes:

Descriptive, translatable attributes such as the content-type name and description are not held in this base table; they reside in the companion translation table AMV_I_CONTENT_TYPES_TL, keyed by CONTENT_TYPE_ID.

Common Use Cases and Queries

The primary practical use of this table is to resolve the human-readable identity of a content type referenced by an item or channel record, and to validate the list of valid types available to the Marketing Encyclopedia.

  • Listing all content types available to users: SELECT content_type_id FROM amv_i_content_types_b ORDER BY content_type_id;
  • Retrieving a name for a given type by joining to the translation table: SELECT b.content_type_id, t.content_type_name FROM amv_i_content_types_b b, amv_i_content_types_tl t WHERE b.content_type_id = t.content_type_id AND t.language = USERENV('LANG');
  • Reporting on item content associations, joining item entries to their type: SELECT i.item_id, b.content_type_id FROM jtf_amv_items_b i, amv_i_content_types_b b WHERE i.content_type_id = b.content_type_id;
  • Audit and security-group analysis, using SECURITY_GROUP_ID to partition results by responsibility or organizational context, and the Who columns to trace change history.

Because of the ZD_EDITION_NAME column, ad-hoc queries in a patched 12.2.2 environment should filter on the active edition when duplicate logical rows may exist across editions.

Related Objects

The following objects are most significant for working with this entity:

  • AMV_I_CONTENT_TYPES_TL — the translation table, joined on CONTENT_TYPE_ID, supplying language-specific names and descriptions. The foreign key from the TL table points back to the base table.
  • JTF_AMV_ITEMS_B — the item repository that references CONTENT_TYPE_ID, linking each content item to its assigned type.
  • FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID, providing the security-group context for the row.
  • AMV_I_CONTENT_TYPES_B_PK and AMV_I_CONTENT_TYPES_B_U1 — the primary key and unique (business-key) indexes that enforce identity and edition uniqueness.
  • AMV schema APIs — the AMV Marketing Encyclopedia System PL/SQL interfaces used to create and maintain content types under the EBS framework conventions.