AKB-Notification-Processor
ALTER SESSION SET TIME_ZONE = ' +04:00 '; SELECT css . id AS credit_subs_id, -- EVENT.CREDIT_SUBS_ID css . customer_id AS customer_id, -- EVENT.CUSTOMER_ID css . subs_date , csl . id AS service_id, csl . name AS device_name, csl . credit_status , csl . auto_payable , csl . counter FROM SUBSCRIPTION . CREDIT_SRV_SUBS css JOIN SUBSCRIPTION . CREDIT_SRV_LIST csl ON css . service_id = csl . id WHERE csl . credit_status = ' a ' AND csl . auto_payable IN ( 1 , 4 ) AND ROWNUM <= 20 ORDER BY css . id DESC ;