SELECT DISTINCT A.MAINT_OBJ_CD,B.DESCR
FROM CI_MD_MO_OPT A, CI_MD_MO_L B
WHERE A.MAINT_OBJ_OPT_FLG= 'F1BN'
AND A.MAINT_OBJ_OPT_VAL='Y'
AND A.MAINT_OBJ_CD=B.MAINT_OBJ_CD
AND B.LANGUAGE_CD = :INSERT_LANGUAGE_HERE
AND NOT EXISTS (SELECT 'X' FROM CI_MD_MO_OPT C WHERE C.MAINT_OBJ_OPT_FLG = A.MAINT_OBJ_OPT_FLG AND A.MAINT_OBJ_CD = C.MAINT_OBJ_CD AND C.SEQ_NUM > A.SEQ_NUM)
uploaded by Nuno Rodrigues