update C_Invoice set Updated = $1, C_BPartner_ID = $2, C_BPartner_Location_ID = $3, C_PaymentTerm_ID = $4, FIN_Paymentmethod_ID = $5 where C_Invoice_ID = $6;

[ Date: 2026-07-13 09:04:34 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]

select materialmg0_.M_InOut_ID as m_inout_1_710_, materialmg0_.AD_Client_ID as ad_clien2_710_, materialmg0_.AD_Org_ID as ad_org_i3_710_, materialmg0_.IsActive as isactive4_710_, materialmg0_.Created as created5_710_, materialmg0_.CreatedBy as createdb6_710_, materialmg0_.Updated as updated7_710_, materialmg0_.UpdatedBy as updatedb8_710_, materialmg0_.IsSOTrx as issotrx9_710_, materialmg0_.DocumentNo as documen10_710_, materialmg0_.DocAction as docacti11_710_, materialmg0_.DocStatus as docstat12_710_, materialmg0_.Posted as posted13_710_, materialmg0_.Processing as process14_710_, materialmg0_.Processed as process15_710_, materialmg0_.C_DocType_ID as c_docty16_710_, materialmg0_.Description as descrip17_710_, materialmg0_.C_Order_ID as c_order18_710_, materialmg0_.DateOrdered as dateord19_710_, materialmg0_.IsPrinted as isprint20_710_, materialmg0_.MovementType as movemen21_710_, materialmg0_.MovementDate as movemen22_710_, materialmg0_.DateAcct as dateacc23_710_, materialmg0_.C_BPartner_ID as c_bpart24_710_, materialmg0_.C_BPartner_Location_ID as c_bpart25_710_, materialmg0_.M_Warehouse_ID as m_wareh26_710_, materialmg0_.POReference as porefer27_710_, materialmg0_.DeliveryRule as deliver28_710_, materialmg0_.FreightCostRule as freight29_710_, materialmg0_.FreightAmt as freight30_710_, materialmg0_.DeliveryViaRule as deliver31_710_, materialmg0_.M_Shipper_ID as m_shipp32_710_, materialmg0_.C_Charge_ID as c_charg33_710_, materialmg0_.ChargeAmt as chargea34_710_, materialmg0_.PriorityRule as priorit35_710_, materialmg0_.DatePrinted as datepri36_710_, materialmg0_.C_Invoice_ID as c_invoi37_710_, materialmg0_.CreateFrom as createf38_710_, materialmg0_.GenerateTo as generat39_710_, materialmg0_.AD_User_ID as ad_user40_710_, materialmg0_.SalesRep_ID as salesre41_710_, materialmg0_.NoPackages as nopacka42_710_, materialmg0_.PickDate as pickdat43_710_, materialmg0_.ShipDate as shipdat44_710_, materialmg0_.TrackingNo as trackin45_710_, materialmg0_.AD_OrgTrx_ID as ad_orgt46_710_, materialmg0_.C_Project_ID as c_proje47_710_, materialmg0_.C_Campaign_ID as c_campa48_710_, materialmg0_.C_Activity_ID as c_activ49_710_, materialmg0_.User1_ID as user50_710_, materialmg0_.User2_ID as user51_710_, materialmg0_.UpdateLines as updatel52_710_, materialmg0_.Islogistic as islogis53_710_, materialmg0_.Calculate_Freight as calcula54_710_, materialmg0_.Delivery_Location_ID as deliver55_710_, materialmg0_.M_FreightCategory_ID as m_freig56_710_, materialmg0_.Freight_Currency_ID as freight57_710_, materialmg0_.RM_Receipt_PickEdit as rm_rece58_710_, materialmg0_.RM_Shipment_Pickedit as rm_ship59_710_, materialmg0_.EM_Obcma_C_Poc_Email_ID as em_obcm60_710_, materialmg0_.M_Condition_Goods_ID as m_condi61_710_, materialmg0_.A_Asset_ID as a_asset62_710_, materialmg0_.C_Costcenter_ID as c_costc63_710_, materialmg0_.Process_Goods_Java as process64_710_, materialmg0_.Isnettingshipment as isnetti65_710_, materialmg0_.Iscompletelyinvoiced as iscompl66_710_, materialmg0_.EM_OBMFM_Freight_ID as em_obmf67_710_, materialmg0_.EM_Obwpack_Packing as em_obwp68_710_, materialmg0_.EM_Sgpcrm_Securitygroups_ID as em_sgpc69_710_, materialmg0_.EM_OBMFM_Delivery_Charges as em_obmf70_710_, materialmg0_.EM_Obwpack_Packingh_ID as em_obwp71_710_, materialmg0_.Invoicefromshipment as invoice72_710_, materialmg0_.EM_Obwpack_Processed as em_obwp73_710_, materialmg0_.Bpartner_Extref as bpartne74_710_, materialmg0_.EM_Etblkp_Accountingstatus as em_etbl75_710_, materialmg0_.EM_Obwpack_Reactivated as em_obwp76_710_, materialmg0_.EM_Etblkp_Bulkposting as em_etbl77_710_, materialmg0_.EM_Prouti_Changebpartner as em_prou78_710_, materialmg0_.EM_Obwpack_Packingrequired as em_obwp79_710_, materialmg0_.EM_Prouti_Totalqtyreceived as em_prou80_710_, materialmg0_.EM_Pruti_Total_Amt_Tax as em_prut81_710_, materialmg0_.EM_Etblkc_Bulkcompletion as em_etbl82_710_, materialmg0_.EM_OBMFM_Deliverynotes as em_obmf83_710_, materialmg0_.EM_OBEUCI_Ship as em_obeu84_710_, materialmg0_.EM_Prouti_Initial_Bp_ID as em_prou85_710_, materialmg0_.EM_Prouti_Move_Stock as em_prou86_710_, materialmg0_.EM_Prouti_Stock_Moved as em_prou87_710_, materialmg0_.EM_Advpro2_Outsourcing_ID as em_advp88_710_, materialmg0_.EM_Pruti_Showpriceingoods as em_prut89_710_, materialmg0_.em_fshpie_piece_manage as em_fshp90_710_, materialmg0_.em_prlab_desc as em_prla91_710_, materialmg0_.em_prouti_invoiced as em_prou92_710_, materialmg0_.EM_Pruti_Createfrom as em_prut93_710_ from M_InOut materialmg0_ left outer join C_BPartner businesspa1_ on materialmg0_.C_BPartner_ID = businesspa1_.C_BPartner_ID cross join M_InOut shipmentin2_ cross join C_DocType documentty3_ where materialmg0_.M_InOut_ID = shipmentin2_.M_InOut_ID and materialmg0_.C_DocType_ID = documentty3_.C_DocType_ID and (upper((businesspa1_.Value || ' - ' || businesspa1_.Name || ' - ' || coalesce(to_char(businesspa1_.TaxID), '') || ' - ' || coalesce(to_char(businesspa1_.Name2), ''))) like upper('%6504%') escape '|') and materialmg0_.DocStatus = 'CO' and ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin2_.m_inout_id) from dual) = '0' and (materialmg0_.MovementType in ('C-', 'C+')) and materialmg0_.Islogistic = 'N' and documentty3_.IsReturn = 'N' and (materialmg0_.AD_Org_ID in ('0', '7AC30B45BDA9448C97F393E9C698F797', 'F6E0484F9EC04B209FBAA42D32AC4560')) and (materialmg0_.AD_Client_ID in ('E94C609967684AD09D3A2D939308F233', '0')) order by materialmg0_.DocumentNo, materialmg0_.M_InOut_ID limit '101';

[ Date: 2026-07-13 14:45:18 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

select businesspa0_.C_BPartner_ID as c_bpartn1_289_, businesspa0_.AD_Client_ID as ad_clien2_289_, businesspa0_.AD_Org_ID as ad_org_i3_289_, businesspa0_.IsActive as isactive4_289_, businesspa0_.Created as created5_289_, businesspa0_.CreatedBy as createdb6_289_, businesspa0_.Updated as updated7_289_, businesspa0_.UpdatedBy as updatedb8_289_, businesspa0_.Value as value9_289_, businesspa0_.Name as name10_289_, businesspa0_.Name2 as name11_289_, businesspa0_.Description as descrip12_289_, businesspa0_.IsSummary as issumma13_289_, businesspa0_.C_BP_Group_ID as c_bp_gr14_289_, businesspa0_.IsOneTime as isoneti15_289_, businesspa0_.IsProspect as isprosp16_289_, businesspa0_.IsVendor as isvendo17_289_, businesspa0_.IsCustomer as iscusto18_289_, businesspa0_.IsEmployee as isemplo19_289_, businesspa0_.IsSalesRep as issales20_289_, businesspa0_.ReferenceNo as referen21_289_, businesspa0_.DUNS as duns22_289_, businesspa0_.URL as url23_289_, businesspa0_.AD_Language as ad_lang24_289_, businesspa0_.TaxID as taxid25_289_, businesspa0_.IsTaxExempt as istaxex26_289_, businesspa0_.C_InvoiceSchedule_ID as c_invoi27_289_, businesspa0_.Rating as rating28_289_, businesspa0_.SalesVolume as salesvo29_289_, businesspa0_.NumberEmployees as numbere30_289_, businesspa0_.NAICS as naics31_289_, businesspa0_.FirstSale as firstsa32_289_, businesspa0_.AcqusitionCost as acqusit33_289_, businesspa0_.PotentialLifeTimeValue as potenti34_289_, businesspa0_.ActualLifeTimeValue as actuall35_289_, businesspa0_.ShareOfCustomer as shareof36_289_, businesspa0_.PaymentRule as payment37_289_, businesspa0_.SO_CreditLimit as so_cred38_289_, businesspa0_.SO_CreditUsed as so_cred39_289_, businesspa0_.C_PaymentTerm_ID as c_payme40_289_, businesspa0_.M_PriceList_ID as m_price41_289_, businesspa0_.IsDiscountPrinted as isdisco42_289_, businesspa0_.SO_Description as so_desc43_289_, businesspa0_.POReference as porefer44_289_, businesspa0_.PaymentRulePO as payment45_289_, businesspa0_.PO_PriceList_ID as po_pric46_289_, businesspa0_.PO_PaymentTerm_ID as po_paym47_289_, businesspa0_.DocumentCopies as documen48_289_, businesspa0_.C_Greeting_ID as c_greet49_289_, businesspa0_.InvoiceRule as invoice50_289_, businesspa0_.DeliveryRule as deliver51_289_, businesspa0_.DeliveryViaRule as deliver52_289_, businesspa0_.SalesRep_ID as salesre53_289_, businesspa0_.BPartner_Parent_ID as bpartne54_289_, businesspa0_.SOCreditStatus as socredi55_289_, businesspa0_.AD_Forced_Org_ID as ad_forc56_289_, businesspa0_.ShowPriceInOrder as showpri57_289_, businesspa0_.Invoicegrouping as invoice58_289_, businesspa0_.FixMonthDay as fixmont59_289_, businesspa0_.FixMonthDay2 as fixmont60_289_, businesspa0_.Fixmonthday3 as fixmont61_289_, businesspa0_.Isworker as isworke62_289_, businesspa0_.UPC as upc63_289_, businesspa0_.C_Salary_Category_ID as c_salar64_289_, businesspa0_.Invoice_Printformat as invoice65_289_, businesspa0_.Last_Days as last_da66_289_, businesspa0_.PO_Bankaccount_ID as po_bank67_289_, businesspa0_.PO_BP_TaxCategory_ID as po_bp_t68_289_, businesspa0_.PO_Fixmonthday as po_fixm69_289_, businesspa0_.PO_Fixmonthday2 as po_fixm70_289_, businesspa0_.PO_Fixmonthday3 as po_fixm71_289_, businesspa0_.SO_Bankaccount_ID as so_bank72_289_, businesspa0_.SO_Bp_Taxcategory_ID as so_bp_t73_289_, businesspa0_.Fiscalcode as fiscalc74_289_, businesspa0_.Isofiscalcode as isofisc75_289_, businesspa0_.EM_Einv_Einvoice as em_einv76_289_, businesspa0_.PO_C_Incoterms_ID as po_c_in77_289_, businesspa0_.EM_Einv_Format_Id as em_einv78_289_, businesspa0_.SO_C_Incoterms_ID as so_c_in79_289_, businesspa0_.EM_Einv_Platform_Id as em_einv80_289_, businesspa0_.FIN_Paymentmethod_ID as fin_pay81_289_, businesspa0_.EM_Einv_Email as em_einv82_289_, businesspa0_.PO_Paymentmethod_ID as po_paym83_289_, businesspa0_.FIN_Financial_Account_ID as fin_fin84_289_, businesspa0_.EM_Einv_Deliverymode as em_einv85_289_, businesspa0_.PO_Financial_Account_ID as po_fina86_289_, businesspa0_.Customer_Blocking as custome87_289_, businesspa0_.Vendor_Blocking as vendor_88_289_, businesspa0_.SO_Payment_Blocking as so_paym89_289_, businesspa0_.PO_Payment_Blocking as po_paym90_289_, businesspa0_.SO_Invoice_Blocking as so_invo91_289_, businesspa0_.PO_Invoice_Blocking as po_invo92_289_, businesspa0_.SO_Order_Blocking as so_orde93_289_, businesspa0_.PO_Order_Blocking as po_orde94_289_, businesspa0_.SO_Goods_Blocking as so_good95_289_, businesspa0_.PO_Goods_Blocking as po_good96_289_, businesspa0_.Iscashvat as iscashv97_289_, businesspa0_.EM_Advcrm_Newactivity as em_advc98_289_, businesspa0_.Update_Currency as update_99_289_, businesspa0_.BP_Currency_ID as bp_cur100_289_, businesspa0_.Birthplace as birthp101_289_, businesspa0_.Birthday as birthd102_289_, businesspa0_.EM_Advpro2_Workshop as em_adv103_289_, businesspa0_.EM_Sgpcrm_Securitygroups_ID as em_sgp104_289_, businesspa0_.em_advpro2_outsrcplist_id as em_adv105_289_, businesspa0_.Is_Customer_Consent as is_cus106_289_, businesspa0_.EM_Advpro2_Createrescap as em_adv107_289_, businesspa0_.EM_Obsepad_Mandate_Identifier as em_obs108_289_, businesspa0_.EM_Obsepad_Mandate_Date as em_obs109_289_, businesspa0_.EM_Aeatsii_Rep_Taxid as em_aea110_289_, businesspa0_.EM_Aeatsii_Menor as em_aea111_289_, businesspa0_.EM_Fshins_Show_Risks as em_fsh112_289_, businesspa0_.EM_Pruti_Addbp as em_pru113_289_, businesspa0_.EM_Pruti_Unlock_Date as em_pru114_289_, businesspa0_.EM_Pruti_Unlock_Order_Date as em_pru115_289_, businesspa0_.EM_Pruti_Annexes_Bp_So_ID as em_pru116_289_, businesspa0_.EM_Pruti_Annexes_Bp_Po_ID as em_pru117_289_, businesspa0_.EM_Aeatsii_Defaultsiikey as em_aea118_289_, businesspa0_.EM_Aeatsii_Siikeylist as em_aea119_289_, businesspa0_.EM_Advcrm2_Confirming_Mail as em_adv120_289_, businesspa0_.EM_Tbai_Issimplifiedinv as em_tba121_289_, businesspa0_.EM_Obwpl_Bp_Block_Pickinglist as em_obw122_289_, businesspa0_.EM_Advpro2_Generate_Capacity as em_adv123_289_, businesspa0_.em_pruti_cus_block_reason_id as em_pru124_289_, businesspa0_.EM_Pruti_Notsendinvoice as em_pru125_289_, businesspa0_.EM_Prfuti_No_Autoconsume as em_prf126_289_, businesspa0_.EM_Pruti_Showpriceingoods as em_pru127_289_, businesspa0_.EM_OBTIK_Tax_ID_Key as em_obt128_289_ from C_BPartner businesspa0_ where (upper((businesspa0_.Value || ' - ' || businesspa0_.Name || ' - ' || coalesce(to_char(businesspa0_.TaxID), '') || ' - ' || coalesce(to_char(businesspa0_.Name2), ''))) like upper('%6%') escape '|') and (exists ( select 1 from M_InOut materialmg1_ inner join C_BPartner businesspa2_ on materialmg1_.C_BPartner_ID = businesspa2_.C_BPartner_ID cross join M_InOut shipmentin3_ cross join C_DocType documentty4_ where materialmg1_.M_InOut_ID = shipmentin3_.M_InOut_ID and materialmg1_.C_DocType_ID = documentty4_.C_DocType_ID and materialmg1_.DocStatus = 'CO' and ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin3_.m_inout_id) from dual) = '0' and (materialmg1_.MovementType in ('C-', 'C+')) and materialmg1_.Islogistic = 'N' and documentty4_.IsReturn = 'N' and businesspa2_.C_BPartner_ID = businesspa0_.C_BPartner_ID and (materialmg1_.AD_Org_ID in ('0', '7AC30B45BDA9448C97F393E9C698F797', 'F6E0484F9EC04B209FBAA42D32AC4560')) and (materialmg1_.AD_Client_ID in ('E94C609967684AD09D3A2D939308F233', '0')))) order by businesspa0_.Value, businesspa0_.Name, businesspa0_.TaxID, businesspa0_.Name2 limit '76';

[ Date: 2026-07-13 14:45:13 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

select businesspa0_.C_BPartner_ID as c_bpartn1_289_, businesspa0_.AD_Client_ID as ad_clien2_289_, businesspa0_.AD_Org_ID as ad_org_i3_289_, businesspa0_.IsActive as isactive4_289_, businesspa0_.Created as created5_289_, businesspa0_.CreatedBy as createdb6_289_, businesspa0_.Updated as updated7_289_, businesspa0_.UpdatedBy as updatedb8_289_, businesspa0_.Value as value9_289_, businesspa0_.Name as name10_289_, businesspa0_.Name2 as name11_289_, businesspa0_.Description as descrip12_289_, businesspa0_.IsSummary as issumma13_289_, businesspa0_.C_BP_Group_ID as c_bp_gr14_289_, businesspa0_.IsOneTime as isoneti15_289_, businesspa0_.IsProspect as isprosp16_289_, businesspa0_.IsVendor as isvendo17_289_, businesspa0_.IsCustomer as iscusto18_289_, businesspa0_.IsEmployee as isemplo19_289_, businesspa0_.IsSalesRep as issales20_289_, businesspa0_.ReferenceNo as referen21_289_, businesspa0_.DUNS as duns22_289_, businesspa0_.URL as url23_289_, businesspa0_.AD_Language as ad_lang24_289_, businesspa0_.TaxID as taxid25_289_, businesspa0_.IsTaxExempt as istaxex26_289_, businesspa0_.C_InvoiceSchedule_ID as c_invoi27_289_, businesspa0_.Rating as rating28_289_, businesspa0_.SalesVolume as salesvo29_289_, businesspa0_.NumberEmployees as numbere30_289_, businesspa0_.NAICS as naics31_289_, businesspa0_.FirstSale as firstsa32_289_, businesspa0_.AcqusitionCost as acqusit33_289_, businesspa0_.PotentialLifeTimeValue as potenti34_289_, businesspa0_.ActualLifeTimeValue as actuall35_289_, businesspa0_.ShareOfCustomer as shareof36_289_, businesspa0_.PaymentRule as payment37_289_, businesspa0_.SO_CreditLimit as so_cred38_289_, businesspa0_.SO_CreditUsed as so_cred39_289_, businesspa0_.C_PaymentTerm_ID as c_payme40_289_, businesspa0_.M_PriceList_ID as m_price41_289_, businesspa0_.IsDiscountPrinted as isdisco42_289_, businesspa0_.SO_Description as so_desc43_289_, businesspa0_.POReference as porefer44_289_, businesspa0_.PaymentRulePO as payment45_289_, businesspa0_.PO_PriceList_ID as po_pric46_289_, businesspa0_.PO_PaymentTerm_ID as po_paym47_289_, businesspa0_.DocumentCopies as documen48_289_, businesspa0_.C_Greeting_ID as c_greet49_289_, businesspa0_.InvoiceRule as invoice50_289_, businesspa0_.DeliveryRule as deliver51_289_, businesspa0_.DeliveryViaRule as deliver52_289_, businesspa0_.SalesRep_ID as salesre53_289_, businesspa0_.BPartner_Parent_ID as bpartne54_289_, businesspa0_.SOCreditStatus as socredi55_289_, businesspa0_.AD_Forced_Org_ID as ad_forc56_289_, businesspa0_.ShowPriceInOrder as showpri57_289_, businesspa0_.Invoicegrouping as invoice58_289_, businesspa0_.FixMonthDay as fixmont59_289_, businesspa0_.FixMonthDay2 as fixmont60_289_, businesspa0_.Fixmonthday3 as fixmont61_289_, businesspa0_.Isworker as isworke62_289_, businesspa0_.UPC as upc63_289_, businesspa0_.C_Salary_Category_ID as c_salar64_289_, businesspa0_.Invoice_Printformat as invoice65_289_, businesspa0_.Last_Days as last_da66_289_, businesspa0_.PO_Bankaccount_ID as po_bank67_289_, businesspa0_.PO_BP_TaxCategory_ID as po_bp_t68_289_, businesspa0_.PO_Fixmonthday as po_fixm69_289_, businesspa0_.PO_Fixmonthday2 as po_fixm70_289_, businesspa0_.PO_Fixmonthday3 as po_fixm71_289_, businesspa0_.SO_Bankaccount_ID as so_bank72_289_, businesspa0_.SO_Bp_Taxcategory_ID as so_bp_t73_289_, businesspa0_.Fiscalcode as fiscalc74_289_, businesspa0_.Isofiscalcode as isofisc75_289_, businesspa0_.EM_Einv_Einvoice as em_einv76_289_, businesspa0_.PO_C_Incoterms_ID as po_c_in77_289_, businesspa0_.EM_Einv_Format_Id as em_einv78_289_, businesspa0_.SO_C_Incoterms_ID as so_c_in79_289_, businesspa0_.EM_Einv_Platform_Id as em_einv80_289_, businesspa0_.FIN_Paymentmethod_ID as fin_pay81_289_, businesspa0_.EM_Einv_Email as em_einv82_289_, businesspa0_.PO_Paymentmethod_ID as po_paym83_289_, businesspa0_.FIN_Financial_Account_ID as fin_fin84_289_, businesspa0_.EM_Einv_Deliverymode as em_einv85_289_, businesspa0_.PO_Financial_Account_ID as po_fina86_289_, businesspa0_.Customer_Blocking as custome87_289_, businesspa0_.Vendor_Blocking as vendor_88_289_, businesspa0_.SO_Payment_Blocking as so_paym89_289_, businesspa0_.PO_Payment_Blocking as po_paym90_289_, businesspa0_.SO_Invoice_Blocking as so_invo91_289_, businesspa0_.PO_Invoice_Blocking as po_invo92_289_, businesspa0_.SO_Order_Blocking as so_orde93_289_, businesspa0_.PO_Order_Blocking as po_orde94_289_, businesspa0_.SO_Goods_Blocking as so_good95_289_, businesspa0_.PO_Goods_Blocking as po_good96_289_, businesspa0_.Iscashvat as iscashv97_289_, businesspa0_.EM_Advcrm_Newactivity as em_advc98_289_, businesspa0_.Update_Currency as update_99_289_, businesspa0_.BP_Currency_ID as bp_cur100_289_, businesspa0_.Birthplace as birthp101_289_, businesspa0_.Birthday as birthd102_289_, businesspa0_.EM_Advpro2_Workshop as em_adv103_289_, businesspa0_.EM_Sgpcrm_Securitygroups_ID as em_sgp104_289_, businesspa0_.em_advpro2_outsrcplist_id as em_adv105_289_, businesspa0_.Is_Customer_Consent as is_cus106_289_, businesspa0_.EM_Advpro2_Createrescap as em_adv107_289_, businesspa0_.EM_Obsepad_Mandate_Identifier as em_obs108_289_, businesspa0_.EM_Obsepad_Mandate_Date as em_obs109_289_, businesspa0_.EM_Aeatsii_Rep_Taxid as em_aea110_289_, businesspa0_.EM_Aeatsii_Menor as em_aea111_289_, businesspa0_.EM_Fshins_Show_Risks as em_fsh112_289_, businesspa0_.EM_Pruti_Addbp as em_pru113_289_, businesspa0_.EM_Pruti_Unlock_Date as em_pru114_289_, businesspa0_.EM_Pruti_Unlock_Order_Date as em_pru115_289_, businesspa0_.EM_Pruti_Annexes_Bp_So_ID as em_pru116_289_, businesspa0_.EM_Pruti_Annexes_Bp_Po_ID as em_pru117_289_, businesspa0_.EM_Aeatsii_Defaultsiikey as em_aea118_289_, businesspa0_.EM_Aeatsii_Siikeylist as em_aea119_289_, businesspa0_.EM_Advcrm2_Confirming_Mail as em_adv120_289_, businesspa0_.EM_Tbai_Issimplifiedinv as em_tba121_289_, businesspa0_.EM_Obwpl_Bp_Block_Pickinglist as em_obw122_289_, businesspa0_.EM_Advpro2_Generate_Capacity as em_adv123_289_, businesspa0_.em_pruti_cus_block_reason_id as em_pru124_289_, businesspa0_.EM_Pruti_Notsendinvoice as em_pru125_289_, businesspa0_.EM_Prfuti_No_Autoconsume as em_prf126_289_, businesspa0_.EM_Pruti_Showpriceingoods as em_pru127_289_, businesspa0_.EM_OBTIK_Tax_ID_Key as em_obt128_289_ from C_BPartner businesspa0_ where (upper((businesspa0_.Value || ' - ' || businesspa0_.Name || ' - ' || coalesce(to_char(businesspa0_.TaxID), '') || ' - ' || coalesce(to_char(businesspa0_.Name2), ''))) like upper('%65%') escape '|') and (exists ( select 1 from M_InOut materialmg1_ inner join C_BPartner businesspa2_ on materialmg1_.C_BPartner_ID = businesspa2_.C_BPartner_ID cross join M_InOut shipmentin3_ cross join C_DocType documentty4_ where materialmg1_.M_InOut_ID = shipmentin3_.M_InOut_ID and materialmg1_.C_DocType_ID = documentty4_.C_DocType_ID and materialmg1_.DocStatus = 'CO' and ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin3_.m_inout_id) from dual) = '0' and (materialmg1_.MovementType in ('C-', 'C+')) and materialmg1_.Islogistic = 'N' and documentty4_.IsReturn = 'N' and businesspa2_.C_BPartner_ID = businesspa0_.C_BPartner_ID and (materialmg1_.AD_Org_ID in ('0', '7AC30B45BDA9448C97F393E9C698F797', 'F6E0484F9EC04B209FBAA42D32AC4560')) and (materialmg1_.AD_Client_ID in ('E94C609967684AD09D3A2D939308F233', '0')))) order by businesspa0_.Value, businesspa0_.Name, businesspa0_.TaxID, businesspa0_.Name2 limit '76';

[ Date: 2026-07-13 14:45:14 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

select businesspa0_.C_BPartner_ID as c_bpartn1_289_, businesspa0_.AD_Client_ID as ad_clien2_289_, businesspa0_.AD_Org_ID as ad_org_i3_289_, businesspa0_.IsActive as isactive4_289_, businesspa0_.Created as created5_289_, businesspa0_.CreatedBy as createdb6_289_, businesspa0_.Updated as updated7_289_, businesspa0_.UpdatedBy as updatedb8_289_, businesspa0_.Value as value9_289_, businesspa0_.Name as name10_289_, businesspa0_.Name2 as name11_289_, businesspa0_.Description as descrip12_289_, businesspa0_.IsSummary as issumma13_289_, businesspa0_.C_BP_Group_ID as c_bp_gr14_289_, businesspa0_.IsOneTime as isoneti15_289_, businesspa0_.IsProspect as isprosp16_289_, businesspa0_.IsVendor as isvendo17_289_, businesspa0_.IsCustomer as iscusto18_289_, businesspa0_.IsEmployee as isemplo19_289_, businesspa0_.IsSalesRep as issales20_289_, businesspa0_.ReferenceNo as referen21_289_, businesspa0_.DUNS as duns22_289_, businesspa0_.URL as url23_289_, businesspa0_.AD_Language as ad_lang24_289_, businesspa0_.TaxID as taxid25_289_, businesspa0_.IsTaxExempt as istaxex26_289_, businesspa0_.C_InvoiceSchedule_ID as c_invoi27_289_, businesspa0_.Rating as rating28_289_, businesspa0_.SalesVolume as salesvo29_289_, businesspa0_.NumberEmployees as numbere30_289_, businesspa0_.NAICS as naics31_289_, businesspa0_.FirstSale as firstsa32_289_, businesspa0_.AcqusitionCost as acqusit33_289_, businesspa0_.PotentialLifeTimeValue as potenti34_289_, businesspa0_.ActualLifeTimeValue as actuall35_289_, businesspa0_.ShareOfCustomer as shareof36_289_, businesspa0_.PaymentRule as payment37_289_, businesspa0_.SO_CreditLimit as so_cred38_289_, businesspa0_.SO_CreditUsed as so_cred39_289_, businesspa0_.C_PaymentTerm_ID as c_payme40_289_, businesspa0_.M_PriceList_ID as m_price41_289_, businesspa0_.IsDiscountPrinted as isdisco42_289_, businesspa0_.SO_Description as so_desc43_289_, businesspa0_.POReference as porefer44_289_, businesspa0_.PaymentRulePO as payment45_289_, businesspa0_.PO_PriceList_ID as po_pric46_289_, businesspa0_.PO_PaymentTerm_ID as po_paym47_289_, businesspa0_.DocumentCopies as documen48_289_, businesspa0_.C_Greeting_ID as c_greet49_289_, businesspa0_.InvoiceRule as invoice50_289_, businesspa0_.DeliveryRule as deliver51_289_, businesspa0_.DeliveryViaRule as deliver52_289_, businesspa0_.SalesRep_ID as salesre53_289_, businesspa0_.BPartner_Parent_ID as bpartne54_289_, businesspa0_.SOCreditStatus as socredi55_289_, businesspa0_.AD_Forced_Org_ID as ad_forc56_289_, businesspa0_.ShowPriceInOrder as showpri57_289_, businesspa0_.Invoicegrouping as invoice58_289_, businesspa0_.FixMonthDay as fixmont59_289_, businesspa0_.FixMonthDay2 as fixmont60_289_, businesspa0_.Fixmonthday3 as fixmont61_289_, businesspa0_.Isworker as isworke62_289_, businesspa0_.UPC as upc63_289_, businesspa0_.C_Salary_Category_ID as c_salar64_289_, businesspa0_.Invoice_Printformat as invoice65_289_, businesspa0_.Last_Days as last_da66_289_, businesspa0_.PO_Bankaccount_ID as po_bank67_289_, businesspa0_.PO_BP_TaxCategory_ID as po_bp_t68_289_, businesspa0_.PO_Fixmonthday as po_fixm69_289_, businesspa0_.PO_Fixmonthday2 as po_fixm70_289_, businesspa0_.PO_Fixmonthday3 as po_fixm71_289_, businesspa0_.SO_Bankaccount_ID as so_bank72_289_, businesspa0_.SO_Bp_Taxcategory_ID as so_bp_t73_289_, businesspa0_.Fiscalcode as fiscalc74_289_, businesspa0_.Isofiscalcode as isofisc75_289_, businesspa0_.EM_Einv_Einvoice as em_einv76_289_, businesspa0_.PO_C_Incoterms_ID as po_c_in77_289_, businesspa0_.EM_Einv_Format_Id as em_einv78_289_, businesspa0_.SO_C_Incoterms_ID as so_c_in79_289_, businesspa0_.EM_Einv_Platform_Id as em_einv80_289_, businesspa0_.FIN_Paymentmethod_ID as fin_pay81_289_, businesspa0_.EM_Einv_Email as em_einv82_289_, businesspa0_.PO_Paymentmethod_ID as po_paym83_289_, businesspa0_.FIN_Financial_Account_ID as fin_fin84_289_, businesspa0_.EM_Einv_Deliverymode as em_einv85_289_, businesspa0_.PO_Financial_Account_ID as po_fina86_289_, businesspa0_.Customer_Blocking as custome87_289_, businesspa0_.Vendor_Blocking as vendor_88_289_, businesspa0_.SO_Payment_Blocking as so_paym89_289_, businesspa0_.PO_Payment_Blocking as po_paym90_289_, businesspa0_.SO_Invoice_Blocking as so_invo91_289_, businesspa0_.PO_Invoice_Blocking as po_invo92_289_, businesspa0_.SO_Order_Blocking as so_orde93_289_, businesspa0_.PO_Order_Blocking as po_orde94_289_, businesspa0_.SO_Goods_Blocking as so_good95_289_, businesspa0_.PO_Goods_Blocking as po_good96_289_, businesspa0_.Iscashvat as iscashv97_289_, businesspa0_.EM_Advcrm_Newactivity as em_advc98_289_, businesspa0_.Update_Currency as update_99_289_, businesspa0_.BP_Currency_ID as bp_cur100_289_, businesspa0_.Birthplace as birthp101_289_, businesspa0_.Birthday as birthd102_289_, businesspa0_.EM_Advpro2_Workshop as em_adv103_289_, businesspa0_.EM_Sgpcrm_Securitygroups_ID as em_sgp104_289_, businesspa0_.em_advpro2_outsrcplist_id as em_adv105_289_, businesspa0_.Is_Customer_Consent as is_cus106_289_, businesspa0_.EM_Advpro2_Createrescap as em_adv107_289_, businesspa0_.EM_Obsepad_Mandate_Identifier as em_obs108_289_, businesspa0_.EM_Obsepad_Mandate_Date as em_obs109_289_, businesspa0_.EM_Aeatsii_Rep_Taxid as em_aea110_289_, businesspa0_.EM_Aeatsii_Menor as em_aea111_289_, businesspa0_.EM_Fshins_Show_Risks as em_fsh112_289_, businesspa0_.EM_Pruti_Addbp as em_pru113_289_, businesspa0_.EM_Pruti_Unlock_Date as em_pru114_289_, businesspa0_.EM_Pruti_Unlock_Order_Date as em_pru115_289_, businesspa0_.EM_Pruti_Annexes_Bp_So_ID as em_pru116_289_, businesspa0_.EM_Pruti_Annexes_Bp_Po_ID as em_pru117_289_, businesspa0_.EM_Aeatsii_Defaultsiikey as em_aea118_289_, businesspa0_.EM_Aeatsii_Siikeylist as em_aea119_289_, businesspa0_.EM_Advcrm2_Confirming_Mail as em_adv120_289_, businesspa0_.EM_Tbai_Issimplifiedinv as em_tba121_289_, businesspa0_.EM_Obwpl_Bp_Block_Pickinglist as em_obw122_289_, businesspa0_.EM_Advpro2_Generate_Capacity as em_adv123_289_, businesspa0_.em_pruti_cus_block_reason_id as em_pru124_289_, businesspa0_.EM_Pruti_Notsendinvoice as em_pru125_289_, businesspa0_.EM_Prfuti_No_Autoconsume as em_prf126_289_, businesspa0_.EM_Pruti_Showpriceingoods as em_pru127_289_, businesspa0_.EM_OBTIK_Tax_ID_Key as em_obt128_289_ from C_BPartner businesspa0_ where (upper((businesspa0_.Value || ' - ' || businesspa0_.Name || ' - ' || coalesce(to_char(businesspa0_.TaxID), '') || ' - ' || coalesce(to_char(businesspa0_.Name2), ''))) like upper('%650%') escape '|') and (exists ( select 1 from M_InOut materialmg1_ inner join C_BPartner businesspa2_ on materialmg1_.C_BPartner_ID = businesspa2_.C_BPartner_ID cross join M_InOut shipmentin3_ cross join C_DocType documentty4_ where materialmg1_.M_InOut_ID = shipmentin3_.M_InOut_ID and materialmg1_.C_DocType_ID = documentty4_.C_DocType_ID and materialmg1_.DocStatus = 'CO' and ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin3_.m_inout_id) from dual) = '0' and (materialmg1_.MovementType in ('C-', 'C+')) and materialmg1_.Islogistic = 'N' and documentty4_.IsReturn = 'N' and businesspa2_.C_BPartner_ID = businesspa0_.C_BPartner_ID and (materialmg1_.AD_Org_ID in ('0', '7AC30B45BDA9448C97F393E9C698F797', 'F6E0484F9EC04B209FBAA42D32AC4560')) and (materialmg1_.AD_Client_ID in ('E94C609967684AD09D3A2D939308F233', '0')))) order by businesspa0_.Value, businesspa0_.Name, businesspa0_.TaxID, businesspa0_.Name2 limit '76';

[ Date: 2026-07-13 14:45:14 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

select businesspa0_.C_BPartner_ID as c_bpartn1_289_, businesspa0_.AD_Client_ID as ad_clien2_289_, businesspa0_.AD_Org_ID as ad_org_i3_289_, businesspa0_.IsActive as isactive4_289_, businesspa0_.Created as created5_289_, businesspa0_.CreatedBy as createdb6_289_, businesspa0_.Updated as updated7_289_, businesspa0_.UpdatedBy as updatedb8_289_, businesspa0_.Value as value9_289_, businesspa0_.Name as name10_289_, businesspa0_.Name2 as name11_289_, businesspa0_.Description as descrip12_289_, businesspa0_.IsSummary as issumma13_289_, businesspa0_.C_BP_Group_ID as c_bp_gr14_289_, businesspa0_.IsOneTime as isoneti15_289_, businesspa0_.IsProspect as isprosp16_289_, businesspa0_.IsVendor as isvendo17_289_, businesspa0_.IsCustomer as iscusto18_289_, businesspa0_.IsEmployee as isemplo19_289_, businesspa0_.IsSalesRep as issales20_289_, businesspa0_.ReferenceNo as referen21_289_, businesspa0_.DUNS as duns22_289_, businesspa0_.URL as url23_289_, businesspa0_.AD_Language as ad_lang24_289_, businesspa0_.TaxID as taxid25_289_, businesspa0_.IsTaxExempt as istaxex26_289_, businesspa0_.C_InvoiceSchedule_ID as c_invoi27_289_, businesspa0_.Rating as rating28_289_, businesspa0_.SalesVolume as salesvo29_289_, businesspa0_.NumberEmployees as numbere30_289_, businesspa0_.NAICS as naics31_289_, businesspa0_.FirstSale as firstsa32_289_, businesspa0_.AcqusitionCost as acqusit33_289_, businesspa0_.PotentialLifeTimeValue as potenti34_289_, businesspa0_.ActualLifeTimeValue as actuall35_289_, businesspa0_.ShareOfCustomer as shareof36_289_, businesspa0_.PaymentRule as payment37_289_, businesspa0_.SO_CreditLimit as so_cred38_289_, businesspa0_.SO_CreditUsed as so_cred39_289_, businesspa0_.C_PaymentTerm_ID as c_payme40_289_, businesspa0_.M_PriceList_ID as m_price41_289_, businesspa0_.IsDiscountPrinted as isdisco42_289_, businesspa0_.SO_Description as so_desc43_289_, businesspa0_.POReference as porefer44_289_, businesspa0_.PaymentRulePO as payment45_289_, businesspa0_.PO_PriceList_ID as po_pric46_289_, businesspa0_.PO_PaymentTerm_ID as po_paym47_289_, businesspa0_.DocumentCopies as documen48_289_, businesspa0_.C_Greeting_ID as c_greet49_289_, businesspa0_.InvoiceRule as invoice50_289_, businesspa0_.DeliveryRule as deliver51_289_, businesspa0_.DeliveryViaRule as deliver52_289_, businesspa0_.SalesRep_ID as salesre53_289_, businesspa0_.BPartner_Parent_ID as bpartne54_289_, businesspa0_.SOCreditStatus as socredi55_289_, businesspa0_.AD_Forced_Org_ID as ad_forc56_289_, businesspa0_.ShowPriceInOrder as showpri57_289_, businesspa0_.Invoicegrouping as invoice58_289_, businesspa0_.FixMonthDay as fixmont59_289_, businesspa0_.FixMonthDay2 as fixmont60_289_, businesspa0_.Fixmonthday3 as fixmont61_289_, businesspa0_.Isworker as isworke62_289_, businesspa0_.UPC as upc63_289_, businesspa0_.C_Salary_Category_ID as c_salar64_289_, businesspa0_.Invoice_Printformat as invoice65_289_, businesspa0_.Last_Days as last_da66_289_, businesspa0_.PO_Bankaccount_ID as po_bank67_289_, businesspa0_.PO_BP_TaxCategory_ID as po_bp_t68_289_, businesspa0_.PO_Fixmonthday as po_fixm69_289_, businesspa0_.PO_Fixmonthday2 as po_fixm70_289_, businesspa0_.PO_Fixmonthday3 as po_fixm71_289_, businesspa0_.SO_Bankaccount_ID as so_bank72_289_, businesspa0_.SO_Bp_Taxcategory_ID as so_bp_t73_289_, businesspa0_.Fiscalcode as fiscalc74_289_, businesspa0_.Isofiscalcode as isofisc75_289_, businesspa0_.EM_Einv_Einvoice as em_einv76_289_, businesspa0_.PO_C_Incoterms_ID as po_c_in77_289_, businesspa0_.EM_Einv_Format_Id as em_einv78_289_, businesspa0_.SO_C_Incoterms_ID as so_c_in79_289_, businesspa0_.EM_Einv_Platform_Id as em_einv80_289_, businesspa0_.FIN_Paymentmethod_ID as fin_pay81_289_, businesspa0_.EM_Einv_Email as em_einv82_289_, businesspa0_.PO_Paymentmethod_ID as po_paym83_289_, businesspa0_.FIN_Financial_Account_ID as fin_fin84_289_, businesspa0_.EM_Einv_Deliverymode as em_einv85_289_, businesspa0_.PO_Financial_Account_ID as po_fina86_289_, businesspa0_.Customer_Blocking as custome87_289_, businesspa0_.Vendor_Blocking as vendor_88_289_, businesspa0_.SO_Payment_Blocking as so_paym89_289_, businesspa0_.PO_Payment_Blocking as po_paym90_289_, businesspa0_.SO_Invoice_Blocking as so_invo91_289_, businesspa0_.PO_Invoice_Blocking as po_invo92_289_, businesspa0_.SO_Order_Blocking as so_orde93_289_, businesspa0_.PO_Order_Blocking as po_orde94_289_, businesspa0_.SO_Goods_Blocking as so_good95_289_, businesspa0_.PO_Goods_Blocking as po_good96_289_, businesspa0_.Iscashvat as iscashv97_289_, businesspa0_.EM_Advcrm_Newactivity as em_advc98_289_, businesspa0_.Update_Currency as update_99_289_, businesspa0_.BP_Currency_ID as bp_cur100_289_, businesspa0_.Birthplace as birthp101_289_, businesspa0_.Birthday as birthd102_289_, businesspa0_.EM_Advpro2_Workshop as em_adv103_289_, businesspa0_.EM_Sgpcrm_Securitygroups_ID as em_sgp104_289_, businesspa0_.em_advpro2_outsrcplist_id as em_adv105_289_, businesspa0_.Is_Customer_Consent as is_cus106_289_, businesspa0_.EM_Advpro2_Createrescap as em_adv107_289_, businesspa0_.EM_Obsepad_Mandate_Identifier as em_obs108_289_, businesspa0_.EM_Obsepad_Mandate_Date as em_obs109_289_, businesspa0_.EM_Aeatsii_Rep_Taxid as em_aea110_289_, businesspa0_.EM_Aeatsii_Menor as em_aea111_289_, businesspa0_.EM_Fshins_Show_Risks as em_fsh112_289_, businesspa0_.EM_Pruti_Addbp as em_pru113_289_, businesspa0_.EM_Pruti_Unlock_Date as em_pru114_289_, businesspa0_.EM_Pruti_Unlock_Order_Date as em_pru115_289_, businesspa0_.EM_Pruti_Annexes_Bp_So_ID as em_pru116_289_, businesspa0_.EM_Pruti_Annexes_Bp_Po_ID as em_pru117_289_, businesspa0_.EM_Aeatsii_Defaultsiikey as em_aea118_289_, businesspa0_.EM_Aeatsii_Siikeylist as em_aea119_289_, businesspa0_.EM_Advcrm2_Confirming_Mail as em_adv120_289_, businesspa0_.EM_Tbai_Issimplifiedinv as em_tba121_289_, businesspa0_.EM_Obwpl_Bp_Block_Pickinglist as em_obw122_289_, businesspa0_.EM_Advpro2_Generate_Capacity as em_adv123_289_, businesspa0_.em_pruti_cus_block_reason_id as em_pru124_289_, businesspa0_.EM_Pruti_Notsendinvoice as em_pru125_289_, businesspa0_.EM_Prfuti_No_Autoconsume as em_prf126_289_, businesspa0_.EM_Pruti_Showpriceingoods as em_pru127_289_, businesspa0_.EM_OBTIK_Tax_ID_Key as em_obt128_289_ from C_BPartner businesspa0_ where (upper((businesspa0_.Value || ' - ' || businesspa0_.Name || ' - ' || coalesce(to_char(businesspa0_.TaxID), '') || ' - ' || coalesce(to_char(businesspa0_.Name2), ''))) like upper('%6504%') escape '|') and (exists ( select 1 from M_InOut materialmg1_ inner join C_BPartner businesspa2_ on materialmg1_.C_BPartner_ID = businesspa2_.C_BPartner_ID cross join M_InOut shipmentin3_ cross join C_DocType documentty4_ where materialmg1_.M_InOut_ID = shipmentin3_.M_InOut_ID and materialmg1_.C_DocType_ID = documentty4_.C_DocType_ID and materialmg1_.DocStatus = 'CO' and ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin3_.m_inout_id) from dual) = '0' and (materialmg1_.MovementType in ('C-', 'C+')) and materialmg1_.Islogistic = 'N' and documentty4_.IsReturn = 'N' and businesspa2_.C_BPartner_ID = businesspa0_.C_BPartner_ID and (materialmg1_.AD_Org_ID in ('0', '7AC30B45BDA9448C97F393E9C698F797', 'F6E0484F9EC04B209FBAA42D32AC4560')) and (materialmg1_.AD_Client_ID in ('E94C609967684AD09D3A2D939308F233', '0')))) order by businesspa0_.Value, businesspa0_.Name, businesspa0_.TaxID, businesspa0_.Name2 limit '76';

[ Date: 2026-07-13 14:45:14 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

select businesspa0_.C_BPartner_ID as c_bpartn1_289_, businesspa0_.AD_Client_ID as ad_clien2_289_, businesspa0_.AD_Org_ID as ad_org_i3_289_, businesspa0_.IsActive as isactive4_289_, businesspa0_.Created as created5_289_, businesspa0_.CreatedBy as createdb6_289_, businesspa0_.Updated as updated7_289_, businesspa0_.UpdatedBy as updatedb8_289_, businesspa0_.Value as value9_289_, businesspa0_.Name as name10_289_, businesspa0_.Name2 as name11_289_, businesspa0_.Description as descrip12_289_, businesspa0_.IsSummary as issumma13_289_, businesspa0_.C_BP_Group_ID as c_bp_gr14_289_, businesspa0_.IsOneTime as isoneti15_289_, businesspa0_.IsProspect as isprosp16_289_, businesspa0_.IsVendor as isvendo17_289_, businesspa0_.IsCustomer as iscusto18_289_, businesspa0_.IsEmployee as isemplo19_289_, businesspa0_.IsSalesRep as issales20_289_, businesspa0_.ReferenceNo as referen21_289_, businesspa0_.DUNS as duns22_289_, businesspa0_.URL as url23_289_, businesspa0_.AD_Language as ad_lang24_289_, businesspa0_.TaxID as taxid25_289_, businesspa0_.IsTaxExempt as istaxex26_289_, businesspa0_.C_InvoiceSchedule_ID as c_invoi27_289_, businesspa0_.Rating as rating28_289_, businesspa0_.SalesVolume as salesvo29_289_, businesspa0_.NumberEmployees as numbere30_289_, businesspa0_.NAICS as naics31_289_, businesspa0_.FirstSale as firstsa32_289_, businesspa0_.AcqusitionCost as acqusit33_289_, businesspa0_.PotentialLifeTimeValue as potenti34_289_, businesspa0_.ActualLifeTimeValue as actuall35_289_, businesspa0_.ShareOfCustomer as shareof36_289_, businesspa0_.PaymentRule as payment37_289_, businesspa0_.SO_CreditLimit as so_cred38_289_, businesspa0_.SO_CreditUsed as so_cred39_289_, businesspa0_.C_PaymentTerm_ID as c_payme40_289_, businesspa0_.M_PriceList_ID as m_price41_289_, businesspa0_.IsDiscountPrinted as isdisco42_289_, businesspa0_.SO_Description as so_desc43_289_, businesspa0_.POReference as porefer44_289_, businesspa0_.PaymentRulePO as payment45_289_, businesspa0_.PO_PriceList_ID as po_pric46_289_, businesspa0_.PO_PaymentTerm_ID as po_paym47_289_, businesspa0_.DocumentCopies as documen48_289_, businesspa0_.C_Greeting_ID as c_greet49_289_, businesspa0_.InvoiceRule as invoice50_289_, businesspa0_.DeliveryRule as deliver51_289_, businesspa0_.DeliveryViaRule as deliver52_289_, businesspa0_.SalesRep_ID as salesre53_289_, businesspa0_.BPartner_Parent_ID as bpartne54_289_, businesspa0_.SOCreditStatus as socredi55_289_, businesspa0_.AD_Forced_Org_ID as ad_forc56_289_, businesspa0_.ShowPriceInOrder as showpri57_289_, businesspa0_.Invoicegrouping as invoice58_289_, businesspa0_.FixMonthDay as fixmont59_289_, businesspa0_.FixMonthDay2 as fixmont60_289_, businesspa0_.Fixmonthday3 as fixmont61_289_, businesspa0_.Isworker as isworke62_289_, businesspa0_.UPC as upc63_289_, businesspa0_.C_Salary_Category_ID as c_salar64_289_, businesspa0_.Invoice_Printformat as invoice65_289_, businesspa0_.Last_Days as last_da66_289_, businesspa0_.PO_Bankaccount_ID as po_bank67_289_, businesspa0_.PO_BP_TaxCategory_ID as po_bp_t68_289_, businesspa0_.PO_Fixmonthday as po_fixm69_289_, businesspa0_.PO_Fixmonthday2 as po_fixm70_289_, businesspa0_.PO_Fixmonthday3 as po_fixm71_289_, businesspa0_.SO_Bankaccount_ID as so_bank72_289_, businesspa0_.SO_Bp_Taxcategory_ID as so_bp_t73_289_, businesspa0_.Fiscalcode as fiscalc74_289_, businesspa0_.Isofiscalcode as isofisc75_289_, businesspa0_.EM_Einv_Einvoice as em_einv76_289_, businesspa0_.PO_C_Incoterms_ID as po_c_in77_289_, businesspa0_.EM_Einv_Format_Id as em_einv78_289_, businesspa0_.SO_C_Incoterms_ID as so_c_in79_289_, businesspa0_.EM_Einv_Platform_Id as em_einv80_289_, businesspa0_.FIN_Paymentmethod_ID as fin_pay81_289_, businesspa0_.EM_Einv_Email as em_einv82_289_, businesspa0_.PO_Paymentmethod_ID as po_paym83_289_, businesspa0_.FIN_Financial_Account_ID as fin_fin84_289_, businesspa0_.EM_Einv_Deliverymode as em_einv85_289_, businesspa0_.PO_Financial_Account_ID as po_fina86_289_, businesspa0_.Customer_Blocking as custome87_289_, businesspa0_.Vendor_Blocking as vendor_88_289_, businesspa0_.SO_Payment_Blocking as so_paym89_289_, businesspa0_.PO_Payment_Blocking as po_paym90_289_, businesspa0_.SO_Invoice_Blocking as so_invo91_289_, businesspa0_.PO_Invoice_Blocking as po_invo92_289_, businesspa0_.SO_Order_Blocking as so_orde93_289_, businesspa0_.PO_Order_Blocking as po_orde94_289_, businesspa0_.SO_Goods_Blocking as so_good95_289_, businesspa0_.PO_Goods_Blocking as po_good96_289_, businesspa0_.Iscashvat as iscashv97_289_, businesspa0_.EM_Advcrm_Newactivity as em_advc98_289_, businesspa0_.Update_Currency as update_99_289_, businesspa0_.BP_Currency_ID as bp_cur100_289_, businesspa0_.Birthplace as birthp101_289_, businesspa0_.Birthday as birthd102_289_, businesspa0_.EM_Advpro2_Workshop as em_adv103_289_, businesspa0_.EM_Sgpcrm_Securitygroups_ID as em_sgp104_289_, businesspa0_.em_advpro2_outsrcplist_id as em_adv105_289_, businesspa0_.Is_Customer_Consent as is_cus106_289_, businesspa0_.EM_Advpro2_Createrescap as em_adv107_289_, businesspa0_.EM_Obsepad_Mandate_Identifier as em_obs108_289_, businesspa0_.EM_Obsepad_Mandate_Date as em_obs109_289_, businesspa0_.EM_Aeatsii_Rep_Taxid as em_aea110_289_, businesspa0_.EM_Aeatsii_Menor as em_aea111_289_, businesspa0_.EM_Fshins_Show_Risks as em_fsh112_289_, businesspa0_.EM_Pruti_Addbp as em_pru113_289_, businesspa0_.EM_Pruti_Unlock_Date as em_pru114_289_, businesspa0_.EM_Pruti_Unlock_Order_Date as em_pru115_289_, businesspa0_.EM_Pruti_Annexes_Bp_So_ID as em_pru116_289_, businesspa0_.EM_Pruti_Annexes_Bp_Po_ID as em_pru117_289_, businesspa0_.EM_Aeatsii_Defaultsiikey as em_aea118_289_, businesspa0_.EM_Aeatsii_Siikeylist as em_aea119_289_, businesspa0_.EM_Advcrm2_Confirming_Mail as em_adv120_289_, businesspa0_.EM_Tbai_Issimplifiedinv as em_tba121_289_, businesspa0_.EM_Obwpl_Bp_Block_Pickinglist as em_obw122_289_, businesspa0_.EM_Advpro2_Generate_Capacity as em_adv123_289_, businesspa0_.em_pruti_cus_block_reason_id as em_pru124_289_, businesspa0_.EM_Pruti_Notsendinvoice as em_pru125_289_, businesspa0_.EM_Prfuti_No_Autoconsume as em_prf126_289_, businesspa0_.EM_Pruti_Showpriceingoods as em_pru127_289_, businesspa0_.EM_OBTIK_Tax_ID_Key as em_obt128_289_ from C_BPartner businesspa0_ where (upper((businesspa0_.Value || ' - ' || businesspa0_.Name || ' - ' || coalesce(to_char(businesspa0_.TaxID), '') || ' - ' || coalesce(to_char(businesspa0_.Name2), ''))) like upper('%6504%') escape '|') and (exists ( select 1 from M_InOut materialmg1_ inner join C_BPartner businesspa2_ on materialmg1_.C_BPartner_ID = businesspa2_.C_BPartner_ID cross join M_InOut shipmentin3_ cross join C_DocType documentty4_ where materialmg1_.M_InOut_ID = shipmentin3_.M_InOut_ID and materialmg1_.C_DocType_ID = documentty4_.C_DocType_ID and materialmg1_.DocStatus = 'CO' and ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin3_.m_inout_id) from dual) = '0' and (materialmg1_.MovementType in ('C-', 'C+')) and materialmg1_.Islogistic = 'N' and documentty4_.IsReturn = 'N' and businesspa2_.C_BPartner_ID = businesspa0_.C_BPartner_ID and (materialmg1_.AD_Org_ID in ('0', '7AC30B45BDA9448C97F393E9C698F797', 'F6E0484F9EC04B209FBAA42D32AC4560')) and (materialmg1_.AD_Client_ID in ('E94C609967684AD09D3A2D939308F233', '0')))) order by businesspa0_.Value, businesspa0_.Name, businesspa0_.TaxID, businesspa0_.Name2 limit '75' offset '38';

[ Date: 2026-07-13 14:45:20 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

select materialmg0_.M_InOut_ID as m_inout_1_710_, materialmg0_.AD_Client_ID as ad_clien2_710_, materialmg0_.AD_Org_ID as ad_org_i3_710_, materialmg0_.IsActive as isactive4_710_, materialmg0_.Created as created5_710_, materialmg0_.CreatedBy as createdb6_710_, materialmg0_.Updated as updated7_710_, materialmg0_.UpdatedBy as updatedb8_710_, materialmg0_.IsSOTrx as issotrx9_710_, materialmg0_.DocumentNo as documen10_710_, materialmg0_.DocAction as docacti11_710_, materialmg0_.DocStatus as docstat12_710_, materialmg0_.Posted as posted13_710_, materialmg0_.Processing as process14_710_, materialmg0_.Processed as process15_710_, materialmg0_.C_DocType_ID as c_docty16_710_, materialmg0_.Description as descrip17_710_, materialmg0_.C_Order_ID as c_order18_710_, materialmg0_.DateOrdered as dateord19_710_, materialmg0_.IsPrinted as isprint20_710_, materialmg0_.MovementType as movemen21_710_, materialmg0_.MovementDate as movemen22_710_, materialmg0_.DateAcct as dateacc23_710_, materialmg0_.C_BPartner_ID as c_bpart24_710_, materialmg0_.C_BPartner_Location_ID as c_bpart25_710_, materialmg0_.M_Warehouse_ID as m_wareh26_710_, materialmg0_.POReference as porefer27_710_, materialmg0_.DeliveryRule as deliver28_710_, materialmg0_.FreightCostRule as freight29_710_, materialmg0_.FreightAmt as freight30_710_, materialmg0_.DeliveryViaRule as deliver31_710_, materialmg0_.M_Shipper_ID as m_shipp32_710_, materialmg0_.C_Charge_ID as c_charg33_710_, materialmg0_.ChargeAmt as chargea34_710_, materialmg0_.PriorityRule as priorit35_710_, materialmg0_.DatePrinted as datepri36_710_, materialmg0_.C_Invoice_ID as c_invoi37_710_, materialmg0_.CreateFrom as createf38_710_, materialmg0_.GenerateTo as generat39_710_, materialmg0_.AD_User_ID as ad_user40_710_, materialmg0_.SalesRep_ID as salesre41_710_, materialmg0_.NoPackages as nopacka42_710_, materialmg0_.PickDate as pickdat43_710_, materialmg0_.ShipDate as shipdat44_710_, materialmg0_.TrackingNo as trackin45_710_, materialmg0_.AD_OrgTrx_ID as ad_orgt46_710_, materialmg0_.C_Project_ID as c_proje47_710_, materialmg0_.C_Campaign_ID as c_campa48_710_, materialmg0_.C_Activity_ID as c_activ49_710_, materialmg0_.User1_ID as user50_710_, materialmg0_.User2_ID as user51_710_, materialmg0_.UpdateLines as updatel52_710_, materialmg0_.Islogistic as islogis53_710_, materialmg0_.Calculate_Freight as calcula54_710_, materialmg0_.Delivery_Location_ID as deliver55_710_, materialmg0_.M_FreightCategory_ID as m_freig56_710_, materialmg0_.Freight_Currency_ID as freight57_710_, materialmg0_.RM_Receipt_PickEdit as rm_rece58_710_, materialmg0_.RM_Shipment_Pickedit as rm_ship59_710_, materialmg0_.EM_Obcma_C_Poc_Email_ID as em_obcm60_710_, materialmg0_.M_Condition_Goods_ID as m_condi61_710_, materialmg0_.A_Asset_ID as a_asset62_710_, materialmg0_.C_Costcenter_ID as c_costc63_710_, materialmg0_.Process_Goods_Java as process64_710_, materialmg0_.Isnettingshipment as isnetti65_710_, materialmg0_.Iscompletelyinvoiced as iscompl66_710_, materialmg0_.EM_OBMFM_Freight_ID as em_obmf67_710_, materialmg0_.EM_Obwpack_Packing as em_obwp68_710_, materialmg0_.EM_Sgpcrm_Securitygroups_ID as em_sgpc69_710_, materialmg0_.EM_OBMFM_Delivery_Charges as em_obmf70_710_, materialmg0_.EM_Obwpack_Packingh_ID as em_obwp71_710_, materialmg0_.Invoicefromshipment as invoice72_710_, materialmg0_.EM_Obwpack_Processed as em_obwp73_710_, materialmg0_.Bpartner_Extref as bpartne74_710_, materialmg0_.EM_Etblkp_Accountingstatus as em_etbl75_710_, materialmg0_.EM_Obwpack_Reactivated as em_obwp76_710_, materialmg0_.EM_Etblkp_Bulkposting as em_etbl77_710_, materialmg0_.EM_Prouti_Changebpartner as em_prou78_710_, materialmg0_.EM_Obwpack_Packingrequired as em_obwp79_710_, materialmg0_.EM_Prouti_Totalqtyreceived as em_prou80_710_, materialmg0_.EM_Pruti_Total_Amt_Tax as em_prut81_710_, materialmg0_.EM_Etblkc_Bulkcompletion as em_etbl82_710_, materialmg0_.EM_OBMFM_Deliverynotes as em_obmf83_710_, materialmg0_.EM_OBEUCI_Ship as em_obeu84_710_, materialmg0_.EM_Prouti_Initial_Bp_ID as em_prou85_710_, materialmg0_.EM_Prouti_Move_Stock as em_prou86_710_, materialmg0_.EM_Prouti_Stock_Moved as em_prou87_710_, materialmg0_.EM_Advpro2_Outsourcing_ID as em_advp88_710_, materialmg0_.EM_Pruti_Showpriceingoods as em_prut89_710_, materialmg0_.em_fshpie_piece_manage as em_fshp90_710_, materialmg0_.em_prlab_desc as em_prla91_710_, materialmg0_.em_prouti_invoiced as em_prou92_710_, materialmg0_.EM_Pruti_Createfrom as em_prut93_710_ from M_InOut materialmg0_ left outer join C_BPartner businesspa1_ on materialmg0_.C_BPartner_ID = businesspa1_.C_BPartner_ID cross join M_InOut shipmentin2_ cross join C_DocType documentty3_ where materialmg0_.M_InOut_ID = shipmentin2_.M_InOut_ID and materialmg0_.C_DocType_ID = documentty3_.C_DocType_ID and upper((businesspa1_.Value || ' - ' || businesspa1_.Name || ' - ' || coalesce(to_char(businesspa1_.TaxID), '') || ' - ' || coalesce(to_char(businesspa1_.Name2), ''))) = upper('6504 - ELIS SEVILLA - A08205056 - ELIS MANOMATIC S.A.') and materialmg0_.DocStatus = 'CO' and ( select C_GETINVOICESTATUSFROMSHIPMENT (shipmentin2_.m_inout_id) from dual) = '0' and (materialmg0_.MovementType in ('C-', 'C+')) and materialmg0_.Islogistic = 'N' and documentty3_.IsReturn = 'N' and (materialmg0_.AD_Org_ID in ('0', '7AC30B45BDA9448C97F393E9C698F797', 'F6E0484F9EC04B209FBAA42D32AC4560')) and (materialmg0_.AD_Client_ID in ('E94C609967684AD09D3A2D939308F233', '0')) order by materialmg0_.DocumentNo, materialmg0_.M_InOut_ID limit '101';