select bass_prod_0_.Bass_Prod_Outsourcing_V_ID as bass_pro1_335_0_, bass_prod_0_.AD_Org_ID as ad_org_i2_335_0_, bass_prod_0_.AD_Client_ID as ad_clien3_335_0_, bass_prod_0_.Isactive as isactive4_335_0_, bass_prod_0_.Created as created5_335_0_, bass_prod_0_.Createdby as createdb6_335_0_, bass_prod_0_.Updated as updated7_335_0_, bass_prod_0_.Updatedby as updatedb8_335_0_, bass_prod_0_.M_Product_ID as m_produc9_335_0_, bass_prod_0_.Advpro2_Outsourcing_ID as advpro10_335_0_, bass_prod_0_.Status as status11_335_0_, bass_prod_0_.Productiontype as product12_335_0_, bass_prod_0_.Qty as qty13_335_0_, bass_prod_0_.EM_Bass_Dateplanned as em_bass14_335_0_, bass_prod_0_.EM_Bass_Qty_Received as em_bass15_335_0_, bass_prod_0_.EM_Bass_Situacion as em_bass16_335_0_, bass_prod_0_.Advpro2_Outsourcing_Phase_ID as advpro17_335_0_ from bass_prod_outsourcing_v bass_prod_0_ where bass_prod_0_.Bass_Prod_Outsourcing_V_ID = '652D0BF307C74B798007A9844F9F209013764BFB64DD41D687323B7EDE2E6C41';

Date: 2026-07-16 16:15:51
Duration: 1s236ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select bass_prod_0_.Bass_Prod_Outsourcing_V_ID as bass_pro1_335_0_, bass_prod_0_.AD_Org_ID as ad_org_i2_335_0_, bass_prod_0_.AD_Client_ID as ad_clien3_335_0_, bass_prod_0_.Isactive as isactive4_335_0_, bass_prod_0_.Created as created5_335_0_, bass_prod_0_.Createdby as createdb6_335_0_, bass_prod_0_.Updated as updated7_335_0_, bass_prod_0_.Updatedby as updatedb8_335_0_, bass_prod_0_.M_Product_ID as m_produc9_335_0_, bass_prod_0_.Advpro2_Outsourcing_ID as advpro10_335_0_, bass_prod_0_.Status as status11_335_0_, bass_prod_0_.Productiontype as product12_335_0_, bass_prod_0_.Qty as qty13_335_0_, bass_prod_0_.EM_Bass_Dateplanned as em_bass14_335_0_, bass_prod_0_.EM_Bass_Qty_Received as em_bass15_335_0_, bass_prod_0_.EM_Bass_Situacion as em_bass16_335_0_, bass_prod_0_.Advpro2_Outsourcing_Phase_ID as advpro17_335_0_ from bass_prod_outsourcing_v bass_prod_0_ where bass_prod_0_.Bass_Prod_Outsourcing_V_ID = '16490CA9886B4F0DAECF84086D65AD25FB9A01FBCA154DAEB0CE879114270E3C';

Date: 2026-07-16 13:21:05
Duration: 1s135ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select bass_prod_0_.Bass_Prod_Outsourcing_V_ID as bass_pro1_335_0_, bass_prod_0_.AD_Org_ID as ad_org_i2_335_0_, bass_prod_0_.AD_Client_ID as ad_clien3_335_0_, bass_prod_0_.Isactive as isactive4_335_0_, bass_prod_0_.Created as created5_335_0_, bass_prod_0_.Createdby as createdb6_335_0_, bass_prod_0_.Updated as updated7_335_0_, bass_prod_0_.Updatedby as updatedb8_335_0_, bass_prod_0_.M_Product_ID as m_produc9_335_0_, bass_prod_0_.Advpro2_Outsourcing_ID as advpro10_335_0_, bass_prod_0_.Status as status11_335_0_, bass_prod_0_.Productiontype as product12_335_0_, bass_prod_0_.Qty as qty13_335_0_, bass_prod_0_.EM_Bass_Dateplanned as em_bass14_335_0_, bass_prod_0_.EM_Bass_Qty_Received as em_bass15_335_0_, bass_prod_0_.EM_Bass_Situacion as em_bass16_335_0_, bass_prod_0_.Advpro2_Outsourcing_Phase_ID as advpro17_335_0_ from bass_prod_outsourcing_v bass_prod_0_ where bass_prod_0_.Bass_Prod_Outsourcing_V_ID = '52E8CB415A0F480A926EE60439331576948990EC200649CEB407AF4FA927435F';

Date: 2026-07-16 13:36:00
Duration: 1s122ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

