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', 'AF26C99F1F5B4BDA9ADE33281C824310', 'A74D5584155C4F2ABB29197BEEAB6AEF', 'A0EA6676758A431D97D0EF94B42A67DF', '999BC0DA6F604831BCE836ACC899B166', '8194420624964FAC9C7553A635DC07AC', '7030BD9DBC1F4E9DB35DA9639DAE294A', '6BFB63A78EB74D33BCF96CA70B345A32', '4DA771C0639B4722ABB73776386246C7', '44283D5184804405B5322523206369DF', '2B3669E169F94F159126C4FD0783410C', '0DECD474EEE04C9288CCC2EF80CB9067', 'D77F3EC2F2FB4F0E8167AE5A720DA84B', 'CF4FE921173D4296A13612C39A226ABB', '974C3A378CBC492C8AC100C35B262D28', '92FB4AA6CF8C4016ABCF18B511F990E4', '902BE349A14C46C484FDE3AA4CA87FD1', '70E06199D44142D2AC0425EA5A0E4E25', '6D1A505D0A874F5B8EFD2CADD6542C78', '57CDF98D9C954D519E6902F8AE16AB0E', '40A7E834ED004BC0BC56E8EBC39E3F96', '3EB2D430287B4C578B13E33CD71028B4', '253A1863F8894B348BBC8235B3B7B4FD', 'D1BBB239C3BA4FCE80C09CA8F3AC90DC', 'CBCA234DA9B74D84B2165C1AD8183CBD', 'B203A5E9D8784D56807F6C07C968B979', 'AF9059E7C4F14AB0877DF403E828905D', '9D60729BADAE4DFEBB393723AA46A9B8', '907395AA40CD4274AECE7E26691CF41E', '2F08189EB11D4B95B70C015C9DD6077C', 'ECA5FA40027D4774A963617F20A182F0', 'C9A66C1D73CD4EAA9A653BC3A834EC8B', 'BF731ED9A22444D69932D55067CCE293', 'BA0DD37FFF49405AB4AC143B9E65AD0A', 'A66132309A6A422BA51FC2B90F9081E2', 'A217C94B57894F7FA59B791FBB7E210D', '9E80B16534FA4450830D2F6F953357D1', '9BA6EC0729E34B88997539E830B001EF', '8577819CD29C40C1A59308306AF3C689', '7FFD4129BE8B43578A912CBF97F0562F', '623A6A2853BE4171BA1F26ED4A75F35A', '47FF59181BC04F739094A7823B20C42A', '2FBF094E5F0B49CDB5A6ABE3A5F4D886', '239264DBCFF1420D9D42E9DB86E5CF26', '20101CF85949484FB7BCFB2AE3C88768', '0C86D437B7AB46B2A17B6865000E794B', '037417A18FF6403684886EABBD4D5057', 'C88F465EDEA34CA39868816F4B96B901', '5ABD202EBA7A425AA48CE424BB714D79', 'FAE634ADA07B4BA0A943FCBC71269F1C');

Date: 2026-07-16 13:53:29
Duration: 47s978ms
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 ('BBC8993C9B36449E95538F8BC635937D', 'BB1C633AA69344E3B614CE64E6E5A73F', 'AEF1C3FCAF094D5F942C80E36690146D', '9C0E76DFFBDE45EBA29593B5EFAD52B5', '9B346B691297488E9962D0EC97A6CDB0', '880CE6172F6B48EA9F796E272E126120', '78B7473F77A84DD7A019891D46AB9004', '5C1C8F2C981D4C9BAE7419CD0A5C94C4', '5279BE3A457A4C78941D40E83F9A614C', '444493353F944B54B46CABE5105A8385', '4334DAD2E4834930A087E1D2C413310D', '340559052E2C4EE0BEDEB94D9100AFC1', '07920CA1DF2E4692823C50BA3116F922', '051E8F6455E94FF3B4CB64A83D6D876E', 'F7B1713212A04ED894689CA1528F6415', 'E5AF9004D37D4CA1A45FA90E52E6D6B6', 'E081848A3FAC4E1DB6638C9B2257ED53', 'B5776043334E4F0B95A45E7E9ADB6CB3', 'B4DEB76EB3DE440AA03884C3AD5BC3A7', 'A613569C616B4400A67CF0D2E98E25B8', '9DE3E845BFFC4A90A3DB21B8ECA3AF83', '9CBAA873B64242F48DEE11BD7BDAB6A1', '7B96CE62188341F8A9F65807E5BDE3CD', '7AC5E7AF6F744819B5866D21F11E5D98', '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');

