MPKG_NOTES

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.

Sample

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,
       n.NOTE_DATA NOTES
FROM   mpkg_packages p,
       mpkg_notes n
WHERE  p.priority = 'Critical'
AND    p.workflow = 'FIN dev -> prod'
AND    p.package_id = n.package_id;