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;