select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('DA6D5109E0794236A336DF4E401DDF51', 'ECA5FA40027D4774A963617F20A182F0', 'C9A66C1D73CD4EAA9A653BC3A834EC8B', 'BF731ED9A22444D69932D55067CCE293', 'BA0DD37FFF49405AB4AC143B9E65AD0A', 'A66132309A6A422BA51FC2B90F9081E2', 'A217C94B57894F7FA59B791FBB7E210D', '9E80B16534FA4450830D2F6F953357D1', '9BA6EC0729E34B88997539E830B001EF', '8577819CD29C40C1A59308306AF3C689', '7FFD4129BE8B43578A912CBF97F0562F', '623A6A2853BE4171BA1F26ED4A75F35A', '47FF59181BC04F739094A7823B20C42A', '2FBF094E5F0B49CDB5A6ABE3A5F4D886', '239264DBCFF1420D9D42E9DB86E5CF26', '20101CF85949484FB7BCFB2AE3C88768', '0C86D437B7AB46B2A17B6865000E794B', '037417A18FF6403684886EABBD4D5057', 'C88F465EDEA34CA39868816F4B96B901', '5ABD202EBA7A425AA48CE424BB714D79', 'FAE634ADA07B4BA0A943FCBC71269F1C', 'F9A194C1F4D0414697752C62AAD78801', 'EF6816B9922F4E4D817CBE44928D53B3', 'EBCD671A6A684CAF81ACA00144BD8448', 'DE2F6D07F55C4F50A200A4C9C6570E9F', 'C904A961AB9940FDADC873790241C5AB', 'BBC8993C9B36449E95538F8BC635937D', 'BB1C633AA69344E3B614CE64E6E5A73F', 'AEF1C3FCAF094D5F942C80E36690146D', '9C0E76DFFBDE45EBA29593B5EFAD52B5', '9B346B691297488E9962D0EC97A6CDB0', '880CE6172F6B48EA9F796E272E126120', '78B7473F77A84DD7A019891D46AB9004', '5C1C8F2C981D4C9BAE7419CD0A5C94C4', '5279BE3A457A4C78941D40E83F9A614C', '444493353F944B54B46CABE5105A8385', '4334DAD2E4834930A087E1D2C413310D', '340559052E2C4EE0BEDEB94D9100AFC1', '07920CA1DF2E4692823C50BA3116F922', '051E8F6455E94FF3B4CB64A83D6D876E', 'F7B1713212A04ED894689CA1528F6415', 'E5AF9004D37D4CA1A45FA90E52E6D6B6', 'E081848A3FAC4E1DB6638C9B2257ED53', 'B5776043334E4F0B95A45E7E9ADB6CB3', 'B4DEB76EB3DE440AA03884C3AD5BC3A7', 'A613569C616B4400A67CF0D2E98E25B8', '9DE3E845BFFC4A90A3DB21B8ECA3AF83', '9CBAA873B64242F48DEE11BD7BDAB6A1', '7B96CE62188341F8A9F65807E5BDE3CD', '7AC5E7AF6F744819B5866D21F11E5D98');

Date: 2026-07-13 18:00:23
Duration: 48s679ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('6E1A004618DF48A08C11E6AB69C776DB', '5DE33BA2BB0C408EB2225A522952B93A', '5706ECDDBB9B4D41BF734341204461B2', '3F8FA22AA507446D87BFA9606F8072EF', '3B63B0F2F82246B2B7DE41D8091EC984', '2CAB937F19A44748B75691078B8720B9', '1226078C4C694576804583ACE24E3CD1', '0F80F36AD02C4185BB146A2523B3A431', '046E97912FB44F5787E61044CA75E783', 'FE8EFFA3F1724CE5A78E4532E8195A2C', 'F48F564D3EE54934A2E6A5D3555590CA', 'DCC1A05E11734188AD665D1C7F6A8B2C', 'CFB49E3F6DFA43988C9820CFCDF4D722', 'C2830A625C984F3FB65E946DF2779D5F', 'AB80C22BCAC74F56A98588F72B0BD6FA', '9D2FC4CF3D2D4DDC8DF9765E7605691D', '885134123AB646009C9FC6B8D5880267', '70BB8001548149C69D5197506CF16EFD', '567187AA7CAB449A886A6680521D3C52', '519ACB7BDE114495B0F2D46047F2782E', '45512BEB1434414FB421BB54F92A104E', '405EBE347D3E4391BE791C5A74742437', '3844AFF038554BBC86F7FD6A1225D528', '0304315403A44A4188FDF14E43C6261B', 'E6A5BF9EE2B3463B9F2ED43DD53F5F72', 'E68E7F26E6824330AD82619695DC47C4', 'D8617618D51949C49ED8F8B312E13F7C', 'BE36F9157A3E4B43AAE7C6E245B63C67', 'B127D2C201914D83957980826A78C82C', 'AFB50D4E088C4FC2AD6C32945FE9FECF', '93637137CC3948A3B193C690B5CC5D8D', '856F5B487C8648F58E83575EB13770F2', '7FA2EEEC4C26405A8A58AA6A8C8A792E', '7CF147638FA5487BB3765E007252D8E8', '663F53DFEAE34DDCA2E80F641BEAE3BA', '63A32197912B4B71BF77B4EEF946B34D', '3F8B6D6F571041E3B3864C62A3E1AA58', '3AE19431A52440B3955BB7C2C58F1AB2', '012C07AC05CE42EB8D1002C4A1E8F7F3', 'E960B83A91454C4F9C4087C950B704F1', 'B4E1D66E2E5341F48D9FA65420AEDE98', 'A7A7EBF4540A4BE79A75116FE22D4042', '99BE82D25CA94D8A996459AD9BAEF5FB', '9555F1FC62C84689AFFD08B798BB993C', '8BBBD22751584F0C85DE477E18C88F96', '7AB88202C53B4028A20C8035B708EB12', '757510D0B13D489986B710EBB5F5E34C', '6C5F8A3717C44C5984D86206C44C94A8', '5D0DBB0CC8354344A44A0618AF28BF67', '4B3927A73DEC408BB7C109CDFE537F68');

Date: 2026-07-13 18:01:11
Duration: 47s831ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID in ('ECA5FA40027D4774A963617F20A182F0', 'C9A66C1D73CD4EAA9A653BC3A834EC8B', 'BF731ED9A22444D69932D55067CCE293', 'BA0DD37FFF49405AB4AC143B9E65AD0A', 'A66132309A6A422BA51FC2B90F9081E2', 'A217C94B57894F7FA59B791FBB7E210D', '9E80B16534FA4450830D2F6F953357D1', '9BA6EC0729E34B88997539E830B001EF', '8577819CD29C40C1A59308306AF3C689', '7FFD4129BE8B43578A912CBF97F0562F', '623A6A2853BE4171BA1F26ED4A75F35A', '47FF59181BC04F739094A7823B20C42A', '2FBF094E5F0B49CDB5A6ABE3A5F4D886', '239264DBCFF1420D9D42E9DB86E5CF26', '20101CF85949484FB7BCFB2AE3C88768', '0C86D437B7AB46B2A17B6865000E794B', '037417A18FF6403684886EABBD4D5057', 'C88F465EDEA34CA39868816F4B96B901', '5C1C8F2C981D4C9BAE7419CD0A5C94C4', '9D2FC4CF3D2D4DDC8DF9765E7605691D', '63A32197912B4B71BF77B4EEF946B34D', '1008095BD92E4B8DB34473FEE5016D28', 'AECBF75476BD40B2AC3EC56CD97F8CA0', 'D2410710DE3347D5B92601793A8FAEF9', 'D09A8A82FBB543F3A09826BA68EC71B7', '1F9CAC0DF2A34234AABA0DEB5CA8B8A1', 'B38E57DC5ED745879E9B5DEB9A6B4D79', '8E2109762FEA466D8C789618826A5271', '4B0B13AF4BF44FF2B2FAC737A1D88CFB', '4720BEB693DB4A54838A2E7A979C6513', '2E1C4C1CF9854E4DB0C796A6F7B5C77B', '4A6A46FCC7994A4DB404DFEFF810C169', '10EA0F995FCC45CC8851599FE8AC2E1A', 'FB91D872258A4A8BAA148B0C5E07E259', 'D759C50627064EA18D1918EFCC22DE2E', '8D58C7781E78431C807F8AEF6A394261', '6770442A0F6F4E83B467CE84E9D2B6B9', 'E66EBA8734D94BD485D9431FEE736A3A', 'F8C3BE00B80E4107A8334ED48B906103', '1D870037B76440B6B11CD5BAE6AF9A8F', '276E345EC9114AD386996E237806F436', '53476E9202344750A17B65E0D7B5C507', '98CD786335B14EED9989AE41BDE30AF2', '8117EE401ED148DD9F0EDC96683BF486', 'E6D34646F0B648E18B83D48D2B80469F', 'F88A9DEEF6134A1097DAE830DE93D46D', 'C5030A142C6F40799D6E86514D9F4140', 'F55936E68F2B483399FF78BD96B5BFC8', '8AA7984053D14BC6905AE63ADC78601C', '9A496CB6DEF24CE4A83D6298AE7C21B3');

