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