tip CCFIL

[Ene Toma - ORCTDB]

stie cineva la noile certificate constatatoare unde sunt salvate tipurile de certificat constatator?
inainte foloseam

select nr_ceree,data_cerere, substr(DATE_SOLICITATE,3, instr(DATE_SOLICITATE,':[{')-4 )
from I_ELIBERARE_INSCRISURI,cerere
where I_ELIBERARE_INSCRISURI.id_cerere=cerere.id and data_cerere=to_date('14/03/2014','dd/mm/yyyy')
order by 2,1

6556    14-03-2014    Certificat constatator fonduri IMM si MINIMIS
6561    14-03-2014    Certificat constatator obtinere viza
6567    14-03-2014    Certificat constatator FEADR
6568    14-03-2014    Certificat constatator obtinere viza
6586    14-03-2014    Certificat constatator obtinere viza
6594    14-03-2014    Certificat constatator banca
6602    14-03-2014    Certificat constatator obtinere viza

Multumesc!