Date: 2026-07-13 18:16:37
Duration: 46s487ms
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 1 < 0 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', 'FF80818133B7413E0133B7164D6A0002')) and (fin_paymen0_.FIN_Payment_Detail_ID is null or fin_paymen13_.Fin_Payment_ID = 'ACF014F49CE24C4EA1124C9EC2924072') and (coalesce(fin_paymen6_.Fin_Payment_Schedule_ID, fin_paymen2_.Fin_Payment_Schedule_ID) is not null) and (fin_paymen0_.AD_Org_ID in ('FF80818134D2AA330134F1D03034277D', 'FF80818134D2AA330134F1D11B372783', 'FF80818133B7413E0133B71974AD28C6')) and (organizati11_.AD_Org_ID is null or organizati11_.IsActive = 'Y') and (fin_paymen0_.FIN_Payment_Scheduledetail_ID in ('4E84A0416B8F465EA21F372DD411AEA2') or 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(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%4E84A0416B8F465EA21F372DD411AEA2%') escape '|' or upper( 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) like upper('%26/3%') escape '|' order by case when array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%4E84A0416B8F465EA21F372DD411AEA2%' 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-13 11:48:06
Duration: 2s292ms
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 1 < 0 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', 'FF80818133B7413E0133B7164D6A0002')) and (fin_paymen0_.FIN_Payment_Detail_ID is null or fin_paymen13_.Fin_Payment_ID = 'ACF014F49CE24C4EA1124C9EC2924072') and (coalesce(fin_paymen6_.Fin_Payment_Schedule_ID, fin_paymen2_.Fin_Payment_Schedule_ID) is not null) and (fin_paymen0_.AD_Org_ID in ('FF80818134D2AA330134F1D03034277D', 'FF80818134D2AA330134F1D11B372783', 'FF80818133B7413E0133B71974AD28C6')) and (organizati11_.AD_Org_ID is null or organizati11_.IsActive = 'Y') and (fin_paymen0_.FIN_Payment_Scheduledetail_ID in ('4E84A0416B8F465EA21F372DD411AEA2') or 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(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%4E84A0416B8F465EA21F372DD411AEA2%') escape '|' or upper( 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) like upper('%26%') escape '|' order by case when array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%4E84A0416B8F465EA21F372DD411AEA2%' 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-13 11:48:04
Duration: 2s251ms
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 1 < 0 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', 'FF80818133B7413E0133B7164D6A0002')) and (fin_paymen0_.FIN_Payment_Detail_ID is null or fin_paymen13_.Fin_Payment_ID = 'ACF014F49CE24C4EA1124C9EC2924072') and (coalesce(fin_paymen6_.Fin_Payment_Schedule_ID, fin_paymen2_.Fin_Payment_Schedule_ID) is not null) and (fin_paymen0_.AD_Org_ID in ('FF80818134D2AA330134F1D03034277D', 'FF80818134D2AA330134F1D11B372783', 'FF80818133B7413E0133B71974AD28C6')) and (organizati11_.AD_Org_ID is null or organizati11_.IsActive = 'Y') and (fin_paymen0_.FIN_Payment_Scheduledetail_ID in ('4E84A0416B8F465EA21F372DD411AEA2') or 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(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%4E84A0416B8F465EA21F372DD411AEA2%') escape '|' or upper( 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) like upper('%26/3752%') escape '|' order by case when array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%4E84A0416B8F465EA21F372DD411AEA2%' 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-13 11:48:07
Duration: 2s250ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID = '037417A18FF6403684886EABBD4D5057';

