MPKG_REFERENCES

References are used throughout PPM to relate transaction entities together. The MPKG_REFERENCES view can be used to view the references of packages in Deployment Management.

There are several types of references for packages. If a package is part of a release, then there will be a reference for that release. If a package was spawned by a request, then there will be a reference for that request. Packages can be related to other packages through the use of references. References are also used to attach documents to a package.

The RELATIONSHIP column in MPKG_REFERENCES describes the relationship of the referenced item to the package that references it. This view also has columns for each of the entities that can be referenced to a package—other packages, projects, tasks, requests, releases, attachments, and URLs. For each record in MPKG_REFERENCES, only one of these columns will have a value and the others will be NULL.

Sample

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

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   mpkg_references
WHERE  package_number = '30121';

Results

PKG  PROJ   REQ  REL  TASK   ATTACHMENT       URL       RELATIONSHIP
---- ----- ----- ---- ----- ---------------- ---------- ---------------------
                 30012                                  Contains this Package
30332                                                   Run after this Package
30043                                                   Run before this Package
30044                                                   Run before this Package
30046                                                   Run before this Package
                             design32_3.doc