Share this page

# MREQ_REQUEST_TYPES

Accesses configuration details of request types in Demand Management.

You can include request type information in a report by joining the REQUEST_TYPE column in this view with the same column in the general request views (MREQ_REQUESTS and MREQ_<Request Type Name>).

PPM supports user data on request types. All defined request type user data fields are represented in MREQ_REQUEST_TYPES view; there is a column for each request type user data field. The column name for each request type user data field is the same as the token name for that field.

Sample 1

A user data field with token name OWNER is defined for request types, to keep track of a PPM administrator responsible for maintaining each request type configuration.

A corresponding view column named OWNER will be present in MREQ_REQUEST_TYPES view:

`SQL`> `desc mreq_request_types;`

Results 1

    Name                            Null?    Type
    ------------------------------- -------- ----
    REQUEST_TYPE                    NOT NULL VARCHAR2(30)
    REQUEST_TYPE_DESCRIPTION        NOT NULL VARCHAR2(240)
    ...
    INITIAL_STATUS                  NOT NULL VARCHAR2(80)
    RESTRICTION                     NOT NULL VARCHAR2(30)
    OWNER                                    VARCHAR2(200)
    CREATION_DATE                   NOT NULL DATE
    CREATED_BY_USERNAME             NOT NULL VARCHAR2(30)
    ...

Sample 2

An SQL query based on this view might be used to determine how many requests were created prior to a configuration change for a particular request type.

For example, a request type named Work Order has undergone a significant configuration change that invalidates open work order requests that were created before the change. Therefore, a report is needed to determine the status of open work order requests that were created before the changes:

    SELECT wo.request_id          REQUEST_NUM,
           wo.request_status      CURRENT_STATUS,
           wo.request_description DESCRIPTION
    FROM   mreq_work_order wo,
           mreq_request_types rt
    WHERE  wo.creation_date < rt.last_update_date
    AND    rt.request_type = 'Work Order'
    ORDER BY 1;

Notice that you do not have to join the explicit request type name to the MREQ_WORK_ORDER view, because it is already implicit in the view definition—only work order requests are returned from that view.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: