QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=9 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2022-12-01_21:00:05 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=9 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-01_21:00:07 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=9 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-01_21:00:07 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=9 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-01_21:00:07 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=9 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2022-12-01_21:00:07 EMPEZO ->> 2022-12-01_21:00:02 TERMINO ->> 2022-12-01_21:00:07 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=9 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2022-12-02_21:00:15 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=9 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-02_21:00:21 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=9 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-02_21:00:21 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=9 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-02_21:00:21 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=9 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2022-12-02_21:00:22 EMPEZO ->> 2022-12-02_21:00:01 TERMINO ->> 2022-12-02_21:00:22 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=9 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2022-12-03_21:00:05 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=9 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-03_21:00:06 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=9 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-03_21:00:06 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=9 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-03_21:00:06 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=9 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2022-12-03_21:00:06 EMPEZO ->> 2022-12-03_21:00:02 TERMINO ->> 2022-12-03_21:00:06 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=9 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2022-12-04_21:00:05 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=9 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-04_21:00:06 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=9 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-04_21:00:06 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=9 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-04_21:00:06 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=9 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2022-12-04_21:00:06 EMPEZO ->> 2022-12-04_21:00:01 TERMINO ->> 2022-12-04_21:00:06 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2022-12-14_21:00:16 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-14_21:00:21 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-14_21:00:21 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-14_21:00:22 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2022-12-14_21:00:22 EMPEZO ->> 2022-12-14_21:00:01 TERMINO ->> 2022-12-14_21:00:22 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2022-12-15_21:00:10 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-15_21:00:12 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-15_21:00:12 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-15_21:00:12 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2022-12-15_21:00:12 EMPEZO ->> 2022-12-15_21:00:03 TERMINO ->> 2022-12-15_21:00:12 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2022-12-16_21:00:05 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-16_21:00:07 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-16_21:00:07 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-16_21:00:07 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2022-12-16_21:00:07 EMPEZO ->> 2022-12-16_21:00:02 TERMINO ->> 2022-12-16_21:00:07 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2022-12-17_21:00:05 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-17_21:00:06 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-17_21:00:06 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-17_21:00:07 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2022-12-17_21:00:07 EMPEZO ->> 2022-12-17_21:00:01 TERMINO ->> 2022-12-17_21:00:07 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2022-12-18_21:00:05 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-18_21:00:06 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-18_21:00:06 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-18_21:00:06 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2022-12-18_21:00:06 EMPEZO ->> 2022-12-18_21:00:01 TERMINO ->> 2022-12-18_21:00:06 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2022-12-19_21:00:06 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-19_21:00:07 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-19_21:00:07 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-19_21:00:07 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2022-12-19_21:00:07 EMPEZO ->> 2022-12-19_21:00:02 TERMINO ->> 2022-12-19_21:00:07 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2022-12-20_21:00:05 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-20_21:00:06 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-20_21:00:06 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-20_21:00:06 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2022-12-20_21:00:06 EMPEZO ->> 2022-12-20_21:00:01 TERMINO ->> 2022-12-20_21:00:06 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2022-12-21_21:00:05 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-21_21:00:06 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-21_21:00:06 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-21_21:00:06 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2022-12-21_21:00:06 EMPEZO ->> 2022-12-21_21:00:01 TERMINO ->> 2022-12-21_21:00:06 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2022-12-22_21:00:05 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-22_21:00:06 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-22_21:00:06 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-22_21:00:06 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2022-12-22_21:00:06 EMPEZO ->> 2022-12-22_21:00:01 TERMINO ->> 2022-12-22_21:00:06 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2022-12-23_21:00:05 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-23_21:00:06 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-23_21:00:06 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-23_21:00:06 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2022-12-23_21:00:06 EMPEZO ->> 2022-12-23_21:00:01 TERMINO ->> 2022-12-23_21:00:06 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2022-12-24_21:00:05 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-24_21:00:07 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-24_21:00:07 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-24_21:00:07 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2022-12-24_21:00:07 EMPEZO ->> 2022-12-24_21:00:02 TERMINO ->> 2022-12-24_21:00:07 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2022-12-25_21:00:05 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-25_21:00:06 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-25_21:00:06 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-25_21:00:06 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2022-12-25_21:00:06 EMPEZO ->> 2022-12-25_21:00:01 TERMINO ->> 2022-12-25_21:00:06 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2022-12-26_21:00:05 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-26_21:00:06 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-26_21:00:06 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-26_21:00:06 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2022-12-26_21:00:06 EMPEZO ->> 2022-12-26_21:00:01 TERMINO ->> 2022-12-26_21:00:06 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2022-12-27_21:00:05 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-27_21:00:06 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-27_21:00:06 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-27_21:00:06 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2022-12-27_21:00:06 EMPEZO ->> 2022-12-27_21:00:01 TERMINO ->> 2022-12-27_21:00:06 QUERY OK -->> UPDATE facelec.NCCELECT SET PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' and substr(IDCFCE,1,10)<>'9999999999' == 2022-12-28_21:00:10 QUERY OK -->> UPDATE facelec.RFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-28_21:00:11 QUERY OK -->> UPDATE facelec.OFCCELECT SET FAEAUT=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-28_21:00:11 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)<>'AUTORIZADO' AND TRIM(FAEMSG)<>'EN PROCESO' AND TRIM(FAEMSG)<>'NO AUTORIZADO' == 2022-12-28_21:00:11 QUERY OK -->> UPDATE facelec.VFCCELECT SET FAEGEN=0, FAEFIR=0, FAEVAL=0, FAEAUT=0, FAEPDFV=0, FAEEMAI=0, PROCESOS=0, TOTFCE = BIMFC1+VIMFC1+BIMFC2+VIMFC2 WHERE YEAR(FEMFCE)=2022 AND MONTH(FEMFCE)>=11 AND TRIM(FAEMSG)='NO AUTORIZADO' == 2022-12-28_21:00:11 EMPEZO ->> 2022-12-28_21:00:02 TERMINO ->> 2022-12-28_21:00:11