select array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') as col_0_0_, array_to_string(array_agg(order3_.DocumentNo), ',') as col_1_0_, case when invoice7_.IsSOTrx = 'N' and (organizati11_.AD_Org_ID is not null) and (organizati11_.EM_Aprm_Payment_Desc like 'Supplier Reference') then invoice7_.POReference else invoice7_.DocumentNo end as col_2_0_, coalesce(fin_paymen6_.Fin_Paymentmethod_ID, fin_paymen2_.Fin_Paymentmethod_ID) as col_3_0_, coalesce(fin_paymen9_.Name, fin_paymen5_.Name) as col_4_0_, coalesce(fin_paymen6_.ExpectedDate, fin_paymen2_.ExpectedDate) as col_5_0_, max(coalesce(fin_paymen6_.Amount, fin_paymen2_.Amount)) as col_6_0_, max(coalesce(invoice7_.GrandTotal, 0)) as col_7_0_, aduser14_.UserName as col_8_0_, aduser16_.UserName as col_9_0_, invoice7_.Created as col_10_0_, invoice7_.Updated as col_11_0_, businesspa1_.C_BPartner_ID as col_12_0_, businesspa1_.Name as col_13_0_, sum(fin_paymen0_.Amount + fin_paymen0_.Writeoffamt) as col_14_0_, coalesce(sum(fin_paymen12_.Amount), 0) as col_15_0_, case when sum(fin_paymen0_.Writeoffamt) <> 0 then true else false end as col_16_0_, case when max(fin_paymen13_.Fin_Payment_ID) is not null then true else false end as col_17_0_, coalesce(businesspa18_.AccountNo, businesspa19_.AccountNo) as col_18_0_ from FIN_Payment_ScheduleDetail fin_paymen0_ inner join C_BPartner businesspa1_ on fin_paymen0_.C_Bpartner_ID = businesspa1_.C_BPartner_ID left outer join FIN_Payment_Schedule fin_paymen2_ on fin_paymen0_.FIN_Payment_Schedule_Order = fin_paymen2_.Fin_Payment_Schedule_ID left outer join C_Order order3_ on fin_paymen2_.C_Order_ID = order3_.C_Order_ID and (order3_.IsSOTrx = 'Y' and order3_.C_Currency_ID = '102') left outer join FIN_Payment_Priority fin_paymen4_ on fin_paymen2_.FIN_Payment_Priority_ID = fin_paymen4_.FIN_Payment_Priority_ID left outer join FIN_PaymentMethod fin_paymen5_ on fin_paymen2_.Fin_Paymentmethod_ID = fin_paymen5_.Fin_Paymentmethod_ID left outer join FIN_Payment_Schedule fin_paymen6_ on fin_paymen0_.FIN_Payment_Schedule_Invoice = fin_paymen6_.Fin_Payment_Schedule_ID left outer join C_Invoice invoice7_ on fin_paymen6_.C_Invoice_ID = invoice7_.C_Invoice_ID and (invoice7_.IsSOTrx = 'Y' and invoice7_.C_Currency_ID = '102') left outer join FIN_Payment_Priority fin_paymen8_ on fin_paymen6_.FIN_Payment_Priority_ID = fin_paymen8_.FIN_Payment_Priority_ID left outer join FIN_PaymentMethod fin_paymen9_ on fin_paymen6_.Fin_Paymentmethod_ID = fin_paymen9_.Fin_Paymentmethod_ID left outer join AD_Org organizati10_ on fin_paymen0_.AD_Org_ID = organizati10_.AD_Org_ID left outer join AD_OrgInfo organizati11_ on organizati10_.AD_Org_ID = organizati11_.AD_Org_ID left outer join FIN_Payment_Detail fin_paymen12_ on fin_paymen0_.FIN_Payment_Detail_ID = fin_paymen12_.Fin_Payment_Detail_ID left outer join FIN_Payment fin_paymen13_ on fin_paymen12_.Fin_Payment_ID = fin_paymen13_.Fin_Payment_ID left outer join AD_User aduser14_ on invoice7_.CreatedBy = aduser14_.AD_User_ID left outer join AD_User aduser15_ on order3_.CreatedBy = aduser15_.AD_User_ID left outer join AD_User aduser16_ on invoice7_.UpdatedBy = aduser16_.AD_User_ID left outer join AD_User aduser17_ on order3_.UpdatedBy = aduser17_.AD_User_ID left outer join C_BP_BankAccount businesspa18_ on invoice7_.EM_Etabam_Bankaccount_ID = businesspa18_.C_BP_BankAccount_ID left outer join C_BP_BankAccount businesspa19_ on order3_.EM_Etabam_Bankaccount_ID = businesspa19_.C_BP_BankAccount_ID where (fin_paymen0_.AD_Client_ID in ('0', '7E3CD157DC6246718BFBF101DCDC4016')) and (fin_paymen0_.FIN_Payment_Detail_ID is null or fin_paymen13_.Fin_Payment_ID = 'D987BAFAB4814DF59297220BD708979D') and (coalesce(fin_paymen6_.Fin_Payment_Schedule_ID, fin_paymen2_.Fin_Payment_Schedule_ID) is not null) and (fin_paymen0_.AD_Org_ID in ('50956713045C4C069FCF0583488E392A', '1D2A574CCE14446D82FFFC40CCBE00BC', '2AA70B4B531C45CAA5F7CD5FBC696F40', '15ED5B57A3C14544995478A2FC8688B4', '62BDFDB7612B40D3B9D865CDF7A36690', 'FF6B3F6071DB4AB29B93C843E10985E4', '0177D0E3EC0548338FDA71A619D3E547', '385847CC725646C9A2C26DF19AC8781D', 'ABB79999997E423B85B205975E7A9BD8', '194125F878A74723A9150F5F4029C0B1', 'DF8352E71AAF43C58F9E96D84486EC1F', 'D95D002A1CD343DD97A00A73514FD9A5', 'F52AE0F2187E446F9E06381199A14184', '7CC7291AE0AF44BAA76A230348DF6004', '209B69CEDF5841E0AA33D37D2E5A68E8', '5E01F0FAFDBD4F0ABC82A5B031723084', '7394B891BC824F24821ACCEBC3A06829', 'E495F7998AB748F59ED3B6ACF2F48CA6', '5CBFB589EF3741F191EC25FC675FF687')) and (organizati11_.AD_Org_ID is null or organizati11_.IsActive = 'Y') and invoice7_.IsSOTrx = 'Y' and invoice7_.C_Currency_ID = '102' group by invoice7_.C_Invoice_ID, invoice7_.DocumentNo, invoice7_.C_DocType_ID, coalesce(fin_paymen6_.Fin_Paymentmethod_ID, fin_paymen2_.Fin_Paymentmethod_ID), coalesce(fin_paymen9_.Name, fin_paymen5_.Name), coalesce(fin_paymen6_.ExpectedDate, fin_paymen2_.ExpectedDate), coalesce(fin_paymen8_.Priority, fin_paymen4_.Priority), invoice7_.IsSOTrx, organizati11_.AD_Org_ID, organizati11_.EM_Aprm_Payment_Desc, invoice7_.POReference, aduser14_.UserName, aduser16_.UserName, invoice7_.Created, invoice7_.Updated, businesspa1_.C_BPartner_ID, businesspa1_.Name, coalesce(businesspa18_.AccountNo, businesspa19_.AccountNo) having upper(coalesce(fin_paymen9_.Name, fin_paymen5_.Name)) like upper('%Compensación%') escape '|' order by case when max(fin_paymen13_.Fin_Payment_ID) is not null then 0 else 1 end, coalesce(fin_paymen8_.Priority, fin_paymen4_.Priority), coalesce(fin_paymen6_.ExpectedDate, fin_paymen2_.ExpectedDate), invoice7_.DocumentNo limit '101';