Date: 2026-07-13 07:42:34
Duration: 2s377ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID = 'ECA5FA40027D4774A963617F20A182F0';

Date: 2026-07-13 08:11:38
Duration: 1s135ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select shipmentin0_.M_InOut_ID as m_inout_1_509_0_, shipmentin0_.AD_Client_ID as ad_clien2_509_0_, shipmentin0_.AD_Org_ID as ad_org_i3_509_0_, ( SELECT count(*) FROM c_bpartner as bp WHERE bp.c_bpartner_id = shipmentin0_.c_bpartner_id and ( select count(*) from probs_bp_observation as obs where obs.c_bpartner_id = bp.c_bpartner_id and obs.popupinout = 'Y') > 0) as formula34_0_, ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin0_.m_inout_id) from dual) as formula35_0_ from M_InOut shipmentin0_ where shipmentin0_.M_InOut_ID = '239264DBCFF1420D9D42E9DB86E5CF26';

Date: 2026-07-13 12:19:29
Duration: 1s103ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

select productsto0_.M_Product_Stock_V_ID as m_produc1_573_, productsto0_.AD_Client_ID as ad_clien2_573_, productsto0_.AD_Org_ID as ad_org_i3_573_, productsto0_.Isactive as isactive4_573_, productsto0_.Created as created5_573_, productsto0_.Createdby as createdb6_573_, productsto0_.Updated as updated7_573_, productsto0_.Updatedby as updatedb8_573_, productsto0_.M_Product_ID as m_produc9_573_, productsto0_.Qtyonhand as qtyonha10_573_, productsto0_.Qtyorderonhand as qtyorde11_573_, productsto0_.Preqtyonhand as preqtyo12_573_, productsto0_.Preqtyorderonhand as preqtyo13_573_, productsto0_.C_Uom_ID as c_uom_i14_573_, productsto0_.M_Product_Uom_ID as m_produ15_573_, productsto0_.M_Attributesetinstance_ID as m_attri16_573_, productsto0_.M_Locator_ID as m_locat17_573_, productsto0_.Stocked as stocked18_573_, productsto0_.M_Warehouse_ID as m_wareh19_573_, productsto0_.M_Refinventory_ID as m_refin20_573_ from M_Product_Stock_V productsto0_ left outer join M_Product product1_ on productsto0_.M_Product_ID = product1_.M_Product_ID where (upper(product1_.Name) like upper('%4243%') escape '|' or upper(product1_.Value) like upper('%4243%') escape '|' or upper(product1_.UPC) like upper('%4243%') escape '|' or upper(coalesce(to_char((product1_.Value || ' - ' || coalesce(to_char(( select producttrl2_.Name from M_Product_Trl producttrl2_ where producttrl2_.M_Product_ID = product1_.M_Product_ID and producttrl2_.AD_Language = 'es_ES')), to_char(product1_.Name), ''))), '')) like upper('%4243%') escape '|') and (productsto0_.AD_Org_ID in ('0', 'FF80818134D2AA330134F1D03034277D', 'FF80818134D2AA330134F1D11B372783', 'FF80818133B7413E0133B71974AD28C6')) and productsto0_.Isactive = 'Y' and (('184' in ('800051', '800052', '800096')) and product1_.Production = 'Y' and productsto0_.Stocked = 'N' or ('184' in ('800053', 'FF808181323E504701323E57E08D0017')) and product1_.Production = 'Y' or ('184' in ('170')) and product1_.IsStocked = 'Y' or ('184' in ('800092')) and product1_.IsPurchased = 'Y' or ('184' in ('169')) and (productsto0_.M_Warehouse_ID is null or productsto0_.M_Warehouse_ID in ( select organizati7_.M_Warehouse_ID from AD_Org_Warehouse organizati7_ where organizati7_.AD_Org_ID = 'FF80818133B7413E0133B71974AD28C6')) or '184' not in ('800051', '800052', '800053', 'FF808181323E504701323E57E08D0017', '800096', '170', '800092', '169')) and (productsto0_.AD_Client_ID in ('FF80818133B7413E0133B7164D6A0002', '0')) and productsto0_.Isactive = 'Y' order by product1_.Value, product1_.Name, product1_.M_Product_ID limit '76';

