Results for “cmp_deliverable_id”

2 results




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

Overview

AST_CAMPAIGNS_VL is a view exposed within the Oracle E-Business Suite TeleSales (AST) module. It presents campaign header information in a language-specific, translated form, joining the campaign base table to its translation table and to the deliverable associations registered in the marketing object model. The "_VL" suffix is the standard Oracle EBS convention indicating a view that resolves translated (TL) columns according to the session language, as determined here by USERENV('LANG'). The view therefore behaves like a language-aware presentation layer over campaign data, returning the campaign name in the language of the connected user's session.

The view is intended for query and reporting consumption rather than as a transaction entry point. Because it exposes denormalized campaign attributes alongside a resolved deliverable identifier, it supports both TeleSales runtime lookups and downstream reporting or integration extracts that must be language sensitive. In the documentation metadata supplied, the object is listed as not implemented in the database from which that metadata was extracted, meaning the view definition and columns are documented but the compiled view was absent in that particular environment. Consumers should verify the object's presence in their own instance before relying on it.

Underlying Base Objects

Based on the documented view text, AST_CAMPAIGNS_VL is defined over three referenced objects:

  • AMS_CAMPAIGNS_ALL_TL — the translation table, aliased T, supplying the language-dependent campaign name column.
  • AMS_CAMPAIGNS_ALL_B — the base table, aliased B, supplying the language-independent campaign attributes such as the campaign identifier, source code, and inbound email identifier.
  • AMS_OBJECT_ASSOCIATIONS — aliased DLA, supplying the deliverable association used to resolve a campaign deliverable identifier.

The join conditions link B.CAMPAIGN_ID to T.CAMPAIGN_ID, and join the association table where the master object type is 'CAMP' and the using object type is 'DELV', matching the association's master object identifier to the campaign identifier. The translation language must equal the session language. No other base objects are documented for this view in the ETRM 12.2.2 metadata, and no join to a standalone deliverable header table is performed; the deliverable identifier is derived entirely through the association table.

Key Columns

  • ROW_ID — the row identifier from the base table, exposed as B.ROWID.
  • CAMPAIGN_ID — the unique campaign identifier, drawn from the base table and used as the join key to both the translation and association tables.
  • CAMPAIGN_NAME — the translated campaign name from AMS_CAMPAIGNS_ALL_TL, returned in the session language.
  • SOURCE_CODE — a language-independent indicator of the campaign's originating source.
  • INBOUND_EMAIL_ID — the identifier of the inbound email associated with the campaign.
  • CMP_DELIVERABLE_ID — the deliverable identifier resolved from AMS_OBJECT_ASSOCIATIONS via USING_OBJECT_ID, providing the campaign's linked deliverable.

Common Use Cases and Queries

Typical uses include TeleSales campaign lookups by name, reporting on campaign source and inbound email linkage, and determining the deliverable attached to a campaign. A representative query retrieves campaign headers for the current session language:

  • SELECT CAMPAIGN_ID, CAMPAIGN_NAME, SOURCE_CODE, INBOUND_EMAIL_ID, CMP_DELIVERABLE_ID FROM AST_CAMPAIGNS_VL ORDER BY CAMPAIGN_NAME;
  • SELECT CAMPAIGN_ID, CAMPAIGN_NAME FROM AST_CAMPAIGNS_VL WHERE CMP_DELIVERABLE_ID = :p_deliverable_id;

Note that because language resolution depends on USERENV('LANG'), joining or filtering by translated names should be avoided across sessions with differing language settings.