Date: 2026-07-16 15:02:58
Duration: 4s903ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') as col_0_0_, array_to_string(array_agg(order3_.DocumentNo), ',') as col_1_0_, case when invoice7_.IsSOTrx = 'N' and (organizati11_.AD_Org_ID is not null) and (organizati11_.EM_Aprm_Payment_Desc like 'Supplier Reference') then invoice7_.POReference else invoice7_.DocumentNo end as col_2_0_, coalesce(fin_paymen6_.Fin_Paymentmethod_ID, fin_paymen2_.Fin_Paymentmethod_ID) as col_3_0_, coalesce(fin_paymen9_.Name, fin_paymen5_.Name) as col_4_0_, coalesce(fin_paymen6_.ExpectedDate, fin_paymen2_.ExpectedDate) as col_5_0_, max(coalesce(fin_paymen6_.Amount, fin_paymen2_.Amount)) as col_6_0_, max(coalesce(invoice7_.GrandTotal, 0)) as col_7_0_, aduser14_.UserName as col_8_0_, aduser16_.UserName as col_9_0_, invoice7_.Created as col_10_0_, invoice7_.Updated as col_11_0_, businesspa1_.C_BPartner_ID as col_12_0_, businesspa1_.Name as col_13_0_, sum(fin_paymen0_.Amount + fin_paymen0_.Writeoffamt) as col_14_0_, coalesce(sum(fin_paymen12_.Amount), 0) as col_15_0_, case when sum(fin_paymen0_.Writeoffamt) <> 0 then true else false end as col_16_0_, case when max(fin_paymen13_.Fin_Payment_ID) is not null then true else false end as col_17_0_, coalesce(businesspa18_.AccountNo, businesspa19_.AccountNo) as col_18_0_ from FIN_Payment_ScheduleDetail fin_paymen0_ inner join C_BPartner businesspa1_ on fin_paymen0_.C_Bpartner_ID = businesspa1_.C_BPartner_ID left outer join FIN_Payment_Schedule fin_paymen2_ on fin_paymen0_.FIN_Payment_Schedule_Order = fin_paymen2_.Fin_Payment_Schedule_ID left outer join C_Order order3_ on fin_paymen2_.C_Order_ID = order3_.C_Order_ID and (order3_.IsSOTrx = 'Y' and order3_.C_Currency_ID = '102') left outer join FIN_Payment_Priority fin_paymen4_ on fin_paymen2_.FIN_Payment_Priority_ID = fin_paymen4_.FIN_Payment_Priority_ID left outer join FIN_PaymentMethod fin_paymen5_ on fin_paymen2_.Fin_Paymentmethod_ID = fin_paymen5_.Fin_Paymentmethod_ID left outer join FIN_Payment_Schedule fin_paymen6_ on fin_paymen0_.FIN_Payment_Schedule_Invoice = fin_paymen6_.Fin_Payment_Schedule_ID left outer join C_Invoice invoice7_ on fin_paymen6_.C_Invoice_ID = invoice7_.C_Invoice_ID and (invoice7_.IsSOTrx = 'Y' and invoice7_.C_Currency_ID = '102') left outer join FIN_Payment_Priority fin_paymen8_ on fin_paymen6_.FIN_Payment_Priority_ID = fin_paymen8_.FIN_Payment_Priority_ID left outer join FIN_PaymentMethod fin_paymen9_ on fin_paymen6_.Fin_Paymentmethod_ID = fin_paymen9_.Fin_Paymentmethod_ID left outer join AD_Org organizati10_ on fin_paymen0_.AD_Org_ID = organizati10_.AD_Org_ID left outer join AD_OrgInfo organizati11_ on organizati10_.AD_Org_ID = organizati11_.AD_Org_ID left outer join FIN_Payment_Detail fin_paymen12_ on fin_paymen0_.FIN_Payment_Detail_ID = fin_paymen12_.Fin_Payment_Detail_ID left outer join FIN_Payment fin_paymen13_ on fin_paymen12_.Fin_Payment_ID = fin_paymen13_.Fin_Payment_ID left outer join AD_User aduser14_ on invoice7_.CreatedBy = aduser14_.AD_User_ID left outer join AD_User aduser15_ on order3_.CreatedBy = aduser15_.AD_User_ID left outer join AD_User aduser16_ on invoice7_.UpdatedBy = aduser16_.AD_User_ID left outer join AD_User aduser17_ on order3_.UpdatedBy = aduser17_.AD_User_ID left outer join C_BP_BankAccount businesspa18_ on invoice7_.EM_Etabam_Bankaccount_ID = businesspa18_.C_BP_BankAccount_ID left outer join C_BP_BankAccount businesspa19_ on order3_.EM_Etabam_Bankaccount_ID = businesspa19_.C_BP_BankAccount_ID where (fin_paymen0_.AD_Client_ID in ('0', '7E3CD157DC6246718BFBF101DCDC4016')) and (fin_paymen0_.FIN_Payment_Detail_ID is null or fin_paymen13_.Fin_Payment_ID = 'D987BAFAB4814DF59297220BD708979D') and (coalesce(fin_paymen6_.Fin_Payment_Schedule_ID, fin_paymen2_.Fin_Payment_Schedule_ID) is not null) and (fin_paymen0_.AD_Org_ID in ('50956713045C4C069FCF0583488E392A', '1D2A574CCE14446D82FFFC40CCBE00BC', '2AA70B4B531C45CAA5F7CD5FBC696F40', '15ED5B57A3C14544995478A2FC8688B4', '62BDFDB7612B40D3B9D865CDF7A36690', 'FF6B3F6071DB4AB29B93C843E10985E4', '0177D0E3EC0548338FDA71A619D3E547', '385847CC725646C9A2C26DF19AC8781D', 'ABB79999997E423B85B205975E7A9BD8', '194125F878A74723A9150F5F4029C0B1', 'DF8352E71AAF43C58F9E96D84486EC1F', 'D95D002A1CD343DD97A00A73514FD9A5', 'F52AE0F2187E446F9E06381199A14184', '7CC7291AE0AF44BAA76A230348DF6004', '209B69CEDF5841E0AA33D37D2E5A68E8', '5E01F0FAFDBD4F0ABC82A5B031723084', '7394B891BC824F24821ACCEBC3A06829', 'E495F7998AB748F59ED3B6ACF2F48CA6', '5CBFB589EF3741F191EC25FC675FF687')) and (organizati11_.AD_Org_ID is null or organizati11_.IsActive = 'Y') and invoice7_.IsSOTrx = 'Y' and invoice7_.C_Currency_ID = '102' group by invoice7_.C_Invoice_ID, invoice7_.DocumentNo, invoice7_.C_DocType_ID, coalesce(fin_paymen6_.Fin_Paymentmethod_ID, fin_paymen2_.Fin_Paymentmethod_ID), coalesce(fin_paymen9_.Name, fin_paymen5_.Name), coalesce(fin_paymen6_.ExpectedDate, fin_paymen2_.ExpectedDate), coalesce(fin_paymen8_.Priority, fin_paymen4_.Priority), invoice7_.IsSOTrx, organizati11_.AD_Org_ID, organizati11_.EM_Aprm_Payment_Desc, invoice7_.POReference, aduser14_.UserName, aduser16_.UserName, invoice7_.Created, invoice7_.Updated, businesspa1_.C_BPartner_ID, businesspa1_.Name, coalesce(businesspa18_.AccountNo, businesspa19_.AccountNo) having upper(coalesce(fin_paymen9_.Name, fin_paymen5_.Name)) like upper('%Compensación%') escape '|' order by case when max(fin_paymen13_.Fin_Payment_ID) is not null then 0 else 1 end, coalesce(fin_paymen8_.Priority, fin_paymen4_.Priority), coalesce(fin_paymen6_.ExpectedDate, fin_paymen2_.ExpectedDate), invoice7_.DocumentNo limit '101';