Date: 2026-07-13 08:21:03
Duration: 3s612ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select productsto0_.M_Product_Stock_V_ID as m_produc1_573_, productsto0_.AD_Client_ID as ad_clien2_573_, productsto0_.AD_Org_ID as ad_org_i3_573_, productsto0_.Isactive as isactive4_573_, productsto0_.Created as created5_573_, productsto0_.Createdby as createdb6_573_, productsto0_.Updated as updated7_573_, productsto0_.Updatedby as updatedb8_573_, productsto0_.M_Product_ID as m_produc9_573_, productsto0_.Qtyonhand as qtyonha10_573_, productsto0_.Qtyorderonhand as qtyorde11_573_, productsto0_.Preqtyonhand as preqtyo12_573_, productsto0_.Preqtyorderonhand as preqtyo13_573_, productsto0_.C_Uom_ID as c_uom_i14_573_, productsto0_.M_Product_Uom_ID as m_produ15_573_, productsto0_.M_Attributesetinstance_ID as m_attri16_573_, productsto0_.M_Locator_ID as m_locat17_573_, productsto0_.Stocked as stocked18_573_, productsto0_.M_Warehouse_ID as m_wareh19_573_, productsto0_.M_Refinventory_ID as m_refin20_573_ from M_Product_Stock_V productsto0_ left outer join M_Product product1_ on productsto0_.M_Product_ID = product1_.M_Product_ID where (upper(product1_.Name) like upper('%70192000%') escape '|' or upper(product1_.Value) like upper('%70192000%') escape '|' or upper(product1_.UPC) like upper('%70192000%') escape '|' or upper(coalesce(to_char((product1_.Value || ' - ' || coalesce(to_char(( select producttrl2_.Name from M_Product_Trl producttrl2_ where producttrl2_.M_Product_ID = product1_.M_Product_ID and producttrl2_.AD_Language = 'es_ES')), to_char(product1_.Name), ''))), '')) like upper('%70192000%') escape '|') and (productsto0_.AD_Org_ID in ('0', 'FF80818134D2AA330134F1D03034277D', 'FF80818134D2AA330134F1D11B372783', 'FF80818133B7413E0133B71974AD28C6')) and productsto0_.Isactive = 'Y' and (('184' in ('800051', '800052', '800096')) and product1_.Production = 'Y' and productsto0_.Stocked = 'N' or ('184' in ('800053', 'FF808181323E504701323E57E08D0017')) and product1_.Production = 'Y' or ('184' in ('170')) and product1_.IsStocked = 'Y' or ('184' in ('800092')) and product1_.IsPurchased = 'Y' or ('184' in ('169')) and (productsto0_.M_Warehouse_ID is null or productsto0_.M_Warehouse_ID in ( select organizati7_.M_Warehouse_ID from AD_Org_Warehouse organizati7_ where organizati7_.AD_Org_ID = 'FF80818133B7413E0133B71974AD28C6')) or '184' not in ('800051', '800052', '800053', 'FF808181323E504701323E57E08D0017', '800096', '170', '800092', '169')) and (productsto0_.AD_Client_ID in ('FF80818133B7413E0133B7164D6A0002', '0')) and productsto0_.Isactive = 'Y' order by product1_.Value, product1_.Name, product1_.M_Product_ID limit '76';

