Search Results ieu_action_object_code




Overview
Explore in AI Chat

Overview

IEU_UWQ_TASKS_V is a reporting and integration view owned by the APPS schema within the IEU (Universal Work Queue) product family. Its documented purpose is to serve the UWQ selector SpreadTable, the tabular component that renders task records in the Universal Work Queue agent interface. The view is delivered with a status of VALID in Oracle EBS 12.1.1 and 12.2.2.

Functionally, the view flattens and decorates task information sourced from the underlying UWQ task view so that it can be consumed directly by the UWQ presentation layer and by any custom reporting or integration that needs a queue-ready projection of tasks. It appends selector-oriented metadata—object function, object parameters, primary key column and value identifiers, media type, and action object code—alongside the standard task attributes such as task number, status, priority, dates, owner, and customer details. Because it exposes SOURCE_OBJECT_TYPE and SOURCE_OBJECT_TYPE_CODE, it is particularly relevant to integrations that must resolve the business object a task is anchored to, for example a service request, a lead, or a campaign.

Underlying Base Objects

The documented base objects referenced by IEU_UWQ_TASKS_V are:

The definition is therefore a two-view join: a broad projection of JTF_TASK_UWQ_V enriched by a single lookup-derived label column, OWN_ASSIGN_LABEL.

Key Columns

Common Use Cases and Queries

Typical scenarios include building custom UWQ-style task listings, extracting queue metrics by object type, and integrating task data into external dashboards. A representative query filters open tasks by source object type code:

  • SELECT TASK_ID, TASK_NUMBER, TASK_NAME, TASK_STATUS, SOURCE_OBJECT_TYPE, SOURCE_OBJECT_TYPE_CODE, SOURCE_OBJECT_ID, OWNER, OWN_ASSIGN_LABEL FROM APPS.IEU_UWQ_TASKS_V WHERE CLOSED_FLAG = 'N' AND SOURCE_OBJECT_TYPE_CODE = :p_code;
  • SELECT SOURCE_OBJECT_TYPE_CODE, COUNT(*) FROM APPS.IEU_UWQ_TASKS_V GROUP BY SOURCE_OBJECT_TYPE_CODE;
  • SELECT TASK_NUMBER, OWNER, OWN_ASSIGN_LABEL, CUSTOMER_NAME, PLANNED_END_DATE FROM APPS.IEU_UWQ_TASKS_V WHERE OWNED_FLAG = 'Y' ORDER BY PLANNED_END_DATE;

Because the view is a selector artefact and provides no row-level security of its own, callers should apply the appropriate organisation and responsibility filters required by their integration.