Provides access to the notes for all packages in Deployment Management.

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

To query package notes, join this view with the MPKG_ALL_PACKAGES view.


To retrieve a list of the notes for all open packages being processed through the FIN dev -> prod workflow, and that have Critical priority, use the following logic in an SQL statement:

SELECT p.package_number PKG_NUM,
FROM   mpkg_packages p,
       mpkg_notes n
WHERE  p.priority = 'Critical'
AND    p.workflow = 'FIN dev -> prod'
AND    p.package_id = n.package_id;