Search Results channel_perspective_id




Overview
Explore in AI Chat

Overview

AMV.AMV_C_CHL_PERSPECTIVES is a seed data table in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 Advanced Marketing (AMV) product family. It stores all perspectives associated with a specific channel. When perspectives are configured for a channel, they serve as matching criteria that determine whether a given piece of information should be published to that channel. As such, the table functions as a routing and eligibility control point for channel-based content distribution.

The table resides in the APPS_TS_SEED tablespace, indicating it holds setup or reference data rather than high-volume transactional records. Heuristic Data Vault modeling suggests classifying this object as a link, since its structure primarily represents an association between a channel and a perspective, with the surrogate key and business key acting as linkage identifiers rather than a hub of descriptive attributes.

Key Information Stored

The table contains ten documented columns. The single-column primary key, CHANNEL_PERSPECTIVE_ID, is a system-generated surrogate identifier for each channel-perspective association. Two unique indexes exist: AMV_C_CHL_PERSPECTIVES_U1 on CHANNEL_PERSPECTIVE_ID (the surrogate key) and AMV_C_CHL_PERSPECTIVES_U2 on (CHANNEL_ID, PERSPECTIVE_ID), which constitutes the business-key candidate and enforces that a given perspective can only be associated with a channel once.

A non-unique index, AMV_C_CHL_PERSPECTIVES_N1, exists on PERSPECTIVE_ID to support reverse lookups from perspective to channel.

Common Use Cases and Queries

Typical usage involves resolving the set of perspectives that gate publication to a channel, or determining which channels reference a given perspective. The following pattern returns all perspectives for a channel:

  • SELECT CHANNEL_PERSPECTIVE_ID, PERSPECTIVE_ID FROM AMV.AMV_C_CHL_PERSPECTIVES WHERE CHANNEL_ID = :p_channel_id;
  • SELECT CHANNEL_ID FROM AMV.AMV_C_CHL_PERSPECTIVES WHERE PERSPECTIVE_ID = :p_perspective_id; — benefits from the N1 index.
  • Joining to AMV_C_CHANNELS_B to produce a channel-to-perspective mapping report for matching-criteria analysis.

Reporting scenarios include auditing which channels have perspectives defined, validating that business-key uniqueness is respected, and tracing why information was or was not published to a channel. Because the table holds setup data placed in APPS_TS_SEED, maintenance is normally performed through the AMV configuration UI rather than direct DML.

Related Objects

The most significant related objects, derived from the documented foreign key relationships, include:

  • AMV.AMV_C_CHANNELS_B — referenced via CHANNEL_ID; the parent channel definition.
  • FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID for hosted-environment security partitioning.
  • The perspective master object referenced via PERSPECTIVE_ID (documented as a wildcard dependency "%,").
  • AMV_C_CHL_PERSPECTIVES# — the underlying object referenced by this table in the AMV schema.

The table does not reference any other database objects beyond the foreign keys noted above. Its design is deliberately narrow, focusing solely on the channel-to-perspective linkage used by the AMV publication matching engine.