Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT dcpe.dcc_dce_id_comunic, dcpe.dcc_dcr_id_cpe, dcpe.dcc_data_leitura
- FROM usr_sat_dtec.dtec_comunicacao_cpe dcpe, usr_sat_dtec.dtec_comunicacao dcomu
- WHERE dcomu.dce_id_comunic=dcpe.dcc_dce_id_comunic
- AND dcomu.dce_id_comunic=15251
- AND dcpe.dcc_dcr_id_cpe IN
- (SELECT proccpe.id_cpe AS linhas
- FROM dtec_procuracao_cpe proccpe, dtec_procuracao_eletronica dproc
- WHERE
- TO_CHAR( dproc.dt_data_validade ,'yyyymmdd') >= TO_CHAR( SYSDATE ,'yyyymmdd')
- AND proccpe.id_procuracao=dproc.id_procuracao
- AND dproc.cd_cpfcnpj_procurador='03143613165'
- AND dproc.dt_revogacao IS NULL
- UNION ALL
- SELECT dcred.dcr_idcpe AS linhas
- FROM dtec_credenciamento dcred
- WHERE dcred.dcr_rge_ruc='03143613165'
- )
- AND dcpe.dcc_corpo_comunic IS NULL
- AND NOT EXISTS(
- SELECT 1
- FROM usr_sat_dtec.dtec_anexo_comunic danex
- WHERE danex.dac_dce_id_comunic=dcpe.dcc_dce_id_comunic
- AND danex.dac_dcr_idcpe IS NOT NULL)
- AND dcpe.dcc_data_leitura IS NULL;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement