ad_column_identifier_std ('fin_financial_account', fa.fin_financial_account_id) AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'La cuenta financiera ' || fa.name || ' descuadra ' || fa.currentbalance || ' / ' || (fa.initialbalance + ( SELECT sum (depositamt) - sum (paymentamt) FROM fin_finacc_transaction WHERE fa.fin_financial_account_id = fin_finacc_transaction.fin_financial_account_id AND fin_finacc_transaction.processed = 'Y')) || 'DIF: ' || fa.currentbalance - (fa.initialbalance + ( SELECT sum (depositamt) - sum (paymentamt) FROM fin_finacc_transaction WHERE fa.fin_financial_account_id = fin_finacc_transaction.fin_financial_account_id AND fin_finacc_transaction.processed = 'Y')) AS description, 'Y' AS isActive, 0 AS ad_org_id, fa.ad_client_id AS ad_client_id, now () AS created, 0 AS createdBy, now () AS updated, 0 AS updatedBy FROM fin_financial_account fa WHERE fa.currentbalance <> fa.initialbalance + ( SELECT sum (depositamt) - sum (paymentamt) FROM fin_finacc_transaction WHERE fa.fin_financial_account_id = fin_finacc_transaction.fin_financial_account_id AND fin_finacc_transaction.processed = 'Y')) AAA WHERE NOT EXISTS ( SELECT 1 FROM ad_alert a WHERE a.ad_alertrule_id = $1 AND a.referencekey_id = aaa.referencekey_id AND COALESCE (a.status, 'NEW') != 'SOLVED');

[ Date: 2026-07-18 09:11:26 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]

ad_column_identifier_std ('fin_financial_account', fa.fin_financial_account_id) AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'La cuenta financiera ' || fa.name || ' descuadra ' || fa.currentbalance || ' / ' || (fa.initialbalance + ( SELECT sum (depositamt) - sum (paymentamt) FROM fin_finacc_transaction WHERE fa.fin_financial_account_id = fin_finacc_transaction.fin_financial_account_id AND fin_finacc_transaction.processed = 'Y')) || 'DIF: ' || fa.currentbalance - (fa.initialbalance + ( SELECT sum (depositamt) - sum (paymentamt) FROM fin_finacc_transaction WHERE fa.fin_financial_account_id = fin_finacc_transaction.fin_financial_account_id AND fin_finacc_transaction.processed = 'Y')) AS description, 'Y' AS isActive, 0 AS ad_org_id, fa.ad_client_id AS ad_client_id, now () AS created, 0 AS createdBy, now () AS updated, 0 AS updatedBy FROM fin_financial_account fa WHERE fa.currentbalance <> fa.initialbalance + ( SELECT sum (depositamt) - sum (paymentamt) FROM fin_finacc_transaction WHERE fa.fin_financial_account_id = fin_finacc_transaction.fin_financial_account_id AND fin_finacc_transaction.processed = 'Y')) AAA WHERE NOT EXISTS ( SELECT 1 FROM ad_alert a WHERE a.ad_alertrule_id = $1 AND a.referencekey_id = aaa.referencekey_id AND COALESCE (a.status, 'NEW') != 'SOLVED');

[ Date: 2026-07-18 09:23:37 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]

ad_column_identifier_std ('fin_financial_account', fa.fin_financial_account_id) AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'La cuenta financiera ' || fa.name || ' descuadra ' || fa.currentbalance || ' / ' || (fa.initialbalance + ( SELECT sum (depositamt) - sum (paymentamt) FROM fin_finacc_transaction WHERE fa.fin_financial_account_id = fin_finacc_transaction.fin_financial_account_id AND fin_finacc_transaction.processed = 'Y')) || 'DIF: ' || fa.currentbalance - (fa.initialbalance + ( SELECT sum (depositamt) - sum (paymentamt) FROM fin_finacc_transaction WHERE fa.fin_financial_account_id = fin_finacc_transaction.fin_financial_account_id AND fin_finacc_transaction.processed = 'Y')) AS description, 'Y' AS isActive, 0 AS ad_org_id, fa.ad_client_id AS ad_client_id, now () AS created, 0 AS createdBy, now () AS updated, 0 AS updatedBy FROM fin_financial_account fa WHERE fa.currentbalance <> fa.initialbalance + ( SELECT sum (depositamt) - sum (paymentamt) FROM fin_finacc_transaction WHERE fa.fin_financial_account_id = fin_finacc_transaction.fin_financial_account_id AND fin_finacc_transaction.processed = 'Y')) AAA WHERE NOT EXISTS ( SELECT 1 FROM ad_alert a WHERE a.ad_alertrule_id = $1 AND a.referencekey_id = aaa.referencekey_id AND COALESCE (a.status, 'NEW') != 'SOLVED');

[ Date: 2026-07-18 09:26:29 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]

INSERT INTO C_Invoice (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, IsSOTrx, DocumentNo, DocStatus, DocAction, Processing, Processed, Posted, C_DocType_ID, C_DocTypeTarget_ID, Description, IsPrinted, DateInvoiced, DateAcct, C_BPartner_ID, C_BPartner_Location_ID, POReference, IsDiscountPrinted, C_Currency_ID, C_PaymentTerm_ID, M_PriceList_ID, IsTaxIncluded, CreateFrom, GenerateTo, CopyFrom, IsSelfService, Ispaid, EM_Einv_Generated, Totalpaid, EM_Einv_Sent, OutstandingAmt, DaysTillDue, DueAmt, FIN_Paymentmethod_ID, Calculate_Promotions, EM_APRM_Addpayment, Iscashvat, EM_APRM_Processinvoice, Prepaymentamt, Createfromorders, Createfrominouts, EM_Advcrm_Newactivity, Paidamtatinvoicing, EM_Obpos_Rounding_Amount, EM_Aeatsii_Send, EM_Aeatsii_Issent, EM_Aeatsii_Fecha_Operacion, EM_Prouti_Recalculate_Price, EM_Aeatsii_Clave_Tipo_Fc, EM_Ml_Select_Product, EM_Aeatsii_Error_Registral, EM_Aeatsii_Modif, EM_Aeatsii_Modified, EM_Aeatsii_Fecha_Reg_Cont, EM_Aeatsii_Dup, EM_Aeatsii_Unsubscribe, EM_Aeatsii_Multi_Dua, EM_Aeatsii_Autofactura, EM_Aeatsii_Isauthorization, EM_Priuti_Createpurchinv, EM_Priuti_Generated, EM_Prges_Expediente_ID, EM_Prges_Annotation_ID, EM_Prges_Record_Number, EM_Priuti_Status_Of_Review, EM_Prges_Grantotal, EM_Priuti_Validate, EM_Priuti_Start_Review, EM_Prges_Poreference, em_cactl_createfromship, C_Invoice_ID) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77);

[ Date: 2026-07-18 11:10:05 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]

ad_column_identifier_std ('fin_financial_account', fa.fin_financial_account_id) AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'La cuenta financiera ' || fa.name || ' descuadra ' || fa.currentbalance || ' / ' || (fa.initialbalance + ( SELECT sum (depositamt) - sum (paymentamt) FROM fin_finacc_transaction WHERE fa.fin_financial_account_id = fin_finacc_transaction.fin_financial_account_id AND fin_finacc_transaction.processed = 'Y')) || 'DIF: ' || fa.currentbalance - (fa.initialbalance + ( SELECT sum (depositamt) - sum (paymentamt) FROM fin_finacc_transaction WHERE fa.fin_financial_account_id = fin_finacc_transaction.fin_financial_account_id AND fin_finacc_transaction.processed = 'Y')) AS description, 'Y' AS isActive, 0 AS ad_org_id, fa.ad_client_id AS ad_client_id, now () AS created, 0 AS createdBy, now () AS updated, 0 AS updatedBy FROM fin_financial_account fa WHERE fa.currentbalance <> fa.initialbalance + ( SELECT sum (depositamt) - sum (paymentamt) FROM fin_finacc_transaction WHERE fa.fin_financial_account_id = fin_finacc_transaction.fin_financial_account_id AND fin_finacc_transaction.processed = 'Y')) AAA WHERE NOT EXISTS ( SELECT 1 FROM ad_alert a WHERE a.ad_alertrule_id = $1 AND a.referencekey_id = aaa.referencekey_id AND COALESCE (a.status, 'NEW') != 'SOLVED');

