SELECT * FROM ( select C_INVOICE_id as referencekey_id, ;

Date: 2026-07-14 12:15:18
Duration: 0ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

SELECT MA_PRODUCTION_COST ('FC263D3DDFED4496AB92F342F33865F5', '100') AS RESULT FROM DUAL;

Date: 2026-07-14 08:04:07
Duration: 4s132ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

SELECT MA_PRODUCTION_COST ($1, $2) AS RESULT FROM DUAL;

Date: 2026-07-14 08:04:06
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 = '7EDC62AE0AF34B74A4B327EA8A957965' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'PURCHASE INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_INVOICE', C_INVOICE_id, 'es_ES') AS RECORD_ID FROM C_INVOICE, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('API', 'APC') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);

Date: 2026-07-14 15:25:57
Duration: 7s527ms
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 = '7EDC62AE0AF34B74A4B327EA8A957965' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'PURCHASE INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_INVOICE', C_INVOICE_id, 'es_ES') AS RECORD_ID FROM C_INVOICE, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('API', 'APC') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);

Date: 2026-07-14 12:15:51
Duration: 7s258ms
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 = '7EDC62AE0AF34B74A4B327EA8A957965' AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select C_INVOICE_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'PURCHASE INVOICE POSTED MORE THAN ONCE' as description, 'Y' as isActive, C_INVOICE.ad_org_id as ad_org_id, C_INVOICE.ad_client_id as ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('C_INVOICE', C_INVOICE_id, 'es_ES') AS RECORD_ID FROM C_INVOICE, c_doctype, fact_acct f1, fact_acct f2 WHERE C_INVOICE.c_doctype_id = c_doctype.c_doctype_id and c_doctype.docbasetype IN ('API', 'APC') and f1.record_id = c_invoice.c_invoice_id and f1.record_id = f2.record_id and f1.ad_table_id = f2.ad_table_id and f1.fact_acct_group_id <> f2.fact_acct_group_id and f1.c_acctschema_id = f2.c_acctschema_id GROUP BY C_INVOICE_id, posted, C_INVOICE.ad_client_id, C_INVOICE.ad_org_id, f1.ad_table_id, f1.record_id) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);

Date: 2026-07-14 20:20:37
Duration: 6s199ms
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 distinct ad_column_identifier ('c_invoice', fin_payment_schedule.c_invoice_id, 'en_US') as record_id, fin_payment_schedule.c_invoice_id as referencekey_id, 0 as ad_role_id, null as ad_user_id, 'This invoice needs to be reactivated and processed again due to wrong payment info.' as description, 'Y' as isActive, fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, now() as created, 0 as createdBy, now() as updated, 0 as updatedBy from fin_payment_schedule, fin_payment_scheduledetail where fin_payment_schedule.fin_payment_schedule_id = fin_payment_scheduledetail.fin_payment_schedule_invoice and fin_payment_scheduledetail.iscanceled = 'N' group by fin_payment_schedule.ad_org_id, fin_payment_schedule.ad_client_id, fin_payment_schedule.fin_payment_schedule_id, fin_payment_schedule.c_invoice_id, fin_payment_schedule.amount having fin_payment_schedule.amount <> sum(fin_payment_scheduledetail.amount + coalesce(fin_payment_scheduledetail.writeoffamt, 0)) order by 1) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);

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

x Hide

select max(financialm0_.Fact_Acct_ID) as col_0_0_, financialm0_.AD_Client_ID as col_1_0_, financialm4_.AD_Org_ID as col_2_0_, max(financialm0_.Created) as col_3_0_, max(financialm0_.CreatedBy) as col_4_0_, max(financialm0_.Updated) as col_5_0_, max(financialm0_.UpdatedBy) as col_6_0_, max(financialm0_.IsActive) as col_7_0_, max(financialm0_.Fact_Acct_ID) as col_8_0_, max(financialm0_.Description) as col_9_0_, financialm4_.C_PeriodControl_ID as col_10_0_, ( select financialm5_.Name from C_AcctSchema financialm5_ where financialm0_.C_AcctSchema_ID = financialm5_.C_AcctSchema_ID) as col_11_0_, ( select financialm6_.Value from C_ElementValue financialm6_ where financialm0_.Account_ID = financialm6_.C_ElementValue_ID) as col_12_0_, financialm0_.FactAcctType as col_13_0_, case when sum(financialm0_.AmtAcctDr - financialm0_.AmtAcctCr) > 0 then sum(financialm0_.AmtAcctDr - financialm0_.AmtAcctCr) else 0 end as col_14_0_, case when sum(financialm0_.AmtAcctCr - financialm0_.AmtAcctDr) > 0 then sum(financialm0_.AmtAcctCr - financialm0_.AmtAcctDr) else 0 end as col_15_0_ from Fact_Acct financialm0_ inner join C_Period financialm1_ on financialm0_.C_Period_ID = financialm1_.C_Period_ID inner join AD_Org organizati2_ on financialm0_.AD_Org_ID = organizati2_.AD_Org_ID cross join C_Period financialm3_ inner join C_PeriodControl financialm4_ on financialm3_.C_Period_ID = financialm4_.C_Period_ID where (financialm0_.FactAcctType in ('O', 'C', 'D', 'R')) and financialm1_.C_Year_ID = financialm3_.C_Year_ID and financialm4_.AD_Org_ID = organizati2_.AD_Periodcontrolallowed_Org_ID and (financialm0_.AD_Client_ID in ('0', '29E43D204AEB4CEC9D1DC4EFFD0E5987')) and (financialm0_.AD_Org_ID in ('0', '975163BBDF184727BFA9D21FECF88F51', '0145CB12BBE04855B3C433728BD65F7C', '7EEF753D8C114D32A101EA8393FEAC19', '8997B74B935D46B08D5E187F5B343F48', '9DFF9C5278274C2DA3F411C2BA23605C')) and financialm4_.C_PeriodControl_ID = 'FF716708B88B4743A1817C985765A0F0' group by financialm0_.AD_Client_ID, financialm4_.C_PeriodControl_ID, financialm0_.C_AcctSchema_ID, financialm0_.Account_ID, financialm0_.FactAcctType, financialm1_.C_Year_ID, financialm4_.AD_Org_ID having sum(financialm0_.AmtAcctCr - financialm0_.AmtAcctDr) <> 0 order by col_12_0_ desc limit '101';

Date: 2026-07-14 09:42:32
Duration: 4s978ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select max(financialm0_.Fact_Acct_ID) as col_0_0_, financialm0_.AD_Client_ID as col_1_0_, financialm4_.AD_Org_ID as col_2_0_, max(financialm0_.Created) as col_3_0_, max(financialm0_.CreatedBy) as col_4_0_, max(financialm0_.Updated) as col_5_0_, max(financialm0_.UpdatedBy) as col_6_0_, max(financialm0_.IsActive) as col_7_0_, max(financialm0_.Fact_Acct_ID) as col_8_0_, max(financialm0_.Description) as col_9_0_, financialm4_.C_PeriodControl_ID as col_10_0_, ( select financialm5_.Name from C_AcctSchema financialm5_ where financialm0_.C_AcctSchema_ID = financialm5_.C_AcctSchema_ID) as col_11_0_, ( select financialm6_.Value from C_ElementValue financialm6_ where financialm0_.Account_ID = financialm6_.C_ElementValue_ID) as col_12_0_, financialm0_.FactAcctType as col_13_0_, case when sum(financialm0_.AmtAcctDr - financialm0_.AmtAcctCr) > 0 then sum(financialm0_.AmtAcctDr - financialm0_.AmtAcctCr) else 0 end as col_14_0_, case when sum(financialm0_.AmtAcctCr - financialm0_.AmtAcctDr) > 0 then sum(financialm0_.AmtAcctCr - financialm0_.AmtAcctDr) else 0 end as col_15_0_ from Fact_Acct financialm0_ inner join C_Period financialm1_ on financialm0_.C_Period_ID = financialm1_.C_Period_ID inner join AD_Org organizati2_ on financialm0_.AD_Org_ID = organizati2_.AD_Org_ID cross join C_Period financialm3_ inner join C_PeriodControl financialm4_ on financialm3_.C_Period_ID = financialm4_.C_Period_ID where (financialm0_.FactAcctType in ('O', 'C', 'D', 'R')) and financialm1_.C_Year_ID = financialm3_.C_Year_ID and financialm4_.AD_Org_ID = organizati2_.AD_Periodcontrolallowed_Org_ID and (financialm0_.AD_Client_ID in ('0', '29E43D204AEB4CEC9D1DC4EFFD0E5987')) and (financialm0_.AD_Org_ID in ('0', '975163BBDF184727BFA9D21FECF88F51', '0145CB12BBE04855B3C433728BD65F7C', '7EEF753D8C114D32A101EA8393FEAC19', '8997B74B935D46B08D5E187F5B343F48', '9DFF9C5278274C2DA3F411C2BA23605C')) and financialm4_.C_PeriodControl_ID = 'FF716708B88B4743A1817C985765A0F0' group by financialm0_.AD_Client_ID, financialm4_.C_PeriodControl_ID, financialm0_.C_AcctSchema_ID, financialm0_.Account_ID, financialm0_.FactAcctType, financialm1_.C_Year_ID, financialm4_.AD_Org_ID having sum(financialm0_.AmtAcctCr - financialm0_.AmtAcctDr) <> 0 order by col_12_0_ desc limit '101';

Date: 2026-07-14 09:43:24
Duration: 2s357ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

SELECT * FROM ( SELECT 0 AS RN1, B.* FROM ( SELECT SCHEMA_ID, SCHEMA_NAME, IDENTIFIER, DATEACCT, AA.VALUE, COALESCE(TRL_NAME, AA.NAME) AS NAME, ID, AD_TABLE_ID, DOCBASETYPE, AR.NAME as DOCNAME, SEQNO, '' AS TOTAL, DESCRIPTION, (CASE FACTACCTTYPE WHEN 'O' THEN 1 WHEN 'N' THEN 2 WHEN 'R' THEN 3 WHEN 'D' THEN 4 ELSE 5 END) AS FACTACCTTYPE2, (CASE AMTACCTDR WHEN 0 THEN NULL ELSE AMTACCTDR END) AS AMTACCTDR, (CASE AMTACCTCR WHEN 0 THEN NULL ELSE AMTACCTCR END) AS AMTACCTCR, '' AS GROUPEDLINES, '' AS TAXID, AD_GETTAB_FROM_TABLE(AA.AD_TABLE_ID, AA.DOCBASETYPE, AA.AD_CLIENT_ID) AS TAB_ID, '' as newStyle, AA.journalbatch_id AS journalbatch_id FROM ( SELECT ev_trl.NAME AS TRL_NAME, F.C_ACCTSCHEMA_ID AS SCHEMA_ID, SC.NAME AS SCHEMA_NAME, F.FACT_ACCT_GROUP_ID AS IDENTIFIER, F.DATEACCT, F.ACCTVALUE AS VALUE, F.ACCTDESCRIPTION AS NAME, CASE WHEN 'N' = 'Y' THEN TO_CHAR(F.DESCRIPTION) ELSE TO_CHAR('') END AS DESCRIPTION, F.RECORD_ID AS ID, F.AD_TABLE_ID, F.DOCBASETYPE, sum(F.AMTACCTDR) AS AMTACCTDR, sum(F.AMTACCTCR) AS AMTACCTCR, MIN(SEQNO) AS SEQNO, F.FACTACCTTYPE AS FACTACCTTYPE, F.AD_CLIENT_ID, MAX(glj.gl_journalbatch_id) as journalbatch_id FROM FACT_ACCT F JOIN C_ACCTSCHEMA SC ON (F.C_ACCTSCHEMA_ID = SC.C_ACCTSCHEMA_ID) LEFT JOIN GL_JOURNAL GLJ ON (GLJ.GL_JOURNAL_ID = F.RECORD_ID AND F.AD_TABLE_ID = '224') LEFT JOIN c_elementvalue ev ON (F.ACCTDESCRIPTION = ev.name and F.ACCTvalue = ev.value and F.AD_CLIENT_ID=ev.AD_CLIENT_ID and F.C_ACCTSCHEMA_ID = ev.c_element_id) LEFT JOIN c_elementvalue_trl ev_trl ON ev.c_elementvalue_id = ev_trl.c_elementvalue_id AND ev_trl.ad_language = 'es_ES' WHERE F.AD_CLIENT_ID IN ('0','29E43D204AEB4CEC9D1DC4EFFD0E5987') AND F.AD_ORG_ID IN('0','975163BBDF184727BFA9D21FECF88F51','0145CB12BBE04855B3C433728BD65F7C','7EEF753D8C114D32A101EA8393FEAC19','8997B74B935D46B08D5E187F5B343F48','9DFF9C5278274C2DA3F411C2BA23605C') AND 1=1 AND f.dateacct >= TO_DATE('01-01-2025') AND f.dateacct < TO_DATE('01-01-2026') AND f.C_ACCTSCHEMA_ID = '07852E85025D4759A77318FB991C7B8F' AND f.AD_ORG_ID IN('9DFF9C5278274C2DA3F411C2BA23605C','975163BBDF184727BFA9D21FECF88F51','8997B74B935D46B08D5E187F5B343F48','7EEF753D8C114D32A101EA8393FEAC19','0145CB12BBE04855B3C433728BD65F7C','0') AND F.FactAcctType IN ('C', 'R', 'O', 'N', 'D') AND f.C_ACCTSCHEMA_ID = SC.C_ACCTSCHEMA_ID AND ('Y'='Y' OR F.FACT_ACCT_GROUP_ID IN ( SELECT FACT_ACCT_GROUP_ID FROM FACT_ACCT WHERE ACCOUNT_ID IN ( SELECT c_elementvalue_id as name FROM C_ELEMENTVALUE WHERE value >= ( select value from c_elementvalue where c_elementvalue_id = NULL) and value <= ( select value from c_elementvalue where c_elementvalue_id = NULL) and c_elementvalue.ELEMENTLEVEL = 'S') AND AD_CLIENT_ID IN ('0','29E43D204AEB4CEC9D1DC4EFFD0E5987') AND AD_ORG_ID IN ('0','975163BBDF184727BFA9D21FECF88F51','0145CB12BBE04855B3C433728BD65F7C','7EEF753D8C114D32A101EA8393FEAC19','8997B74B935D46B08D5E187F5B343F48','9DFF9C5278274C2DA3F411C2BA23605C') AND 3=3 AND dateacct >= TO_DATE('01-01-2025') AND dateacct < TO_DATE('01-01-2026') AND C_ACCTSCHEMA_ID = '07852E85025D4759A77318FB991C7B8F' AND AD_ORG_ID IN('9DFF9C5278274C2DA3F411C2BA23605C','975163BBDF184727BFA9D21FECF88F51','8997B74B935D46B08D5E187F5B343F48','7EEF753D8C114D32A101EA8393FEAC19','0145CB12BBE04855B3C433728BD65F7C','0') AND FactAcctType IN ('C', 'R', 'O', 'N', 'D') )) GROUP BY ev_trl.NAME, f.C_ACCTSCHEMA_ID, SC.NAME, F.AD_TABLE_ID, F.DATEACCT, F.ACCTDESCRIPTION, CASE WHEN 'N' = 'Y' THEN TO_CHAR(F.DESCRIPTION) ELSE TO_CHAR('') END, F.ACCTVALUE, F.DOCBASETYPE, F.RECORD_ID, F.FACT_ACCT_GROUP_ID, F.ACCOUNT_ID, F.FACTACCTTYPE, ( CASE F.AMTACCTDR WHEN 0 THEN ( CASE SIGN(F.AMTACCTCR) WHEN -1 THEN 1 ELSE 2 END) ELSE ( CASE SIGN(F.AMTACCTDR) WHEN -1 THEN 3 ELSE 4 END) END), F.AD_CLIENT_ID HAVING (sum(F.AMTACCTDR) <> 0 OR sum(F.AMTACCTCR) <> 0)) AA LEFT JOIN ( select * from AD_REF_LIST_V WHERE AD_REFERENCE_ID = '183' AND AD_LANGUAGE = 'es_ES') AR ON AR.VALUE = AA.DOCBASETYPE ORDER BY SCHEMA_NAME, DATEACCT, FACTACCTTYPE2, IDENTIFIER, AA.AMTACCTDR DESC, AA.AMTACCTCR DESC, SEQNO) B) C WHERE 1 = 1;

