SELECT *
  FROM	(
  
		   
		/* ------- ERROR: SBOM Priority Section Incomplete ------- */   
		SELECT DISTINCT 'enum_MSG_PACKAGE_SBOMPRIORITY_INCOMPLETE' AS err_message,
					    'fixed_issues.asp' AS rfile,
				        '#SBOM_PRIORITY' AS anchor,
		                1 AS priority,
					    'ERROR' AS products_msg
				   FROM PACKAGE_VERSIONS pv
				  WHERE pv.pv_id = :PV_ID
				    AND ( pv.SBOM_PRIORITY IS NULL )
				       	            

         
		) errmsg
ORDER BY priority        		      