Search Results private_flag




Overview
Explore in AI Chat

Overview

APPS.AMS_SOURCE_CODES_DETAILS_V is a consolidated reporting view within the Oracle E-Business Suite Marketing (AMS) module. It presents a unified, de-normalized listing of active source codes and the marketing objects to which they are bound. Source codes in AMS are short identifiers used to tag campaigns, events, event offers, schedules, and offers, enabling attribution and response tracking across the marketing lifecycle. The view resolves each active source code to its target object and returns a common set of descriptive attributes, including the object name, description, and the PRIVATE_FLAG indicator. This makes the view particularly relevant to users searching on private_flag, since several of its UNION ALL branches project the private/confidential status of the underlying marketing entity.

Underlying Base Objects

The view is defined as a series of UNION ALL branches, each joining the source-code table to a specific marketing object view. The documented base objects are:

In every branch the join is restricted to records where the source code is active (ACTIVE_FLAG = 'Y'), so the view returns only currently valid mappings.

Key Columns

  • SOURCE_CODE_ID — primary key of the source code record.
  • SOURCE_CODE — the literal source code value used for tagging and attribution.
  • SOURCE_TYPE — the object class the code applies to (CAMP, EVEH, EVEO, CSCH, OFFR).
  • OBJECT_ID — the identifier of the referenced marketing object.
  • NAME — the resolved name of the object (campaign, event, offer, or schedule).
  • DESCRIPTION — descriptive text for the object.
  • PRIVATE_FLAG — indicates whether the underlying object is private/confidential. For schedules this is always 'N'; for offers it derives from OFFR.confidential_flag.
  • CUSTOM_SETUP_ID / SETUP_TYPE_ID — setup classification identifiers carried from the object.

Common Use Cases and Queries

This view is typically used in reporting, integration extracts, and migration validation where a single query must enumerate active source codes across all marketing object types. A representative query filtering on the private indicator is:

  • SELECT SOURCE_CODE, SOURCE_TYPE, NAME, PRIVATE_FLAG FROM APPS.AMS_SOURCE_CODES_DETAILS_V WHERE PRIVATE_FLAG = 'Y';
  • SELECT SOURCE_TYPE, COUNT(*) FROM APPS.AMS_SOURCE_CODES_DETAILS_V GROUP BY SOURCE_TYPE;
  • SELECT SOURCE_CODE, NAME FROM APPS.AMS_SOURCE_CODES_DETAILS_V WHERE SOURCE_TYPE = 'CAMP' AND PRIVATE_FLAG = 'N';

Because the view already filters on ACTIVE_FLAG = 'Y' and resolves object names, it eliminates the need for multiple joins in downstream reports and provides a reliable read-only surface for source-code analysis.