--выбираем абонента
SELECT DISTINCT s.subscriber_no,
                ba.ban
FROM   vmpapp102.subscriber s
       join vmpapp102.billing_account ba
         ON s.customer_ban = ba.ban
WHERE  ba.ban_status = 'O'
       AND s.sub_status = 'A'
       AND account_type = '13'
       AND ba.market_code = 'VIP';



--выбираем сок для подключения
SELECT soc_dest
FROM   vmpapp102.soc_relation
WHERE  soc_src IN (SELECT soc
                   FROM   vmpapp102.service_agreement
                   WHERE  ban = 'BAN из запроса выше')
       AND expiration_date IS NULL
       AND soc_dest IN ((SELECT soc
                         FROM   vmpapp102.soc
                         WHERE  service_class = 'SOC'
                                AND soc_status = 'A'
                                AND expiration_date IS NULL
                         INTERSECT
                         SELECT soc
                         FROM   vmpapp102.soc_acc_restriction
                         WHERE  account_types = '13'
                         INTERSECT
                         SELECT soc
                         FROM   vmpapp102.market_soc_restrict
                         WHERE  market_code = 'VIP'
                                AND expiration_date IS NULL)
                        MINUS
                        SELECT soc
                        FROM   vmpapp102.service_agreement
                        WHERE  ban = 'BAN из запроса выше')
MINUS
SELECT soc
FROM   vmpapp102.service_agreement
WHERE  ban = 'BAN из запроса выше'
       AND expiration_date IS NULL
MINUS
(SELECT soc
 FROM   vmpapp102.service_feature
 MINUS
 SELECT soc
 FROM   vmpapp102.service_feature
 WHERE  ftr_expiration_date IS NOT NULL)