select
ADVISE_ID, -- ADVISE_ID NUMBER
RANK, -- RANK NUMBER
REQUIRED, -- REQUIRED VARCHAR2(3)
MESSAGE -- MESSAGE VARCHAR2(1024)
from
GV$IR_MANUAL_CHECKLIST
where
inst_id=USERENV('Instance')