Date: 2026-07-16 10:52:07
Duration: 47s687ms
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 ('CEA9CD52250B4B29B846C042C96F2922', 'C73F04E916A542A6A7C6BC804ECAA073', 'A727D6966444476BA22F8B1311B551A3', '9E2ACDE62C4148E19F2FE87DCFAC03F8', '8D26BC165048413D88C1685253901CD6', '5E9BAB4472444E47A9E6EBA94854EFC3', '4D2AAFB1CFDE47549AC2FE79A4F9FB1A', 'D016BF162A0D44C89BB2E6990520C605', 'ACFDB325EB4F4DF8BF58378D22D9F44F', '937405A6B3724C9A83634E5506AD705A', '4491D6600BF14B59B3CD6CF7ABBD15DA', '2EDE7CF7A16A477E8410E2BAA1926C37', '22BC19172EF541DDA63167D80D768B04', 'EB82D8DBCF924F68A64FE58482C75215', '991C37144AC14AFCBF08A9EC3C82F3D3', '722FDF555D484CB5988814C95EB555B3', '62A7795968BB46E798B6E10EB46FAD1C', 'FDEFE41886A84F968C0EADEED98AD68A', 'DF3FAA6669134BE583F1B43CE2FCD4EE', 'DB96D645ED944C42922CACB8EA52035B', 'C3C80C6B41E44E57995481EE244760BE', 'BA08B5F7E11646858B2F33220E9B9185', 'AD0AA61E1DC245A599E0F4DF70DB8383', '932529E707E34CB4A3ACF355958E7D64', '9099F11C2EE14F519D6DCA39EE22C9C5', '8BAA962A033249688B9F67D4C6DE2576', '5608C842F1734D239A116534E2882093', '32105F26116F4B27AE11F14975663678', '2C5ACB9469B3491FB15AB1C8A35A3EE9', '1927365C95C7490DA32C4CDF2EB75C0C', 'FB82FC2562A940338FD986F8F0269025', '75D9B11D98FF4665BB603C010156228A', '3BC6405AA4E44A549C9ACE2FDDF91C63', 'D75BD6F5F66B44A5990103A873EAD7D8', 'B61FB40211F548B0AA9D0C4AAF09C554', 'A99C8AEEE2C943FBA55966D4C5E31CB8', '9366F4352F624DEB9C23C52FCB18D321', '83106130B1D3435387E43EF91FC7B5A2', '25AB778E4A0F443981A3F6F4546E75F4', '1406F359228A43E39D0A769EC593546F', 'FA61AF6FAAD44AB5A6D03C15D4E3FA9C', 'D674DE7912FB4C18B9E970DDF4247484', 'B633C5444578453888DE901687603DAB', '34163C4142ED4F2CBDF60FF1CDACE2D6', '1E461566C8C748719C8E4DC8592F7698', '1BDBD8AA6E5D40178C7DCF53AA759250', '194F1E050D33409D9EA355391AAD2E01', '9073B8C50C8042F59C68214375FF34F7', '7A6F82E9F9E1442A8C0B1F993EA3F25F', '5CA665CBF27249A7AC2BB3B134D5F308');

Date: 2026-07-16 10:36:29
Duration: 47s673ms
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 = '6BFB63A78EB74D33BCF96CA70B345A32';

Date: 2026-07-16 13:48:18
Duration: 2s315ms
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 = 'A0EA6676758A431D97D0EF94B42A67DF';

Date: 2026-07-16 08:06:53
Duration: 1s517ms
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 = '7030BD9DBC1F4E9DB35DA9639DAE294A';

Date: 2026-07-16 10:50:16
Duration: 1s67ms
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 = 'E69E2D002CCB4024A16DD21B1C0522FB') 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 ('371C217A299F49F38CD125AAF533554B', 'CC3BE66466C94DD5B1855A24ECFB8BF4', 'F447124FDA8747EF995CB7FA91FB9435', '036846AE393F4045BDE3A0BF7B0404A5', '5E059F3EDBC74A22A99CCB939F8A0F74', 'B260BF3761554D6DBAEEFBA5002FB650', 'E4BE732D587D40B4A952BA7A553C93AB') 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('%371C217A299F49F38CD125AAF533554B%') escape '|' or upper(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%CC3BE66466C94DD5B1855A24ECFB8BF4%') escape '|' or upper(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%F447124FDA8747EF995CB7FA91FB9435%') escape '|' or upper(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%036846AE393F4045BDE3A0BF7B0404A5%') escape '|' or upper(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%5E059F3EDBC74A22A99CCB939F8A0F74%') escape '|' or upper(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%B260BF3761554D6DBAEEFBA5002FB650%') escape '|' or upper(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%E4BE732D587D40B4A952BA7A553C93AB%') 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/379%') escape '|' order by case when array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%371C217A299F49F38CD125AAF533554B%' or array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%CC3BE66466C94DD5B1855A24ECFB8BF4%' or array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%F447124FDA8747EF995CB7FA91FB9435%' or array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%036846AE393F4045BDE3A0BF7B0404A5%' or array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%5E059F3EDBC74A22A99CCB939F8A0F74%' or array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%B260BF3761554D6DBAEEFBA5002FB650%' or array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%E4BE732D587D40B4A952BA7A553C93AB%' 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 10:50:54
Duration: 2s156ms
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 = 'E69E2D002CCB4024A16DD21B1C0522FB') 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 ('371C217A299F49F38CD125AAF533554B', '46B3AAC3A06B4ED793016C4E5C54E704', '7037B0EC9AA9481E92BB79013794D122', '9548EA89B074486593E4DB6ACF8C1F7C', 'D154E2095B75489AA5779DB1C1B1EA53', 'E425E7CD846B4FDF9E6488B94D9EF109', 'F3CF3A9446AF497EBF31A19599BA946F') 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('%371C217A299F49F38CD125AAF533554B%') escape '|' or upper(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%F3CF3A9446AF497EBF31A19599BA946F%') escape '|' or upper(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%F3CF3A9446AF497EBF31A19599BA946F%') escape '|' or upper(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%F3CF3A9446AF497EBF31A19599BA946F%') escape '|' or upper(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%F3CF3A9446AF497EBF31A19599BA946F%') escape '|' or upper(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%F3CF3A9446AF497EBF31A19599BA946F%') escape '|' or upper(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%F3CF3A9446AF497EBF31A19599BA946F%') 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('%C3580%') escape '|' order by case when array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%371C217A299F49F38CD125AAF533554B%' or array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%46B3AAC3A06B4ED793016C4E5C54E704%' or array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%7037B0EC9AA9481E92BB79013794D122%' or array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%9548EA89B074486593E4DB6ACF8C1F7C%' or array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%D154E2095B75489AA5779DB1C1B1EA53%' or array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%E425E7CD846B4FDF9E6488B94D9EF109%' or array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%F3CF3A9446AF497EBF31A19599BA946F%' 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 10:48:57
Duration: 2s128ms
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 = 'E69E2D002CCB4024A16DD21B1C0522FB') 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 ('371C217A299F49F38CD125AAF533554B', '46B3AAC3A06B4ED793016C4E5C54E704', '7037B0EC9AA9481E92BB79013794D122', '9548EA89B074486593E4DB6ACF8C1F7C', 'D154E2095B75489AA5779DB1C1B1EA53', 'E425E7CD846B4FDF9E6488B94D9EF109', 'F3CF3A9446AF497EBF31A19599BA946F') 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('%371C217A299F49F38CD125AAF533554B%') escape '|' or upper(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%F3CF3A9446AF497EBF31A19599BA946F%') escape '|' or upper(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%F3CF3A9446AF497EBF31A19599BA946F%') escape '|' or upper(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%F3CF3A9446AF497EBF31A19599BA946F%') escape '|' or upper(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%F3CF3A9446AF497EBF31A19599BA946F%') escape '|' or upper(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%F3CF3A9446AF497EBF31A19599BA946F%') escape '|' or upper(array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',')) like upper('%F3CF3A9446AF497EBF31A19599BA946F%') 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('%C26/3580%') escape '|' order by case when array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%371C217A299F49F38CD125AAF533554B%' or array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%46B3AAC3A06B4ED793016C4E5C54E704%' or array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%7037B0EC9AA9481E92BB79013794D122%' or array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%9548EA89B074486593E4DB6ACF8C1F7C%' or array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%D154E2095B75489AA5779DB1C1B1EA53%' or array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%E425E7CD846B4FDF9E6488B94D9EF109%' or array_to_string(array_agg(fin_paymen0_.FIN_Payment_Scheduledetail_ID), ',') like '%F3CF3A9446AF497EBF31A19599BA946F%' 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 10:48:59
Duration: 2s123ms
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', 'FF80818133B7413E0133B7164D6A0002')) and (fin_paymen0_.AD_Org_ID in ('0', 'FF80818134D2AA330134F1D03034277D', 'FF80818134D2AA330134F1D11B372783', 'FF80818133B7413E0133B71974AD28C6')) and (fin_paymen0_.FIN_Payment_Detail_ID is null or fin_paymen13_.Fin_Payment_ID = 'E69E2D002CCB4024A16DD21B1C0522FB') 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 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' offset '400';

Date: 2026-07-16 10:48:42
Duration: 2s29ms
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', 'FF80818133B7413E0133B7164D6A0002')) and (fin_paymen0_.AD_Org_ID in ('0', 'FF80818134D2AA330134F1D03034277D', 'FF80818134D2AA330134F1D11B372783', 'FF80818133B7413E0133B71974AD28C6')) and (fin_paymen0_.FIN_Payment_Detail_ID is null or fin_paymen13_.Fin_Payment_ID = 'E69E2D002CCB4024A16DD21B1C0522FB') 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 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' offset '100';

Date: 2026-07-16 10:48:35
Duration: 1s999ms
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', 'FF80818133B7413E0133B7164D6A0002')) and (fin_paymen0_.AD_Org_ID in ('0', 'FF80818134D2AA330134F1D03034277D', 'FF80818134D2AA330134F1D11B372783', 'FF80818133B7413E0133B71974AD28C6')) and (fin_paymen0_.FIN_Payment_Detail_ID is null or fin_paymen13_.Fin_Payment_ID = 'E69E2D002CCB4024A16DD21B1C0522FB') 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 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' offset '500';

Date: 2026-07-16 10:48:45
Duration: 1s954ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo