Results for “ams_web_placements_vl”

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

Overview

AMS_WEB_PLACEMENTS_VL is a seed data view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the AMS (Marketing) product family. As the "_VL" suffix indicates, it is a "view with translation" — it joins a base (non-translated) table to its translation table so that a single query returns both operational columns and language-specific descriptive text. The view returns placement information for web placements, which in Oracle Marketing represent the configured slots on a web site or page where content items, offers, or creatives are published.

Because it is a view rather than a table, it carries no storage of its own and is not directly updatable for the translated attributes. It serves as a reporting and integration convenience layer: concurrent programs, Oracle Discoverer workbooks, Oracle Reports, and custom OAF or JSP pages query it instead of hand-joining the two underlying tables. The view is marked VALID and is present in both 12.1.1 and 12.2.2, though the "_VL" translated views were introduced in later releases of the AMS schema, so installations upgraded from earlier code levels may need to verify its presence.

Underlying Base Objects

The view is defined over two documented base objects, exposed through APPS synonyms:

• AMS_WEB_PLACEMENTS_B — the base table holding placement identifiers, category, site/page references, status, publishing flags, stylesheet defaults, DFF attributes, and standard WHO columns.
• AMS_WEB_PLACEMENTS_TL — the translation table holding PLACEMENT_NAME and DESCRIPTION per language.

The join predicate is B.PLACEMENT_ID = T.PLACEMENT_ID AND T.LANGUAGE = USERENV('LANG'). The use of USERENV('LANG') means the view automatically returns the placement name and description in the language of the current session, which is why it is the preferred object for multilingual reporting. The alias B supplies the entire column list except the two translated text columns, which come from alias T. The view additionally surfaces B.ROWID as ROW_ID, although this pseudo-column cannot be used to update the underlying table through the view.

Key Columns

• PLACEMENT_ID — primary identifier; the join key to both base tables and to related AMS entities.
• PLACEMENT_CATEGORY — the classification of the placement, and the column most frequently searched by users. It distinguishes placement types used by the marketing content publishing model.
• PLACEMENT_NAME / DESCRIPTION — translated descriptive text sourced from AMS_WEB_PLACEMENTS_TL.
• SITE_ID, SITE_REF_CODE, PAGE_ID, PAGE_REF_CODE, LOCATION_CODE — identify the site and page on which the placement appears.
• SITE_PARAM1 … SITE_PARAM1..5 — five generic parameters passed to the site for rendering.
• DEFAULT_CONTENT_ITEM_ID, DEFAULT_CITEM_VER_ID, DEFAULT_STYLESHEET_ID, DEFAULT_STYLESHEET_VER_ID — defaults applied when the placement is rendered.
• STATUS_CODE, AUTO_PUBLISH_FLAG, DISPLAY_SELECTION_CODE — control whether the placement is active, whether content publishes automatically, and how content is selected for display.
• SECURITY_GROUP_ID, OBJECT_VERSION_NUMBER — multi-organization security and optimistic locking.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — the descriptive flexfield (DFF) columns.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Typical scenarios include auditing which placements exist by category, listing all placements on a given site or page, and identifying placements whose status is inactive or which lack a default content item. Because the view resolves the session language, it is also used to produce bilingual extracts and to feed downstream content-delivery systems.

To find all placements for a specific category:

SELECT placement_id,
       placement_name,
       placement_category,
       site_id,
       page_id,
       status_code
FROM   apps.ams_web_placements_vl
WHERE  placement_category = :p_category
ORDER  BY placement_name;

To list active placements on a page with their default content and stylesheet:

SELECT v.placement_id,
       v.placement_name,
       v.default_content_item_id,
       v.default_stylesheet_id,
       v.auto_publish_flag
FROM   apps.ams_web_placements_vl v
WHERE  v.page_id      = :p_page_id
AND    v.status_code  = 'ACTIVE';

Note that USERENV('LANG') is evaluated once per session; reports run under a batch responsibility return translations for that session's language only. When a specific language is required regardless of session, the base tables should be queried directly against AMS_WEB_PLACEMENTS_TL with an explicit LANGUAGE value.