select --Organizacion ad_org.ad_org_id, ad_org.social_name, ad_orginfo.taxid as taxidorg, c_locationorg.address1 address1org, c_locationorg.city cityorg, c_locationorg.postal postalorg, c_regionorg.name as regionorg, c_countryorg.name as countryorg, CASE WHEN c_bpartner.em_ec_isvalorated = 'Y' THEN c_bpartner.em_ec_isvalorated ELSE m_inout.em_ec_isvalued END as em_ec_isvalued, --OrganizationUtil ad_orginfo.em_pruti_email, ad_orginfo.em_pruti_url, ad_orginfo.em_pruti_phone, ad_orginfo.em_pruti_phone2, ad_orginfo.em_pruti_fax, ad_orginfo.em_pruti_inforeport, ad_orginfo.em_pruti_inforeport2, --Tercero c_bpartner.value as valuepartner, upper(c_bpartner.name) as namepartner, upper(c_bpartner.name2) as name2partner, c_bpartner.taxid as taxid, --Contact contact.name || ' ' || coalesce(contact.phone, ' ') as contact_info, contact.email as contact_mail, --AddressOrder c_location.address1, c_location.postal, c_location.city, c_region.name as region, upper(c_country_trl.name) as country, c_location_description (c_location.c_location_id) || ' (' || upper(c_country.name) || ') ' AS locationdesc, --AddressOrderDelivery c_location_description (c_locationdeliv.c_location_id) || ' (' || upper(c_countrydel.name) || ') ' AS locationdelivdesc, upper(c_counttrl_del.name) as countrydel, --Inout m_inout.movementdate, m_inout.documentno, m_inout.poreference, m_inout.description as descorder, upper(coalesce(c_doctype_trl.printname, c_doctype.printname)) doctype, m_inout.m_inout_id, --Comercial concat(repre.firstname, ' ', repre.lastname) as comercial, repre.email comercialmail, repre.phone comercialphone, --Order c_order.documentno as docorder, c_currency.CurSymbol, ( select sum(movementqty * c_orderline.priceactual) from c_orderline, m_inoutline where c_orderline.c_orderline_id = m_inoutline.c_orderline_id and m_inoutline.m_inout_id = m_inout.m_inout_id) as total, --Personal ( select sum(movementqty * m_product.weight) from m_inoutline, m_product where m_inoutline.m_product_id = m_product.m_product_id and m_inoutline.m_inout_id = m_inout.m_inout_id) as weight, ROW_NUMBER() OVER (ORDER BY m_inout.m_inout_id) % 2 = 1 AS row from m_inout left join c_bpartner on m_inout.c_bpartner_id = c_bpartner.c_bpartner_id left join c_bpartner_location on m_inout.c_bpartner_location_id = c_bpartner_location.c_bpartner_location_id left join c_location on c_bpartner_location.c_location_id = c_location.c_location_id left join c_region on c_location.c_region_id = c_region.c_region_id left join c_country on c_location.c_country_id = c_country.c_country_id left join c_country_trl on c_country.c_country_id = c_country_trl.c_country_id and c_country_trl.ad_language = coalesce(c_bpartner_location.em_pbl_ad_language, c_bpartner.ad_language) left join c_order on m_inout.c_order_id = c_order.c_order_id left join ad_user contact on m_inout.ad_user_id = contact.ad_user_id left join c_bpartner_location delivadd on m_inout.Delivery_Location_ID = delivadd.c_bpartner_location_id left join c_location c_locationdeliv on delivadd.c_location_id = c_locationdeliv.c_location_id left join c_country c_countrydel on c_locationdeliv.c_country_id = c_countrydel.c_country_id left join c_country_trl c_counttrl_del on c_countrydel.c_country_id = c_counttrl_del.c_country_id and c_counttrl_del.ad_language = coalesce(c_bpartner_location.em_pbl_ad_language, c_bpartner.ad_language) left join ad_org on m_inout.ad_org_id = ad_org.ad_org_id left join ad_orginfo on ad_org.ad_org_id = ad_orginfo.ad_org_id left join c_location c_locationorg on ad_orginfo.c_location_id = c_locationorg.c_location_id left join c_region c_regionorg on c_locationorg.c_region_id = c_regionorg.c_region_id left join c_country c_countryorg on c_locationorg.c_country_id = c_countryorg.c_country_id left join c_doctype on m_inout.c_doctype_id = c_doctype.c_doctype_id left join c_doctype_trl on c_doctype_trl.c_doctype_id = c_doctype.c_doctype_id and c_doctype_trl.ad_language = coalesce(c_bpartner_location.em_pbl_ad_language, c_bpartner.ad_language) left join c_currency on c_order.c_currency_id = c_currency.c_currency_id left join ad_user repre on m_inout.salesrep_id = repre.ad_user_id left join fin_financial_account on fin_financial_account.fin_financial_account_id = c_bpartner.fin_financial_account_id left join pruti_paymentmethod_trl on c_order.fin_paymentmethod_id = pruti_paymentmethod_trl.fin_paymentmethod_id AND pruti_paymentmethod_trl.ad_language = c_bpartner.ad_language left join prlab_num on 2 > prlab_num.num where 1 = 1 and m_inout.m_inout_id in ( select distinct il.m_inout_id from obwpl_pickinglist pl left join m_inoutline il on il.em_obwpl_pickinglist_id = pl.obwpl_pickinglist_id where pl.obwpl_pickinglist_id in ('2ECEE9B6A7894EDCB3924B098E28C358')) order by m_inout.documentno;