Date: 2026-07-13 08:28:30
Duration: 3s511ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select productsto0_.M_Product_Stock_V_ID as m_produc1_573_, productsto0_.AD_Client_ID as ad_clien2_573_, productsto0_.AD_Org_ID as ad_org_i3_573_, productsto0_.Isactive as isactive4_573_, productsto0_.Created as created5_573_, productsto0_.Createdby as createdb6_573_, productsto0_.Updated as updated7_573_, productsto0_.Updatedby as updatedb8_573_, productsto0_.M_Product_ID as m_produc9_573_, productsto0_.Qtyonhand as qtyonha10_573_, productsto0_.Qtyorderonhand as qtyorde11_573_, productsto0_.Preqtyonhand as preqtyo12_573_, productsto0_.Preqtyorderonhand as preqtyo13_573_, productsto0_.C_Uom_ID as c_uom_i14_573_, productsto0_.M_Product_Uom_ID as m_produ15_573_, productsto0_.M_Attributesetinstance_ID as m_attri16_573_, productsto0_.M_Locator_ID as m_locat17_573_, productsto0_.Stocked as stocked18_573_, productsto0_.M_Warehouse_ID as m_wareh19_573_, productsto0_.M_Refinventory_ID as m_refin20_573_ from M_Product_Stock_V productsto0_ left outer join M_Product product1_ on productsto0_.M_Product_ID = product1_.M_Product_ID where (upper(product1_.Name) like upper('%70192000%') escape '|' or upper(product1_.Value) like upper('%70192000%') escape '|' or upper(product1_.UPC) like upper('%70192000%') escape '|' or upper(coalesce(to_char((product1_.Value || ' - ' || coalesce(to_char(( select producttrl2_.Name from M_Product_Trl producttrl2_ where producttrl2_.M_Product_ID = product1_.M_Product_ID and producttrl2_.AD_Language = 'es_ES')), to_char(product1_.Name), ''))), '')) like upper('%70192000%') escape '|') and (productsto0_.AD_Org_ID in ('0', 'FF80818134D2AA330134F1D03034277D', 'FF80818134D2AA330134F1D11B372783', 'FF80818133B7413E0133B71974AD28C6')) and productsto0_.Isactive = 'Y' and (('184' in ('800051', '800052', '800096')) and product1_.Production = 'Y' and productsto0_.Stocked = 'N' or ('184' in ('800053', 'FF808181323E504701323E57E08D0017')) and product1_.Production = 'Y' or ('184' in ('170')) and product1_.IsStocked = 'Y' or ('184' in ('800092')) and product1_.IsPurchased = 'Y' or ('184' in ('169')) and (productsto0_.M_Warehouse_ID is null or productsto0_.M_Warehouse_ID in ( select organizati7_.M_Warehouse_ID from AD_Org_Warehouse organizati7_ where organizati7_.AD_Org_ID = 'FF80818133B7413E0133B71974AD28C6')) or '184' not in ('800051', '800052', '800053', 'FF808181323E504701323E57E08D0017', '800096', '170', '800092', '169')) and (productsto0_.AD_Client_ID in ('FF80818133B7413E0133B7164D6A0002', '0')) and productsto0_.Isactive = 'Y' order by product1_.Value, product1_.Name, product1_.M_Product_ID limit '76';

