MREQ_PENDING_REQUESTS

Used to create a report that shows the volume of open requests for any given request type in Demand Management.

This report can be used to get information about ongoing request processing work. It shows a summary of requests currently open for a specific Demand Management request type (for example, total number or average age), and information showing how many requests have been opened and closed in the current week and current month.

MREQ_PENDING_REQUESTS is aggregated across all requests.

In addition to overall totals of open requests, this view breaks down the information by priority (using the Priority header field). This is done because priority is usually the most important breakdown of load information. Data is grouped into three priority groupings—P1, P2, and P3, which map to the three highest-priority levels defined.

Sample

A QA manager has three types of requests to handle, running through three separate processes. The manager needs a report that will show current work volume for each of these request types, to help prioritize work and identify bottlenecks.

If the three request types are named MFG bug report, FIN bug report, and APPS enhancement request, the following SQL query can be used as a basis for a report to display the desired information:

SELECT request_type          Request_Type,
       open_requests         Open_Reqs,
       avg_age_open_requests Avg Age,
       p1_open_requests      P1 Open Reqs,
       p2_open_requests      P2 Open Reqs
FROM   mreq_pending_requests
WHERE  process_name IN
       ('MFG bug report',
       'FIN bug report',
       'APPS enhancement request');

Results

                                        P1    P2
                           Open  Avg  Open  Open
REQUEST_TYPE               Reqs  Age  Reqs  Reqs
------------------------- ----- ---- ----- -----
MFG bug report               98    3    21    77
FIN bug report               39    4    14    25
APPS enhancement request    140   12     8   132

This view ignores requests that have not been submitted.