'with' + #13#10 + 
'      -- Запрашиваем ВСЕ доступные в данный момент скидки' + #13#10 + 
'      ALL_DISC as (' + #13#10 + 
'        select DISC.ID, DPOS.ID POS_ID,  DISC.NAME, DISC.UNION_MODE,' + #13#10 + 
'               CPRESS.ID CHECKPRESS_ID, DPOS.CATEGORY_ID, DPOS.IS_CATEGORY_ID,' + #13#10 + 
'               DPOS.PERCENT' + #13#10 + 
'        from DISCOUNT DISC' + #13#10 + 
'          join DISCOUNT_POS DPOS on DPOS.PARENT_ID = DISC.ID' + #13#10 + 
'          join CHECKPRESS CPRESS on 1 = 1 -- CPRESS.ID = AD.CHPRESS_ID' + #13#10 + 
'          join CHKPRESSREG CPREG on CPREG.PARENT_ID = CPRESS.ID' + #13#10 + 
'        where DISC.STATUS > 0 and DPOS.STATUS > 0 and CPRESS.STATUS > 0 and CPREG.STATUS > 0' + #13#10 + 
'          and DISC.IS_ACTIVE = 1 and DISC.TYPE_DISCOUNT = 0' + #13#10 + 
'          and (DPOS.CASHREGISTER_ID is NULL or' + #13#10 + 
'              (DPOS.CASHREGISTER_ID = :CASHREGID and DPOS.IS_CASHREGISTER_ID = 1) or' + #13#10 + 
'              (DPOS.CASHREGISTER_ID <> :CASHREGID and DPOS.IS_CASHREGISTER_ID = 0)' + #13#10 + 
'              )' + #13#10 + 
'          and (DPOS.CHECKPRESS_ID is NULL or' + #13#10 + 
'              (DPOS.CHECKPRESS_ID = CPRESS.ID and DPOS.IS_CHECKPRESS_ID = 1) or' + #13#10 + 
'              (DPOS.CHECKPRESS_ID <> CPRESS.ID and DPOS.IS_CHECKPRESS_ID = 0))' + #13#10 + 
'          and CPREG.CASHREG_ID = :CASHREGID' + #13#10 + 
'      ),' + #13#10 + 

with
      -- Запрашиваем ВСЕ доступные в данный момент скидки
      ALL_DISC as (
        select DISC.ID, DPOS.ID POS_ID,  DISC.NAME, DISC.UNION_MODE,
               CPRESS.ID CHECKPRESS_ID, DPOS.CATEGORY_ID, DPOS.IS_CATEGORY_ID,
               DPOS.PERCENT
        from DISCOUNT DISC
          join DISCOUNT_POS DPOS on DPOS.PARENT_ID = DISC.ID
          join CHECKPRESS CPRESS on 1 = 1 -- CPRESS.ID = AD.CHPRESS_I