Date: 2026-07-13 08:28:53
Duration: 3s449ms
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 1 < 0 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', 'FF80818133B7413E0133B7164D6A0002')) and (fin_paymen0_.FIN_Payment_Detail_ID is null or fin_paymen13_.Fin_Payment_ID = '85C76D71726F489B9AEE39AEFB04E4FF') and (coalesce(fin_paymen6_.Fin_Payment_Schedule_ID, fin_paymen2_.Fin_Payment_Schedule_ID) is not null) and (fin_paymen0_.AD_Org_ID in ('FF80818134D2AA330134F1D03034277D', 'FF80818134D2AA330134F1D11B372783', 'FF80818133B7413E0133B71974AD28C6')) and (organizati11_.AD_Org_ID is null or organizati11_.IsActive = 'Y') and (fin_paymen0_.FIN_Payment_Scheduledetail_ID in ('50080F2CF848449A9C272C07D8160B7E', '55A0EACA93BC462BBA6A8D447CD477F9', '6E2FFA092E7240909F4CA068A9CD8DAC', '064C2FF19F5E460CAACD8F8E10DF5055') or 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(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%50080F2CF848449A9C272C07D8160B7E%') escape '|' or upper(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%55A0EACA93BC462BBA6A8D447CD477F9%') escape '|' or upper(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%6E2FFA092E7240909F4CA068A9CD8DAC%') escape '|' or upper(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%064C2FF19F5E460CAACD8F8E10DF5055%') escape '|' or upper( 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) like upper('%26/37%') escape '|' order by case when array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%50080F2CF848449A9C272C07D8160B7E%' or array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%55A0EACA93BC462BBA6A8D447CD477F9%' or array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%6E2FFA092E7240909F4CA068A9CD8DAC%' or array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%064C2FF19F5E460CAACD8F8E10DF5055%' 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-13 11:45:12
Duration: 2s268ms
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 1 < 0 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', 'FF80818133B7413E0133B7164D6A0002')) and (fin_paymen0_.FIN_Payment_Detail_ID is null or fin_paymen13_.Fin_Payment_ID = '85C76D71726F489B9AEE39AEFB04E4FF') and (coalesce(fin_paymen6_.Fin_Payment_Schedule_ID, fin_paymen2_.Fin_Payment_Schedule_ID) is not null) and (fin_paymen0_.AD_Org_ID in ('FF80818134D2AA330134F1D03034277D', 'FF80818134D2AA330134F1D11B372783', 'FF80818133B7413E0133B71974AD28C6')) and (organizati11_.AD_Org_ID is null or organizati11_.IsActive = 'Y') and (fin_paymen0_.FIN_Payment_Scheduledetail_ID in ('50080F2CF848449A9C272C07D8160B7E', '55A0EACA93BC462BBA6A8D447CD477F9', '6E2FFA092E7240909F4CA068A9CD8DAC', '064C2FF19F5E460CAACD8F8E10DF5055') or 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(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%50080F2CF848449A9C272C07D8160B7E%') escape '|' or upper(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%55A0EACA93BC462BBA6A8D447CD477F9%') escape '|' or upper(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%6E2FFA092E7240909F4CA068A9CD8DAC%') escape '|' or upper(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%064C2FF19F5E460CAACD8F8E10DF5055%') escape '|' or upper( 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) like upper('%26/3748%') escape '|' order by case when array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%50080F2CF848449A9C272C07D8160B7E%' or array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%55A0EACA93BC462BBA6A8D447CD477F9%' or array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%6E2FFA092E7240909F4CA068A9CD8DAC%' or array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%064C2FF19F5E460CAACD8F8E10DF5055%' 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-13 11:45:13
Duration: 2s239ms
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 1 < 0 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', 'FF80818133B7413E0133B7164D6A0002')) and (fin_paymen0_.FIN_Payment_Detail_ID is null or fin_paymen13_.Fin_Payment_ID = '85C76D71726F489B9AEE39AEFB04E4FF') and (coalesce(fin_paymen6_.Fin_Payment_Schedule_ID, fin_paymen2_.Fin_Payment_Schedule_ID) is not null) and (fin_paymen0_.AD_Org_ID in ('FF80818134D2AA330134F1D03034277D', 'FF80818134D2AA330134F1D11B372783', 'FF80818133B7413E0133B71974AD28C6')) and (organizati11_.AD_Org_ID is null or organizati11_.IsActive = 'Y') and (fin_paymen0_.FIN_Payment_Scheduledetail_ID in ('50080F2CF848449A9C272C07D8160B7E', '55A0EACA93BC462BBA6A8D447CD477F9', '6E2FFA092E7240909F4CA068A9CD8DAC', '064C2FF19F5E460CAACD8F8E10DF5055') or 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(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%50080F2CF848449A9C272C07D8160B7E%') escape '|' or upper(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%55A0EACA93BC462BBA6A8D447CD477F9%') escape '|' or upper(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%6E2FFA092E7240909F4CA068A9CD8DAC%') escape '|' or upper(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%064C2FF19F5E460CAACD8F8E10DF5055%') escape '|' or upper( 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) like upper('%26/374%') escape '|' order by case when array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%50080F2CF848449A9C272C07D8160B7E%' or array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%55A0EACA93BC462BBA6A8D447CD477F9%' or array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%6E2FFA092E7240909F4CA068A9CD8DAC%' or array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%064C2FF19F5E460CAACD8F8E10DF5055%' 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-13 11:45:13
Duration: 2s190ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo