Results for “ieu_object_function”

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

Overview

The AMS_LIST_ENTRIES_UWQ_V view is an Oracle E-Business Suite (EBS) database object owned by the APPS schema within the AMS – Marketing product family. It is defined as a standard (non-materialized) view and is documented with a VALID status in 12.1.1 and 12.2.2. Its stated purpose is to feed the Universal Work Queue (UWQ), the framework that surfaces actionable work items to agents in telemarketing, telesales, and campaign execution contexts. The "UWQ_V" suffix and the presence of IEU_* columns (IEU_OBJECT_FUNCTION, IEU_OBJECT_PARAMETERS, IEU_MEDIA_TYPE_UUID, IEU_PARAM_PK_COL, IEU_PARAM_PK_VALUE) indicate that the view conforms to the Interaction/Universal Work Queue interface contract, which relies on a generic set of identifier columns so that the queue can route and open the correct underlying entity.

Rather than presenting new data, the view projects and re-shapes existing marketing list, schedule, and source-code data into the flat shape expected by UWQ. In this respect it acts as an integration glue layer between the AMS campaign scheduling and list-management tables and the work-queue presentation layer.

Underlying Base Objects

The view joins five documented base objects: AMS_CAMPAIGN_SCHEDULES_VL (VIEW), AMS_LIST_HEADERS_VL (VIEW), AMS_LIST_ENTRIES (SYNONYM), AMS_ACT_LISTS (SYNONYM), and AMS_SOURCE_CODES (SYNONYM). The core driving table is AMS_LIST_ENTRIES (ALE), which holds individual prospect or customer records within a list. These entries relate to a header in AMS_LIST_HEADERS_VL (ALH) via LIST_HEADER_ID, and the header in turn is linked to a campaign schedule through AMS_ACT_LISTS (ACTS), which is filtered to LIST_USED_BY='CSCH', LIST_ACT_TYPE='TARGET'. The schedule itself is resolved through AMS_CAMPAIGN_SCHEDULES_VL (CSCH) on SCHEDULE_ID = ACTS.LIST_USED_BY_ID. AMS_SOURCE_CODES (ASOU) provides source-code attributes and is joined on SOURCE_CODE. The join conditions restrict the result to enabled entries (ENABLED_FLAG='Y') that have not yet been worked (OUTCOME_ID IS NULL).

Key Columns

• IEU_OBJECT_FUNCTION – Constant value 'AST_RC_ALL', identifying the object type exposed to UWQ.
• IEU_OBJECT_PARAMETERS – Constant string 'PARTY_ID=&ID ' used to build the object URL or launch parameters.
• IEU_PARAM_PK_COL – Constant 'PARTY_ID', naming the primary key column UWQ should use; this is the column referenced by searches such as ieu_param_pk_col.
• IEU_PARAM_PK_VALUE – Carries ALE.PARTY_ID, the actual key value passed into the object.
• RESOURCE_TYPE / RESOURCE_ID – 'RS_INDIVIDUAL' and ALE.RESOURCE_ID, identifying the assigned resource.
• SCHEDULE_ID / SCHEDULE_NAME / STATUS_CODE / SOURCE_CODE – Campaign schedule context for the entry.
• LIST_NAME, LIST_HEADER_ID, LIST_ENTRY_ID, LIST_TYPE, LIST_SOURCE_TYPE – List management identifiers.
• Party and contact attributes – FIRST_NAME, LAST_NAME, FULL_NAME, CUSTOMER_NAME, TITLE, EMAIL_ADDRESS, PHONE, ADDRESS_LINE1/2, CITY, STATE, ZIPCODE, COUNTRY, PARTY_ID, LOCATION_ID, CONTACT_POINT_ID.
• Control flags – MARKED_AS_DUPLICATE_FLAG, PART_OF_CONTROL_GROUP_FLAG, SALES_AGENT_EMAIL_ADDRESS, VEHICLE_RESPONSE_CODE.

Common Use Cases and Queries

The primary consumer is Universal Work Queue, which queries this view to populate agent worklists with unworked list entries tied to target schedules. Typical ad hoc reporting includes identifying unprocessed prospects per schedule, auditing duplicate-flagged entries, or exporting contact details for campaign reconciliation.

A representative query retrieves unworked entries for a schedule:

• SELECT LIST_ENTRY_ID, LIST_NAME, FULL_NAME, EMAIL_ADDRESS, PHONE, IEU_PARAM_PK_COL, IEU_PARAM_PK_VALUE FROM APPS.AMS_LIST_ENTRIES_UWQ_V WHERE SCHEDULE_ID = :p_schedule_id;

Because the view only returns rows where OUTCOME_ID IS NULL and ENABLED_FLAG='Y', queries automatically inherit the "still actionable" filter. Reporting on completed entries requires querying AMS_LIST_ENTRIES directly rather than this view.