Search Results ieu_node_labels




Overview
Explore in AI Chat

Overview

APPS.IEU_UWQ_WEB_CALLBACK_V is a reporting view in the Oracle E-Business Suite Interaction Center / Universal Work Queue (UWQ) module, part of the iSupport (IEU) schema family. Its purpose is to expose a callback queue entry listing for web-based callback processing, aggregating queue identification, media type information, and media type naming into a single queryable structure. The view is defined with fixed literal values for the object function, object parameters, and resource type, which identify the row source as an individual-resource queue selection rather than a functional or role-based assignment.

A distinguishing characteristic of this view is its hard-coded filter against a single media type UUID, '7F7FB3A0B6F511D3A05000C04F53FBA6', meaning the view returns data for one specific media type only. The view also joins to the FND_LOOKUP_VALUES_VL lookup view using the lookup type IEU_NODE_LABELS, which is directly relevant to users searching on that term. This lookup is constrained to view_application_id 696 and lookup_code IEU_ANY_LBL, allowing the view to substitute a localized, human-readable label for queue names that would otherwise be null.

Underlying Base Objects

The view is defined over four documented objects:

  • IEU_UWQ_SEL_MRT_DATA (synonym) — the primary driver, supplying queue_name, resource_id, media_type_id, queue_count, and the not_valid flag.
  • IEU_UWQ_MEDIA_TYPES_B (synonym) — supplies media_type_uuid and joins on media_type_id; the base for the hard-coded UUID filter.
  • IEU_UWQ_MEDIA_TYPES_TL (synonym) — the translated media type name, joined on media_type_id and language = USERENV('LANG').
  • FND_LOOKUP_VALUES_VL (view) — the standard EBS lookup view providing the localized "any" label via lookup_type IEU_NODE_LABELS.

The join topology is a straight inner join chain on media_type_id, with a filtered lookup join on the label attributes. The NVL(a.not_valid,'N') = 'N' predicate excludes invalidated queue selections.

Key Columns

Common Use Cases and Queries

This view supports callback queue reporting and integration code that needs callback node or queue metadata resolved against the IEU_NODE_LABELS lookup. Typical usage includes diagnostics of why a callback queue appears unnamed (the lookup fallback), and reporting on individual-resource callback volumes.

  • List callback queues with resolved names: SELECT queue_name, queue_type, queue_count FROM apps.ieu_uwq_web_callback_v ORDER BY queue_count DESC;
  • Inspect the lookup mapping driving the fallback label: SELECT lookup_code, meaning FROM fnd_lookup_values_vl WHERE lookup_type = 'IEU_NODE_LABELS' AND view_application_id = 696;
  • Join back to resources for individual-level breakdowns using RESOURCE_ID where RESOURCE_TYPE = 'RS_INDIVIDUAL'.

Because the media type UUID is fixed, the view is not a general purpose media type report; queries requiring other media types must be built directly against IEU_UWQ_SEL_MRT_DATA and its related tables.