Search Results ieu_node_labels




Overview
Explore in AI Chat

Overview

IEU_UWQ_WEB_CALLBACK_V is a packaged Oracle E-Business Suite view owned by the APPS schema and defined in the IEU (Universal Work Queue) product. Within the UWQ framework, it is documented as the view used for the UWQ selector SpreadTable, meaning it exposes the flattened result set that the Universal Work Queue work selector renders for callback and media-type driven queue listings. The view is reported as VALID in both the 12.1.1 and 12.2.2 releases and presents a normalized, presentation-ready projection of work queue data rather than raw transactional content.

Because the view surfaces a fixed set of derived attributes (object function, object parameters, media type identifiers, queue names and queue counts), it functions as an integration and reporting access point for UWQ queue statistics. Its role is primarily analytical and UI-supporting: downstream components, custom reports, and DBA diagnostics can query the view without needing to reconstruct the join logic against the UWQ media type and selector tables.

Underlying Base Objects

The ETRM metadata documents the following referenced objects: FND_LOOKUP_VALUES_VL (a view), and the synonyms IEU_UWQ_MEDIA_TYPES_B, IEU_UWQ_MEDIA_TYPES_TL, and IEU_UWQ_SEL_MRT_DATA. The view definition joins these as follows:

  • IEU_UWQ_SEL_MRT_DATA A — the driving source of queue names, resource identifiers, and queue counts.
  • IEU_UWQ_MEDIA_TYPES_B B — supplies the media type UUID; the join is restricted to the UUID value 7F7FB3A0B6F511D3A05000C04F53FBA6.
  • IEU_UWQ_MEDIA_TYPES_TL C — provides the translated media type name, joined on LANGUAGE = USERENV('LANG').
  • FND_LOOKUP_VALUES_VL L — supplies the localized fallback label from lookup type IEU_NODE_LABELS, VIEW_APPLICATION_ID 696, LOOKUP_CODE 'IEU_ANY_LBL'.

The join also filters out records where NOT_VALID is not 'N'. A DECODE substitutes the lookup meaning for a NULL queue name, ensuring a displayable label is always returned.

Key Columns

Common Use Cases and Queries

Typical uses include queue-depth reporting, validating UWQ selector configuration, and diagnosing why a queue label falls back to the generic 'IEU_ANY_LBL' meaning. A simple listing query:

  • SELECT queue_name, queue_type, resource_id, queue_count FROM apps.ieu_uwq_web_callback_v ORDER BY queue_name;
  • SELECT resource_id, SUM(queue_count) FROM apps.ieu_uwq_web_callback_v GROUP BY resource_id;
  • SELECT * FROM apps.ieu_uwq_web_callback_v WHERE queue_count > 0;

Because the view is language-aware, results depend on the session language. Queries should be executed with the appropriate APPS credentials and, where volume is high, filtered on queue_count or resource_id.