UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = $1 AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select o.c_order_id AS referencekey_id, ad_column_identifier ('c_order', o.c_order_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'SM en pedido incorrecto, Pv: ' || o.documentno || ' SM: ' || ri.value || ' PV-SM: ' || o_ri.documentno || ' Producto: ' || prod.value AS description, 'Y' AS isActive, o.ad_org_id, o.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy from m_reservation r join c_orderline ol on ol.c_orderline_id = r.c_orderline_id join c_order o on o.c_order_id = ol.c_order_id join m_reservation_stock rs on rs.m_reservation_id = r.m_reservation_id join m_attributesetinstance att on att.m_attributesetinstance_id = rs.m_attributesetinstance_id join m_refinventory ri on ri.m_refinventory_id = att.m_refinventory_id join c_order o_ri on o_ri.c_order_id = ri.em_prpp_order_id join m_product prod on prod.m_product_id = r.m_product_id where 1 = 1 --and r.m_reservation_id = '001B269942C1479FA446FCEC3614D5C7' and o_ri.c_order_id <> o.c_order_id order by ri.value) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);

Date: 2026-07-17 07:05:32
Duration: 0ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

SELECT * FROM ( select wrphase.ma_wrphase_id AS referencekey_id, ad_column_identifier ('ma_wrphase', wrphase.ma_wrphase_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Fase de OF sin P- en los partes de trabajo' AS description, 'Y' AS isActive, wrphase.ad_org_id, wrphase.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy from m_production p join m_productionplan pp on pp.m_production_id = p.m_production_id join ma_wrphase wrphase on wrphase.ma_wrphase_id = pp.ma_wrphase_id join ma_workrequirement wr on wr.ma_workrequirement_id = wrphase.ma_workrequirement_id join ma_wrphaseproduct wrpprod on wrpprod.ma_wrphase_id = wrphase.ma_wrphase_id join m_product prod on prod.m_product_id = wrpprod.m_product_id where 1 = 1 and wrpprod.movementqty > 0 and prod.isstocked = 'Y' and p.processed = 'Y' and wrphase.ma_process_id <> '08B07C6C6B0A47DE84A14272077A8AFF' and not exists ( select 1 from m_productionline pl where pl.m_productionplan_id = pp.m_productionplan_id)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '01D3DCF08E944DDD8A30964ADC46CF67' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-17 15:02:13
Duration: 11s255ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

SELECT * FROM ( select wrphase.ma_wrphase_id AS referencekey_id, ad_column_identifier ('ma_wrphase', wrphase.ma_wrphase_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Fase de OF sin P- en los partes de trabajo' AS description, 'Y' AS isActive, wrphase.ad_org_id, wrphase.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy from m_production p join m_productionplan pp on pp.m_production_id = p.m_production_id join ma_wrphase wrphase on wrphase.ma_wrphase_id = pp.ma_wrphase_id join ma_workrequirement wr on wr.ma_workrequirement_id = wrphase.ma_workrequirement_id join ma_wrphaseproduct wrpprod on wrpprod.ma_wrphase_id = wrphase.ma_wrphase_id join m_product prod on prod.m_product_id = wrpprod.m_product_id where 1 = 1 and wrpprod.movementqty > 0 and prod.isstocked = 'Y' and p.processed = 'Y' and wrphase.ma_process_id <> '08B07C6C6B0A47DE84A14272077A8AFF' and not exists ( select 1 from m_productionline pl where pl.m_productionplan_id = pp.m_productionplan_id)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '01D3DCF08E944DDD8A30964ADC46CF67' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-17 17:02:08
Duration: 10s940ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

SELECT * FROM ( select wrphase.ma_wrphase_id AS referencekey_id, ad_column_identifier ('ma_wrphase', wrphase.ma_wrphase_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Fase de OF sin P- en los partes de trabajo' AS description, 'Y' AS isActive, wrphase.ad_org_id, wrphase.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy from m_production p join m_productionplan pp on pp.m_production_id = p.m_production_id join ma_wrphase wrphase on wrphase.ma_wrphase_id = pp.ma_wrphase_id join ma_workrequirement wr on wr.ma_workrequirement_id = wrphase.ma_workrequirement_id join ma_wrphaseproduct wrpprod on wrpprod.ma_wrphase_id = wrphase.ma_wrphase_id join m_product prod on prod.m_product_id = wrpprod.m_product_id where 1 = 1 and wrpprod.movementqty > 0 and prod.isstocked = 'Y' and p.processed = 'Y' and wrphase.ma_process_id <> '08B07C6C6B0A47DE84A14272077A8AFF' and not exists ( select 1 from m_productionline pl where pl.m_productionplan_id = pp.m_productionplan_id)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '01D3DCF08E944DDD8A30964ADC46CF67' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-17 07:02:13
Duration: 10s906ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

SELECT * FROM ( select ;

Date: 2026-07-17 07:20:27
Duration: 6s502ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

SELECT * FROM ( select ;

Date: 2026-07-17 07:00:07
Duration: 0ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = $1 AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select prepc_epc_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Matricula ' || epc || ' está duplicada en transacciones. ' as description, 'Y' as isActive, ad_org_id as ad_org_id, ad_client_id as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('prepc_epc', prepc_epc_id, 'es_ES') AS RECORD_ID FROM prepc_epc WHERE prepc_epc_id IN ( SELECT prepc_epc_id FROM ( SELECT count(1), prepc_epc_id, m_inoutline_id, m_inventoryline_id, m_productionline_id, m_movementline_id, m_internal_consumptionline_id FROM prepc_epctransaction pe GROUP BY prepc_epc_id, m_inoutline_id, m_inventoryline_id, m_productionline_id, m_movementline_id, m_internal_consumptionline_id HAVING count(1) > 1) AS sub)) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);

Date: 2026-07-17 07:00:44
Duration: 0ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

SELECT * FROM ( select o.c_order_id AS referencekey_id, ad_column_identifier ('c_order', o.c_order_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'SM en pedido incorrecto, Pv: ' || o.documentno || ' SM: ' || ri.value || ' PV-SM: ' || o_ri.documentno || ' Producto: ' || prod.value AS description, 'Y' AS isActive, o.ad_org_id, o.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy from m_reservation r join c_orderline ol on ol.c_orderline_id = r.c_orderline_id join c_order o on o.c_order_id = ol.c_order_id join m_reservation_stock rs on rs.m_reservation_id = r.m_reservation_id join m_attributesetinstance att on att.m_attributesetinstance_id = rs.m_attributesetinstance_id join m_refinventory ri on ri.m_refinventory_id = att.m_refinventory_id join c_order o_ri on o_ri.c_order_id = ri.em_prpp_order_id join m_product prod on prod.m_product_id = r.m_product_id where 1 = 1 --and r.m_reservation_id = '001B269942C1479FA446FCEC3614D5C7' and o_ri.c_order_id <> o.c_order_id order by ri.value) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = 'FD01694F176A481CBBAFD42553B093DA' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-17 07:05:30
Duration: 5s199ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

SELECT * FROM ( select o.c_order_id AS referencekey_id, ad_column_identifier ('c_order', o.c_order_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'SM en pedido incorrecto, Pv: ' || o.documentno || ' SM: ' || ri.value || ' PV-SM: ' || o_ri.documentno || ' Producto: ' || prod.value AS description, 'Y' AS isActive, o.ad_org_id, o.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy from m_reservation r join c_orderline ol on ol.c_orderline_id = r.c_orderline_id join c_order o on o.c_order_id = ol.c_order_id join m_reservation_stock rs on rs.m_reservation_id = r.m_reservation_id join m_attributesetinstance att on att.m_attributesetinstance_id = rs.m_attributesetinstance_id join m_refinventory ri on ri.m_refinventory_id = att.m_refinventory_id join c_order o_ri on o_ri.c_order_id = ri.em_prpp_order_id join m_product prod on prod.m_product_id = r.m_product_id where 1 = 1 --and r.m_reservation_id = '001B269942C1479FA446FCEC3614D5C7' and o_ri.c_order_id <> o.c_order_id order by ri.value) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = $1 and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-17 07:05:29
Duration: 0ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = '991CC9BB4C49433893DBE5EC05EEC67F' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select i.c_invoice_id AS referencekey_id, ad_column_identifier ('c_invoice', i.c_invoice_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Factura con mas de un vencimiento con la misma fecha, documento: ' || i.documentno AS description, 'Y' AS isActive, i.ad_org_id, i.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy from c_invoice i join fin_payment_schedule ps on ps.c_invoice_id = i.c_invoice_id where i.issotrx = 'Y' group by ps.expecteddate, i.c_invoice_id, i.documentno, i.ad_org_id, i.ad_client_id having count(*) > 1) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);

Date: 2026-07-17 09:01:54
Duration: 15s309ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = '991CC9BB4C49433893DBE5EC05EEC67F' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select i.c_invoice_id AS referencekey_id, ad_column_identifier ('c_invoice', i.c_invoice_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Factura con mas de un vencimiento con la misma fecha, documento: ' || i.documentno AS description, 'Y' AS isActive, i.ad_org_id, i.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy from c_invoice i join fin_payment_schedule ps on ps.c_invoice_id = i.c_invoice_id where i.issotrx = 'Y' group by ps.expecteddate, i.c_invoice_id, i.documentno, i.ad_org_id, i.ad_client_id having count(*) > 1) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);

Date: 2026-07-17 21:41:47
Duration: 14s843ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = '991CC9BB4C49433893DBE5EC05EEC67F' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select i.c_invoice_id AS referencekey_id, ad_column_identifier ('c_invoice', i.c_invoice_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Factura con mas de un vencimiento con la misma fecha, documento: ' || i.documentno AS description, 'Y' AS isActive, i.ad_org_id, i.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy from c_invoice i join fin_payment_schedule ps on ps.c_invoice_id = i.c_invoice_id where i.issotrx = 'Y' group by ps.expecteddate, i.c_invoice_id, i.documentno, i.ad_org_id, i.ad_client_id having count(*) > 1) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);

Date: 2026-07-17 21:21:53
Duration: 14s773ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

epct.prepc_epc_id AS referencekey_id, ad_column_identifier ('prepc_epc', epct.prepc_epc_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Matricula metida por duplicado ' || ad_column_identifier ('prepc_epc', epct.prepc_epc_id, 'es_ES') AS description, 'Y' AS isActive, pl.ad_org_id, pl.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy from m_productionplan pp join m_productionline pl on pl.m_productionplan_id = pp.m_productionplan_id join m_production p on p.m_production_id = pp.m_production_id join prepc_epctransaction epct on epct.m_productionline_id = pl.m_productionline_id where pl.productiontype = '+' group by epct.prepc_epc_id, pl.m_product_id, pl.ad_org_id, pl.ad_client_id having count(*) > 1) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = $1 and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

Date: 2026-07-17 07:20:15
Duration: 0ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide