Search Results ieu_uwqm_worklist_v

Overview

IEU_UWQM_WORKLIST_V is a database view belonging to the IEU (Universal Work Queue) product family in Oracle E-Business Suite, and is supported in both the 12.1.1 and 12.2.2 releases. Its documented purpose is to serve as the data source for the Universal Work Queue selector "SpreadTable" component. In practical terms, the view flattens the work item queue into a tabular, presentation-ready result set that a UWQ selector can bind to and render as a spread table of assigned work.

Rather than storing data, the view is a read-only consolidation layer. It joins the transaction work queue master table with object definition, enumerator, priority, and lookup metadata so that each work item row carries not only operational identifiers (work item number, status, priority, due date, title) but also the navigation and action metadata required to launch the underlying object (function, parameters, action object code). This makes it an integration and reporting surface as much as a UI helper.

Underlying Base Objects

The view is defined over the following base objects, as revealed by its view text:

• IEU_UWQM_ITEMS — the work item queue master (aliased UWQM), supplying work item identity, ownership, assignment, status, priority, and source object linkage.
• JTF_OBJECTS_B (aliased JTFO and JTFO1) — the object definition table, joined on OBJECT_CODE. It resolves the source object type and the action object code. The second instance (JTFO1) is fixed to the 'TASK' object code to support task-based branching.
• IEU_UWQ_SEL_ENUMERATORS (aliased ENUM) — enumerator metadata, joined on ENUM_TYPE_UUID, providing the work queue label lookup context and enumerator type UUID.
• IEU_UWQM_PRIORITIES_TL (aliased PR) — the translatable priority table, supplying the priority display name.
• FND_LOOKUP_VALUES_VL (aliased LKUPS and LKUPS1) — lookup values for work type labels (outer-joined) and node labels (IEU_NODE_LABELS, joined on IN_USE).

Note that the ETRM metadata records no documented referenced base objects and notes the view is "not implemented in this database" in the captured instance, so the joins above are drawn from the documented view text.

Key Columns

• WORK_ITEM_ID, WORK_ITEM_NUMBER, WORKITEM_PK_ID, WORKITEM_OBJ_CODE — core work item identity.
• IEU_OBJECT_FUNCTION — the function to invoke for the work item, derived via DECODE logic that branches on SOURCE_OBJECT_TYPE_CODE and the ENTER_FROM_TASK flag.
• IEU_OBJECT_PARAMETERS — the parameter string passed to the target function. This is the column most associated with the user's object_parameters search and is subject to the same nested DECODE branching.
• IEU_ACTION_OBJECT_CODE — the action object code, similarly derived through the task/non-task DECODE.
• IEU_PARAM_PK_VALUE — carries SOURCE_OBJECT_ID, the primary key of the source object.
• IEU_ENUM_TYPE_UUID, IEU_MEDIA_TYPE_UUID, IEU_PARAM_PK_COL — enumerator/media metadata; the latter two are returned as empty strings.
• PRIORITY, PRIORITY_LEVEL, STATUS_CODE, WORK_TYPE — descriptive enumerations resolved from the priority and lookup tables.
• OWNER_ID/ASSIGNEE_ID (plus _ACTUAL variants), PARTY_ID, DUE_DATE, TITLE, APPLICATION_ID — operational work assignment attributes.

Common Use Cases and Queries

Because the view supplies both display data and navigation metadata, it is commonly used to build UWQ selector result grids and to drive programmatic object launches. To inspect the parameter string for a specific work item:

• SELECT work_item_number, ieu_object_function, ieu_object_parameters FROM ieu_uwqm_worklist_v WHERE work_item_id = :id;
• To list open work by priority: SELECT work_item_number, priority, due_date FROM ieu_uwqm_worklist_v WHERE status_code = 'IN_USE' ORDER BY priority_level;
• To trace navigation details: SELECT ieu_action_object_code, ieu_object_function, ieu_object_parameters, ieu_param_pk_value FROM ieu_uwqm_worklist_v;

When troubleshooting object launches, examine IEU_OBJECT_PARAMETERS alongside IEU_OBJECT_FUNCTION, since both are resolved dynamically from JTF_OBJECTS_B based on the ENTER_FROM_TASK flag on the object definition.