MREQ_REQUEST_HEADER_TYPES

Accesses configuration details of request header types in Demand Management.

In some cases a report designer might need to include request header type information in a report, and can join the REQUEST_HEADER_TYPE column in this view with the same column in the MREQ_REQUEST_TYPES view, and in general request views (MREQ_REQUESTS and MREQ_<Request Type Name>).

PPM supports user data on request header types. All defined request header type user data fields are represented in MREQ_REQUEST_HEADER_TYPES view; there is a column for each request header type user data field.

The column name for each request header type user data field is the same as the token name for that field.

Sample

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

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

SQL> desc mreq_request_header_types;

Results

Name                            Null?    Type
------------------------------- -------- ----
REQUEST_HEADER_TYPE             NOT NULL VARCHAR2(80)
REQUEST_HEADER_TYPE_DESC                 VARCHAR2(240)
...
ACCELERATOR_NAME                NOT NULL VARCHAR2(80)
OWNER                                    VARCHAR2(200)
CREATION_DATE                   NOT NULL DATE
CREATED_BY_USERNAME             NOT NULL VARCHAR2(30)
LAST_UPDATE_DATE                NOT NULL DATE