MREQ_REFERENCES

Used to view the references of requests in Demand Management.

There are several types of references for requests. If a request is part of a release, then there will be a reference for that release. If a request is a parent or child of another request, then there will be a reference for that request. References are also used to attach documents to a request.

The RELATIONSHIP column in MREQ_REFERENCES describes the relationship of the referenced item to the request that references it. This view also has columns for each of the entities that can be referenced to a request—other requests, packages, projects, tasks, releases, attachments, and URLs.

For each record in MREQ_REFERENCES, only one of these columns will have a value and the others will be NULL.

Sample

The following SQL can be used to retrieve a list of all references to a particular request:

SELECT referenced_package_id PKG,
       referenced_project_id PROJ,
       referenced_request_id REQ,
       referenced_release_id REL,
       referenced_task_id    TASK,
       attachment_name       ATTACHMENT,
       document_url          URL,
       relationship          RELATIONSHIP
FROM   mreq_references
WHERE  request_number = '54872';

Results

PKG  PROJ  REQ   REL  TASK   ATTACHMENT       URL         RELATIONSHIP
--- ----- ----- ----- ----- ------------ ---------- ---------------------------
                      43301                               Contains this Request                        43304                               Contains this request 
30043                                                     Child of this Request
          52383                                           Parent of this Request
                            screenShot.doc