SELECT 
TO_DATE('02.02.2008', 'DD.MM.YYYY') AS DT, 
CC.ID_CONTRACTS, 
B.ID_BALANCE, 
S.SALDO,
C.NUM_CONTRACTS
FROM
FCT_PRCST_CRED P, DET_ACCOUNT A, DET_BALANCE B, FCT_ACOUNT_SALTRAN S, DET_CONTRACTS C,
CON_ASS_CONTR_ACC CC, DET_ORD_LIAB O, DET_TACC T, DET_SOURCE SR 
WHERE A.ID_ACCOUNT = S.ID_ACCOUNT
AND A.ID_BALANCE   = B.ID_BALANCE
AND A.ID_ACCOUNT   = CC.ID_ACCOUNT
AND C.ID_CONTRACTS = CC.ID_CONTRACTS
AND CC.ID_TACC     = T.ID_TACC
AND C.ID_SOURCE    = SR.ID_SOURCE
AND C.ID_CONTRACTS = P.ID_CONTRACTS
AND P.ID_ORD_LIAB  = O.ID_ORD_LIAB
--AND O.NL_ORD_LIAB  = '1'
AND TO_DATE('02.02.2008', 'DD.MM.YYYY') BETWEEN P.DT_OPEN  AND P.DT_CLOSE
AND TO_DATE('02.02.2008', 'DD.MM.YYYY') BETWEEN S.DT_OPEN  AND S.DT_CLOSE
AND TO_DATE('02.02.2008', 'DD.MM.YYYY') BETWEEN CC.DT_OPEN AND CC.DT_CLOSE
AND SR.CODE_SOURCE = 'Loans'
AND C.CODE_CONTRACTS NOT LIKE '%gar%'
AND SUBSTR(B.CODE_BALANCE, 1, 1) IN ( '1', '2' )
AND T.CODE_TACC = '1'
AND A.IS_GK != '1'
AND S.SALDO <> 0