INTEGRAÇAO script_usu_tc_mov INICIADA AS 16/08/2026 13:47:24<br>                Ultima Data: <br>                Ultima Data: 2022-10-27 15:12:03<br>                Data Atual: 2022-10-27 15:12:03<br>                SELECT cp.cod_batelada as usu_nrmov, COALESCE(cp.empresa_erp, 1) as usu_codemp, COALESCE(cp.filial_erp, 1) as usu_codfil, cd.deposito_erp as usu_coddep, cpa.id_produto as usu_codpro, cpa.nr_lote as usu_codlot, cpa.dta_inc as usu_dtamov, (SELECT transacao_erp_est_pa FROM ceqnep_configuracao LIMIT 1) as usu_codtns, cpa.qt_apontada as usu_qtdmov,'0' as usu_vlrmov, 'A' as usu_status, '2026-08-16 13:47:24' as usu_dtregistro, prod.codigo_erp as tmp_cod_erp, '1.000' as tmp_volume, cpa.nr_sequencia, cp.capela as id_cfl
					    FROM ceqnep_prescricao_apontamento cpa
					    	 LEFT JOIN ceqnep_prescricao cp ON cpa.id_prescricao = cp.id_prescricao
					    	 LEFT JOIN ceqnep_deposito cd ON cp.id_deposito_pa = cd.id_deposito
					    	 LEFT JOIN ceqnep_produto prod ON prod.id = cpa.id_produto
					   WHERE cpa.tp_apontamento = 'P'
					     AND COALESCE(cpa.dta_inc) >= COALESCE('2022-10-27 15:12:03',COALESCE(cpa.dta_inc)) UNION ALL SELECT cp.cod_batelada as usu_nrmov, COALESCE(cp.empresa_erp, 1) as usu_codemp, COALESCE(cp.filial_erp, 1) as usu_codfil, cfl.deposito_erp as usu_coddep, cpa.id_produto as usu_codpro, cpa.nr_lote as usu_codlot, cpa.dta_inc as usu_dtamov, (SELECT transacao_erp_est_mp FROM ceqnep_configuracao LIMIT 1) as usu_codtns, cpa.qt_apontada as usu_qtdmov,'0' as usu_vlrmov, 'A' as usu_status, '2026-08-16 13:47:24' as usu_dtregistro, prod.codigo_erp as tmp_cod_erp, prod.volume as tmp_volume, cpa.nr_sequencia, cp.capela as id_cfl
 					    FROM ceqnep_prescricao_apontamento cpa
 					         LEFT JOIN ceqnep_prescricao cp ON cpa.id_prescricao = cp.id_prescricao
 					         LEFT JOIN ceqnep_cfl cfl ON cfl.id_cfl = cp.capela
 					         LEFT JOIN ceqnep_produto prod ON prod.id = cpa.id_produto
					   WHERE cpa.tp_apontamento = 'M'
					   	 AND COALESCE(cpa.dta_inc) >=  COALESCE('2022-10-27 15:12:03',COALESCE(cpa.dta_inc)) UNION ALL SELECT crop.cod_batelada as usu_nrmov, re.emp_erp as usu_codemp, re.emp_fil as usu_codfil, cfl.deposito_erp as usu_coddep,crp.id_produto as usu_codpro, crp.nr_lote as usu_codlot, crp.dta_inc as usu_dtamov, ctr.transacao_erp as usu_codtns, crp.qt_requisicao as usu_qtdmov,'0' as usu_vlrmov, 'A' as usu_status, '2026-08-16 13:47:24' as usu_dtregistro, prod.codigo_erp as tmp_cod_erp, prod.volume as tmp_volume, crp.nr_sequencia, cp.capela as id_cfl
					    FROM ceqnep_requisicao_produto crp
					         LEFT JOIN ceqnep_requisicao cr ON crp.nr_requisicao = cr.nr_requisicao and crp.reve_cod = cr.reve_cod
					         LEFT JOIN ceqnep_requisicao_op crop ON  crop.nr_requisicao = cr.nr_requisicao
					         LEFT JOIN ceqnep_tipo_requisicao ctr ON cr.id_tipo_requisicao = ctr.id_tipo_requisicao
					         LEFT JOIN ceqnep_prescricao cp ON cp.cod_batelada = crop.cod_batelada
					         LEFT JOIN ceqnep_produto prod ON prod.id = crp.id_produto
					         LEFT JOIN ceqnep_cfl cfl ON cfl.id_cfl = cp.capela
                             LEFT JOIN revendas re on (re.reve_cod = cr.reve_cod)
					   WHERE COALESCE(crop.dta_inc) >=  COALESCE('2022-10-27 15:12:03',COALESCE(crop.dta_inc))
					   	 AND cr.nr_requisicao IN (SELECT DISTINCT(nr_requisicao) FROM ceqnep_requisicao_op)
					   	 AND ctr.entre_filial = 'N' UNION ALL SELECT rp.nr_requisicao as usu_nrmov, re.emp_erp as usu_codemp, re.emp_fil as usu_codfil, cd_des.deposito_erp as usu_coddep, rp.id_produto as usu_codpro, rp.nr_lote as usu_codlot, COALESCE(r.dta_alt,r.dta_inc) as usu_dtamov, tp.transacao_erp as usu_codtns, rp.qt_requisicao as usu_qtdmov, '0' as usu_vlrmov, 'A' as usu_status, '2026-08-16 13:47:24' as usu_dtregistro, p.codigo_erp as usu_codpro, p.volume as tmp_volume, rp.nr_sequencia, r.id_cfl_des as id_cfl
                        FROM ceqnep_requisicao r
                             LEFT JOIN ceqnep_requisicao_produto rp on (r.nr_requisicao = rp.nr_requisicao)
                             LEFT JOIN revendas re on (re.reve_cod = r.reve_cod)
                             LEFT JOIN ceqnep_produto p on rp.id_produto = p.id
                             LEFT JOIN ceqnep_tipo_requisicao tp on tp.id_tipo_requisicao = r.id_tipo_requisicao
                             LEFT JOIN ceqnep_deposito cd_ori on r.id_deposito_ori = cd_ori.id_deposito
                             LEFT JOIN ceqnep_deposito cd_des on r.id_deposito_des = cd_des.id_deposito
                             LEFT JOIN ceqnep_produto prod on prod.id = rp.id_produto
                        WHERE COALESCE(r.dta_alt,r.dta_inc) >= COALESCE('2022-10-27 15:12:03',COALESCE(r.dta_alt,r.dta_inc))
                          AND r.nr_requisicao NOT IN (SELECT DISTINCT(nr_requisicao) FROM ceqnep_prescricao_requisicao)
                          AND tp.acumulador <> 'T'
                          AND tp.entre_filial = 'N' UNION ALL SELECT rp.nr_requisicao as usu_nrmov,
		                     re.emp_erp as usu_codemp,
		                     re.emp_fil as usu_codfil,
		                     cd_des.deposito_erp as usu_coddep,
		                     rp.id_produto as usu_codpro,
		                     rp.nr_lote as usu_codlot,
		                     COALESCE(r.dta_alt,r.dta_inc) as usu_dtamov,
		                     tp.transacao_erp_mov_ent as usu_codtns,
		                     rp.qt_requisicao as usu_qtdmov,
		                     '0' as usu_vlrmov,
		                     'A' as usu_status,
		                     '2026-08-16 13:47:24' as usu_dtregistro,
		                     p.codigo_erp as usu_codpro,
		                     p.volume as tmp_volume,
		                     rp.nr_sequencia,
		                     r.id_cfl_des as id_cfl
                        FROM ceqnep_requisicao r
                             LEFT JOIN ceqnep_requisicao_produto rp on (r.nr_requisicao = rp.nr_requisicao)
                             LEFT JOIN revendas re on (re.reve_cod = r.reve_cod)
                             LEFT JOIN ceqnep_produto p on rp.id_produto = p.id
                             LEFT JOIN ceqnep_tipo_requisicao tp on tp.id_tipo_requisicao = r.id_tipo_requisicao
                             LEFT JOIN ceqnep_deposito cd_ori on r.id_deposito_ori = cd_ori.id_deposito
                             LEFT JOIN ceqnep_deposito cd_des on r.id_deposito_des = cd_des.id_deposito
                             LEFT JOIN ceqnep_produto prod on prod.id = rp.id_produto
                        WHERE COALESCE(r.dta_alt,r.dta_inc) >= COALESCE('2022-10-27 15:12:03',COALESCE(r.dta_alt,r.dta_inc))
                          AND r.nr_requisicao NOT IN (SELECT DISTINCT(nr_requisicao) FROM ceqnep_prescricao_requisicao)
                          AND tp.acumulador = 'T'
                          AND tp.entre_filial = 'S' UNION ALL SELECT rp.nr_requisicao as usu_nrmov,
		                     re.emp_erp as usu_codemp,
		                     re.emp_fil as usu_codfil,
		                     cd_ori.deposito_erp as usu_coddep,
		                     rp.id_produto as usu_codpro,
		                     rp.nr_lote as usu_codlot,
		                     COALESCE(r.dta_alt,r.dta_inc) as usu_dtamov,
		                     tp.transacao_erp_mov_sai as usu_codtns,
		                     rp.qt_requisicao as usu_qtdmov,
		                     '0' as usu_vlrmov,
		                     'A' as usu_status,
		                     '2026-08-16 13:47:24' as usu_dtregistro,
		                     p.codigo_erp as usu_codpro,
		                     p.volume as tmp_volume,
		                     rp.nr_sequencia,
		                     r.id_cfl_des as id_cfl
                        FROM ceqnep_requisicao r
                             LEFT JOIN ceqnep_requisicao_produto rp on (r.nr_requisicao = rp.nr_requisicao)
                             LEFT JOIN revendas re on (re.reve_cod = r.reve_cod)
                             LEFT JOIN ceqnep_produto p on rp.id_produto = p.id
                             LEFT JOIN ceqnep_tipo_requisicao tp on tp.id_tipo_requisicao = r.id_tipo_requisicao
                             LEFT JOIN ceqnep_deposito cd_ori on r.id_deposito_ori = cd_ori.id_deposito
                             LEFT JOIN ceqnep_deposito cd_des on r.id_deposito_des = cd_des.id_deposito
                             LEFT JOIN ceqnep_produto prod on prod.id = rp.id_produto
                        WHERE COALESCE(r.dta_alt,r.dta_inc) >= COALESCE('2022-10-27 15:12:03',COALESCE(r.dta_alt,r.dta_inc))
                          AND r.nr_requisicao NOT IN (SELECT DISTINCT(nr_requisicao) FROM ceqnep_prescricao_requisicao)
                          AND tp.acumulador   = 'T'
                          AND tp.entre_filial = 'S' ORDER BY 1 <br>                UPDATE usu_tintegracao SET usu_tc_mov = '2022-10-27 15:12:04' <br>                DATA DA INTEGRACAO usu_tc_mov ATUALIZADA<br>                INTEGRAÇAO script_usu_tc_mov FINALIZADA AS 16/08/2026 13:47:24<br>                INTEGRA�AO script_usu_tc_req INICIADA AS 16/08/2026 13:47:24<br>Sql de Consulta <br>SELECT rp.nr_sequencia as nr_sequencia, tp.atende_automatico, tp.exige_conferencia as tmp_exige_conferencia, emp_erp as usu_codemp, emp_fil as usu_codfil, r.nr_requisicao as usu_numeme, rp.id_produto as usu_seqeme, p.codigo_erp as usu_codpro, rp.nr_lote as usu_codlot, rp.qt_requisicao as usu_qtdeme, tp.transacao_erp as usu_codtns, COALESCE(r.dta_alt,r.dta_inc) as dta_requisicao, cd_ori.deposito_erp as usu_depreq, cd_des.deposito_erp as usu_depatd, r.id_cfl_des as tmp_cfl_des, r.id_cfl_ori as tmp_cfl_ori, prod.volume as tmp_volume, 0 as qt_conferida, r.dta_canc as dta_cancelamento, r.dta_conf as dta_conferencia, 0 qt_cancelada from ceqnep_requisicao r left join ceqnep_requisicao_produto rp on (r.nr_requisicao = rp.nr_requisicao) left join revendas re on (re.reve_cod = r.reve_cod) left join ceqnep_produto p on rp.id_produto = p.id left join ceqnep_tipo_requisicao tp on tp.id_tipo_requisicao = r.id_tipo_requisicao left join ceqnep_deposito cd_ori on r.id_deposito_ori = cd_ori.id_deposito left join ceqnep_deposito cd_des on r.id_deposito_des = cd_des.id_deposito left join ceqnep_produto prod on prod.id = rp.id_produto where COALESCE(r.dta_alt,r.dta_inc) >= COALESCE('2026-06-16 14:52:12',COALESCE(r.dta_alt,r.dta_inc)) and r.nr_requisicao NOT IN (SELECT DISTINCT(nr_requisicao) FROM ceqnep_prescricao_requisicao) and tp.acumulador = 'T' and tp.entre_filial = 'N' UNION ALL SELECT rp.nr_sequencia as nr_sequencia, tp.atende_automatico, tp.exige_conferencia as tmp_exige_conferencia, emp_erp as usu_codemp, emp_fil as usu_codfil, r.nr_requisicao as usu_numeme, rp.id_produto as usu_seqeme, p.codigo_erp as usu_codpro, rp.nr_lote as usu_codlot, rp.qt_requisicao as usu_qtdeme, tp.transacao_erp as usu_codtns, COALESCE(r.dta_alt,r.dta_inc) as dta_requisicao, cd_ori.deposito_erp as usu_depreq, cd_des.deposito_erp as usu_depatd, r.id_cfl_des as tmp_cfl_des, r.id_cfl_ori as tmp_cfl_ori, prod.volume as tmp_volume, 0 as qt_conferida, r.dta_canc as dta_cancelamento, r.dta_conf as dta_conferencia, rp.qt_cancelada from ceqnep_requisicao r left join ceqnep_requisicao_produto rp on (r.nr_requisicao = rp.nr_requisicao) left join revendas re on (re.reve_cod = r.reve_cod) left join ceqnep_produto p on rp.id_produto = p.id left join ceqnep_tipo_requisicao tp on tp.id_tipo_requisicao = r.id_tipo_requisicao left join ceqnep_deposito cd_ori on r.id_deposito_ori = cd_ori.id_deposito left join ceqnep_deposito cd_des on r.id_deposito_des = cd_des.id_deposito left join ceqnep_produto prod on prod.id = rp.id_produto where r.dta_canc >= COALESCE('2026-06-16 14:52:12',dta_canc) and tp.acumulador = 'T' and tp.entre_filial = 'N' UNION ALL SELECT rp.nr_sequencia as nr_sequencia, tp.atende_automatico, tp.exige_conferencia as tmp_exige_conferencia, emp_erp as usu_codemp, emp_fil as usu_codfil, r.nr_requisicao as usu_numeme, rp.id_produto as usu_seqeme, p.codigo_erp as usu_codpro, rp.nr_lote as usu_codlot, 0 as usu_qtdeme, tp.transacao_erp as usu_codtns, COALESCE(r.dta_alt,r.dta_inc) as dta_requisicao, cd_ori.deposito_erp as usu_depreq, cd_des.deposito_erp as usu_depatd, r.id_cfl_des as tmp_cfl_des, r.id_cfl_ori as tmp_cfl_ori, prod.volume as tmp_volume, rp.qt_conferida, r.dta_canc as dta_cancelamento, r.dta_conf as dta_conferencia, 0 qt_cancelada                  from ceqnep_requisicao r left join ceqnep_requisicao_produto rp on (r.nr_requisicao = rp.nr_requisicao) left join revendas re on (re.reve_cod = r.reve_cod) left join ceqnep_produto p on rp.id_produto = p.id left join ceqnep_tipo_requisicao tp on tp.id_tipo_requisicao = r.id_tipo_requisicao left join ceqnep_deposito cd_ori on r.id_deposito_ori = cd_ori.id_deposito left join ceqnep_deposito cd_des on r.id_deposito_des = cd_des.id_deposito left join ceqnep_produto prod on rp.id_produto = prod.id where r.dta_conf >= COALESCE('2026-06-16 14:52:12',dta_conf) and tp.acumulador = 'T'  and tp.entre_filial = 'N' ORDER BY 4 <br><br>INTEGRA�AO script_usu_tc_req FINALIZADA AS 16/08/2026 13:47:24<br>INTEGRA�AO script_usu_ts_cad INICIADA AS 16/08/2026 13:47:24<br>                INTEGRA�AO script_usu_ts_cad FINALIZADA AS 16/08/2026 13:47:25<br>                INTEGRA�AO script_usu_ts_codbar INICIADA AS 16/08/2026 13:47:25<br>                INTEGRA�AO script_usu_ts_codbar FINALIZADA AS 16/08/2026 13:47:25<br>                INTEGRA�AO script_usu_ts_est INICIADA AS 16/08/2026 13:47:25<br>                SELECT ute.*,cp.id as id_produto,cd.id_deposito as id_deposito,cd.usa_cfl as usa_cfl FROM usu_ts_est ute INNER JOIN ceqnep_produto cp ON (TRIM(ute.usu_codpro) = TRIM(cp.codigo_erp)) INNER JOIN ceqnep_deposito cd ON (TRIM(ute.usu_coddep) = TRIM(cd.deposito_erp)) WHERE usu_status = 'P'  AND usu_codpro NOT LIKE 'NE%'  AND usu_codpro NOT LIKE 'IM%'  AND usu_codpro NOT LIKE 'NP%' order by usu_id DESC, usu_datmov DESC <br>                <br>                INTEGRA�AO script_usu_ts_est FINALIZADA AS 16/08/2026 13:47:25<br>                INTEGRA�AO script_usu_ts_prod INICIADA AS 16/08/2026 13:47:25<br>                INTEGRA�AO script_usu_ts_prod FINALIZADA AS 16/08/2026 13:47:25<br>                INTEGRA�AO script_usu_ts_proddep INICIADA AS 16/08/2026 13:47:25<br>                Produto IM084 Não existe na tabela ceqnep_produto <br>Produto IM099 Não existe na tabela ceqnep_produto <br>INTEGRA�AO script_usu_ts_prodep FINALIZADA AS 16/08/2026 13:47:25<br>                INTEGRA�AO script_usu_ts_req INICIADA AS 16/08/2026 13:47:25<br>                INTEGRA�AO script_usu_ts_req FINALIZADA AS 16/08/2026 13:47:25<br>                INTEGRA�AO script_usu_ts_vctlot INICIADA AS 16/08/2026 13:47:25<br>                INTEGRA�AO script_usu_ts_vctlot FINALIZADA AS 16/08/2026 13:47:25<br>                INTEGRA�AO script_transfere_cfl INICIADA AS 16/08/2026 13:47:25<br><br>NUMERO DE LINHAS : 0<br><br>Nova data Atualizada: 2014-01-16 06:50:42<br><br>INTEGRA�AO script_transfere_cfl FINALIZADA AS 16/08/2026 13:47:25<br><br>