Results for “root_list_name”
8 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:
- AMS_LIST_HEADERS_ALL (synonym) — the primary base table holding marketing list header rows (aliased L in the view text).
- AMS_LOOKUPS (view) — supplies MEANING for ACTIVITY_TYPE (LK) and ACCESS_LEVEL_MEANING (LK2).
- AMS_P_LIST_RULES_V (view) — list rule detail, joined for rule-related attributes.
- AMS_UTILITY_PVT (package) — function GET_OBJECT_NAME resolves the object referenced by ARC_LIST_USED_BY and LIST_USED_BY_ID into ACTIVITY_NAME.
- HR_GENERAL, HR_PERSON_NAME, HR_SECURITY (packages) — resolve owner full name, email, and employee number, and enforce HR security.
- JTF_RS_RES_EMP_VL (view) — resource/employee source for owner attributes (RES).
- AMS_P_LIST_RULES_V — and the self-join to AMS_LIST_HEADERS_ALL (R) for the root list name (ROOT_LIST_NAME).
Key Columns
- LIST_HEADER_ID — primary key of the marketing list.
- LIST_NAME, DESCRIPTION, KEYWORDS — identifying attributes.
- OWNER_USER_ID, OWNER_NAME, OWNER_EMAIL_ADDRESS, OWNER_EMPLOYEE_ID — owner identity resolved through HR packages.
- STATUS_CODE, STATUS_DATE, LIST_TYPE, GENERATION_TYPE, ROW_SELECTION_TYPE, ACCESS_LEVEL, ACCESS_LEVEL_MEANING — lifecycle and classification.
- LAST_DEDUPE_DATE and LAST_DEDUPED_BY_USER_ID — the last deduplication timestamp and the user who performed it (this is the column referenced by the "last_deduped_by_user_id" search term).
- NO_OF_ROWS_DUPLICATES, NO_OF_ROWS_IN_LIST, NO_OF_ROWS_ACTIVE, NO_OF_ROWS_IN_CTRL_GROUP — list volume metrics.
- FORECASTED_START_DATE, FORECASTED_END_DATE, ACTUAL_END_DATE, SENT_OUT_DATE, MAIN_GEN_START_TIME, MAIN_GEN_END_TIME — scheduling and generation timing.
- WORKFLOW_ITEM_KEY — workflow correlation identifier.
- ORG_ID — multi-org operating unit context.
- ATTRIBUTE1..15, ATTRIBUTE_CATEGORY — DFF descriptive flexfield columns.
- REPEAT_SOURCE_LIST_HEADER_ID, ROOT_LIST_NAME — source/root list lineage.
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.
-
View: AMS_P_LIST_HEADERS_V 12.2.2
This public view returns the general information about marketing list.
APPS.AMS_P_LIST_HEADERS_V·↳ AMS_LIST_HEADERS_ALL·↳ AMS_LOOKUPS·↳ AMS_P_LIST_RULES_V·Explore AMS module →
-
View: AMS_P_LIST_HEADERS_V 12.1.1
This public view returns the general information about marketing list.
APPS.AMS_P_LIST_HEADERS_V·↳ AMS_LIST_HEADERS_ALL·↳ AMS_LOOKUPS·↳ AMS_P_LIST_RULES_V·Explore AMS module →
-
eTRM - AMS Tables and Views 12.2.2
This table is used to store tracking data for web advertisement and offer type schedules
-
eTRM - AMS Tables and Views 12.1.1
This table is used to store tracking data for web advertisement and offer type schedules