Search Results no_of_rows_active




Overview
Explore in AI Chat

Overview

APPS.AST_PLIST_NAMES_UWQ_V is a reporting and integration view in Oracle E-Business Suite, owned by the APPS schema. It exposes the header-level attributes of Oracle Advanced Marketing (AMS) prospect lists — internally termed list headers — in a structure conforming to the EBS "UWQ" (Universal Work Queue) resource-view convention. The name prefix AST_PLIST_NAMES reflects the Oracle Sales/TeleSales (AST) product family, while the _UWQ_V suffix indicates it is intended for consumption by the Universal Work Queue framework.

The view's defining characteristic is that it projects two synthetic leading columns, IEU_OBJECT_FUNCTION and IEU_OBJECT_PARAMETERS (both returned as NULL), together with the literal constants 'RS_INDIVIDUAL' as RESOURCE_TYPE and OWNER_USER_ID as RESOURCE_ID. In doing so, it re-casts each prospect list as a UWQ-assignable resource of type "Individual", so that the Interactive Intelligence / IEU routing engine can treat prospect lists as work items assigned to a resource. This makes the view a bridge between AMS list management and UWQ/IEU media routing rather than a pure reporting object, although its columns are equally usable for ad hoc list inventory reporting.

Underlying Base Objects

The view is defined over a single documented base object: AMS_LIST_HEADERS_VL, which is itself a view (the "_VL" suffix denotes a translated/MLS view pairing AMS_LIST_HEADERS_B and AMS_LIST_HEADERS_TL). The definition is a straightforward SELECT ... FROM ams_list_headers_vl alh with no joins, no filters, and no aggregation. Every functional column in AST_PLIST_NAMES_UWQ_V is therefore inherited unmodified from AMS_LIST_HEADERS_VL, with the sole exception of the aliased UWQ columns described above. Because the source is a translation-enabled view, LIST_NAME and DESCRIPTION are returned in the session's language.

Key Columns

Common Use Cases and Queries

Typical usage is to inventory prospect lists with their population statistics, or to feed the UWQ/IEU engine. To find lists with active rows, a common query is:

  • SELECT list_header_id, list_name, no_of_rows_in_list, no_of_rows_active, no_of_rows_inactive, status_code FROM apps.ast_plist_names_uwq_v WHERE no_of_rows_active > 0 AND org_id = :p_org_id ORDER BY no_of_rows_active DESC;
  • Locate empty or exhausted lists: ... WHERE NVL(no_of_rows_active,0) = 0 AND enabled_flag = 'Y';
  • Report generation readiness: filter on last_generation_success_flag, sent_out_date, and forecasted_end_date.
  • UWQ consumption: SELECT resource_type, resource_id, list_header_id, list_name FROM apps.ast_plist_names_uwq_v WHERE owner_user_id = :user_id;

Because the view performs no filtering, callers must apply their own ORG_ID and status predicates; the NO_OF_ROWS_* counters are snapshots maintained by AMS generation and may lag the detail tables. For current counts, aggregate the underlying list-line table instead.