Date: 2026-07-14 11:47:38
Duration: 3s107ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select --Organizacion ad_org.ad_org_id, ad_org.social_name, ad_orginfo.taxid as taxidorg, c_locationorg.address1 address1org, c_locationorg.city cityorg, c_locationorg.postal postalorg, c_regionorg.name as regionorg, c_countryorg.name as countryorg, CASE WHEN c_bpartner.em_ec_isvalorated = 'Y' THEN c_bpartner.em_ec_isvalorated ELSE m_inout.em_ec_isvalued END as em_ec_isvalued, --OrganizationUtil ad_orginfo.em_pruti_email, ad_orginfo.em_pruti_url, ad_orginfo.em_pruti_phone, ad_orginfo.em_pruti_phone2, ad_orginfo.em_pruti_fax, ad_orginfo.em_pruti_inforeport, ad_orginfo.em_pruti_inforeport2, --Tercero c_bpartner.value as valuepartner, upper(c_bpartner.name) as namepartner, upper(c_bpartner.name2) as name2partner, c_bpartner.taxid as taxid, --Contact contact.name || ' ' || coalesce(contact.phone, ' ') as contact_info, contact.email as contact_mail, --AddressOrder c_location.address1, c_location.postal, c_location.city, c_region.name as region, upper(c_country_trl.name) as country, c_location_description (c_location.c_location_id) || ' (' || upper(c_country.name) || ') ' AS locationdesc, --AddressOrderDelivery c_location_description (c_locationdeliv.c_location_id) || ' (' || upper(c_countrydel.name) || ') ' AS locationdelivdesc, upper(c_counttrl_del.name) as countrydel, --Inout m_inout.movementdate, m_inout.documentno, m_inout.poreference, m_inout.description as descorder, upper(coalesce(c_doctype_trl.printname, c_doctype.printname)) doctype, m_inout.m_inout_id, --Comercial concat(repre.firstname, ' ', repre.lastname) as comercial, repre.email comercialmail, repre.phone comercialphone, --Order c_order.documentno as docorder, c_currency.CurSymbol, ( select sum(movementqty * c_orderline.priceactual) from c_orderline, m_inoutline where c_orderline.c_orderline_id = m_inoutline.c_orderline_id and m_inoutline.m_inout_id = m_inout.m_inout_id) as total, --Personal ( select sum(movementqty * m_product.weight) from m_inoutline, m_product where m_inoutline.m_product_id = m_product.m_product_id and m_inoutline.m_inout_id = m_inout.m_inout_id) as weight, ROW_NUMBER() OVER (ORDER BY m_inout.m_inout_id) % 2 = 1 AS row from m_inout left join c_bpartner on m_inout.c_bpartner_id = c_bpartner.c_bpartner_id left join c_bpartner_location on m_inout.c_bpartner_location_id = c_bpartner_location.c_bpartner_location_id left join c_location on c_bpartner_location.c_location_id = c_location.c_location_id left join c_region on c_location.c_region_id = c_region.c_region_id left join c_country on c_location.c_country_id = c_country.c_country_id left join c_country_trl on c_country.c_country_id = c_country_trl.c_country_id and c_country_trl.ad_language = coalesce(c_bpartner_location.em_pbl_ad_language, c_bpartner.ad_language) left join c_order on m_inout.c_order_id = c_order.c_order_id left join ad_user contact on m_inout.ad_user_id = contact.ad_user_id left join c_bpartner_location delivadd on m_inout.Delivery_Location_ID = delivadd.c_bpartner_location_id left join c_location c_locationdeliv on delivadd.c_location_id = c_locationdeliv.c_location_id left join c_country c_countrydel on c_locationdeliv.c_country_id = c_countrydel.c_country_id left join c_country_trl c_counttrl_del on c_countrydel.c_country_id = c_counttrl_del.c_country_id and c_counttrl_del.ad_language = coalesce(c_bpartner_location.em_pbl_ad_language, c_bpartner.ad_language) left join ad_org on m_inout.ad_org_id = ad_org.ad_org_id left join ad_orginfo on ad_org.ad_org_id = ad_orginfo.ad_org_id left join c_location c_locationorg on ad_orginfo.c_location_id = c_locationorg.c_location_id left join c_region c_regionorg on c_locationorg.c_region_id = c_regionorg.c_region_id left join c_country c_countryorg on c_locationorg.c_country_id = c_countryorg.c_country_id left join c_doctype on m_inout.c_doctype_id = c_doctype.c_doctype_id left join c_doctype_trl on c_doctype_trl.c_doctype_id = c_doctype.c_doctype_id and c_doctype_trl.ad_language = coalesce(c_bpartner_location.em_pbl_ad_language, c_bpartner.ad_language) left join c_currency on c_order.c_currency_id = c_currency.c_currency_id left join ad_user repre on m_inout.salesrep_id = repre.ad_user_id left join fin_financial_account on fin_financial_account.fin_financial_account_id = c_bpartner.fin_financial_account_id left join pruti_paymentmethod_trl on c_order.fin_paymentmethod_id = pruti_paymentmethod_trl.fin_paymentmethod_id AND pruti_paymentmethod_trl.ad_language = c_bpartner.ad_language left join prlab_num on 2 > prlab_num.num where 1 = 1 and m_inout.m_inout_id in ( select distinct il.m_inout_id from obwpl_pickinglist pl left join m_inoutline il on il.em_obwpl_pickinglist_id = pl.obwpl_pickinglist_id where pl.obwpl_pickinglist_id in ('AC9BC2FB6DC446BE951B8A89F5431861')) order by m_inout.documentno;

Date: 2026-07-14 16:38:23
Duration: 3s12ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select --Organizacion ad_org.ad_org_id, ad_org.social_name, ad_orginfo.taxid as taxidorg, c_locationorg.address1 address1org, c_locationorg.city cityorg, c_locationorg.postal postalorg, c_regionorg.name as regionorg, c_countryorg.name as countryorg, CASE WHEN c_bpartner.em_ec_isvalorated = 'Y' THEN c_bpartner.em_ec_isvalorated ELSE m_inout.em_ec_isvalued END as em_ec_isvalued, --OrganizationUtil ad_orginfo.em_pruti_email, ad_orginfo.em_pruti_url, ad_orginfo.em_pruti_phone, ad_orginfo.em_pruti_phone2, ad_orginfo.em_pruti_fax, ad_orginfo.em_pruti_inforeport, ad_orginfo.em_pruti_inforeport2, --Tercero c_bpartner.value as valuepartner, upper(c_bpartner.name) as namepartner, upper(c_bpartner.name2) as name2partner, c_bpartner.taxid as taxid, --Contact contact.name || ' ' || coalesce(contact.phone, ' ') as contact_info, contact.email as contact_mail, --AddressOrder c_location.address1, c_location.postal, c_location.city, c_region.name as region, upper(c_country_trl.name) as country, c_location_description (c_location.c_location_id) || ' (' || upper(c_country.name) || ') ' AS locationdesc, --AddressOrderDelivery c_location_description (c_locationdeliv.c_location_id) || ' (' || upper(c_countrydel.name) || ') ' AS locationdelivdesc, upper(c_counttrl_del.name) as countrydel, --Inout m_inout.movementdate, m_inout.documentno, m_inout.poreference, m_inout.description as descorder, upper(coalesce(c_doctype_trl.printname, c_doctype.printname)) doctype, m_inout.m_inout_id, --Comercial concat(repre.firstname, ' ', repre.lastname) as comercial, repre.email comercialmail, repre.phone comercialphone, --Order c_order.documentno as docorder, c_currency.CurSymbol, ( select sum(movementqty * c_orderline.priceactual) from c_orderline, m_inoutline where c_orderline.c_orderline_id = m_inoutline.c_orderline_id and m_inoutline.m_inout_id = m_inout.m_inout_id) as total, --Personal ( select sum(movementqty * m_product.weight) from m_inoutline, m_product where m_inoutline.m_product_id = m_product.m_product_id and m_inoutline.m_inout_id = m_inout.m_inout_id) as weight, ROW_NUMBER() OVER (ORDER BY m_inout.m_inout_id) % 2 = 1 AS row from m_inout left join c_bpartner on m_inout.c_bpartner_id = c_bpartner.c_bpartner_id left join c_bpartner_location on m_inout.c_bpartner_location_id = c_bpartner_location.c_bpartner_location_id left join c_location on c_bpartner_location.c_location_id = c_location.c_location_id left join c_region on c_location.c_region_id = c_region.c_region_id left join c_country on c_location.c_country_id = c_country.c_country_id left join c_country_trl on c_country.c_country_id = c_country_trl.c_country_id and c_country_trl.ad_language = coalesce(c_bpartner_location.em_pbl_ad_language, c_bpartner.ad_language) left join c_order on m_inout.c_order_id = c_order.c_order_id left join ad_user contact on m_inout.ad_user_id = contact.ad_user_id left join c_bpartner_location delivadd on m_inout.Delivery_Location_ID = delivadd.c_bpartner_location_id left join c_location c_locationdeliv on delivadd.c_location_id = c_locationdeliv.c_location_id left join c_country c_countrydel on c_locationdeliv.c_country_id = c_countrydel.c_country_id left join c_country_trl c_counttrl_del on c_countrydel.c_country_id = c_counttrl_del.c_country_id and c_counttrl_del.ad_language = coalesce(c_bpartner_location.em_pbl_ad_language, c_bpartner.ad_language) left join ad_org on m_inout.ad_org_id = ad_org.ad_org_id left join ad_orginfo on ad_org.ad_org_id = ad_orginfo.ad_org_id left join c_location c_locationorg on ad_orginfo.c_location_id = c_locationorg.c_location_id left join c_region c_regionorg on c_locationorg.c_region_id = c_regionorg.c_region_id left join c_country c_countryorg on c_locationorg.c_country_id = c_countryorg.c_country_id left join c_doctype on m_inout.c_doctype_id = c_doctype.c_doctype_id left join c_doctype_trl on c_doctype_trl.c_doctype_id = c_doctype.c_doctype_id and c_doctype_trl.ad_language = coalesce(c_bpartner_location.em_pbl_ad_language, c_bpartner.ad_language) left join c_currency on c_order.c_currency_id = c_currency.c_currency_id left join ad_user repre on m_inout.salesrep_id = repre.ad_user_id left join fin_financial_account on fin_financial_account.fin_financial_account_id = c_bpartner.fin_financial_account_id left join pruti_paymentmethod_trl on c_order.fin_paymentmethod_id = pruti_paymentmethod_trl.fin_paymentmethod_id AND pruti_paymentmethod_trl.ad_language = c_bpartner.ad_language left join prlab_num on 2 > prlab_num.num where 1 = 1 and m_inout.m_inout_id in ( select distinct il.m_inout_id from obwpl_pickinglist pl left join m_inoutline il on il.em_obwpl_pickinglist_id = pl.obwpl_pickinglist_id where pl.obwpl_pickinglist_id in ('CB85114E7BBF474FA8FBBC19B44D594F')) order by m_inout.documentno;

Date: 2026-07-14 16:59:09
Duration: 2s989ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

select businesspa0_.C_BPartner_ID as c_bpartn1_189_, businesspa0_.AD_Client_ID as ad_clien2_189_, businesspa0_.AD_Org_ID as ad_org_i3_189_, businesspa0_.IsActive as isactive4_189_, businesspa0_.Created as created5_189_, businesspa0_.CreatedBy as createdb6_189_, businesspa0_.Updated as updated7_189_, businesspa0_.UpdatedBy as updatedb8_189_, businesspa0_.Value as value9_189_, businesspa0_.Name as name10_189_, businesspa0_.Name2 as name11_189_, businesspa0_.Description as descrip12_189_, businesspa0_.IsSummary as issumma13_189_, businesspa0_.C_BP_Group_ID as c_bp_gr14_189_, businesspa0_.IsOneTime as isoneti15_189_, businesspa0_.IsProspect as isprosp16_189_, businesspa0_.IsVendor as isvendo17_189_, businesspa0_.IsCustomer as iscusto18_189_, businesspa0_.IsEmployee as isemplo19_189_, businesspa0_.IsSalesRep as issales20_189_, businesspa0_.ReferenceNo as referen21_189_, businesspa0_.DUNS as duns22_189_, businesspa0_.URL as url23_189_, businesspa0_.AD_Language as ad_lang24_189_, businesspa0_.TaxID as taxid25_189_, businesspa0_.IsTaxExempt as istaxex26_189_, businesspa0_.C_InvoiceSchedule_ID as c_invoi27_189_, businesspa0_.Rating as rating28_189_, businesspa0_.SalesVolume as salesvo29_189_, businesspa0_.NumberEmployees as numbere30_189_, businesspa0_.NAICS as naics31_189_, businesspa0_.FirstSale as firstsa32_189_, businesspa0_.AcqusitionCost as acqusit33_189_, businesspa0_.PotentialLifeTimeValue as potenti34_189_, businesspa0_.ActualLifeTimeValue as actuall35_189_, businesspa0_.ShareOfCustomer as shareof36_189_, businesspa0_.PaymentRule as payment37_189_, businesspa0_.SO_CreditLimit as so_cred38_189_, businesspa0_.SO_CreditUsed as so_cred39_189_, businesspa0_.C_PaymentTerm_ID as c_payme40_189_, businesspa0_.M_PriceList_ID as m_price41_189_, businesspa0_.IsDiscountPrinted as isdisco42_189_, businesspa0_.SO_Description as so_desc43_189_, businesspa0_.POReference as porefer44_189_, businesspa0_.PaymentRulePO as payment45_189_, businesspa0_.PO_PriceList_ID as po_pric46_189_, businesspa0_.PO_PaymentTerm_ID as po_paym47_189_, businesspa0_.DocumentCopies as documen48_189_, businesspa0_.C_Greeting_ID as c_greet49_189_, businesspa0_.InvoiceRule as invoice50_189_, businesspa0_.DeliveryRule as deliver51_189_, businesspa0_.DeliveryViaRule as deliver52_189_, businesspa0_.SalesRep_ID as salesre53_189_, businesspa0_.BPartner_Parent_ID as bpartne54_189_, businesspa0_.SOCreditStatus as socredi55_189_, businesspa0_.AD_Forced_Org_ID as ad_forc56_189_, businesspa0_.ShowPriceInOrder as showpri57_189_, businesspa0_.Invoicegrouping as invoice58_189_, businesspa0_.FixMonthDay as fixmont59_189_, businesspa0_.FixMonthDay2 as fixmont60_189_, businesspa0_.Fixmonthday3 as fixmont61_189_, businesspa0_.Isworker as isworke62_189_, businesspa0_.UPC as upc63_189_, businesspa0_.C_Salary_Category_ID as c_salar64_189_, businesspa0_.Invoice_Printformat as invoice65_189_, businesspa0_.Last_Days as last_da66_189_, businesspa0_.PO_Bankaccount_ID as po_bank67_189_, businesspa0_.PO_BP_TaxCategory_ID as po_bp_t68_189_, businesspa0_.PO_Fixmonthday as po_fixm69_189_, businesspa0_.PO_Fixmonthday2 as po_fixm70_189_, businesspa0_.PO_Fixmonthday3 as po_fixm71_189_, businesspa0_.SO_Bankaccount_ID as so_bank72_189_, businesspa0_.SO_Bp_Taxcategory_ID as so_bp_t73_189_, businesspa0_.Fiscalcode as fiscalc74_189_, businesspa0_.Isofiscalcode as isofisc75_189_, businesspa0_.EM_Einv_Einvoice as em_einv76_189_, businesspa0_.PO_C_Incoterms_ID as po_c_in77_189_, businesspa0_.EM_Einv_Format_Id as em_einv78_189_, businesspa0_.SO_C_Incoterms_ID as so_c_in79_189_, businesspa0_.EM_Einv_Platform_Id as em_einv80_189_, businesspa0_.FIN_Paymentmethod_ID as fin_pay81_189_, businesspa0_.EM_Einv_Email as em_einv82_189_, businesspa0_.PO_Paymentmethod_ID as po_paym83_189_, businesspa0_.FIN_Financial_Account_ID as fin_fin84_189_, businesspa0_.EM_Einv_Deliverymode as em_einv85_189_, businesspa0_.PO_Financial_Account_ID as po_fina86_189_, businesspa0_.Customer_Blocking as custome87_189_, businesspa0_.Vendor_Blocking as vendor_88_189_, businesspa0_.SO_Payment_Blocking as so_paym89_189_, businesspa0_.PO_Payment_Blocking as po_paym90_189_, businesspa0_.SO_Invoice_Blocking as so_invo91_189_, businesspa0_.PO_Invoice_Blocking as po_invo92_189_, businesspa0_.SO_Order_Blocking as so_orde93_189_, businesspa0_.PO_Order_Blocking as po_orde94_189_, businesspa0_.SO_Goods_Blocking as so_good95_189_, businesspa0_.PO_Goods_Blocking as po_good96_189_, businesspa0_.Iscashvat as iscashv97_189_, businesspa0_.Update_Currency as update_98_189_, businesspa0_.BP_Currency_ID as bp_curr99_189_, businesspa0_.Birthplace as birthp100_189_, businesspa0_.Birthday as birthd101_189_, businesspa0_.Is_Customer_Consent as is_cus102_189_, businesspa0_.EM_Obsepad_Mandate_Identifier as em_obs103_189_, businesspa0_.EM_Obsepad_Mandate_Date as em_obs104_189_, businesspa0_.EM_Aeatsii_Rep_Taxid as em_aea105_189_, businesspa0_.EM_Aeatsii_Menor as em_aea106_189_, businesspa0_.EM_Ec_Isvalorated as em_ec_107_189_, businesspa0_.EM_Pruti_Addbp as em_pru108_189_, businesspa0_.EM_Ec_Isminoutvalued as em_ec_109_189_, businesspa0_.EM_Pruti_Unlock_Date as em_pru110_189_, businesspa0_.EM_Pruti_Unlock_Order_Date as em_pru111_189_, businesspa0_.EM_Pruti_Annexes_Bp_So_ID as em_pru112_189_, businesspa0_.EM_Pruti_Annexes_Bp_Po_ID as em_pru113_189_, businesspa0_.EM_Aeatsii_Defaultsiikey as em_aea114_189_, businesspa0_.EM_Aeatsii_Siikeylist as em_aea115_189_, businesspa0_.EM_Prsii_Clave_Tipo_Proveedor as em_prs116_189_, businesspa0_.EM_Tbai_Issimplifiedinv as em_tba117_189_, businesspa0_.EM_Prsii_Clave_Tipo_Cliente as em_prs118_189_, businesspa0_.EM_Obwpl_Bp_Block_Pickinglist as em_obw119_189_, businesspa0_.em_pruti_cus_block_reason_id as em_pru120_189_, businesspa0_.EM_Pruti_Notsendinvoice as em_pru121_189_, businesspa0_.EM_Pruti_Showpriceingoods as em_pru122_189_, businesspa0_.EM_OBTIK_Tax_ID_Key as em_obt123_189_, businesspa0_.Em_Prcex_Glitem_Id as em_prc124_189_ from C_BPartner businesspa0_ where (upper((businesspa0_.Name || ' - ' || coalesce(to_char(businesspa0_.Name2), ''))) like upper('%planet%') escape '|') and (exists (select 1 from ec_product_cost_v ec_product1_ left outer join M_Product product2_ on ec_product1_.M_Product_ID=product2_.M_Product_ID inner join C_BPartner businesspa3_ on ec_product1_.C_Bpartner_ID=businesspa3_.C_BPartner_ID where (upper((coalesce(to_char((select producttrl4_.Name from M_Product_Trl producttrl4_ where producttrl4_.M_Product_ID=product2_.M_Product_ID and producttrl4_.AD_Language='es_ES')), to_char(product2_.Name), '') || ' - ' || coalesce(to_char(product2_.Description), ''))) like upper('%fermator%') escape '|') and businesspa3_.C_BPartner_ID = businesspa0_.C_BPartner_ID and (ec_product1_.AD_Org_ID in ('0', '4336B51A28B149DF911A36B0D3F03677', 'F7EA3492149E4357B7FCFAE16C7F027F', 'EB72268743764DE99601631DDF69CFA1', '547464619E3348369E774BA8164BD820', 'E55BA2DCBF9C4D4A83D456F5B710B033')) and (ec_product1_.AD_Client_ID in ('CFEDC17130E14D2BAE431B401DF89CF1', '0')))) order by businesspa0_.Name, businesspa0_.Name2 limit '76';

Date: 2026-07-14 11:00:55
Duration: 2s584ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select businesspa0_.C_BPartner_ID as c_bpartn1_189_, businesspa0_.AD_Client_ID as ad_clien2_189_, businesspa0_.AD_Org_ID as ad_org_i3_189_, businesspa0_.IsActive as isactive4_189_, businesspa0_.Created as created5_189_, businesspa0_.CreatedBy as createdb6_189_, businesspa0_.Updated as updated7_189_, businesspa0_.UpdatedBy as updatedb8_189_, businesspa0_.Value as value9_189_, businesspa0_.Name as name10_189_, businesspa0_.Name2 as name11_189_, businesspa0_.Description as descrip12_189_, businesspa0_.IsSummary as issumma13_189_, businesspa0_.C_BP_Group_ID as c_bp_gr14_189_, businesspa0_.IsOneTime as isoneti15_189_, businesspa0_.IsProspect as isprosp16_189_, businesspa0_.IsVendor as isvendo17_189_, businesspa0_.IsCustomer as iscusto18_189_, businesspa0_.IsEmployee as isemplo19_189_, businesspa0_.IsSalesRep as issales20_189_, businesspa0_.ReferenceNo as referen21_189_, businesspa0_.DUNS as duns22_189_, businesspa0_.URL as url23_189_, businesspa0_.AD_Language as ad_lang24_189_, businesspa0_.TaxID as taxid25_189_, businesspa0_.IsTaxExempt as istaxex26_189_, businesspa0_.C_InvoiceSchedule_ID as c_invoi27_189_, businesspa0_.Rating as rating28_189_, businesspa0_.SalesVolume as salesvo29_189_, businesspa0_.NumberEmployees as numbere30_189_, businesspa0_.NAICS as naics31_189_, businesspa0_.FirstSale as firstsa32_189_, businesspa0_.AcqusitionCost as acqusit33_189_, businesspa0_.PotentialLifeTimeValue as potenti34_189_, businesspa0_.ActualLifeTimeValue as actuall35_189_, businesspa0_.ShareOfCustomer as shareof36_189_, businesspa0_.PaymentRule as payment37_189_, businesspa0_.SO_CreditLimit as so_cred38_189_, businesspa0_.SO_CreditUsed as so_cred39_189_, businesspa0_.C_PaymentTerm_ID as c_payme40_189_, businesspa0_.M_PriceList_ID as m_price41_189_, businesspa0_.IsDiscountPrinted as isdisco42_189_, businesspa0_.SO_Description as so_desc43_189_, businesspa0_.POReference as porefer44_189_, businesspa0_.PaymentRulePO as payment45_189_, businesspa0_.PO_PriceList_ID as po_pric46_189_, businesspa0_.PO_PaymentTerm_ID as po_paym47_189_, businesspa0_.DocumentCopies as documen48_189_, businesspa0_.C_Greeting_ID as c_greet49_189_, businesspa0_.InvoiceRule as invoice50_189_, businesspa0_.DeliveryRule as deliver51_189_, businesspa0_.DeliveryViaRule as deliver52_189_, businesspa0_.SalesRep_ID as salesre53_189_, businesspa0_.BPartner_Parent_ID as bpartne54_189_, businesspa0_.SOCreditStatus as socredi55_189_, businesspa0_.AD_Forced_Org_ID as ad_forc56_189_, businesspa0_.ShowPriceInOrder as showpri57_189_, businesspa0_.Invoicegrouping as invoice58_189_, businesspa0_.FixMonthDay as fixmont59_189_, businesspa0_.FixMonthDay2 as fixmont60_189_, businesspa0_.Fixmonthday3 as fixmont61_189_, businesspa0_.Isworker as isworke62_189_, businesspa0_.UPC as upc63_189_, businesspa0_.C_Salary_Category_ID as c_salar64_189_, businesspa0_.Invoice_Printformat as invoice65_189_, businesspa0_.Last_Days as last_da66_189_, businesspa0_.PO_Bankaccount_ID as po_bank67_189_, businesspa0_.PO_BP_TaxCategory_ID as po_bp_t68_189_, businesspa0_.PO_Fixmonthday as po_fixm69_189_, businesspa0_.PO_Fixmonthday2 as po_fixm70_189_, businesspa0_.PO_Fixmonthday3 as po_fixm71_189_, businesspa0_.SO_Bankaccount_ID as so_bank72_189_, businesspa0_.SO_Bp_Taxcategory_ID as so_bp_t73_189_, businesspa0_.Fiscalcode as fiscalc74_189_, businesspa0_.Isofiscalcode as isofisc75_189_, businesspa0_.EM_Einv_Einvoice as em_einv76_189_, businesspa0_.PO_C_Incoterms_ID as po_c_in77_189_, businesspa0_.EM_Einv_Format_Id as em_einv78_189_, businesspa0_.SO_C_Incoterms_ID as so_c_in79_189_, businesspa0_.EM_Einv_Platform_Id as em_einv80_189_, businesspa0_.FIN_Paymentmethod_ID as fin_pay81_189_, businesspa0_.EM_Einv_Email as em_einv82_189_, businesspa0_.PO_Paymentmethod_ID as po_paym83_189_, businesspa0_.FIN_Financial_Account_ID as fin_fin84_189_, businesspa0_.EM_Einv_Deliverymode as em_einv85_189_, businesspa0_.PO_Financial_Account_ID as po_fina86_189_, businesspa0_.Customer_Blocking as custome87_189_, businesspa0_.Vendor_Blocking as vendor_88_189_, businesspa0_.SO_Payment_Blocking as so_paym89_189_, businesspa0_.PO_Payment_Blocking as po_paym90_189_, businesspa0_.SO_Invoice_Blocking as so_invo91_189_, businesspa0_.PO_Invoice_Blocking as po_invo92_189_, businesspa0_.SO_Order_Blocking as so_orde93_189_, businesspa0_.PO_Order_Blocking as po_orde94_189_, businesspa0_.SO_Goods_Blocking as so_good95_189_, businesspa0_.PO_Goods_Blocking as po_good96_189_, businesspa0_.Iscashvat as iscashv97_189_, businesspa0_.Update_Currency as update_98_189_, businesspa0_.BP_Currency_ID as bp_curr99_189_, businesspa0_.Birthplace as birthp100_189_, businesspa0_.Birthday as birthd101_189_, businesspa0_.Is_Customer_Consent as is_cus102_189_, businesspa0_.EM_Obsepad_Mandate_Identifier as em_obs103_189_, businesspa0_.EM_Obsepad_Mandate_Date as em_obs104_189_, businesspa0_.EM_Aeatsii_Rep_Taxid as em_aea105_189_, businesspa0_.EM_Aeatsii_Menor as em_aea106_189_, businesspa0_.EM_Ec_Isvalorated as em_ec_107_189_, businesspa0_.EM_Pruti_Addbp as em_pru108_189_, businesspa0_.EM_Ec_Isminoutvalued as em_ec_109_189_, businesspa0_.EM_Pruti_Unlock_Date as em_pru110_189_, businesspa0_.EM_Pruti_Unlock_Order_Date as em_pru111_189_, businesspa0_.EM_Pruti_Annexes_Bp_So_ID as em_pru112_189_, businesspa0_.EM_Pruti_Annexes_Bp_Po_ID as em_pru113_189_, businesspa0_.EM_Aeatsii_Defaultsiikey as em_aea114_189_, businesspa0_.EM_Aeatsii_Siikeylist as em_aea115_189_, businesspa0_.EM_Prsii_Clave_Tipo_Proveedor as em_prs116_189_, businesspa0_.EM_Tbai_Issimplifiedinv as em_tba117_189_, businesspa0_.EM_Prsii_Clave_Tipo_Cliente as em_prs118_189_, businesspa0_.EM_Obwpl_Bp_Block_Pickinglist as em_obw119_189_, businesspa0_.em_pruti_cus_block_reason_id as em_pru120_189_, businesspa0_.EM_Pruti_Notsendinvoice as em_pru121_189_, businesspa0_.EM_Pruti_Showpriceingoods as em_pru122_189_, businesspa0_.EM_OBTIK_Tax_ID_Key as em_obt123_189_, businesspa0_.Em_Prcex_Glitem_Id as em_prc124_189_ from C_BPartner businesspa0_ where (upper((businesspa0_.Name || ' - ' || coalesce(to_char(businesspa0_.Name2), ''))) like upper('%planet%') escape '|') and (exists (select 1 from ec_product_cost_v ec_product1_ left outer join M_Product product2_ on ec_product1_.M_Product_ID=product2_.M_Product_ID inner join C_BPartner businesspa3_ on ec_product1_.C_Bpartner_ID=businesspa3_.C_BPartner_ID where (upper((coalesce(to_char((select producttrl4_.Name from M_Product_Trl producttrl4_ where producttrl4_.M_Product_ID=product2_.M_Product_ID and producttrl4_.AD_Language='es_ES')), to_char(product2_.Name), '') || ' - ' || coalesce(to_char(product2_.Description), ''))) like upper('%fermator%') escape '|') and businesspa3_.C_BPartner_ID = businesspa0_.C_BPartner_ID and (ec_product1_.AD_Org_ID in ('0', '4336B51A28B149DF911A36B0D3F03677', 'F7EA3492149E4357B7FCFAE16C7F027F', 'EB72268743764DE99601631DDF69CFA1', '547464619E3348369E774BA8164BD820', 'E55BA2DCBF9C4D4A83D456F5B710B033')) and (ec_product1_.AD_Client_ID in ('CFEDC17130E14D2BAE431B401DF89CF1', '0')))) order by businesspa0_.Name, businesspa0_.Name2 limit '76';

Date: 2026-07-14 10:57:49
Duration: 2s566ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select businesspa0_.C_BPartner_ID as c_bpartn1_189_, businesspa0_.AD_Client_ID as ad_clien2_189_, businesspa0_.AD_Org_ID as ad_org_i3_189_, businesspa0_.IsActive as isactive4_189_, businesspa0_.Created as created5_189_, businesspa0_.CreatedBy as createdb6_189_, businesspa0_.Updated as updated7_189_, businesspa0_.UpdatedBy as updatedb8_189_, businesspa0_.Value as value9_189_, businesspa0_.Name as name10_189_, businesspa0_.Name2 as name11_189_, businesspa0_.Description as descrip12_189_, businesspa0_.IsSummary as issumma13_189_, businesspa0_.C_BP_Group_ID as c_bp_gr14_189_, businesspa0_.IsOneTime as isoneti15_189_, businesspa0_.IsProspect as isprosp16_189_, businesspa0_.IsVendor as isvendo17_189_, businesspa0_.IsCustomer as iscusto18_189_, businesspa0_.IsEmployee as isemplo19_189_, businesspa0_.IsSalesRep as issales20_189_, businesspa0_.ReferenceNo as referen21_189_, businesspa0_.DUNS as duns22_189_, businesspa0_.URL as url23_189_, businesspa0_.AD_Language as ad_lang24_189_, businesspa0_.TaxID as taxid25_189_, businesspa0_.IsTaxExempt as istaxex26_189_, businesspa0_.C_InvoiceSchedule_ID as c_invoi27_189_, businesspa0_.Rating as rating28_189_, businesspa0_.SalesVolume as salesvo29_189_, businesspa0_.NumberEmployees as numbere30_189_, businesspa0_.NAICS as naics31_189_, businesspa0_.FirstSale as firstsa32_189_, businesspa0_.AcqusitionCost as acqusit33_189_, businesspa0_.PotentialLifeTimeValue as potenti34_189_, businesspa0_.ActualLifeTimeValue as actuall35_189_, businesspa0_.ShareOfCustomer as shareof36_189_, businesspa0_.PaymentRule as payment37_189_, businesspa0_.SO_CreditLimit as so_cred38_189_, businesspa0_.SO_CreditUsed as so_cred39_189_, businesspa0_.C_PaymentTerm_ID as c_payme40_189_, businesspa0_.M_PriceList_ID as m_price41_189_, businesspa0_.IsDiscountPrinted as isdisco42_189_, businesspa0_.SO_Description as so_desc43_189_, businesspa0_.POReference as porefer44_189_, businesspa0_.PaymentRulePO as payment45_189_, businesspa0_.PO_PriceList_ID as po_pric46_189_, businesspa0_.PO_PaymentTerm_ID as po_paym47_189_, businesspa0_.DocumentCopies as documen48_189_, businesspa0_.C_Greeting_ID as c_greet49_189_, businesspa0_.InvoiceRule as invoice50_189_, businesspa0_.DeliveryRule as deliver51_189_, businesspa0_.DeliveryViaRule as deliver52_189_, businesspa0_.SalesRep_ID as salesre53_189_, businesspa0_.BPartner_Parent_ID as bpartne54_189_, businesspa0_.SOCreditStatus as socredi55_189_, businesspa0_.AD_Forced_Org_ID as ad_forc56_189_, businesspa0_.ShowPriceInOrder as showpri57_189_, businesspa0_.Invoicegrouping as invoice58_189_, businesspa0_.FixMonthDay as fixmont59_189_, businesspa0_.FixMonthDay2 as fixmont60_189_, businesspa0_.Fixmonthday3 as fixmont61_189_, businesspa0_.Isworker as isworke62_189_, businesspa0_.UPC as upc63_189_, businesspa0_.C_Salary_Category_ID as c_salar64_189_, businesspa0_.Invoice_Printformat as invoice65_189_, businesspa0_.Last_Days as last_da66_189_, businesspa0_.PO_Bankaccount_ID as po_bank67_189_, businesspa0_.PO_BP_TaxCategory_ID as po_bp_t68_189_, businesspa0_.PO_Fixmonthday as po_fixm69_189_, businesspa0_.PO_Fixmonthday2 as po_fixm70_189_, businesspa0_.PO_Fixmonthday3 as po_fixm71_189_, businesspa0_.SO_Bankaccount_ID as so_bank72_189_, businesspa0_.SO_Bp_Taxcategory_ID as so_bp_t73_189_, businesspa0_.Fiscalcode as fiscalc74_189_, businesspa0_.Isofiscalcode as isofisc75_189_, businesspa0_.EM_Einv_Einvoice as em_einv76_189_, businesspa0_.PO_C_Incoterms_ID as po_c_in77_189_, businesspa0_.EM_Einv_Format_Id as em_einv78_189_, businesspa0_.SO_C_Incoterms_ID as so_c_in79_189_, businesspa0_.EM_Einv_Platform_Id as em_einv80_189_, businesspa0_.FIN_Paymentmethod_ID as fin_pay81_189_, businesspa0_.EM_Einv_Email as em_einv82_189_, businesspa0_.PO_Paymentmethod_ID as po_paym83_189_, businesspa0_.FIN_Financial_Account_ID as fin_fin84_189_, businesspa0_.EM_Einv_Deliverymode as em_einv85_189_, businesspa0_.PO_Financial_Account_ID as po_fina86_189_, businesspa0_.Customer_Blocking as custome87_189_, businesspa0_.Vendor_Blocking as vendor_88_189_, businesspa0_.SO_Payment_Blocking as so_paym89_189_, businesspa0_.PO_Payment_Blocking as po_paym90_189_, businesspa0_.SO_Invoice_Blocking as so_invo91_189_, businesspa0_.PO_Invoice_Blocking as po_invo92_189_, businesspa0_.SO_Order_Blocking as so_orde93_189_, businesspa0_.PO_Order_Blocking as po_orde94_189_, businesspa0_.SO_Goods_Blocking as so_good95_189_, businesspa0_.PO_Goods_Blocking as po_good96_189_, businesspa0_.Iscashvat as iscashv97_189_, businesspa0_.Update_Currency as update_98_189_, businesspa0_.BP_Currency_ID as bp_curr99_189_, businesspa0_.Birthplace as birthp100_189_, businesspa0_.Birthday as birthd101_189_, businesspa0_.Is_Customer_Consent as is_cus102_189_, businesspa0_.EM_Obsepad_Mandate_Identifier as em_obs103_189_, businesspa0_.EM_Obsepad_Mandate_Date as em_obs104_189_, businesspa0_.EM_Aeatsii_Rep_Taxid as em_aea105_189_, businesspa0_.EM_Aeatsii_Menor as em_aea106_189_, businesspa0_.EM_Ec_Isvalorated as em_ec_107_189_, businesspa0_.EM_Pruti_Addbp as em_pru108_189_, businesspa0_.EM_Ec_Isminoutvalued as em_ec_109_189_, businesspa0_.EM_Pruti_Unlock_Date as em_pru110_189_, businesspa0_.EM_Pruti_Unlock_Order_Date as em_pru111_189_, businesspa0_.EM_Pruti_Annexes_Bp_So_ID as em_pru112_189_, businesspa0_.EM_Pruti_Annexes_Bp_Po_ID as em_pru113_189_, businesspa0_.EM_Aeatsii_Defaultsiikey as em_aea114_189_, businesspa0_.EM_Aeatsii_Siikeylist as em_aea115_189_, businesspa0_.EM_Prsii_Clave_Tipo_Proveedor as em_prs116_189_, businesspa0_.EM_Tbai_Issimplifiedinv as em_tba117_189_, businesspa0_.EM_Prsii_Clave_Tipo_Cliente as em_prs118_189_, businesspa0_.EM_Obwpl_Bp_Block_Pickinglist as em_obw119_189_, businesspa0_.em_pruti_cus_block_reason_id as em_pru120_189_, businesspa0_.EM_Pruti_Notsendinvoice as em_pru121_189_, businesspa0_.EM_Pruti_Showpriceingoods as em_pru122_189_, businesspa0_.EM_OBTIK_Tax_ID_Key as em_obt123_189_, businesspa0_.Em_Prcex_Glitem_Id as em_prc124_189_ from C_BPartner businesspa0_ where (upper((businesspa0_.Name || ' - ' || coalesce(to_char(businesspa0_.Name2), ''))) like upper('%pla%') escape '|') and (exists (select 1 from ec_product_cost_v ec_product1_ left outer join M_Product product2_ on ec_product1_.M_Product_ID=product2_.M_Product_ID inner join C_BPartner businesspa3_ on ec_product1_.C_Bpartner_ID=businesspa3_.C_BPartner_ID where (upper((coalesce(to_char((select producttrl4_.Name from M_Product_Trl producttrl4_ where producttrl4_.M_Product_ID=product2_.M_Product_ID and producttrl4_.AD_Language='es_ES')), to_char(product2_.Name), '') || ' - ' || coalesce(to_char(product2_.Description), ''))) like upper('%fermator%') escape '|') and businesspa3_.C_BPartner_ID = businesspa0_.C_BPartner_ID and (ec_product1_.AD_Org_ID in ('0', '4336B51A28B149DF911A36B0D3F03677', 'F7EA3492149E4357B7FCFAE16C7F027F', 'EB72268743764DE99601631DDF69CFA1', '547464619E3348369E774BA8164BD820', 'E55BA2DCBF9C4D4A83D456F5B710B033')) and (ec_product1_.AD_Client_ID in ('CFEDC17130E14D2BAE431B401DF89CF1', '0')))) order by businesspa0_.Name, businesspa0_.Name2 limit '76';

Date: 2026-07-14 11:00:54
Duration: 1s508ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

select "_"."c_order_id", "_"."ad_org_id", "_"."isactive", "_"."issotrx", "_"."m_pricelist_id", "_"."Documento", "_"."Estado Pedido", "_"."Accion Pedido", "_"."Procesado", "_"."Tipo Documento", "_"."Descripción", "_"."Fecha Pedido", "_"."Fecha Comprometida", "_"."c_bpartner_id", "_"."Referencia Pedido", "_"."c_currency_id", "_"."Currency ISO", "_"."m_warehouse_id", "_"."Ciudad", "_"."Codigo Postal", "_"."Pais", "_"."Region", "_"."Vendedor", "_"."Delegacion" from ( SELECT O.c_order_id, O.ad_org_id, O.isactive, O.issotrx, O.m_pricelist_id, O.documentno as "Documento", O.docstatus as "Estado Pedido", O.docaction as "Accion Pedido", O.processed as "Procesado", DT.name as "Tipo Documento", O.description as "Descripción", O.dateordered as "Fecha Pedido", O.datepromised as "Fecha Comprometida", O.c_bpartner_id, O.poreference "Referencia Pedido", O.c_currency_id, cu.iso_code "Currency ISO", O.m_warehouse_id, cl.city as "Ciudad", cl.postal as "Codigo Postal", cc."name" as "Pais", cr."name" as "Region", us.name as "Vendedor", mw."name" as "Delegacion" FROM c_order O LEFT JOIN c_doctype DT on DT.c_doctype_id = O.c_doctype_id INNER JOIN c_currency cu on cu.c_currency_id = o.c_currency_id LEFT JOIN c_bpartner_location cbl on cbl.c_bpartner_location_id = O.c_bpartner_location_id LEFT JOIN c_location cl on cl.c_location_id = cbl.c_location_id LEFT JOIN c_country cc on cc.c_country_id = cl.c_country_id LEFT JOIN c_region cr on cr.c_region_id = cl.c_region_id LEFT JOIN ad_user us on us.ad_user_id = O.salesrep_id left join m_warehouse mw on mw.m_warehouse_id = us.default_m_warehouse_id WHERE 1 = 1 AND O.issotrx = 'Y') "_" order by "_"."Fecha Pedido" desc;

Date: 2026-07-14 14:02:42
Duration: 17s403ms
Database: etendo
User: tad
Remote: 51.195.39.29
Application: Mashup Engine

select "_"."c_order_id", "_"."ad_org_id", "_"."isactive", "_"."issotrx", "_"."m_pricelist_id", "_"."Documento", "_"."Estado Pedido", "_"."Accion Pedido", "_"."Procesado", "_"."Tipo Documento", "_"."Descripción", "_"."Fecha Pedido", "_"."Fecha Comprometida", "_"."c_bpartner_id", "_"."Referencia Pedido", "_"."c_currency_id", "_"."Currency ISO", "_"."m_warehouse_id", "_"."Ciudad", "_"."Codigo Postal", "_"."Pais", "_"."Region", "_"."Vendedor", "_"."Delegacion" from ( SELECT O.c_order_id, O.ad_org_id, O.isactive, O.issotrx, O.m_pricelist_id, O.documentno as "Documento", O.docstatus as "Estado Pedido", O.docaction as "Accion Pedido", O.processed as "Procesado", DT.name as "Tipo Documento", O.description as "Descripción", O.dateordered as "Fecha Pedido", O.datepromised as "Fecha Comprometida", O.c_bpartner_id, O.poreference "Referencia Pedido", O.c_currency_id, cu.iso_code "Currency ISO", O.m_warehouse_id, cl.city as "Ciudad", cl.postal as "Codigo Postal", cc."name" as "Pais", cr."name" as "Region", us.name as "Vendedor", mw."name" as "Delegacion" FROM c_order O LEFT JOIN c_doctype DT on DT.c_doctype_id = O.c_doctype_id INNER JOIN c_currency cu on cu.c_currency_id = o.c_currency_id LEFT JOIN c_bpartner_location cbl on cbl.c_bpartner_location_id = O.c_bpartner_location_id LEFT JOIN c_location cl on cl.c_location_id = cbl.c_location_id LEFT JOIN c_country cc on cc.c_country_id = cl.c_country_id LEFT JOIN c_region cr on cr.c_region_id = cl.c_region_id LEFT JOIN ad_user us on us.ad_user_id = O.salesrep_id left join m_warehouse mw on mw.m_warehouse_id = us.default_m_warehouse_id WHERE 1 = 1 AND O.issotrx = 'Y') "_" order by "_"."Fecha Pedido" desc;

Date: 2026-07-14 20:03:19
Duration: 17s194ms
Database: etendo
User: tad
Remote: 51.195.39.29
Application: Mashup Engine

select "_"."c_order_id", "_"."ad_org_id", "_"."isactive", "_"."issotrx", "_"."m_pricelist_id", "_"."Documento", "_"."Estado Pedido", "_"."Accion Pedido", "_"."Procesado", "_"."Tipo Documento", "_"."Descripción", "_"."Fecha Pedido", "_"."Fecha Comprometida", "_"."c_bpartner_id", "_"."Referencia Pedido", "_"."c_currency_id", "_"."Currency ISO", "_"."m_warehouse_id", "_"."Ciudad", "_"."Codigo Postal", "_"."Pais", "_"."Region", "_"."Vendedor", "_"."Delegacion" from ( SELECT O.c_order_id, O.ad_org_id, O.isactive, O.issotrx, O.m_pricelist_id, O.documentno as "Documento", O.docstatus as "Estado Pedido", O.docaction as "Accion Pedido", O.processed as "Procesado", DT.name as "Tipo Documento", O.description as "Descripción", O.dateordered as "Fecha Pedido", O.datepromised as "Fecha Comprometida", O.c_bpartner_id, O.poreference "Referencia Pedido", O.c_currency_id, cu.iso_code "Currency ISO", O.m_warehouse_id, cl.city as "Ciudad", cl.postal as "Codigo Postal", cc."name" as "Pais", cr."name" as "Region", us.name as "Vendedor", mw."name" as "Delegacion" FROM c_order O LEFT JOIN c_doctype DT on DT.c_doctype_id = O.c_doctype_id INNER JOIN c_currency cu on cu.c_currency_id = o.c_currency_id LEFT JOIN c_bpartner_location cbl on cbl.c_bpartner_location_id = O.c_bpartner_location_id LEFT JOIN c_location cl on cl.c_location_id = cbl.c_location_id LEFT JOIN c_country cc on cc.c_country_id = cl.c_country_id LEFT JOIN c_region cr on cr.c_region_id = cl.c_region_id LEFT JOIN ad_user us on us.ad_user_id = O.salesrep_id left join m_warehouse mw on mw.m_warehouse_id = us.default_m_warehouse_id WHERE 1 = 1 AND O.issotrx = 'Y') "_" order by "_"."Fecha Pedido" desc;

Date: 2026-07-14 16:03:03
Duration: 15s142ms
Database: etendo
User: tad
Remote: 51.195.39.29
Application: Mashup Engine

x Hide