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, 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;