Results for “ams_p_list_headers_v”

24 results




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

Overview

AMS_P_LIST_HEADERS_V is a public view owned by the APPS schema in the Oracle E-Business Suite marketing module (AMS – Marketing). It returns the general header-level information about a marketing list. In EBS 12.1.1 and 12.2.2, this view is the primary read interface used to expose list definitions to concurrent programs, OBIEE/BI Publisher reports, forms, and integration endpoints without requiring direct access to the transactional base table AMS_LIST_HEADERS_ALL. The view is documented as VALID in the ETRM metadata.

Because the view resolves foreign-key identifiers into meaningful names — for example the activity name via AMS_UTILITY_PVT.GET_OBJECT_NAME, the owner name from HR resources, and lookup meanings from AMS_LOOKUPS — it is well suited for operational reporting on list ownership, status, deduplication results, generation statistics, and workflow context.

Underlying Base Objects

The view is defined over the following referenced objects:

Key Columns

Common Use Cases and Queries

Typical uses include list inventory reporting, deduplication audit, ownership dashboards, and status monitoring for concurrent list generation.

  • List inventory by owner and status.
  • Deduplication audit — who deduped and when.
  • Generation performance — volumes and timing.
  • Root/source list lineage.

Sample SQL — retrieve lists with their dedup audit information:

SELECT list_header_id,
       list_name,
       owner_name,
       status_code,
       last_dedupe_date,
       last_deduped_by_user_id,
       no_of_rows_duplicates,
       no_of_rows_active
FROM   apps.ams_p_list_headers_v
WHERE  org_id = :p_org_id
ORDER  BY last_dedupe_date DESC;

Sample SQL — resolve the user who last deduped a list:

SELECT l.list_header_id,
       l.list_name,
       l.last_dedupe_date,
       f.user_name  AS deduped_by_user
FROM   apps.ams_p_list_headers_v l,
       fnd_user f
WHERE  f.user_id(+) = l.last_deduped_by_user_id
AND    l.list_header_id = :p_list_header_id;

Because the view invokes HR_SECURITY and other PL/SQL packages, query cost is higher than a direct base-table read; filter on LIST_HEADER_ID, ORG_ID, or OWNER_USER_ID where possible, and avoid function-based predicates on OWNER_NAME in high-volume extracts.