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.
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';
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