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')