Search Results ieu_display_order




Overview
Explore in AI Chat

Overview

IEU_UWQ_BLENDED_V is a database view owned by the APPS schema in the Oracle E-Business Suite environment, catalogued under the IEU (Universal Work Queue) product family. Its documented purpose is to serve the UWQ selector SpreadTable — that is, it supplies the row set consumed by the work queue's "spread" presentation control, which distributes workload totals across resource, media type, and queue dimensions for display in the Universal Work Queue self-service interface. In EBS 12.1.1 and 12.2.2 the object is registered as VALID and is defined in the ETRM metadata as a read-only reporting construct rather than a base table. Its principal integration role is to provide a normalized projection of existing UWQ selection data so that the selector can retrieve queue counts without directly joining the underlying media type and selection tables at runtime.

Underlying Base Objects

The view is defined over three documented base objects, all exposed to APPS through synonyms:

  • IEU_UWQ_SEL_MRT_DATA (aliased A) — the queue selection and count data source, supplying resource, queue name, queue count, media type identifier, and the NOT_VALID flag.
  • IEU_UWQ_MEDIA_TYPES_B (aliased B) — the media type definition table, supplying the media type UUID used to isolate a specific queue category.
  • IEU_UWQ_MEDIA_TYPES_TL (aliased C) — the translated media type names, joined on MEDIA_TYPE_ID and restricted to the session language via USERENV('LANG').

The joins are inner joins on MEDIA_TYPE_ID between the selection data and both media type tables. A filter excludes rows where NOT_VALID is 'Y', and the media type UUID is pinned to the literal value 28DE0ECA16D411D4AED100C04F601AB2, meaning the view is deliberately scoped to a single media type rather than returning all queue types.

Key Columns

  • IEU_DISPLAY_ORDER — a numeric ordering key, hard-coded to 1 in the view text. It is the column most often referenced when searching for "ieu_display_order", since it controls the sort position of the row in the SpreadTable selector.
  • RESOURCE_ID — the identifier of the resource (agent) to whom the queue count belongs.
  • RESOURCE_TYPE — hard-coded to 'RS_INDIVIDUAL', indicating resource-level rather than group-level aggregation.
  • QUEUE_TYPE — the translated media type name from the TL table, used as the queue classification label.
  • QUEUE_NAME and QUEUE_COUNT — the queue identifier and the number of items in it.
  • IEU_MEDIA_TYPE_UUID — the media type UUID from the base table.
  • IEU_OBJECT_FUNCTION, IEU_OBJECT_PARAMETERS, IEU_PARAM_PK_COL, IEU_PARAM_PK_VALUE — placeholder columns returned as empty strings or zero, present to satisfy the uniform column signature expected by the UWQ selector framework.

Common Use Cases and Queries

Typical usage is diagnostic: verifying what the SpreadTable will render for a given resource, confirming the display ordering value, or tracing which translated queue type names are active. A representative query is:

SELECT resource_id, queue_type, queue_name, queue_count, ieu_display_order FROM apps.ieu_uwq_blended_v ORDER BY ieu_display_order, resource_id;

Because IEU_DISPLAY_ORDER is a constant, ordering by it produces no meaningful secondary sort; report authors should order by RESOURCE_ID or QUEUE_NAME instead. To inspect the unscoped data behind the view, query IEU_UWQ_SEL_MRT_DATA directly and join to the media type tables, removing the UUID predicate. Note that the view returns only rows for the pinned media type and the current session language, so language-specific testing requires setting the session language accordingly.