SELECT SMBAOGN.*

FROM SMBAOGN
WHERE
SMBAOGN.SMBAOGN_PROGRAM='LICINGTEL001'
 AND SMBAOGN.SMBAOGN_MET_IND='N'
AND SMBAOGN.SMBAOGN_AREA <(
                                                        SELECT S.SMBAOGN_AREA AS AREA_CODE
                                                        FROM SMBAOGN S
                                                        WHERE
                                                         S.SMBAOGN_PIDM=SMBAOGN.SMBAOGN_PIDM
                                                       AND  S.SMBAOGN_PROGRAM=SMBAOGN.SMBAOGN_PROGRAM
                                                       AND S.SMBAOGN_MET_IND='Y'
                                                        AND S.SMBAOGN_REQUEST_NO = (SELECT MAX(AOGN.SMBAOGN_REQUEST_NO)
                                                                                                            FROM SMBAOGN AOGN
                                                                                                            WHERE AOGN.SMBAOGN_PIDM = S.SMBAOGN_PIDM
                                                                                                                        AND AOGN.SMBAOGN_AREA = S.SMBAOGN_AREA
                                                                                                                        AND AOGN.SMBAOGN_PROGRAM = S.SMBAOGN_PROGRAM
                                                                                                                        AND AOGN.SMBAOGN_MET_IND='Y'
                                                                                                                        AND AOGN.SMBAOGN_AREA_PRIORITY=(SELECT MAX(AOGN2.SMBAOGN_AREA_PRIORITY)
                                                                                                                                                                                    FROM SMBAOGN AOGN2
                                                                                                                                                                                    WHERE AOGN2.SMBAOGN_PIDM = AOGN.SMBAOGN_PIDM
                                                                                                                                                                                               -- AND AOGN2.SMBAOGN_AREA = AOGN.SMBAOGN_AREA
                                                                                                                                                                                                AND AOGN2.SMBAOGN_PROGRAM = AOGN.SMBAOGN_PROGRAM
                                                                                                                                                                                                AND AOGN2.SMBAOGN_MET_IND='Y'
                                                                                                                                                                                    )
                                                                                                           )
                                        )


 AND SMBAOGN.SMBAOGN_REQUEST_NO  =(SELECT MAX(AOGN.SMBAOGN_REQUEST_NO)
                FROM SMBAOGN AOGN
                WHERE AOGN.SMBAOGN_PIDM = SMBAOGN.SMBAOGN_PIDM
                            AND AOGN.SMBAOGN_AREA = SMBAOGN.SMBAOGN_AREA
                            AND AOGN.SMBAOGN_PROGRAM = SMBAOGN.SMBAOGN_PROGRAM )

ORDER BY
SMBAOGN.SMBAOGN_PROGRAM,
SMBAOGN.SMBAOGN_PIDM,
SMBAOGN.SMBAOGN_AREA_PRIORITY
;