Date: 2026-07-16 15:04:02
Duration: 4s615ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') as col_0_0_, array_to_string(array_agg(order3_.DocumentNo), ',') as col_1_0_, case when invoice7_.IsSOTrx = 'N' and (organizati11_.AD_Org_ID is not null) and (organizati11_.EM_Aprm_Payment_Desc like 'Supplier Reference') then invoice7_.POReference else invoice7_.DocumentNo end as col_2_0_, coalesce(fin_paymen6_.Fin_Paymentmethod_ID, fin_paymen2_.Fin_Paymentmethod_ID) as col_3_0_, coalesce(fin_paymen9_.Name, fin_paymen5_.Name) as col_4_0_, coalesce(fin_paymen6_.ExpectedDate, fin_paymen2_.ExpectedDate) as col_5_0_, max(coalesce(fin_paymen6_.Amount, fin_paymen2_.Amount)) as col_6_0_, max(coalesce(invoice7_.GrandTotal, 0)) as col_7_0_, aduser14_.UserName as col_8_0_, aduser16_.UserName as col_9_0_, invoice7_.Created as col_10_0_, invoice7_.Updated as col_11_0_, businesspa1_.C_BPartner_ID as col_12_0_, businesspa1_.Name as col_13_0_, sum(fin_paymen0_.Amount + fin_paymen0_.Writeoffamt) as col_14_0_, coalesce(sum(fin_paymen12_.Amount), 0) as col_15_0_, case when sum(fin_paymen0_.Writeoffamt) <> 0 then true else false end as col_16_0_, case when max(fin_paymen13_.Fin_Payment_ID) is not null then true else false end as col_17_0_, coalesce(businesspa18_.AccountNo, businesspa19_.AccountNo) as col_18_0_ from FIN_Payment_ScheduleDetail fin_paymen0_ inner join C_BPartner businesspa1_ on fin_paymen0_.C_Bpartner_ID = businesspa1_.C_BPartner_ID left outer join FIN_Payment_Schedule fin_paymen2_ on fin_paymen0_.FIN_Payment_Schedule_Order = fin_paymen2_.Fin_Payment_Schedule_ID left outer join C_Order order3_ on fin_paymen2_.C_Order_ID = order3_.C_Order_ID and (order3_.IsSOTrx = $1 and order3_.C_Currency_ID = $2) left outer join FIN_Payment_Priority fin_paymen4_ on fin_paymen2_.FIN_Payment_Priority_ID = fin_paymen4_.FIN_Payment_Priority_ID left outer join FIN_PaymentMethod fin_paymen5_ on fin_paymen2_.Fin_Paymentmethod_ID = fin_paymen5_.Fin_Paymentmethod_ID left outer join FIN_Payment_Schedule fin_paymen6_ on fin_paymen0_.FIN_Payment_Schedule_Invoice = fin_paymen6_.Fin_Payment_Schedule_ID left outer join C_Invoice invoice7_ on fin_paymen6_.C_Invoice_ID = invoice7_.C_Invoice_ID and (invoice7_.IsSOTrx = $3 and invoice7_.C_Currency_ID = $4) left outer join FIN_Payment_Priority fin_paymen8_ on fin_paymen6_.FIN_Payment_Priority_ID = fin_paymen8_.FIN_Payment_Priority_ID left outer join FIN_PaymentMethod fin_paymen9_ on fin_paymen6_.Fin_Paymentmethod_ID = fin_paymen9_.Fin_Paymentmethod_ID left outer join AD_Org organizati10_ on fin_paymen0_.AD_Org_ID = organizati10_.AD_Org_ID left outer join AD_OrgInfo organizati11_ on organizati10_.AD_Org_ID = organizati11_.AD_Org_ID left outer join FIN_Payment_Detail fin_paymen12_ on fin_paymen0_.FIN_Payment_Detail_ID = fin_paymen12_.Fin_Payment_Detail_ID left outer join FIN_Payment fin_paymen13_ on fin_paymen12_.Fin_Payment_ID = fin_paymen13_.Fin_Payment_ID left outer join AD_User aduser14_ on invoice7_.CreatedBy = aduser14_.AD_User_ID left outer join AD_User aduser15_ on order3_.CreatedBy = aduser15_.AD_User_ID left outer join AD_User aduser16_ on invoice7_.UpdatedBy = aduser16_.AD_User_ID left outer join AD_User aduser17_ on order3_.UpdatedBy = aduser17_.AD_User_ID left outer join C_BP_BankAccount businesspa18_ on invoice7_.EM_Etabam_Bankaccount_ID = businesspa18_.C_BP_BankAccount_ID left outer join C_BP_BankAccount businesspa19_ on order3_.EM_Etabam_Bankaccount_ID = businesspa19_.C_BP_BankAccount_ID where (fin_paymen0_.AD_Client_ID in ('0', $5)) and (fin_paymen0_.FIN_Payment_Detail_ID is null or fin_paymen13_.Fin_Payment_ID = $6) and (coalesce(fin_paymen6_.Fin_Payment_Schedule_ID, fin_paymen2_.Fin_Payment_Schedule_ID) is not null) and (fin_paymen0_.AD_Org_ID in ($7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25)) and (organizati11_.AD_Org_ID is null or organizati11_.IsActive = 'Y') and invoice7_.IsSOTrx = $26 and invoice7_.C_Currency_ID = $27 group by invoice7_.C_Invoice_ID, invoice7_.DocumentNo, invoice7_.C_DocType_ID, coalesce(fin_paymen6_.Fin_Paymentmethod_ID, fin_paymen2_.Fin_Paymentmethod_ID), coalesce(fin_paymen9_.Name, fin_paymen5_.Name), coalesce(fin_paymen6_.ExpectedDate, fin_paymen2_.ExpectedDate), coalesce(fin_paymen8_.Priority, fin_paymen4_.Priority), invoice7_.IsSOTrx, organizati11_.AD_Org_ID, organizati11_.EM_Aprm_Payment_Desc, invoice7_.POReference, aduser14_.UserName, aduser16_.UserName, invoice7_.Created, invoice7_.Updated, businesspa1_.C_BPartner_ID, businesspa1_.Name, coalesce(businesspa18_.AccountNo, businesspa19_.AccountNo) having upper(coalesce(fin_paymen9_.Name, fin_paymen5_.Name)) like upper($28) escape '|' order by case when max(fin_paymen13_.Fin_Payment_ID) is not null then 0 else 1 end, coalesce(fin_paymen8_.Priority, fin_paymen4_.Priority), coalesce(fin_paymen6_.ExpectedDate, fin_paymen2_.ExpectedDate), invoice7_.DocumentNo limit $29;

Date: 2026-07-16 15:02:55
Duration: 0ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

select "_"."c_order_id" as "c_order_id", ;

Date: 2026-07-16 06:06:09
Duration: 0ms
Database: etendo
User: tad
Remote: 51.38.221.201
Application: Mashup Engine

x Hide