[ Date: 2026-07-18 11:16:21 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]

UPDATE C_Order SET Updated = $1, C_PaymentTerm_ID = $2, InvoiceRule = $3, DeliveryRule = $4, DeliveryViaRule = $5, M_Warehouse_ID = $6 WHERE C_Order_ID = $7;

[ Date: 2026-07-18 11:35:16 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]

ad_column_identifier_std ('fin_financial_account', fa.fin_financial_account_id) AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'La cuenta financiera ' || fa.name || ' descuadra ' || fa.currentbalance || ' / ' || (fa.initialbalance + ( SELECT sum (depositamt) - sum (paymentamt) FROM fin_finacc_transaction WHERE fa.fin_financial_account_id = fin_finacc_transaction.fin_financial_account_id AND fin_finacc_transaction.processed = 'Y')) || 'DIF: ' || fa.currentbalance - (fa.initialbalance + ( SELECT sum (depositamt) - sum (paymentamt) FROM fin_finacc_transaction WHERE fa.fin_financial_account_id = fin_finacc_transaction.fin_financial_account_id AND fin_finacc_transaction.processed = 'Y')) AS description, 'Y' AS isActive, 0 AS ad_org_id, fa.ad_client_id AS ad_client_id, now () AS created, 0 AS createdBy, now () AS updated, 0 AS updatedBy FROM fin_financial_account fa WHERE fa.currentbalance <> fa.initialbalance + ( SELECT sum (depositamt) - sum (paymentamt) FROM fin_finacc_transaction WHERE fa.fin_financial_account_id = fin_finacc_transaction.fin_financial_account_id AND fin_finacc_transaction.processed = 'Y')) AAA WHERE NOT EXISTS ( SELECT 1 FROM ad_alert a WHERE a.ad_alertrule_id = $1 AND a.referencekey_id = aaa.referencekey_id AND COALESCE (a.status, 'NEW') != 'SOLVED');

[ Date: 2026-07-18 11:45:34 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]

UPDATE m_requisitionline rl SET em_cactl_consumption = cactl_calculate_consumption (rl.m_product_id, rl.ad_org_id, rl.ad_client_id) FROM m_requisition r WHERE rl.reqstatus = 'O' AND rl.m_requisition_id = r.m_requisition_id AND r.docstatus = 'CO';

[ Date: 2026-07-18 15:21:09 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

UPDATE m_requisitionline rl SET em_cactl_consumption = cactl_calculate_consumption (rl.m_product_id, rl.ad_org_id, rl.ad_client_id) FROM m_requisition r WHERE rl.reqstatus = 'O' AND rl.m_requisition_id = r.m_requisition_id AND r.docstatus = 'CO';

[ Date: 2026-07-18 16:21:08 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

UPDATE m_requisitionline rl SET em_cactl_consumption = cactl_calculate_consumption (rl.m_product_id, rl.ad_org_id, rl.ad_client_id) FROM m_requisition r WHERE rl.reqstatus = 'O' AND rl.m_requisition_id = r.m_requisition_id AND r.docstatus = 'CO';

[ Date: 2026-07-18 17:20:59 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

UPDATE m_requisitionline rl SET em_cactl_consumption = cactl_calculate_consumption (rl.m_product_id, rl.ad_org_id, rl.ad_client_id) FROM m_requisition r WHERE rl.reqstatus = 'O' AND rl.m_requisition_id = r.m_requisition_id AND r.docstatus = 'CO';

[ Date: 2026-07-18 18:20:59 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

UPDATE m_requisitionline rl SET em_cactl_consumption = cactl_calculate_consumption (rl.m_product_id, rl.ad_org_id, rl.ad_client_id) FROM m_requisition r WHERE rl.reqstatus = 'O' AND rl.m_requisition_id = r.m_requisition_id AND r.docstatus = 'CO';

[ Date: 2026-07-18 20:20:54 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

UPDATE m_requisitionline rl SET em_cactl_consumption = cactl_calculate_consumption (rl.m_product_id, rl.ad_org_id, rl.ad_client_id) FROM m_requisition r WHERE rl.reqstatus = 'O' AND rl.m_requisition_id = r.m_requisition_id AND r.docstatus = 'CO';

[ Date: 2026-07-18 19:20:54 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

UPDATE m_requisitionline rl SET em_cactl_consumption = cactl_calculate_consumption (rl.m_product_id, rl.ad_org_id, rl.ad_client_id) FROM m_requisition r WHERE rl.reqstatus = 'O' AND rl.m_requisition_id = r.m_requisition_id AND r.docstatus = 'CO';

[ Date: 2026-07-18 21:20:54 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

UPDATE m_requisitionline rl SET em_cactl_consumption = cactl_calculate_consumption (rl.m_product_id, rl.ad_org_id, rl.ad_client_id) FROM m_requisition r WHERE rl.reqstatus = 'O' AND rl.m_requisition_id = r.m_requisition_id AND r.docstatus = 'CO';

[ Date: 2026-07-18 12:20:50 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

UPDATE m_requisitionline rl SET em_cactl_consumption = cactl_calculate_consumption (rl.m_product_id, rl.ad_org_id, rl.ad_client_id) FROM m_requisition r WHERE rl.reqstatus = 'O' AND rl.m_requisition_id = r.m_requisition_id AND r.docstatus = 'CO';

[ Date: 2026-07-18 11:20:50 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

UPDATE m_requisitionline rl SET em_cactl_consumption = cactl_calculate_consumption (rl.m_product_id, rl.ad_org_id, rl.ad_client_id) FROM m_requisition r WHERE rl.reqstatus = 'O' AND rl.m_requisition_id = r.m_requisition_id AND r.docstatus = 'CO';

[ Date: 2026-07-18 13:20:49 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

UPDATE m_requisitionline rl SET em_cactl_consumption = cactl_calculate_consumption (rl.m_product_id, rl.ad_org_id, rl.ad_client_id) FROM m_requisition r WHERE rl.reqstatus = 'O' AND rl.m_requisition_id = r.m_requisition_id AND r.docstatus = 'CO';

[ Date: 2026-07-18 14:20:49 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

UPDATE m_requisitionline rl SET em_cactl_consumption = cactl_calculate_consumption (rl.m_product_id, rl.ad_org_id, rl.ad_client_id) FROM m_requisition r WHERE rl.reqstatus = 'O' AND rl.m_requisition_id = r.m_requisition_id AND r.docstatus = 'CO';

[ Date: 2026-07-18 09:20:48 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

UPDATE m_requisitionline rl SET em_cactl_consumption = cactl_calculate_consumption (rl.m_product_id, rl.ad_org_id, rl.ad_client_id) FROM m_requisition r WHERE rl.reqstatus = 'O' AND rl.m_requisition_id = r.m_requisition_id AND r.docstatus = 'CO';

[ Date: 2026-07-18 07:20:47 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

UPDATE m_requisitionline rl SET em_cactl_consumption = cactl_calculate_consumption (rl.m_product_id, rl.ad_org_id, rl.ad_client_id) FROM m_requisition r WHERE rl.reqstatus = 'O' AND rl.m_requisition_id = r.m_requisition_id AND r.docstatus = 'CO';

[ Date: 2026-07-18 10:20:47 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

UPDATE m_requisitionline rl SET em_cactl_consumption = cactl_calculate_consumption (rl.m_product_id, rl.ad_org_id, rl.ad_client_id) FROM m_requisition r WHERE rl.reqstatus = 'O' AND rl.m_requisition_id = r.m_requisition_id AND r.docstatus = 'CO';

[ Date: 2026-07-18 08:20:47 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

SELECT businesspa0_.C_BPartner_ID AS C_BPartn1_203_, businesspa0_.AD_Client_ID AS AD_Clien2_203_, businesspa0_.AD_Org_ID AS AD_Org_I3_203_, businesspa0_.IsActive AS IsActive4_203_, businesspa0_.Created AS Created5_203_, businesspa0_.CreatedBy AS CreatedB6_203_, businesspa0_.Updated AS Updated7_203_, businesspa0_.UpdatedBy AS UpdatedB8_203_, businesspa0_.Value AS Value9_203_, businesspa0_.Name AS Name10_203_, businesspa0_.Name2 AS Name11_203_, businesspa0_.Description AS Descrip12_203_, businesspa0_.IsSummary AS IsSumma13_203_, businesspa0_.C_BP_Group_ID AS C_BP_Gr14_203_, businesspa0_.IsOneTime AS IsOneTi15_203_, businesspa0_.IsProspect AS IsProsp16_203_, businesspa0_.IsVendor AS IsVendo17_203_, businesspa0_.IsCustomer AS IsCusto18_203_, businesspa0_.IsEmployee AS IsEmplo19_203_, businesspa0_.IsSalesRep AS IsSales20_203_, businesspa0_.ReferenceNo AS Referen21_203_, businesspa0_.DUNS AS DUNS22_203_, businesspa0_.URL AS URL23_203_, businesspa0_.AD_Language AS AD_Lang24_203_, businesspa0_.TaxID AS TaxID25_203_, businesspa0_.IsTaxExempt AS IsTaxEx26_203_, businesspa0_.C_InvoiceSchedule_ID AS C_Invoi27_203_, businesspa0_.Rating AS Rating28_203_, businesspa0_.SalesVolume AS SalesVo29_203_, businesspa0_.NumberEmployees AS NumberE30_203_, businesspa0_.NAICS AS NAICS31_203_, businesspa0_.FirstSale AS FirstSa32_203_, businesspa0_.AcqusitionCost AS Acqusit33_203_, businesspa0_.PotentialLifeTimeValue AS Potenti34_203_, businesspa0_.ActualLifeTimeValue AS ActualL35_203_, businesspa0_.ShareOfCustomer AS ShareOf36_203_, businesspa0_.PaymentRule AS Payment37_203_, businesspa0_.SO_CreditLimit AS SO_Cred38_203_, businesspa0_.SO_CreditUsed AS SO_Cred39_203_, businesspa0_.C_PaymentTerm_ID AS C_Payme40_203_, businesspa0_.M_PriceList_ID AS M_Price41_203_, businesspa0_.IsDiscountPrinted AS IsDisco42_203_, businesspa0_.SO_Description AS SO_Desc43_203_, businesspa0_.POReference AS PORefer44_203_, businesspa0_.PaymentRulePO AS Payment45_203_, businesspa0_.PO_PriceList_ID AS PO_Pric46_203_, businesspa0_.PO_PaymentTerm_ID AS PO_Paym47_203_, businesspa0_.DocumentCopies AS Documen48_203_, businesspa0_.C_Greeting_ID AS C_Greet49_203_, businesspa0_.InvoiceRule AS Invoice50_203_, businesspa0_.DeliveryRule AS Deliver51_203_, businesspa0_.DeliveryViaRule AS Deliver52_203_, businesspa0_.SalesRep_ID AS SalesRe53_203_, businesspa0_.BPartner_Parent_ID AS BPartne54_203_, businesspa0_.SOCreditStatus AS SOCredi55_203_, businesspa0_.AD_Forced_Org_ID AS AD_Forc56_203_, businesspa0_.ShowPriceInOrder AS ShowPri57_203_, businesspa0_.Invoicegrouping AS Invoice58_203_, businesspa0_.FixMonthDay AS FixMont59_203_, businesspa0_.FixMonthDay2 AS FixMont60_203_, businesspa0_.Fixmonthday3 AS Fixmont61_203_, businesspa0_.Isworker AS Isworke62_203_, businesspa0_.UPC AS UPC63_203_, businesspa0_.C_Salary_Category_ID AS C_Salar64_203_, businesspa0_.Invoice_Printformat AS Invoice65_203_, businesspa0_.Last_Days AS Last_Da66_203_, businesspa0_.PO_Bankaccount_ID AS PO_Bank67_203_, businesspa0_.PO_BP_TaxCategory_ID AS PO_BP_T68_203_, businesspa0_.PO_Fixmonthday AS PO_Fixm69_203_, businesspa0_.PO_Fixmonthday2 AS PO_Fixm70_203_, businesspa0_.PO_Fixmonthday3 AS PO_Fixm71_203_, businesspa0_.SO_Bankaccount_ID AS SO_Bank72_203_, businesspa0_.SO_Bp_Taxcategory_ID AS SO_Bp_T73_203_, businesspa0_.Fiscalcode AS Fiscalc74_203_, businesspa0_.Isofiscalcode AS Isofisc75_203_, businesspa0_.EM_Einv_Einvoice AS EM_Einv76_203_, businesspa0_.PO_C_Incoterms_ID AS PO_C_In77_203_, businesspa0_.EM_Einv_Format_Id AS EM_Einv78_203_, businesspa0_.SO_C_Incoterms_ID AS SO_C_In79_203_, businesspa0_.EM_Einv_Platform_Id AS EM_Einv80_203_, businesspa0_.FIN_Paymentmethod_ID AS FIN_Pay81_203_, businesspa0_.EM_Einv_Email AS EM_Einv82_203_, businesspa0_.PO_Paymentmethod_ID AS PO_Paym83_203_, businesspa0_.FIN_Financial_Account_ID AS FIN_Fin84_203_, businesspa0_.EM_Einv_Deliverymode AS EM_Einv85_203_, businesspa0_.PO_Financial_Account_ID AS PO_Fina86_203_, businesspa0_.Customer_Blocking AS Custome87_203_, businesspa0_.Vendor_Blocking AS Vendor_88_203_, businesspa0_.SO_Payment_Blocking AS SO_Paym89_203_, businesspa0_.PO_Payment_Blocking AS PO_Paym90_203_, businesspa0_.SO_Invoice_Blocking AS SO_Invo91_203_, businesspa0_.PO_Invoice_Blocking AS PO_Invo92_203_, businesspa0_.SO_Order_Blocking AS SO_Orde93_203_, businesspa0_.PO_Order_Blocking AS PO_Orde94_203_, businesspa0_.SO_Goods_Blocking AS SO_Good95_203_, businesspa0_.PO_Goods_Blocking AS PO_Good96_203_, businesspa0_.Iscashvat AS Iscashv97_203_, businesspa0_.EM_Advcrm_Newactivity AS EM_Advc98_203_, businesspa0_.Update_Currency AS Update_99_203_, businesspa0_.BP_Currency_ID AS BP_Cur100_203_, businesspa0_.Birthplace AS Birthp101_203_, businesspa0_.Birthday AS Birthd102_203_, businesspa0_.EM_Sgpcrm_Securitygroups_ID AS EM_Sgp103_203_, businesspa0_.Is_Customer_Consent AS Is_Cus104_203_, businesspa0_.EM_OBSMAIL_INVOICEVIAEMAIL AS EM_OBS105_203_, businesspa0_.EM_Obsepad_Mandate_Identifier AS EM_Obs106_203_, businesspa0_.EM_Obsmail_Language AS EM_Obs107_203_, businesspa0_.EM_Obsepad_Mandate_Date AS EM_Obs108_203_, businesspa0_.EM_Aeatsii_Rep_Taxid AS EM_Aea109_203_, businesspa0_.EM_Aeatsii_Menor AS EM_Aea110_203_, businesspa0_.EM_Pricm_Isintercompany AS EM_Pri111_203_, businesspa0_.EM_Psat_Billtobpartner_ID AS EM_Psa112_203_, businesspa0_.EM_Psat_Locator_ID AS EM_Psa113_203_, businesspa0_.EM_Psat_Mobile_Request AS EM_Psa114_203_, businesspa0_.EM_Prges_Glitem_ID AS EM_Prg115_203_, businesspa0_.EM_Rrhh_Exemployee AS EM_Rrh116_203_, businesspa0_.EM_Rrhh_Candidate AS EM_Rrh117_203_, businesspa0_.EM_Prpass_No_Print_Pass AS EM_Prp118_203_, businesspa0_.EM_Rrhh_Holidays_Supervisor AS EM_Rrh119_203_, businesspa0_.EM_Cactal_Emp_No AS EM_Cac120_203_, businesspa0_.EM_Cactal_Emp_Relationship_No AS EM_Cac121_203_, businesspa0_.EM_Obwpl_Bp_Block_Pickinglist AS EM_Obw122_203_, businesspa0_.EM_Pruti_Addbp AS EM_Pru123_203_, businesspa0_.EM_Prpass_Generatepassemployee AS EM_Prp124_203_, businesspa0_.EM_Rrhh_Mainworkstation_ID AS EM_Rrh125_203_, businesspa0_.EM_Rrhh_Bp_Transfer_Code AS EM_Rrh126_203_, businesspa0_.EM_OBTIK_Tax_ID_Key AS EM_OBT127_203_ FROM C_BPartner businesspa0_ WHERE EXISTS ( SELECT 1 FROM C_Order order1_ INNER JOIN C_BPartner businesspa2_ ON order1_.C_BPartner_ID = businesspa2_.C_BPartner_ID WHERE (upper ((order1_.DocumentNo || ' - ' || COALESCE (to_char (order1_.DateOrdered), '') || ' - ' || COALESCE (to_char (order1_.GrandTotal), ''))) LIKE upper ('%2865%') ESCAPE '|') AND businesspa2_.C_BPartner_ID = businesspa0_.C_BPartner_ID AND (order1_.AD_Org_ID IN ('BDE84FCE50FF46FBBFAC648A621443DF', 'D575B67D82034C269C7E0FAF196D90E7', 'F7430A5D620748B19BE7915CDDDA9BE7', '09AA2CDD5352474690D9BB84C869850A', '86EB5CCF7EFE4EACAC3F2E025C137019', '6FA42D7B78034BD8994E9BA7F2CA2281', '1984C825F5534428BD6DDB0CA6D5A440', '5E311B81CDF64243B4C16520C49F3B59', 'D629402D7AE24904A093B7DC01A5CCA5', 'E007B9685155401596452F7B6CD0A6B8', '117C4CA3249B4C0993D36BA80F450C77', 'F89A6E1DA44F40868BF983D4C2384DA6', '2C9FE48909B54B599491D9F69A70A307', 'C2B9461D37104A31B9FD2C1D5E0D381E', '7DBD8F71A3C640028913A30FBCCDF7A7', '432480F1E32D48A19D89CD9A28D7DC1F', 'CDCEFC97D42749ABA78BA3EB973BAC89', 'FCD700C048BB487AA26E639649EB5A96', 'D675D150EA7D4218AF15CF6221A15349', 'DD5A08978B9D43E0ABFAD0B01A9168B0', '9FF601A70F8443138C0EF03BDFDF29F0', '25548EE38FDF4B068F7CFA9FA70FA4FF', '891AF965E0874B4F911504C515619C58', 'CF85EFF5B85A46679AA07AC10CA26CEA', '900D5488BFB64AD4BE463A30ECEDD0FF', '139ED2D4B4CE4901996E0B72E0F87F6C', '0', '4A09EF8E85474DAFA7C132836C07FFF1', '1C36F5B48E224E4D9C82D6A8202996E8', '71ED1EFD88354240BB0412C35E03BF1C', '88CD22344C324943BF5200E06A942459', 'F22E1A745C4C42BCA2386BF8DC013634', '9F797A8A00FC467F90A60E9E62873D59', 'F660F82B9E8C420CAB4FDD68F6DEA416', 'D19EF13F20CD471BB6F6664909C352AF', 'F9B7F11E4E9C43308578C4D73D2B7E00', '658F3A7A05DF4261A63E57B277843BE9', '5D0AF8482E7F489EB482A8B80E7D3F38')) AND (order1_.AD_Client_ID IN ('9CE5D25B1359417991AD7697D6F09896', '0'))) ORDER BY businesspa0_.Value, businesspa0_.Name, businesspa0_.TaxID, businesspa0_.Name2 LIMIT '76';

[ Date: 2026-07-18 10:47:11 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

SELECT businesspa0_.C_BPartner_ID AS C_BPartn1_203_, businesspa0_.AD_Client_ID AS AD_Clien2_203_, businesspa0_.AD_Org_ID AS AD_Org_I3_203_, businesspa0_.IsActive AS IsActive4_203_, businesspa0_.Created AS Created5_203_, businesspa0_.CreatedBy AS CreatedB6_203_, businesspa0_.Updated AS Updated7_203_, businesspa0_.UpdatedBy AS UpdatedB8_203_, businesspa0_.Value AS Value9_203_, businesspa0_.Name AS Name10_203_, businesspa0_.Name2 AS Name11_203_, businesspa0_.Description AS Descrip12_203_, businesspa0_.IsSummary AS IsSumma13_203_, businesspa0_.C_BP_Group_ID AS C_BP_Gr14_203_, businesspa0_.IsOneTime AS IsOneTi15_203_, businesspa0_.IsProspect AS IsProsp16_203_, businesspa0_.IsVendor AS IsVendo17_203_, businesspa0_.IsCustomer AS IsCusto18_203_, businesspa0_.IsEmployee AS IsEmplo19_203_, businesspa0_.IsSalesRep AS IsSales20_203_, businesspa0_.ReferenceNo AS Referen21_203_, businesspa0_.DUNS AS DUNS22_203_, businesspa0_.URL AS URL23_203_, businesspa0_.AD_Language AS AD_Lang24_203_, businesspa0_.TaxID AS TaxID25_203_, businesspa0_.IsTaxExempt AS IsTaxEx26_203_, businesspa0_.C_InvoiceSchedule_ID AS C_Invoi27_203_, businesspa0_.Rating AS Rating28_203_, businesspa0_.SalesVolume AS SalesVo29_203_, businesspa0_.NumberEmployees AS NumberE30_203_, businesspa0_.NAICS AS NAICS31_203_, businesspa0_.FirstSale AS FirstSa32_203_, businesspa0_.AcqusitionCost AS Acqusit33_203_, businesspa0_.PotentialLifeTimeValue AS Potenti34_203_, businesspa0_.ActualLifeTimeValue AS ActualL35_203_, businesspa0_.ShareOfCustomer AS ShareOf36_203_, businesspa0_.PaymentRule AS Payment37_203_, businesspa0_.SO_CreditLimit AS SO_Cred38_203_, businesspa0_.SO_CreditUsed AS SO_Cred39_203_, businesspa0_.C_PaymentTerm_ID AS C_Payme40_203_, businesspa0_.M_PriceList_ID AS M_Price41_203_, businesspa0_.IsDiscountPrinted AS IsDisco42_203_, businesspa0_.SO_Description AS SO_Desc43_203_, businesspa0_.POReference AS PORefer44_203_, businesspa0_.PaymentRulePO AS Payment45_203_, businesspa0_.PO_PriceList_ID AS PO_Pric46_203_, businesspa0_.PO_PaymentTerm_ID AS PO_Paym47_203_, businesspa0_.DocumentCopies AS Documen48_203_, businesspa0_.C_Greeting_ID AS C_Greet49_203_, businesspa0_.InvoiceRule AS Invoice50_203_, businesspa0_.DeliveryRule AS Deliver51_203_, businesspa0_.DeliveryViaRule AS Deliver52_203_, businesspa0_.SalesRep_ID AS SalesRe53_203_, businesspa0_.BPartner_Parent_ID AS BPartne54_203_, businesspa0_.SOCreditStatus AS SOCredi55_203_, businesspa0_.AD_Forced_Org_ID AS AD_Forc56_203_, businesspa0_.ShowPriceInOrder AS ShowPri57_203_, businesspa0_.Invoicegrouping AS Invoice58_203_, businesspa0_.FixMonthDay AS FixMont59_203_, businesspa0_.FixMonthDay2 AS FixMont60_203_, businesspa0_.Fixmonthday3 AS Fixmont61_203_, businesspa0_.Isworker AS Isworke62_203_, businesspa0_.UPC AS UPC63_203_, businesspa0_.C_Salary_Category_ID AS C_Salar64_203_, businesspa0_.Invoice_Printformat AS Invoice65_203_, businesspa0_.Last_Days AS Last_Da66_203_, businesspa0_.PO_Bankaccount_ID AS PO_Bank67_203_, businesspa0_.PO_BP_TaxCategory_ID AS PO_BP_T68_203_, businesspa0_.PO_Fixmonthday AS PO_Fixm69_203_, businesspa0_.PO_Fixmonthday2 AS PO_Fixm70_203_, businesspa0_.PO_Fixmonthday3 AS PO_Fixm71_203_, businesspa0_.SO_Bankaccount_ID AS SO_Bank72_203_, businesspa0_.SO_Bp_Taxcategory_ID AS SO_Bp_T73_203_, businesspa0_.Fiscalcode AS Fiscalc74_203_, businesspa0_.Isofiscalcode AS Isofisc75_203_, businesspa0_.EM_Einv_Einvoice AS EM_Einv76_203_, businesspa0_.PO_C_Incoterms_ID AS PO_C_In77_203_, businesspa0_.EM_Einv_Format_Id AS EM_Einv78_203_, businesspa0_.SO_C_Incoterms_ID AS SO_C_In79_203_, businesspa0_.EM_Einv_Platform_Id AS EM_Einv80_203_, businesspa0_.FIN_Paymentmethod_ID AS FIN_Pay81_203_, businesspa0_.EM_Einv_Email AS EM_Einv82_203_, businesspa0_.PO_Paymentmethod_ID AS PO_Paym83_203_, businesspa0_.FIN_Financial_Account_ID AS FIN_Fin84_203_, businesspa0_.EM_Einv_Deliverymode AS EM_Einv85_203_, businesspa0_.PO_Financial_Account_ID AS PO_Fina86_203_, businesspa0_.Customer_Blocking AS Custome87_203_, businesspa0_.Vendor_Blocking AS Vendor_88_203_, businesspa0_.SO_Payment_Blocking AS SO_Paym89_203_, businesspa0_.PO_Payment_Blocking AS PO_Paym90_203_, businesspa0_.SO_Invoice_Blocking AS SO_Invo91_203_, businesspa0_.PO_Invoice_Blocking AS PO_Invo92_203_, businesspa0_.SO_Order_Blocking AS SO_Orde93_203_, businesspa0_.PO_Order_Blocking AS PO_Orde94_203_, businesspa0_.SO_Goods_Blocking AS SO_Good95_203_, businesspa0_.PO_Goods_Blocking AS PO_Good96_203_, businesspa0_.Iscashvat AS Iscashv97_203_, businesspa0_.EM_Advcrm_Newactivity AS EM_Advc98_203_, businesspa0_.Update_Currency AS Update_99_203_, businesspa0_.BP_Currency_ID AS BP_Cur100_203_, businesspa0_.Birthplace AS Birthp101_203_, businesspa0_.Birthday AS Birthd102_203_, businesspa0_.EM_Sgpcrm_Securitygroups_ID AS EM_Sgp103_203_, businesspa0_.Is_Customer_Consent AS Is_Cus104_203_, businesspa0_.EM_OBSMAIL_INVOICEVIAEMAIL AS EM_OBS105_203_, businesspa0_.EM_Obsepad_Mandate_Identifier AS EM_Obs106_203_, businesspa0_.EM_Obsmail_Language AS EM_Obs107_203_, businesspa0_.EM_Obsepad_Mandate_Date AS EM_Obs108_203_, businesspa0_.EM_Aeatsii_Rep_Taxid AS EM_Aea109_203_, businesspa0_.EM_Aeatsii_Menor AS EM_Aea110_203_, businesspa0_.EM_Pricm_Isintercompany AS EM_Pri111_203_, businesspa0_.EM_Psat_Billtobpartner_ID AS EM_Psa112_203_, businesspa0_.EM_Psat_Locator_ID AS EM_Psa113_203_, businesspa0_.EM_Psat_Mobile_Request AS EM_Psa114_203_, businesspa0_.EM_Prges_Glitem_ID AS EM_Prg115_203_, businesspa0_.EM_Rrhh_Exemployee AS EM_Rrh116_203_, businesspa0_.EM_Rrhh_Candidate AS EM_Rrh117_203_, businesspa0_.EM_Prpass_No_Print_Pass AS EM_Prp118_203_, businesspa0_.EM_Rrhh_Holidays_Supervisor AS EM_Rrh119_203_, businesspa0_.EM_Cactal_Emp_No AS EM_Cac120_203_, businesspa0_.EM_Cactal_Emp_Relationship_No AS EM_Cac121_203_, businesspa0_.EM_Obwpl_Bp_Block_Pickinglist AS EM_Obw122_203_, businesspa0_.EM_Pruti_Addbp AS EM_Pru123_203_, businesspa0_.EM_Prpass_Generatepassemployee AS EM_Prp124_203_, businesspa0_.EM_Rrhh_Mainworkstation_ID AS EM_Rrh125_203_, businesspa0_.EM_Rrhh_Bp_Transfer_Code AS EM_Rrh126_203_, businesspa0_.EM_OBTIK_Tax_ID_Key AS EM_OBT127_203_ FROM C_BPartner businesspa0_ WHERE EXISTS ( SELECT 1 FROM C_Order order1_ INNER JOIN C_BPartner businesspa2_ ON order1_.C_BPartner_ID = businesspa2_.C_BPartner_ID WHERE (upper ((order1_.DocumentNo || ' - ' || COALESCE (to_char (order1_.DateOrdered), '') || ' - ' || COALESCE (to_char (order1_.GrandTotal), ''))) LIKE upper ('%informat%') ESCAPE '|') AND businesspa2_.C_BPartner_ID = businesspa0_.C_BPartner_ID AND (order1_.AD_Org_ID IN ('BDE84FCE50FF46FBBFAC648A621443DF', 'D575B67D82034C269C7E0FAF196D90E7', 'F7430A5D620748B19BE7915CDDDA9BE7', '09AA2CDD5352474690D9BB84C869850A', '86EB5CCF7EFE4EACAC3F2E025C137019', '1984C825F5534428BD6DDB0CA6D5A440', '5E311B81CDF64243B4C16520C49F3B59', '6FA42D7B78034BD8994E9BA7F2CA2281', 'D629402D7AE24904A093B7DC01A5CCA5', 'E007B9685155401596452F7B6CD0A6B8', '117C4CA3249B4C0993D36BA80F450C77', 'F89A6E1DA44F40868BF983D4C2384DA6', '2C9FE48909B54B599491D9F69A70A307', 'C2B9461D37104A31B9FD2C1D5E0D381E', '7DBD8F71A3C640028913A30FBCCDF7A7', '432480F1E32D48A19D89CD9A28D7DC1F', 'CDCEFC97D42749ABA78BA3EB973BAC89', 'FCD700C048BB487AA26E639649EB5A96', 'D675D150EA7D4218AF15CF6221A15349', 'DD5A08978B9D43E0ABFAD0B01A9168B0', '9FF601A70F8443138C0EF03BDFDF29F0', '25548EE38FDF4B068F7CFA9FA70FA4FF', '891AF965E0874B4F911504C515619C58', 'CF85EFF5B85A46679AA07AC10CA26CEA', '900D5488BFB64AD4BE463A30ECEDD0FF', '139ED2D4B4CE4901996E0B72E0F87F6C', '0', '4A09EF8E85474DAFA7C132836C07FFF1', '71ED1EFD88354240BB0412C35E03BF1C', '1C36F5B48E224E4D9C82D6A8202996E8', '88CD22344C324943BF5200E06A942459', '9F797A8A00FC467F90A60E9E62873D59', 'F22E1A745C4C42BCA2386BF8DC013634', 'D19EF13F20CD471BB6F6664909C352AF', 'F660F82B9E8C420CAB4FDD68F6DEA416', 'F9B7F11E4E9C43308578C4D73D2B7E00', '658F3A7A05DF4261A63E57B277843BE9', '5D0AF8482E7F489EB482A8B80E7D3F38')) AND (order1_.AD_Client_ID IN ('9CE5D25B1359417991AD7697D6F09896', '0'))) ORDER BY businesspa0_.Value, businesspa0_.Name, businesspa0_.TaxID, businesspa0_.Name2 LIMIT '76';

[ Date: 2026-07-18 13:36:05 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

SELECT businesspa0_.C_BPartner_ID AS C_BPartn1_203_, businesspa0_.AD_Client_ID AS AD_Clien2_203_, businesspa0_.AD_Org_ID AS AD_Org_I3_203_, businesspa0_.IsActive AS IsActive4_203_, businesspa0_.Created AS Created5_203_, businesspa0_.CreatedBy AS CreatedB6_203_, businesspa0_.Updated AS Updated7_203_, businesspa0_.UpdatedBy AS UpdatedB8_203_, businesspa0_.Value AS Value9_203_, businesspa0_.Name AS Name10_203_, businesspa0_.Name2 AS Name11_203_, businesspa0_.Description AS Descrip12_203_, businesspa0_.IsSummary AS IsSumma13_203_, businesspa0_.C_BP_Group_ID AS C_BP_Gr14_203_, businesspa0_.IsOneTime AS IsOneTi15_203_, businesspa0_.IsProspect AS IsProsp16_203_, businesspa0_.IsVendor AS IsVendo17_203_, businesspa0_.IsCustomer AS IsCusto18_203_, businesspa0_.IsEmployee AS IsEmplo19_203_, businesspa0_.IsSalesRep AS IsSales20_203_, businesspa0_.ReferenceNo AS Referen21_203_, businesspa0_.DUNS AS DUNS22_203_, businesspa0_.URL AS URL23_203_, businesspa0_.AD_Language AS AD_Lang24_203_, businesspa0_.TaxID AS TaxID25_203_, businesspa0_.IsTaxExempt AS IsTaxEx26_203_, businesspa0_.C_InvoiceSchedule_ID AS C_Invoi27_203_, businesspa0_.Rating AS Rating28_203_, businesspa0_.SalesVolume AS SalesVo29_203_, businesspa0_.NumberEmployees AS NumberE30_203_, businesspa0_.NAICS AS NAICS31_203_, businesspa0_.FirstSale AS FirstSa32_203_, businesspa0_.AcqusitionCost AS Acqusit33_203_, businesspa0_.PotentialLifeTimeValue AS Potenti34_203_, businesspa0_.ActualLifeTimeValue AS ActualL35_203_, businesspa0_.ShareOfCustomer AS ShareOf36_203_, businesspa0_.PaymentRule AS Payment37_203_, businesspa0_.SO_CreditLimit AS SO_Cred38_203_, businesspa0_.SO_CreditUsed AS SO_Cred39_203_, businesspa0_.C_PaymentTerm_ID AS C_Payme40_203_, businesspa0_.M_PriceList_ID AS M_Price41_203_, businesspa0_.IsDiscountPrinted AS IsDisco42_203_, businesspa0_.SO_Description AS SO_Desc43_203_, businesspa0_.POReference AS PORefer44_203_, businesspa0_.PaymentRulePO AS Payment45_203_, businesspa0_.PO_PriceList_ID AS PO_Pric46_203_, businesspa0_.PO_PaymentTerm_ID AS PO_Paym47_203_, businesspa0_.DocumentCopies AS Documen48_203_, businesspa0_.C_Greeting_ID AS C_Greet49_203_, businesspa0_.InvoiceRule AS Invoice50_203_, businesspa0_.DeliveryRule AS Deliver51_203_, businesspa0_.DeliveryViaRule AS Deliver52_203_, businesspa0_.SalesRep_ID AS SalesRe53_203_, businesspa0_.BPartner_Parent_ID AS BPartne54_203_, businesspa0_.SOCreditStatus AS SOCredi55_203_, businesspa0_.AD_Forced_Org_ID AS AD_Forc56_203_, businesspa0_.ShowPriceInOrder AS ShowPri57_203_, businesspa0_.Invoicegrouping AS Invoice58_203_, businesspa0_.FixMonthDay AS FixMont59_203_, businesspa0_.FixMonthDay2 AS FixMont60_203_, businesspa0_.Fixmonthday3 AS Fixmont61_203_, businesspa0_.Isworker AS Isworke62_203_, businesspa0_.UPC AS UPC63_203_, businesspa0_.C_Salary_Category_ID AS C_Salar64_203_, businesspa0_.Invoice_Printformat AS Invoice65_203_, businesspa0_.Last_Days AS Last_Da66_203_, businesspa0_.PO_Bankaccount_ID AS PO_Bank67_203_, businesspa0_.PO_BP_TaxCategory_ID AS PO_BP_T68_203_, businesspa0_.PO_Fixmonthday AS PO_Fixm69_203_, businesspa0_.PO_Fixmonthday2 AS PO_Fixm70_203_, businesspa0_.PO_Fixmonthday3 AS PO_Fixm71_203_, businesspa0_.SO_Bankaccount_ID AS SO_Bank72_203_, businesspa0_.SO_Bp_Taxcategory_ID AS SO_Bp_T73_203_, businesspa0_.Fiscalcode AS Fiscalc74_203_, businesspa0_.Isofiscalcode AS Isofisc75_203_, businesspa0_.EM_Einv_Einvoice AS EM_Einv76_203_, businesspa0_.PO_C_Incoterms_ID AS PO_C_In77_203_, businesspa0_.EM_Einv_Format_Id AS EM_Einv78_203_, businesspa0_.SO_C_Incoterms_ID AS SO_C_In79_203_, businesspa0_.EM_Einv_Platform_Id AS EM_Einv80_203_, businesspa0_.FIN_Paymentmethod_ID AS FIN_Pay81_203_, businesspa0_.EM_Einv_Email AS EM_Einv82_203_, businesspa0_.PO_Paymentmethod_ID AS PO_Paym83_203_, businesspa0_.FIN_Financial_Account_ID AS FIN_Fin84_203_, businesspa0_.EM_Einv_Deliverymode AS EM_Einv85_203_, businesspa0_.PO_Financial_Account_ID AS PO_Fina86_203_, businesspa0_.Customer_Blocking AS Custome87_203_, businesspa0_.Vendor_Blocking AS Vendor_88_203_, businesspa0_.SO_Payment_Blocking AS SO_Paym89_203_, businesspa0_.PO_Payment_Blocking AS PO_Paym90_203_, businesspa0_.SO_Invoice_Blocking AS SO_Invo91_203_, businesspa0_.PO_Invoice_Blocking AS PO_Invo92_203_, businesspa0_.SO_Order_Blocking AS SO_Orde93_203_, businesspa0_.PO_Order_Blocking AS PO_Orde94_203_, businesspa0_.SO_Goods_Blocking AS SO_Good95_203_, businesspa0_.PO_Goods_Blocking AS PO_Good96_203_, businesspa0_.Iscashvat AS Iscashv97_203_, businesspa0_.EM_Advcrm_Newactivity AS EM_Advc98_203_, businesspa0_.Update_Currency AS Update_99_203_, businesspa0_.BP_Currency_ID AS BP_Cur100_203_, businesspa0_.Birthplace AS Birthp101_203_, businesspa0_.Birthday AS Birthd102_203_, businesspa0_.EM_Sgpcrm_Securitygroups_ID AS EM_Sgp103_203_, businesspa0_.Is_Customer_Consent AS Is_Cus104_203_, businesspa0_.EM_OBSMAIL_INVOICEVIAEMAIL AS EM_OBS105_203_, businesspa0_.EM_Obsepad_Mandate_Identifier AS EM_Obs106_203_, businesspa0_.EM_Obsmail_Language AS EM_Obs107_203_, businesspa0_.EM_Obsepad_Mandate_Date AS EM_Obs108_203_, businesspa0_.EM_Aeatsii_Rep_Taxid AS EM_Aea109_203_, businesspa0_.EM_Aeatsii_Menor AS EM_Aea110_203_, businesspa0_.EM_Pricm_Isintercompany AS EM_Pri111_203_, businesspa0_.EM_Psat_Billtobpartner_ID AS EM_Psa112_203_, businesspa0_.EM_Psat_Locator_ID AS EM_Psa113_203_, businesspa0_.EM_Psat_Mobile_Request AS EM_Psa114_203_, businesspa0_.EM_Prges_Glitem_ID AS EM_Prg115_203_, businesspa0_.EM_Rrhh_Exemployee AS EM_Rrh116_203_, businesspa0_.EM_Rrhh_Candidate AS EM_Rrh117_203_, businesspa0_.EM_Prpass_No_Print_Pass AS EM_Prp118_203_, businesspa0_.EM_Rrhh_Holidays_Supervisor AS EM_Rrh119_203_, businesspa0_.EM_Cactal_Emp_No AS EM_Cac120_203_, businesspa0_.EM_Cactal_Emp_Relationship_No AS EM_Cac121_203_, businesspa0_.EM_Obwpl_Bp_Block_Pickinglist AS EM_Obw122_203_, businesspa0_.EM_Pruti_Addbp AS EM_Pru123_203_, businesspa0_.EM_Prpass_Generatepassemployee AS EM_Prp124_203_, businesspa0_.EM_Rrhh_Mainworkstation_ID AS EM_Rrh125_203_, businesspa0_.EM_Rrhh_Bp_Transfer_Code AS EM_Rrh126_203_, businesspa0_.EM_OBTIK_Tax_ID_Key AS EM_OBT127_203_ FROM C_BPartner businesspa0_ WHERE EXISTS ( SELECT 1 FROM C_Order order1_ INNER JOIN C_BPartner businesspa2_ ON order1_.C_BPartner_ID = businesspa2_.C_BPartner_ID WHERE (upper ((order1_.DocumentNo || ' - ' || COALESCE (to_char (order1_.DateOrdered), '') || ' - ' || COALESCE (to_char (order1_.GrandTotal), ''))) LIKE upper ('%FUEL%') ESCAPE '|') AND businesspa2_.C_BPartner_ID = businesspa0_.C_BPartner_ID AND (order1_.AD_Org_ID IN ('BDE84FCE50FF46FBBFAC648A621443DF', 'D575B67D82034C269C7E0FAF196D90E7', 'F7430A5D620748B19BE7915CDDDA9BE7', '09AA2CDD5352474690D9BB84C869850A', '86EB5CCF7EFE4EACAC3F2E025C137019', '6FA42D7B78034BD8994E9BA7F2CA2281', '1984C825F5534428BD6DDB0CA6D5A440', '5E311B81CDF64243B4C16520C49F3B59', 'D629402D7AE24904A093B7DC01A5CCA5', 'E007B9685155401596452F7B6CD0A6B8', '117C4CA3249B4C0993D36BA80F450C77', 'F89A6E1DA44F40868BF983D4C2384DA6', '2C9FE48909B54B599491D9F69A70A307', 'C2B9461D37104A31B9FD2C1D5E0D381E', '7DBD8F71A3C640028913A30FBCCDF7A7', '432480F1E32D48A19D89CD9A28D7DC1F', 'CDCEFC97D42749ABA78BA3EB973BAC89', 'FCD700C048BB487AA26E639649EB5A96', 'D675D150EA7D4218AF15CF6221A15349', 'DD5A08978B9D43E0ABFAD0B01A9168B0', '9FF601A70F8443138C0EF03BDFDF29F0', '25548EE38FDF4B068F7CFA9FA70FA4FF', '891AF965E0874B4F911504C515619C58', 'CF85EFF5B85A46679AA07AC10CA26CEA', '900D5488BFB64AD4BE463A30ECEDD0FF', '139ED2D4B4CE4901996E0B72E0F87F6C', '0', '4A09EF8E85474DAFA7C132836C07FFF1', '1C36F5B48E224E4D9C82D6A8202996E8', '71ED1EFD88354240BB0412C35E03BF1C', '88CD22344C324943BF5200E06A942459', 'F22E1A745C4C42BCA2386BF8DC013634', '9F797A8A00FC467F90A60E9E62873D59', 'F660F82B9E8C420CAB4FDD68F6DEA416', 'D19EF13F20CD471BB6F6664909C352AF', 'F9B7F11E4E9C43308578C4D73D2B7E00', '658F3A7A05DF4261A63E57B277843BE9', '5D0AF8482E7F489EB482A8B80E7D3F38')) AND (order1_.AD_Client_ID IN ('9CE5D25B1359417991AD7697D6F09896', '0'))) ORDER BY businesspa0_.Value, businesspa0_.Name, businesspa0_.TaxID, businesspa0_.Name2 LIMIT '76';

[ Date: 2026-07-18 10:28:21 - Database: openbravo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

SELECT businesspa0_.C_BPartner_ID AS C_BPartn1_203_, businesspa0_.AD_Client_ID AS AD_Clien2_203_, businesspa0_.AD_Org_ID AS AD_Org_I3_203_, businesspa0_.IsActive AS IsActive4_203_, businesspa0_.Created AS Created5_203_, businesspa0_.CreatedBy AS CreatedB6_203_, businesspa0_.Updated AS Updated7_203_, businesspa0_.UpdatedBy AS UpdatedB8_203_, businesspa0_.Value AS Value9_203_, businesspa0_.Name AS Name10_203_, businesspa0_.Name2 AS Name11_203_, businesspa0_.Description AS Descrip12_203_, businesspa0_.IsSummary AS IsSumma13_203_, businesspa0_.C_BP_Group_ID AS C_BP_Gr14_203_, businesspa0_.IsOneTime AS IsOneTi15_203_, businesspa0_.IsProspect AS IsProsp16_203_, businesspa0_.IsVendor AS IsVendo17_203_, businesspa0_.IsCustomer AS IsCusto18_203_, businesspa0_.IsEmployee AS IsEmplo19_203_, businesspa0_.IsSalesRep AS IsSales20_203_, businesspa0_.ReferenceNo AS Referen21_203_, businesspa0_.DUNS AS DUNS22_203_, businesspa0_.URL AS URL23_203_, businesspa0_.AD_Language AS AD_Lang24_203_, businesspa0_.TaxID AS TaxID25_203_, businesspa0_.IsTaxExempt AS IsTaxEx26_203_, businesspa0_.C_InvoiceSchedule_ID AS C_Invoi27_203_, businesspa0_.Rating AS Rating28_203_, businesspa0_.SalesVolume AS SalesVo29_203_, businesspa0_.NumberEmployees AS NumberE30_203_, businesspa0_.NAICS AS NAICS31_203_, businesspa0_.FirstSale AS FirstSa32_203_, businesspa0_.AcqusitionCost AS Acqusit33_203_, businesspa0_.PotentialLifeTimeValue AS Potenti34_203_, businesspa0_.ActualLifeTimeValue AS ActualL35_203_, businesspa0_.ShareOfCustomer AS ShareOf36_203_, businesspa0_.PaymentRule AS Payment37_203_, businesspa0_.SO_CreditLimit AS SO_Cred38_203_, businesspa0_.SO_CreditUsed AS SO_Cred39_203_, businesspa0_.C_PaymentTerm_ID AS C_Payme40_203_, businesspa0_.M_PriceList_ID AS M_Price41_203_, businesspa0_.IsDiscountPrinted AS IsDisco42_203_, businesspa0_.SO_Description AS SO_Desc43_203_, businesspa0_.POReference AS PORefer44_203_, businesspa0_.PaymentRulePO AS Payment45_203_, businesspa0_.PO_PriceList_ID AS PO_Pric46_203_, businesspa0_.PO_PaymentTerm_ID AS PO_Paym47_203_, businesspa0_.DocumentCopies AS Documen48_203_, businesspa0_.C_Greeting_ID AS C_Greet49_203_, businesspa0_.InvoiceRule AS Invoice50_203_, businesspa0_.DeliveryRule AS Deliver51_203_, businesspa0_.DeliveryViaRule AS Deliver52_203_, businesspa0_.SalesRep_ID AS SalesRe53_203_, businesspa0_.BPartner_Parent_ID AS BPartne54_203_, businesspa0_.SOCreditStatus AS SOCredi55_203_, businesspa0_.AD_Forced_Org_ID AS AD_Forc56_203_, businesspa0_.ShowPriceInOrder AS ShowPri57_203_, businesspa0_.Invoicegrouping AS Invoice58_203_, businesspa0_.FixMonthDay AS FixMont59_203_, businesspa0_.FixMonthDay2 AS FixMont60_203_, businesspa0_.Fixmonthday3 AS Fixmont61_203_, businesspa0_.Isworker AS Isworke62_203_, businesspa0_.UPC AS UPC63_203_, businesspa0_.C_Salary_Category_ID AS C_Salar64_203_, businesspa0_.Invoice_Printformat AS Invoice65_203_, businesspa0_.Last_Days AS Last_Da66_203_, businesspa0_.PO_Bankaccount_ID AS PO_Bank67_203_, businesspa0_.PO_BP_TaxCategory_ID AS PO_BP_T68_203_, businesspa0_.PO_Fixmonthday AS PO_Fixm69_203_, businesspa0_.PO_Fixmonthday2 AS PO_Fixm70_203_, businesspa0_.PO_Fixmonthday3 AS PO_Fixm71_203_, businesspa0_.SO_Bankaccount_ID AS SO_Bank72_203_, businesspa0_.SO_Bp_Taxcategory_ID AS SO_Bp_T73_203_, businesspa0_.Fiscalcode AS Fiscalc74_203_, businesspa0_.Isofiscalcode AS Isofisc75_203_, businesspa0_.EM_Einv_Einvoice AS EM_Einv76_203_, businesspa0_.PO_C_Incoterms_ID AS PO_C_In77_203_, businesspa0_.EM_Einv_Format_Id AS EM_Einv78_203_, businesspa0_.SO_C_Incoterms_ID AS SO_C_In79_203_, businesspa0_.EM_Einv_Platform_Id AS EM_Einv80_203_, businesspa0_.FIN_Paymentmethod_ID AS FIN_Pay81_203_, businesspa0_.EM_Einv_Email AS EM_Einv82_203_, businesspa0_.PO_Paymentmethod_ID AS PO_Paym83_203_, businesspa0_.FIN_Financial_Account_ID AS FIN_Fin84_203_, businesspa0_.EM_Einv_Deliverymode AS EM_Einv85_203_, businesspa0_.PO_Financial_Account_ID AS PO_Fina86_203_, businesspa0_.Customer_Blocking AS Custome87_203_, businesspa0_.Vendor_Blocking AS Vendor_88_203_, businesspa0_.SO_Payment_Blocking AS SO_Paym89_203_, businesspa0_.PO_Payment_Blocking AS PO_Paym90_203_, businesspa0_.SO_Invoice_Blocking AS SO_Invo91_203_, businesspa0_.PO_Invoice_Blocking AS PO_Invo92_203_, businesspa0_.SO_Order_Blocking AS SO_Orde93_203_, businesspa0_.PO_Order_Blocking AS PO_Orde94_203_, businesspa0_.SO_Goods_Blocking AS SO_Good95_203_, businesspa0_.PO_Goods_Blocking AS PO_Good96_203_, businesspa0_.Iscashvat AS Iscashv97_203_, businesspa0_.EM_Advcrm_Newactivity AS EM_Advc98_203_, businesspa0_.Update_Currency AS Update_99_203_, businesspa0_.BP_Currency_ID AS BP_Cur100_203_, businesspa0_.Birthplace AS Birthp101_203_, businesspa0_.Birthday AS Birthd102_203_, businesspa0_.EM_Sgpcrm_Securitygroups_ID AS EM_Sgp103_203_, businesspa0_.Is_Customer_Consent AS Is_Cus104_203_, businesspa0_.EM_OBSMAIL_INVOICEVIAEMAIL AS EM_OBS105_203_, businesspa0_.EM_Obsepad_Mandate_Identifier AS EM_Obs106_203_, businesspa0_.EM_Obsmail_Language AS EM_Obs107_203_, businesspa0_.EM_Obsepad_Mandate_Date AS EM_Obs108_203_, businesspa0_.EM_Aeatsii_Rep_Taxid AS EM_Aea109_203_, businesspa0_.EM_Aeatsii_Menor AS EM_Aea110_203_, businesspa0_.EM_Pricm_Isintercompany AS EM_Pri111_203_, businesspa0_.EM_Psat_Billtobpartner_ID AS EM_Psa112_203_, businesspa0_.EM_Psat_Locator_ID AS EM_Psa113_203_, businesspa0_.EM_Psat_Mobile_Request AS EM_Psa114_203_, businesspa0_.EM_Prges_Glitem_ID AS EM_Prg115_203_, businesspa0_.EM_Rrhh_Exemployee AS EM_Rrh116_203_, businesspa0_.EM_Rrhh_Candidate AS EM_Rrh117_203_, businesspa0_.EM_Prpass_No_Print_Pass AS EM_Prp118_203_, businesspa0_.EM_Rrhh_Holidays_Supervisor AS EM_Rrh119_203_, businesspa0_.EM_Cactal_Emp_No AS EM_Cac120_203_, businesspa0_.EM_Cactal_Emp_Relationship_No AS EM_Cac121_203_, businesspa0_.EM_Obwpl_Bp_Block_Pickinglist AS EM_Obw122_203_, businesspa0_.EM_Pruti_Addbp AS EM_Pru123_203_, businesspa0_.EM_Prpass_Generatepassemployee AS EM_Prp124_203_, businesspa0_.EM_Rrhh_Mainworkstation_ID AS EM_Rrh125_203_, businesspa0_.EM_Rrhh_Bp_Transfer_Code AS EM_Rrh126_203_, businesspa0_.EM_OBTIK_Tax_ID_Key AS EM_OBT127_203_ FROM C_BPartner businesspa0_ WHERE EXISTS ( SELECT 1 FROM C_Order order1_ INNER JOIN C_BPartner businesspa2_ ON order1_.C_BPartner_ID = businesspa2_.C_BPartner_ID WHERE (upper ((order1_.DocumentNo || ' - ' || COALESCE (to_char (order1_.DateOrdered), '') || ' - ' || COALESCE (to_char (order1_.GrandTotal), ''))) LIKE upper ('%2865%') ESCAPE '|') AND businesspa2_.C_BPartner_ID = businesspa0_.C_BPartner_ID AND (order1_.AD_Org_ID IN ('BDE84FCE50FF46FBBFAC648A621443DF', 'D575B67D82034C269C7E0FAF196D90E7', 'F7430A5D620748B19BE7915CDDDA9BE7', '09AA2CDD5352474690D9BB84C869850A', '86EB5CCF7EFE4EACAC3F2E025C137019', '6FA42D7B78034BD8994E9BA7F2CA2281', '1984C825F5534428BD6DDB0CA6D5A440', '5E311B81CDF64243B4C16520C49F3B59', 'D629402D7AE24904A093B7DC01A5CCA5', 'E007B9685155401596452F7B6CD0A6B8', '117C4CA3249B4C0993D36BA80F450C77', 'F89A6E1DA44F40868BF983D4C2384DA6', '2C9FE48909B54B599491D9F69A70A307', 'C2B9461D37104A31B9FD2C1D5E0D381E', '7DBD8F71A3C640028913A30FBCCDF7A7', '432480F1E32D48A19D89CD9A28D7DC1F', 'CDCEFC97D42749ABA78BA3EB973BAC89', 'FCD700C048BB487AA26E639649EB5A96', 'D675D150EA7D4218AF15CF6221A15349', 'DD5A08978B9D43E0ABFAD0B01A9168B0', '9FF601A70F8443138C0EF03BDFDF29F0', '25548EE38FDF4B068F7CFA9FA70FA4FF', '891AF965E0874B4F911504C515619C58', 'CF85EFF5B85A46679AA07AC10CA26CEA', '900D5488BFB64AD4BE463A30ECEDD0FF', '139ED2D4B4CE4901996E0B72E0F87F6C', '0', '4A09EF8E85474DAFA7C132836C07FFF1', '1C36F5B48E224E4D9C82D6A8202996E8', '71ED1EFD88354240BB0412C35E03BF1C', '88CD22344C324943BF5200E06A942459', 'F22E1A745C4C42BCA2386BF8DC013634', '9F797A8A00FC467F90A60E9E62873D59', 'F660F82B9E8C420CAB4FDD68F6DEA416', 'D19EF13F20CD471BB6F6664909C352AF', 'F9B7F11E4E9C43308578C4D73D2B7E00', '658F3A7A05DF4261A63E57B277843BE9', '5D0AF8482E7F489EB482A8B80E7D3F38')) AND (order1_.AD_Client_ID IN ('9CE5D25B1359417991AD7697D6F09896', '0'))) ORDER BY businesspa0_.Value, businesspa0_.Name, businesspa0_.TaxID, businesspa0_.Name2 LIMIT '76';