Results for “ieu_object_parameters”

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

Overview

IEU_UWQ_MEDIA_V is a database view owned by the APPS schema in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It belongs to the IEU product, the Universal Work Queue (UWQ) module, which provides a centralized framework for routing and presenting work items to agents. The view is documented as being used for the UWQ selector SpreadTable, meaning it supplies the flattened, presentation-ready row source that populates a UWQ selector display. In practical terms, IEU_UWQ_MEDIA_V exposes a list of media-type queues (nodes) with their weights, labels, resource associations, and a queue count, allowing the UWQ layer to render queue selections and counters without querying the underlying normalized tables directly.

The view is a read-only construct intended for reporting and selector rendering rather than transactional processing. Status is VALID, and it carries no dependencies on interface tables or concurrent programs; it is purely a query-side aggregation of UWQ configuration and runtime node data.

Underlying Base Objects

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

• IEU_UWQ_SEL_RT_NODES (aliased A) — the runtime selector node source supplying NODE_ID, NODE_WEIGHT, NODE_LABEL, MEDIA_TYPE_ID, COUNT, NOT_VALID, NODE_PID, and RESOURCE_ID.
• IEU_UWQ_MEDIA_TYPES_B (aliased B) — the media type base table supplying MEDIA_TYPE_ID and MEDIA_TYPE_UUID.
• IEU_UWQ_MEDIA_TYPES_TL (aliased C) — the translated media type table supplying MEDIA_TYPE_NAME.

The joins are driven from the node table to the media type base table on MEDIA_TYPE_ID, and from the base table to the translated table on MEDIA_TYPE_ID with a language restriction via USERENV('LANG'). The filter NVL(NOT_VALID,'N') = 'N' excludes invalidated nodes, and NODE_PID = 4000 pins the selector to a specific parent node (4000), which is the root selector for the media/queue spread table.

Key Columns

• IEU_OBJECT_FUNCTION / IEU_OBJECT_PARAMETERS — returned as empty strings; placeholders reserved by the UWQ framework for object-level navigation.
• IEU_MEDIA_TYPE_UUID — the UUID of the media type, sourced from the base table; used by UWQ to uniquely identify the media/queue category.
• IEU_PARAM_PK_COL / IEU_PARAM_PK_VALUE — a literal column name ('QUEUE_NAME') paired with NODE_ID; defines the primary key mapping consumed by the selector.
• IEU_DISPLAY_ORDER — the node weight (NODE_WEIGHT), determining ordering of queues in the SpreadTable.
• RESOURCE_ID / RESOURCE_TYPE — the owner of the queue node and a fixed type of 'RS_INDIVIDUAL'.
• QUEUE_TYPE — the media type name, describing the queue category.
• QUEUE_NAME — the node label presented to the agent.
• QUEUE_COUNT — the item count for the queue; this is the column users target when searching for "queue_count". It reflects the pending work item total for the node.

Common Use Cases and Queries

The most common use is retrieving queue counts per media type for an agent or resource. For example:

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

To locate a specific queue by its UUID or label:

SELECT queue_name, queue_count, ieu_media_type_uuid
FROM   apps.ieu_uwq_media_v
WHERE  queue_name = :p_queue_name;

Because the view resolves language via USERENV('LANG'), results are automatically localized for the session. Analysts frequently join the view to UWQ resource or role tables to build workload dashboards, and developers reference it when debugging why a queue count does not match expectations — the NODE_PID = 4000 and NOT_VALID filters are the usual cause of missing rows. Note that the queue_count value is derived from the selector runtime node table, so it reflects the UWQ snapshot at query time rather than a real-time transactional count.