Search Results applicable_to_code

Overview

The IBE_DSP_AMV_ITEMS_V view is a read-only database object owned by the APPS schema in Oracle E-Business Suite. It resides within the IBE (iStore) product family and serves as a consolidated repository of item-related information drawn from the Oracle Marketing and Media (AMV) framework. The view joins item master records with their associated keywords, file attachments, and language/site mapping information, producing a flattened result set suitable for iStore display, integration, and reporting.

Because the view is defined WITH READ ONLY, it is intended strictly for query and reporting purposes and cannot be used as the target of DML operations. It is validated as VALID in the ETRM 12.2.2 reference, and its structure is consistent across the 12.1.1 and 12.2.2 releases. This view is particularly relevant to iStore administrators and developers who need to expose AMV-hosted content items—such as rich media, deliverables, and attachments—through the storefront or through custom integrations.

Underlying Base Objects

The view is constructed over four documented base objects, three of which are referenced through APPS synonyms and two of which are themselves views:

• JTF_AMV_ITEMS_VL — the primary driving view (the "_VL" suffix indicates it carries language-translated columns). It supplies the core item identity and descriptive attributes.
• JTF_AMV_ITEM_KEYWORDS_V — provides keyword metadata associated with each item, joined via an outer join on ITEM_ID.
• JTF_AMV_ATTACHMENTS — a base table supplying attachment and file information, joined through the mapping table.
• IBE_DSP_LGL_PHYS_MAP — an iStore-specific mapping synonym that links logical content items to physical attachment records and constrains the join to default site and default language rows.

All joins except the primary one are outer joins (the (+) operator is used throughout), meaning items without keywords or attachments are still returned. The mapping table is further restricted so that DEFAULT_SITE = 'Y' and DEFAULT_LANGUAGE = 'Y', and only rows where CONTENT_ITEM_KEY IS NULL are eligible.

Key Columns

The view exposes eleven columns. Notable definitions include:

• ITEM_ID — the primary identifier for the AMV content item; the join key across all base objects.
• ACCESS_NAME — the internal programmatic name used to reference the item.
• ITEM_NAME — the translated display name of the item.
• APPLICATION_ID — the owning Oracle application, used to scope content by product.
• DELIVERABLE_TYPE_CODE and APPLICABLE_TO_CODE — classification codes indicating the nature and applicability of the deliverable.
• DESCRIPTION — the translated long description.
• KEYWORD — a searchable keyword supplied by the keyword view.
• FILE_NAME and FILE_ID — the attachment's file name and its identifier in FND_LOBS-style storage.
• OBJECT_VERSION_NUMBER — the optimistic locking version for the underlying item record.

Common Use Cases and Queries

Typical scenarios include retrieving all content items with their default-language attachments for iStore rendering, auditing which items lack keywords or files, and building integration extracts for downstream content systems.

SELECT ITEM_ID, ITEM_NAME, KEYWORD, FILE_NAME
FROM   APPS.IBE_DSP_AMV_ITEMS_V
WHERE  APPLICATION_ID = :app_id;

To identify items with no attached file:

SELECT ITEM_ID, ITEM_NAME
FROM   APPS.IBE_DSP_AMV_ITEMS_V
WHERE  FILE_ID IS NULL;

Because the view is read-only and pre-filtered to default site/language mappings, it should be used directly rather than replicated; custom queries needing non-default mappings must access the base tables instead.