Date: 2026-07-14 10:42:41
Duration: 1s220ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

SELECT * FROM ( SELECT 0 AS RN1, B.* FROM ( SELECT SCHEMA_ID, SCHEMA_NAME, IDENTIFIER, DATEACCT, AA.VALUE, COALESCE(TRL_NAME, AA.NAME) AS NAME, ID, AD_TABLE_ID, DOCBASETYPE, AR.NAME as DOCNAME, SEQNO, '' AS TOTAL, DESCRIPTION, (CASE FACTACCTTYPE WHEN 'O' THEN 1 WHEN 'N' THEN 2 WHEN 'R' THEN 3 WHEN 'D' THEN 4 ELSE 5 END) AS FACTACCTTYPE2, (CASE AMTACCTDR WHEN 0 THEN NULL ELSE AMTACCTDR END) AS AMTACCTDR, (CASE AMTACCTCR WHEN 0 THEN NULL ELSE AMTACCTCR END) AS AMTACCTCR, '' AS GROUPEDLINES, '' AS TAXID, AD_GETTAB_FROM_TABLE(AA.AD_TABLE_ID, AA.DOCBASETYPE, AA.AD_CLIENT_ID) AS TAB_ID, '' as newStyle, AA.journalbatch_id AS journalbatch_id FROM ( SELECT ev_trl.NAME AS TRL_NAME, F.C_ACCTSCHEMA_ID AS SCHEMA_ID, SC.NAME AS SCHEMA_NAME, F.FACT_ACCT_GROUP_ID AS IDENTIFIER, F.DATEACCT, F.ACCTVALUE AS VALUE, F.ACCTDESCRIPTION AS NAME, CASE WHEN 'N' = 'Y' THEN TO_CHAR(F.DESCRIPTION) ELSE TO_CHAR('') END AS DESCRIPTION, F.RECORD_ID AS ID, F.AD_TABLE_ID, F.DOCBASETYPE, sum(F.AMTACCTDR) AS AMTACCTDR, sum(F.AMTACCTCR) AS AMTACCTCR, MIN(SEQNO) AS SEQNO, F.FACTACCTTYPE AS FACTACCTTYPE, F.AD_CLIENT_ID, MAX(glj.gl_journalbatch_id) as journalbatch_id FROM FACT_ACCT F JOIN C_ACCTSCHEMA SC ON (F.C_ACCTSCHEMA_ID = SC.C_ACCTSCHEMA_ID) LEFT JOIN GL_JOURNAL GLJ ON (GLJ.GL_JOURNAL_ID = F.RECORD_ID AND F.AD_TABLE_ID = '224') LEFT JOIN c_elementvalue ev ON (F.ACCTDESCRIPTION = ev.name and F.ACCTvalue = ev.value and F.AD_CLIENT_ID=ev.AD_CLIENT_ID and F.C_ACCTSCHEMA_ID = ev.c_element_id) LEFT JOIN c_elementvalue_trl ev_trl ON ev.c_elementvalue_id = ev_trl.c_elementvalue_id AND ev_trl.ad_language = 'es_ES' WHERE F.AD_CLIENT_ID IN ('0','29E43D204AEB4CEC9D1DC4EFFD0E5987') AND F.AD_ORG_ID IN('0','975163BBDF184727BFA9D21FECF88F51','0145CB12BBE04855B3C433728BD65F7C','7EEF753D8C114D32A101EA8393FEAC19','8997B74B935D46B08D5E187F5B343F48','9DFF9C5278274C2DA3F411C2BA23605C') AND 1=1 AND f.dateacct >= TO_DATE('01-01-2025') AND f.dateacct < TO_DATE('01-01-2026') AND f.C_ACCTSCHEMA_ID = '07852E85025D4759A77318FB991C7B8F' AND f.AD_ORG_ID IN('9DFF9C5278274C2DA3F411C2BA23605C','975163BBDF184727BFA9D21FECF88F51','8997B74B935D46B08D5E187F5B343F48','7EEF753D8C114D32A101EA8393FEAC19','0145CB12BBE04855B3C433728BD65F7C','0') AND F.FactAcctType IN ('C', 'R', 'O', 'N', 'D') AND f.C_ACCTSCHEMA_ID = SC.C_ACCTSCHEMA_ID AND ('Y'='Y' OR F.FACT_ACCT_GROUP_ID IN ( SELECT FACT_ACCT_GROUP_ID FROM FACT_ACCT WHERE ACCOUNT_ID IN ( SELECT c_elementvalue_id as name FROM C_ELEMENTVALUE WHERE value >= ( select value from c_elementvalue where c_elementvalue_id = NULL) and value <= ( select value from c_elementvalue where c_elementvalue_id = NULL) and c_elementvalue.ELEMENTLEVEL = 'S') AND AD_CLIENT_ID IN ('0','29E43D204AEB4CEC9D1DC4EFFD0E5987') AND AD_ORG_ID IN ('0','975163BBDF184727BFA9D21FECF88F51','0145CB12BBE04855B3C433728BD65F7C','7EEF753D8C114D32A101EA8393FEAC19','8997B74B935D46B08D5E187F5B343F48','9DFF9C5278274C2DA3F411C2BA23605C') AND 3=3 AND dateacct >= TO_DATE('01-01-2025') AND dateacct < TO_DATE('01-01-2026') AND C_ACCTSCHEMA_ID = '07852E85025D4759A77318FB991C7B8F' AND AD_ORG_ID IN('9DFF9C5278274C2DA3F411C2BA23605C','975163BBDF184727BFA9D21FECF88F51','8997B74B935D46B08D5E187F5B343F48','7EEF753D8C114D32A101EA8393FEAC19','0145CB12BBE04855B3C433728BD65F7C','0') AND FactAcctType IN ('C', 'R', 'O', 'N', 'D') )) GROUP BY ev_trl.NAME, f.C_ACCTSCHEMA_ID, SC.NAME, F.AD_TABLE_ID, F.DATEACCT, F.ACCTDESCRIPTION, CASE WHEN 'N' = 'Y' THEN TO_CHAR(F.DESCRIPTION) ELSE TO_CHAR('') END, F.ACCTVALUE, F.DOCBASETYPE, F.RECORD_ID, F.FACT_ACCT_GROUP_ID, F.ACCOUNT_ID, F.FACTACCTTYPE, ( CASE F.AMTACCTDR WHEN 0 THEN ( CASE SIGN(F.AMTACCTCR) WHEN -1 THEN 1 ELSE 2 END) ELSE ( CASE SIGN(F.AMTACCTDR) WHEN -1 THEN 3 ELSE 4 END) END), F.AD_CLIENT_ID HAVING (sum(F.AMTACCTDR) <> 0 OR sum(F.AMTACCTCR) <> 0)) AA LEFT JOIN ( select * from AD_REF_LIST_V WHERE AD_REFERENCE_ID = '183' AND AD_LANGUAGE = 'es_ES') AR ON AR.VALUE = AA.DOCBASETYPE ORDER BY SCHEMA_NAME, DATEACCT, FACTACCTTYPE2, IDENTIFIER, AA.AMTACCTDR DESC, AA.AMTACCTCR DESC, SEQNO) B) C WHERE 1 = 1;

Date: 2026-07-14 10:42:50
Duration: 1s55ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

SELECT * FROM ( SELECT 0 AS RN1, G.* FROM ( SELECT COUNT(*) AS GROUPEDLINES, IDENTIFIER, SCHEMA_NAME, DATEACCT FROM ( SELECT SCHEMA_ID, SCHEMA_NAME, IDENTIFIER, DATEACCT, VALUE, NAME, ID, AD_TABLE_ID, DOCBASETYPE, SEQNO, '' AS TOTAL, '' AS DESCRIPTION, ( CASE AMTACCTDR WHEN 0 THEN NULL ELSE AMTACCTDR END) AS AMTACCTDR, ( CASE AMTACCTCR WHEN 0 THEN NULL ELSE AMTACCTCR END) AS AMTACCTCR FROM ( SELECT F.C_ACCTSCHEMA_ID AS SCHEMA_ID, SC.NAME AS SCHEMA_NAME, F.FACT_ACCT_GROUP_ID AS IDENTIFIER, F.DATEACCT, F.ACCTVALUE AS VALUE, F.ACCTDESCRIPTION AS NAME, F.RECORD_ID AS ID, F.AD_TABLE_ID, F.DOCBASETYPE, sum(F.AMTACCTDR) AS AMTACCTDR, sum(F.AMTACCTCR) AS AMTACCTCR, MIN(SEQNO) AS SEQNO FROM FACT_ACCT F, C_ACCTSCHEMA SC WHERE F.AD_CLIENT_ID IN ('0', '29E43D204AEB4CEC9D1DC4EFFD0E5987') AND F.AD_ORG_ID IN ('0', '975163BBDF184727BFA9D21FECF88F51', '0145CB12BBE04855B3C433728BD65F7C', '7EEF753D8C114D32A101EA8393FEAC19', '8997B74B935D46B08D5E187F5B343F48', '9DFF9C5278274C2DA3F411C2BA23605C') AND 1 = 1 AND f.dateacct >= TO_DATE('01-01-2025') AND f.dateacct < TO_DATE('01-01-2026') AND f.C_ACCTSCHEMA_ID = '07852E85025D4759A77318FB991C7B8F' AND f.AD_ORG_ID IN ('9DFF9C5278274C2DA3F411C2BA23605C', '975163BBDF184727BFA9D21FECF88F51', '8997B74B935D46B08D5E187F5B343F48', '7EEF753D8C114D32A101EA8393FEAC19', '0145CB12BBE04855B3C433728BD65F7C', '0') AND F.FactAcctType IN ('C', 'R', 'O', 'N', 'D') AND f.C_ACCTSCHEMA_ID = SC.C_ACCTSCHEMA_ID AND ('Y' = 'Y' OR F.FACT_ACCT_GROUP_ID IN ( SELECT FACT_ACCT_GROUP_ID FROM FACT_ACCT WHERE ACCOUNT_ID IN ( SELECT c_elementvalue_id as name FROM C_ELEMENTVALUE WHERE value >= ( select value from c_elementvalue where c_elementvalue_id = NULL) and value <= ( select value from c_elementvalue where c_elementvalue_id = NULL) and c_elementvalue.ELEMENTLEVEL = 'S') AND AD_CLIENT_ID IN ('0', '29E43D204AEB4CEC9D1DC4EFFD0E5987') AND AD_ORG_ID IN ('0', '975163BBDF184727BFA9D21FECF88F51', '0145CB12BBE04855B3C433728BD65F7C', '7EEF753D8C114D32A101EA8393FEAC19', '8997B74B935D46B08D5E187F5B343F48', '9DFF9C5278274C2DA3F411C2BA23605C') AND 3 = 3 AND dateacct >= TO_DATE('01-01-2025') AND dateacct < TO_DATE('01-01-2026') AND C_ACCTSCHEMA_ID = '07852E85025D4759A77318FB991C7B8F' AND AD_ORG_ID IN ('9DFF9C5278274C2DA3F411C2BA23605C', '975163BBDF184727BFA9D21FECF88F51', '8997B74B935D46B08D5E187F5B343F48', '7EEF753D8C114D32A101EA8393FEAC19', '0145CB12BBE04855B3C433728BD65F7C', '0') AND FactAcctType IN ('C', 'R', 'O', 'N', 'D'))) GROUP BY f.C_ACCTSCHEMA_ID, SC.NAME, F.AD_TABLE_ID, F.DATEACCT, F.ACCTDESCRIPTION, F.ACCTVALUE, F.DOCBASETYPE, F.RECORD_ID, F.FACT_ACCT_GROUP_ID, F.ACCOUNT_ID, ( CASE F.AMTACCTDR WHEN 0 THEN ( CASE SIGN(F.AMTACCTCR) WHEN -1 THEN 1 ELSE 2 END) ELSE ( CASE SIGN(F.AMTACCTDR) WHEN -1 THEN 3 ELSE 4 END) END)) AA ORDER BY SCHEMA_NAME, DATEACCT, IDENTIFIER, SEQNO) BB GROUP BY IDENTIFIER, SCHEMA_NAME, DATEACCT ORDER BY SCHEMA_NAME, DATEACCT, IDENTIFIER) G) H WHERE 1 = 1;

Date: 2026-07-14 10:42:38
Duration: 1s812ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide