Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT COUNT(1)
- -- dcc.dcc_dcr_id_cpe, dcc.dcc_dce_id_comunic, DAC.DTA_DATA,DCC.DCC_DATA_ENVIO,DCC.DCC_DATA_LEITURA, TO_CHAR(DAC.DTA_DATA, 'yyyymmddHH24MISS')
- FROM usr_sat_dtec.DTEC_COMUNICACAO_CPE DCC
- JOIN usr_sat_dtec.DTEC_CIENTE_ELETRONICO DCE ON DCC.DCC_DCE_ID_COMUNIC = DCE.DCE_DCE_ID_COMUNIC AND DCC.DCC_DCR_ID_CPE = DCE.DCE_DCR_ID_CPE
- JOIN usr_sat_dtec.DTEC_ACESSO_CPE DAC ON DAC.DTA_ID_CPE = DCE.DCE_DCR_ID_CPE
- WHERE TO_CHAR(DCC.DCC_DATA_ENVIO, 'yyyymm') = '201909'
- AND TO_CHAR(DAC.DTA_DATA, 'yyyymmddHH24MISS') >= TO_CHAR(DCC.DCC_DATA_ENVIO, 'yyyymmddHH24MISS')
- AND TO_CHAR(DAC.DTA_DATA, 'yyyymmddHH24MISS') <= TO_CHAR(DCC.DCC_DATA_LEITURA, 'yyyymmddHH24MISS')
- AND DCE.DCE_DCE_ID_ESTADO_CIENTE = 3
- AND NOT EXISTS(
- SELECT *
- FROM usr_sat_dtec.DTEC_ACESSO_CPE DAC2
- WHERE DAC2.DTA_ID_CPE = DCE.DCE_DCR_ID_CPE
- AND TO_CHAR(DAC2.DTA_DATA, 'yyyymmddHH24MISS') >= TO_CHAR(DCC.DCC_DATA_ENVIO, 'yyyymmddHH24MISS')
- AND TO_CHAR(DAC2.DTA_DATA, 'yyyymmddHH24MISS') < TO_CHAR(DAC.DTA_DATA, 'yyyymmddHH24MISS') )
- AND dcc.dcc_dcr_id_cpe=101520
- ORDER BY DCC.DCC_DCE_ID_COMUNIC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement