MREQ_NOTES

Provides access to the notes for all requests in Demand Management.

Notes are stored in an Oracle LONG database column; to prevent an overload of information this was presented in a separate Meta Layer view, making it less likely to design a report that inadvertently returns too much data.

To query request notes, join this view with a request view (MREQ_REQUESTS, or a request type-specific view MREQ_<Request Type Name>).

Sample

To retrieve a list of the notes for all open requests of the Bug request type, that have Critical priority, use the following logic in an SQL statement:

SELECT r.request_number REQ_NUM,
       n.notes NOTES
FROM   mreq_bug r,
       mreq_notes n
WHERE  r.priority = 'Critical'
AND    r.request_id = n.request_id;