select array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') as col_0_0_, array_to_string(array_agg(order3_.DocumentNo), ',') as col_1_0_, case when invoice7_.IsSOTrx = 'N' and (organizati11_.AD_Org_ID is not null) and (organizati11_.EM_Aprm_Payment_Desc like 'Supplier Reference') then invoice7_.POReference else invoice7_.DocumentNo end as col_2_0_, coalesce(fin_paymen6_.Fin_Paymentmethod_ID, fin_paymen2_.Fin_Paymentmethod_ID) as col_3_0_, coalesce(fin_paymen9_.Name, fin_paymen5_.Name) as col_4_0_, coalesce(fin_paymen6_.ExpectedDate, fin_paymen2_.ExpectedDate) as col_5_0_, max(coalesce(fin_paymen6_.Amount, fin_paymen2_.Amount)) as col_6_0_, max(coalesce(invoice7_.GrandTotal, 0)) as col_7_0_, aduser14_.UserName as col_8_0_, aduser16_.UserName as col_9_0_, invoice7_.Created as col_10_0_, invoice7_.Updated as col_11_0_, businesspa1_.C_BPartner_ID as col_12_0_, businesspa1_.Name as col_13_0_, sum(fin_paymen0_.Amount + fin_paymen0_.Writeoffamt) as col_14_0_, coalesce(sum(fin_paymen12_.Amount), 0) as col_15_0_, case when sum(fin_paymen0_.Writeoffamt) <> 0 then true else false end as col_16_0_, case when max(fin_paymen13_.Fin_Payment_ID) is not null then true else false end as col_17_0_, coalesce(businesspa18_.AccountNo, businesspa19_.AccountNo) as col_18_0_ from FIN_Payment_ScheduleDetail fin_paymen0_ inner join C_BPartner businesspa1_ on fin_paymen0_.C_Bpartner_ID = businesspa1_.C_BPartner_ID left outer join FIN_Payment_Schedule fin_paymen2_ on fin_paymen0_.FIN_Payment_Schedule_Order = fin_paymen2_.Fin_Payment_Schedule_ID left outer join C_Order order3_ on fin_paymen2_.C_Order_ID = order3_.C_Order_ID and (order3_.IsSOTrx = 'Y' and order3_.C_Currency_ID = '102') left outer join FIN_Payment_Priority fin_paymen4_ on fin_paymen2_.FIN_Payment_Priority_ID = fin_paymen4_.FIN_Payment_Priority_ID left outer join FIN_PaymentMethod fin_paymen5_ on fin_paymen2_.Fin_Paymentmethod_ID = fin_paymen5_.Fin_Paymentmethod_ID left outer join FIN_Payment_Schedule fin_paymen6_ on fin_paymen0_.FIN_Payment_Schedule_Invoice = fin_paymen6_.Fin_Payment_Schedule_ID left outer join C_Invoice invoice7_ on fin_paymen6_.C_Invoice_ID = invoice7_.C_Invoice_ID and (invoice7_.IsSOTrx = 'Y' and invoice7_.C_Currency_ID = '102') left outer join FIN_Payment_Priority fin_paymen8_ on fin_paymen6_.FIN_Payment_Priority_ID = fin_paymen8_.FIN_Payment_Priority_ID left outer join FIN_PaymentMethod fin_paymen9_ on fin_paymen6_.Fin_Paymentmethod_ID = fin_paymen9_.Fin_Paymentmethod_ID left outer join AD_Org organizati10_ on fin_paymen0_.AD_Org_ID = organizati10_.AD_Org_ID left outer join AD_OrgInfo organizati11_ on organizati10_.AD_Org_ID = organizati11_.AD_Org_ID left outer join FIN_Payment_Detail fin_paymen12_ on fin_paymen0_.FIN_Payment_Detail_ID = fin_paymen12_.Fin_Payment_Detail_ID left outer join FIN_Payment fin_paymen13_ on fin_paymen12_.Fin_Payment_ID = fin_paymen13_.Fin_Payment_ID left outer join AD_User aduser14_ on invoice7_.CreatedBy = aduser14_.AD_User_ID left outer join AD_User aduser15_ on order3_.CreatedBy = aduser15_.AD_User_ID left outer join AD_User aduser16_ on invoice7_.UpdatedBy = aduser16_.AD_User_ID left outer join AD_User aduser17_ on order3_.UpdatedBy = aduser17_.AD_User_ID left outer join C_BP_BankAccount businesspa18_ on invoice7_.EM_Etabam_Bankaccount_ID = businesspa18_.C_BP_BankAccount_ID left outer join C_BP_BankAccount businesspa19_ on order3_.EM_Etabam_Bankaccount_ID = businesspa19_.C_BP_BankAccount_ID where (fin_paymen0_.AD_Client_ID in ('0', '7E3CD157DC6246718BFBF101DCDC4016')) and (fin_paymen0_.AD_Org_ID in ('50956713045C4C069FCF0583488E392A', '1D2A574CCE14446D82FFFC40CCBE00BC', '2AA70B4B531C45CAA5F7CD5FBC696F40', '15ED5B57A3C14544995478A2FC8688B4', '62BDFDB7612B40D3B9D865CDF7A36690', 'FF6B3F6071DB4AB29B93C843E10985E4', '0177D0E3EC0548338FDA71A619D3E547', '5CE219D3542A4FF4949922C8765C375D', '0', '385847CC725646C9A2C26DF19AC8781D', 'ABB79999997E423B85B205975E7A9BD8', '194125F878A74723A9150F5F4029C0B1', 'DF8352E71AAF43C58F9E96D84486EC1F', 'D95D002A1CD343DD97A00A73514FD9A5', 'F52AE0F2187E446F9E06381199A14184', '7CC7291AE0AF44BAA76A230348DF6004', '209B69CEDF5841E0AA33D37D2E5A68E8', '5E01F0FAFDBD4F0ABC82A5B031723084', '7394B891BC824F24821ACCEBC3A06829', 'E495F7998AB748F59ED3B6ACF2F48CA6', '5CBFB589EF3741F191EC25FC675FF687')) and (fin_paymen0_.FIN_Payment_Detail_ID is null or fin_paymen13_.Fin_Payment_ID = 'D987BAFAB4814DF59297220BD708979D') and (coalesce(fin_paymen6_.Fin_Payment_Schedule_ID, fin_paymen2_.Fin_Payment_Schedule_ID) is not null) and (fin_paymen0_.AD_Org_ID in ('50956713045C4C069FCF0583488E392A', '1D2A574CCE14446D82FFFC40CCBE00BC', '2AA70B4B531C45CAA5F7CD5FBC696F40', '15ED5B57A3C14544995478A2FC8688B4', '62BDFDB7612B40D3B9D865CDF7A36690', 'FF6B3F6071DB4AB29B93C843E10985E4', '0177D0E3EC0548338FDA71A619D3E547', '385847CC725646C9A2C26DF19AC8781D', 'ABB79999997E423B85B205975E7A9BD8', '194125F878A74723A9150F5F4029C0B1', 'DF8352E71AAF43C58F9E96D84486EC1F', 'D95D002A1CD343DD97A00A73514FD9A5', 'F52AE0F2187E446F9E06381199A14184', '7CC7291AE0AF44BAA76A230348DF6004', '209B69CEDF5841E0AA33D37D2E5A68E8', '5E01F0FAFDBD4F0ABC82A5B031723084', '7394B891BC824F24821ACCEBC3A06829', 'E495F7998AB748F59ED3B6ACF2F48CA6', '5CBFB589EF3741F191EC25FC675FF687')) and (organizati11_.AD_Org_ID is null or organizati11_.IsActive = 'Y') and invoice7_.IsSOTrx = 'Y' and invoice7_.C_Currency_ID = '102' group by invoice7_.C_Invoice_ID, invoice7_.DocumentNo, invoice7_.C_DocType_ID, coalesce(fin_paymen6_.Fin_Paymentmethod_ID, fin_paymen2_.Fin_Paymentmethod_ID), coalesce(fin_paymen9_.Name, fin_paymen5_.Name), coalesce(fin_paymen6_.ExpectedDate, fin_paymen2_.ExpectedDate), coalesce(fin_paymen8_.Priority, fin_paymen4_.Priority), invoice7_.IsSOTrx, organizati11_.AD_Org_ID, organizati11_.EM_Aprm_Payment_Desc, invoice7_.POReference, aduser14_.UserName, aduser16_.UserName, invoice7_.Created, invoice7_.Updated, businesspa1_.C_BPartner_ID, businesspa1_.Name, coalesce(businesspa18_.AccountNo, businesspa19_.AccountNo) order by case when max(fin_paymen13_.Fin_Payment_ID) is not null then 0 else 1 end, coalesce(fin_paymen8_.Priority, fin_paymen4_.Priority), coalesce(fin_paymen6_.ExpectedDate, fin_paymen2_.ExpectedDate), invoice7_.DocumentNo limit '101';

