SELECT uabscon_number
     , uabscon_cust_code
     , uabscon_prem_code
FROM   uabscon
WHERE  ( uabscon_cust_code,uabscon_prem_code ) NOT IN
       ( SELECT c_cust
              , c_prem
         FROM   ( SELECT a.min_rank
                       , a.c_cust
                       , a.c_prem
                       , a.c_srvc
                       , ( SELECT MIN(p.ucrprod_srvc_code)
                           FROM   utvsrvc r
                                , ucrprod p
                           WHERE  p.ucrprod_cust_code = a.c_cust
                           AND    p.ucrprod_prem_code = a.c_prem
                           AND    p.ucrprod_srvc_code = r.utvsrvc_code
                           AND    r.utvsrvc_ranking = a.min_rank ) srvc_code
                       , ( SELECT uabscon_srvc_code
                           FROM   uabscon
                           WHERE  uabscon_cust_code = a.c_cust
                           AND    uabscon_prem_code = a.c_prem ) srvc_code_uax
                  FROM   ( SELECT ( SELECT MIN(r.utvsrvc_ranking)
                                    FROM   utvsrvc r
                                         , ucrprod p
                                    WHERE  p.ucrprod_cust_code = c.uabscon_cust_code
                                    AND p.ucrprod_prem_code = c.uabscon_prem_code
                                    AND p.ucrprod_srvc_code = r.utvsrvc_code ) min_rank
                             , c.uabscon_cust_code c_cust
                             , c.uabscon_prem_code c_prem
                             , c.uabscon_srvc_code c_srvc
                      FROM   uabscon c
                      WHERE  c.uabscon_status_ind <> 'C' ) a
                ) b
         WHERE  srvc_code = srvc_code_uax )
AND    uabscon_status_ind <> 'C'