Date: 2026-07-16 15:04:06
Duration: 5s926ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') as col_0_0_, array_to_string(array_agg(order3_.DocumentNo), ',') as col_1_0_, case when invoice7_.IsSOTrx = 'N' and (organizati11_.AD_Org_ID is not null) and (organizati11_.EM_Aprm_Payment_Desc like 'Supplier Reference') then invoice7_.POReference else invoice7_.DocumentNo end as col_2_0_, coalesce(fin_paymen6_.Fin_Paymentmethod_ID, fin_paymen2_.Fin_Paymentmethod_ID) as col_3_0_, coalesce(fin_paymen9_.Name, fin_paymen5_.Name) as col_4_0_, coalesce(fin_paymen6_.ExpectedDate, fin_paymen2_.ExpectedDate) as col_5_0_, max(coalesce(fin_paymen6_.Amount, fin_paymen2_.Amount)) as col_6_0_, max(coalesce(invoice7_.GrandTotal, 0)) as col_7_0_, aduser14_.UserName as col_8_0_, aduser16_.UserName as col_9_0_, invoice7_.Created as col_10_0_, invoice7_.Updated as col_11_0_, businesspa1_.C_BPartner_ID as col_12_0_, businesspa1_.Name as col_13_0_, sum(fin_paymen0_.Amount + fin_paymen0_.Writeoffamt) as col_14_0_, coalesce(sum(fin_paymen12_.Amount), 0) as col_15_0_, case when sum(fin_paymen0_.Writeoffamt) <> 0 then true else false end as col_16_0_, case when max(fin_paymen13_.Fin_Payment_ID) is not null then true else false end as col_17_0_, coalesce(businesspa18_.AccountNo, businesspa19_.AccountNo) as col_18_0_ from FIN_Payment_ScheduleDetail fin_paymen0_ inner join C_BPartner businesspa1_ on fin_paymen0_.C_Bpartner_ID = businesspa1_.C_BPartner_ID left outer join FIN_Payment_Schedule fin_paymen2_ on fin_paymen0_.FIN_Payment_Schedule_Order = fin_paymen2_.Fin_Payment_Schedule_ID left outer join C_Order order3_ on fin_paymen2_.C_Order_ID = order3_.C_Order_ID and (order3_.IsSOTrx = $1 and order3_.C_Currency_ID = $2) left outer join FIN_Payment_Priority fin_paymen4_ on fin_paymen2_.FIN_Payment_Priority_ID = fin_paymen4_.FIN_Payment_Priority_ID left outer join FIN_PaymentMethod fin_paymen5_ on fin_paymen2_.Fin_Paymentmethod_ID = fin_paymen5_.Fin_Paymentmethod_ID left outer join FIN_Payment_Schedule fin_paymen6_ on fin_paymen0_.FIN_Payment_Schedule_Invoice = fin_paymen6_.Fin_Payment_Schedule_ID left outer join C_Invoice invoice7_ on fin_paymen6_.C_Invoice_ID = invoice7_.C_Invoice_ID and (invoice7_.IsSOTrx = $3 and invoice7_.C_Currency_ID = $4) left outer join FIN_Payment_Priority fin_paymen8_ on fin_paymen6_.FIN_Payment_Priority_ID = fin_paymen8_.FIN_Payment_Priority_ID left outer join FIN_PaymentMethod fin_paymen9_ on fin_paymen6_.Fin_Paymentmethod_ID = fin_paymen9_.Fin_Paymentmethod_ID left outer join AD_Org organizati10_ on fin_paymen0_.AD_Org_ID = organizati10_.AD_Org_ID left outer join AD_OrgInfo organizati11_ on organizati10_.AD_Org_ID = organizati11_.AD_Org_ID left outer join FIN_Payment_Detail fin_paymen12_ on fin_paymen0_.FIN_Payment_Detail_ID = fin_paymen12_.Fin_Payment_Detail_ID left outer join FIN_Payment fin_paymen13_ on fin_paymen12_.Fin_Payment_ID = fin_paymen13_.Fin_Payment_ID left outer join AD_User aduser14_ on invoice7_.CreatedBy = aduser14_.AD_User_ID left outer join AD_User aduser15_ on order3_.CreatedBy = aduser15_.AD_User_ID left outer join AD_User aduser16_ on invoice7_.UpdatedBy = aduser16_.AD_User_ID left outer join AD_User aduser17_ on order3_.UpdatedBy = aduser17_.AD_User_ID left outer join C_BP_BankAccount businesspa18_ on invoice7_.EM_Etabam_Bankaccount_ID = businesspa18_.C_BP_BankAccount_ID left outer join C_BP_BankAccount businesspa19_ on order3_.EM_Etabam_Bankaccount_ID = businesspa19_.C_BP_BankAccount_ID where (fin_paymen0_.AD_Client_ID in ('0', $5)) and (fin_paymen0_.AD_Org_ID in ($6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26)) and (fin_paymen0_.FIN_Payment_Detail_ID is null or fin_paymen13_.Fin_Payment_ID = $27) and (coalesce(fin_paymen6_.Fin_Payment_Schedule_ID, fin_paymen2_.Fin_Payment_Schedule_ID) is not null) and (fin_paymen0_.AD_Org_ID in ($28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46)) and (organizati11_.AD_Org_ID is null or organizati11_.IsActive = 'Y') and invoice7_.IsSOTrx = $47 and invoice7_.C_Currency_ID = $48 group by invoice7_.C_Invoice_ID, invoice7_.DocumentNo, invoice7_.C_DocType_ID, coalesce(fin_paymen6_.Fin_Paymentmethod_ID, fin_paymen2_.Fin_Paymentmethod_ID), coalesce(fin_paymen9_.Name, fin_paymen5_.Name), coalesce(fin_paymen6_.ExpectedDate, fin_paymen2_.ExpectedDate), coalesce(fin_paymen8_.Priority, fin_paymen4_.Priority), invoice7_.IsSOTrx, organizati11_.AD_Org_ID, organizati11_.EM_Aprm_Payment_Desc, invoice7_.POReference, aduser14_.UserName, aduser16_.UserName, invoice7_.Created, invoice7_.Updated, businesspa1_.C_BPartner_ID, businesspa1_.Name, coalesce(businesspa18_.AccountNo, businesspa19_.AccountNo) order by case when max(fin_paymen13_.Fin_Payment_ID) is not null then 0 else 1 end, coalesce(fin_paymen8_.Priority, fin_paymen4_.Priority), coalesce(fin_paymen6_.ExpectedDate, fin_paymen2_.ExpectedDate), invoice7_.DocumentNo limit $49;

Date: 2026-07-16 15:04:02
Duration: 0ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

select array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') as col_0_0_, array_to_string(array_agg(order3_.DocumentNo), ',') as col_1_0_, case when invoice7_.IsSOTrx = 'N' and (organizati11_.AD_Org_ID is not null) and (organizati11_.EM_Aprm_Payment_Desc like 'Supplier Reference') then invoice7_.POReference else invoice7_.DocumentNo end as col_2_0_, coalesce(fin_paymen6_.Fin_Paymentmethod_ID, fin_paymen2_.Fin_Paymentmethod_ID) as col_3_0_, coalesce(fin_paymen9_.Name, fin_paymen5_.Name) as col_4_0_, coalesce(fin_paymen6_.ExpectedDate, fin_paymen2_.ExpectedDate) as col_5_0_, max(coalesce(fin_paymen6_.Amount, fin_paymen2_.Amount)) as col_6_0_, max(coalesce(invoice7_.GrandTotal, 0)) as col_7_0_, aduser14_.UserName as col_8_0_, aduser16_.UserName as col_9_0_, invoice7_.Created as col_10_0_, invoice7_.Updated as col_11_0_, businesspa1_.C_BPartner_ID as col_12_0_, businesspa1_.Name as col_13_0_, sum(fin_paymen0_.Amount + fin_paymen0_.Writeoffamt) as col_14_0_, coalesce(sum(fin_paymen12_.Amount), 0) as col_15_0_, case when sum(fin_paymen0_.Writeoffamt) <> 0 then true else false end as col_16_0_, case when max(fin_paymen13_.Fin_Payment_ID) is not null then true else false end as col_17_0_, coalesce(businesspa18_.AccountNo, businesspa19_.AccountNo) as col_18_0_ from FIN_Payment_ScheduleDetail fin_paymen0_ inner join C_BPartner businesspa1_ on fin_paymen0_.C_Bpartner_ID = businesspa1_.C_BPartner_ID left outer join FIN_Payment_Schedule fin_paymen2_ on fin_paymen0_.FIN_Payment_Schedule_Order = fin_paymen2_.Fin_Payment_Schedule_ID left outer join C_Order order3_ on fin_paymen2_.C_Order_ID = order3_.C_Order_ID and (order3_.IsSOTrx = 'Y' and order3_.C_Currency_ID = '102') left outer join FIN_Payment_Priority fin_paymen4_ on fin_paymen2_.FIN_Payment_Priority_ID = fin_paymen4_.FIN_Payment_Priority_ID left outer join FIN_PaymentMethod fin_paymen5_ on fin_paymen2_.Fin_Paymentmethod_ID = fin_paymen5_.Fin_Paymentmethod_ID left outer join FIN_Payment_Schedule fin_paymen6_ on fin_paymen0_.FIN_Payment_Schedule_Invoice = fin_paymen6_.Fin_Payment_Schedule_ID left outer join C_Invoice invoice7_ on fin_paymen6_.C_Invoice_ID = invoice7_.C_Invoice_ID and (invoice7_.IsSOTrx = 'Y' and invoice7_.C_Currency_ID = '102') left outer join FIN_Payment_Priority fin_paymen8_ on fin_paymen6_.FIN_Payment_Priority_ID = fin_paymen8_.FIN_Payment_Priority_ID left outer join FIN_PaymentMethod fin_paymen9_ on fin_paymen6_.Fin_Paymentmethod_ID = fin_paymen9_.Fin_Paymentmethod_ID left outer join AD_Org organizati10_ on fin_paymen0_.AD_Org_ID = organizati10_.AD_Org_ID left outer join AD_OrgInfo organizati11_ on organizati10_.AD_Org_ID = organizati11_.AD_Org_ID left outer join FIN_Payment_Detail fin_paymen12_ on fin_paymen0_.FIN_Payment_Detail_ID = fin_paymen12_.Fin_Payment_Detail_ID left outer join FIN_Payment fin_paymen13_ on fin_paymen12_.Fin_Payment_ID = fin_paymen13_.Fin_Payment_ID left outer join AD_User aduser14_ on invoice7_.CreatedBy = aduser14_.AD_User_ID left outer join AD_User aduser15_ on order3_.CreatedBy = aduser15_.AD_User_ID left outer join AD_User aduser16_ on invoice7_.UpdatedBy = aduser16_.AD_User_ID left outer join AD_User aduser17_ on order3_.UpdatedBy = aduser17_.AD_User_ID left outer join C_BP_BankAccount businesspa18_ on invoice7_.EM_Etabam_Bankaccount_ID = businesspa18_.C_BP_BankAccount_ID left outer join C_BP_BankAccount businesspa19_ on order3_.EM_Etabam_Bankaccount_ID = businesspa19_.C_BP_BankAccount_ID where (fin_paymen0_.AD_Client_ID in ('0', '7E3CD157DC6246718BFBF101DCDC4016')) and (fin_paymen0_.FIN_Payment_Detail_ID is null or fin_paymen13_.Fin_Payment_ID = 'D987BAFAB4814DF59297220BD708979D') and (coalesce(fin_paymen6_.Fin_Payment_Schedule_ID, fin_paymen2_.Fin_Payment_Schedule_ID) is not null) and (fin_paymen0_.AD_Org_ID in ('50956713045C4C069FCF0583488E392A', '1D2A574CCE14446D82FFFC40CCBE00BC', '2AA70B4B531C45CAA5F7CD5FBC696F40', '15ED5B57A3C14544995478A2FC8688B4', '62BDFDB7612B40D3B9D865CDF7A36690', 'FF6B3F6071DB4AB29B93C843E10985E4', '0177D0E3EC0548338FDA71A619D3E547', '385847CC725646C9A2C26DF19AC8781D', 'ABB79999997E423B85B205975E7A9BD8', '194125F878A74723A9150F5F4029C0B1', 'DF8352E71AAF43C58F9E96D84486EC1F', 'D95D002A1CD343DD97A00A73514FD9A5', 'F52AE0F2187E446F9E06381199A14184', '7CC7291AE0AF44BAA76A230348DF6004', '209B69CEDF5841E0AA33D37D2E5A68E8', '5E01F0FAFDBD4F0ABC82A5B031723084', '7394B891BC824F24821ACCEBC3A06829', 'E495F7998AB748F59ED3B6ACF2F48CA6', '5CBFB589EF3741F191EC25FC675FF687')) and (organizati11_.AD_Org_ID is null or organizati11_.IsActive = 'Y') and invoice7_.IsSOTrx = 'Y' and invoice7_.C_Currency_ID = '102' group by invoice7_.C_Invoice_ID, invoice7_.DocumentNo, invoice7_.C_DocType_ID, coalesce(fin_paymen6_.Fin_Paymentmethod_ID, fin_paymen2_.Fin_Paymentmethod_ID), coalesce(fin_paymen9_.Name, fin_paymen5_.Name), coalesce(fin_paymen6_.ExpectedDate, fin_paymen2_.ExpectedDate), coalesce(fin_paymen8_.Priority, fin_paymen4_.Priority), invoice7_.IsSOTrx, organizati11_.AD_Org_ID, organizati11_.EM_Aprm_Payment_Desc, invoice7_.POReference, aduser14_.UserName, aduser16_.UserName, invoice7_.Created, invoice7_.Updated, businesspa1_.C_BPartner_ID, businesspa1_.Name, coalesce(businesspa18_.AccountNo, businesspa19_.AccountNo) having upper(coalesce(fin_paymen9_.Name, fin_paymen5_.Name)) like upper('%Compensación%') escape '|' order by case when max(fin_paymen13_.Fin_Payment_ID) is not null then 0 else 1 end, coalesce(fin_paymen8_.Priority, fin_paymen4_.Priority), coalesce(fin_paymen6_.ExpectedDate, fin_paymen2_.ExpectedDate), invoice7_.DocumentNo limit '101' offset '100';

Date: 2026-07-16 15:03:03
Duration: 4s449ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') as col_0_0_, array_to_string(array_agg(order3_.DocumentNo), ',') as col_1_0_, case when invoice7_.IsSOTrx = 'N' and (organizati11_.AD_Org_ID is not null) and (organizati11_.EM_Aprm_Payment_Desc like 'Supplier Reference') then invoice7_.POReference else invoice7_.DocumentNo end as col_2_0_, coalesce(fin_paymen6_.Fin_Paymentmethod_ID, fin_paymen2_.Fin_Paymentmethod_ID) as col_3_0_, coalesce(fin_paymen9_.Name, fin_paymen5_.Name) as col_4_0_, coalesce(fin_paymen6_.ExpectedDate, fin_paymen2_.ExpectedDate) as col_5_0_, max(coalesce(fin_paymen6_.Amount, fin_paymen2_.Amount)) as col_6_0_, max(coalesce(invoice7_.GrandTotal, 0)) as col_7_0_, aduser14_.UserName as col_8_0_, aduser16_.UserName as col_9_0_, invoice7_.Created as col_10_0_, invoice7_.Updated as col_11_0_, businesspa1_.C_BPartner_ID as col_12_0_, businesspa1_.Name as col_13_0_, sum(fin_paymen0_.Amount + fin_paymen0_.Writeoffamt) as col_14_0_, coalesce(sum(fin_paymen12_.Amount), 0) as col_15_0_, case when sum(fin_paymen0_.Writeoffamt) <> 0 then true else false end as col_16_0_, case when max(fin_paymen13_.Fin_Payment_ID) is not null then true else false end as col_17_0_, coalesce(businesspa18_.AccountNo, businesspa19_.AccountNo) as col_18_0_ from FIN_Payment_ScheduleDetail fin_paymen0_ inner join C_BPartner businesspa1_ on fin_paymen0_.C_Bpartner_ID = businesspa1_.C_BPartner_ID left outer join FIN_Payment_Schedule fin_paymen2_ on fin_paymen0_.FIN_Payment_Schedule_Order = fin_paymen2_.Fin_Payment_Schedule_ID left outer join C_Order order3_ on fin_paymen2_.C_Order_ID = order3_.C_Order_ID and (order3_.IsSOTrx = $1 and order3_.C_Currency_ID = $2) left outer join FIN_Payment_Priority fin_paymen4_ on fin_paymen2_.FIN_Payment_Priority_ID = fin_paymen4_.FIN_Payment_Priority_ID left outer join FIN_PaymentMethod fin_paymen5_ on fin_paymen2_.Fin_Paymentmethod_ID = fin_paymen5_.Fin_Paymentmethod_ID left outer join FIN_Payment_Schedule fin_paymen6_ on fin_paymen0_.FIN_Payment_Schedule_Invoice = fin_paymen6_.Fin_Payment_Schedule_ID left outer join C_Invoice invoice7_ on fin_paymen6_.C_Invoice_ID = invoice7_.C_Invoice_ID and (invoice7_.IsSOTrx = $3 and invoice7_.C_Currency_ID = $4) left outer join FIN_Payment_Priority fin_paymen8_ on fin_paymen6_.FIN_Payment_Priority_ID = fin_paymen8_.FIN_Payment_Priority_ID left outer join FIN_PaymentMethod fin_paymen9_ on fin_paymen6_.Fin_Paymentmethod_ID = fin_paymen9_.Fin_Paymentmethod_ID left outer join AD_Org organizati10_ on fin_paymen0_.AD_Org_ID = organizati10_.AD_Org_ID left outer join AD_OrgInfo organizati11_ on organizati10_.AD_Org_ID = organizati11_.AD_Org_ID left outer join FIN_Payment_Detail fin_paymen12_ on fin_paymen0_.FIN_Payment_Detail_ID = fin_paymen12_.Fin_Payment_Detail_ID left outer join FIN_Payment fin_paymen13_ on fin_paymen12_.Fin_Payment_ID = fin_paymen13_.Fin_Payment_ID left outer join AD_User aduser14_ on invoice7_.CreatedBy = aduser14_.AD_User_ID left outer join AD_User aduser15_ on order3_.CreatedBy = aduser15_.AD_User_ID left outer join AD_User aduser16_ on invoice7_.UpdatedBy = aduser16_.AD_User_ID left outer join AD_User aduser17_ on order3_.UpdatedBy = aduser17_.AD_User_ID left outer join C_BP_BankAccount businesspa18_ on invoice7_.EM_Etabam_Bankaccount_ID = businesspa18_.C_BP_BankAccount_ID left outer join C_BP_BankAccount businesspa19_ on order3_.EM_Etabam_Bankaccount_ID = businesspa19_.C_BP_BankAccount_ID where (fin_paymen0_.AD_Client_ID in ('0', $5)) and (fin_paymen0_.FIN_Payment_Detail_ID is null or fin_paymen13_.Fin_Payment_ID = $6) and (coalesce(fin_paymen6_.Fin_Payment_Schedule_ID, fin_paymen2_.Fin_Payment_Schedule_ID) is not null) and (fin_paymen0_.AD_Org_ID in ($7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25)) and (organizati11_.AD_Org_ID is null or organizati11_.IsActive = 'Y') and invoice7_.IsSOTrx = $26 and invoice7_.C_Currency_ID = $27 group by invoice7_.C_Invoice_ID, invoice7_.DocumentNo, invoice7_.C_DocType_ID, coalesce(fin_paymen6_.Fin_Paymentmethod_ID, fin_paymen2_.Fin_Paymentmethod_ID), coalesce(fin_paymen9_.Name, fin_paymen5_.Name), coalesce(fin_paymen6_.ExpectedDate, fin_paymen2_.ExpectedDate), coalesce(fin_paymen8_.Priority, fin_paymen4_.Priority), invoice7_.IsSOTrx, organizati11_.AD_Org_ID, organizati11_.EM_Aprm_Payment_Desc, invoice7_.POReference, aduser14_.UserName, aduser16_.UserName, invoice7_.Created, invoice7_.Updated, businesspa1_.C_BPartner_ID, businesspa1_.Name, coalesce(businesspa18_.AccountNo, businesspa19_.AccountNo) having upper(coalesce(fin_paymen9_.Name, fin_paymen5_.Name)) like upper($28) escape '|' order by case when max(fin_paymen13_.Fin_Payment_ID) is not null then 0 else 1 end, coalesce(fin_paymen8_.Priority, fin_paymen4_.Priority), coalesce(fin_paymen6_.ExpectedDate, fin_paymen2_.ExpectedDate), invoice7_.DocumentNo limit $29 offset $30;

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