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 ('16F2119A3001448C8E8E09A885A0E24D')) order by m_inout.documentno;

Date: 2026-07-16 15:21:23
Duration: 2s986ms
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 ('88763AAA935A48B38B1F9FF53CF74409')) order by m_inout.documentno;

Date: 2026-07-16 16:03:10
Duration: 2s889ms
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 ('092A22232A1E443C87FD7C95936FFA2C')) order by m_inout.documentno;

Date: 2026-07-16 16:03:00
Duration: 2s884ms
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-16 20:03:20
Duration: 28s571ms
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-16 11:04:41
Duration: 24s639ms
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-16 16:03:10
Duration: 21s790ms
Database: etendo
User: tad
Remote: 51.195.39.29
Application: Mashup Engine

x Hide

SELECT ID, C_ORDER_ID, DOCUMENTNO, DATEORDERED, C_BPARTNER_ID, PARTNER_NAME, PRODUCT_VALUE, PRODUCT_ID, PRODUCT_NAME, DESCRIPTION, ATTRIBUTEID, TOTAL_QTY, QTYORDERED, MLOCATORID, MLOCATORNAME, ORDERLINEID, QTYPENDING, ISACTIVE, 'DD-MM-YYYY' AS DATE_FORMAT, coalesce(( select coalesce(c_uom_trl.name, c_uom.name) from c_uom left join c_uom_trl on c_uom_trl.c_uom_id = c_uom.c_uom_id and c_uom_trl.ad_language = 'es_ES' where c_uom.c_uom_id = coalesce(a.c_aum, a.c_uom_id, '')), '') as uomsymbol, conversionrate, c_aum as alternativeuom FROM ( SELECT C_ORDERLINE.C_ORDERLINE_ID AS ID, C_ORDER.C_ORDER_ID AS C_ORDER_ID, C_ORDER.DOCUMENTNO || ' - ' || TO_CHAR(C_ORDER.DATEORDERED, 'DD-MM-YYYY') || ' / ' || TO_CHAR(C_ORDER.DATEPROMISED, 'DD-MM-YYYY') AS DOCUMENTNO, C_ORDER.DATEORDERED AS DATEORDERED, C_BPARTNER.C_BPARTNER_ID AS C_BPARTNER_ID, C_BPARTNER.NAME || ' - ' || C_BPARTNER.NAME2 AS PARTNER_NAME, C_ORDERLINE.M_PRODUCT_ID AS PRODUCT_ID, AD_COLUMN_IDENTIFIER (TO_CHAR('M_Product'), TO_CHAR(C_ORDERLINE.M_PRODUCT_ID), TO_CHAR('es_ES')) AS PRODUCT_NAME, ( select VALUE from M_PRODUCT where M_PRODUCT_ID = C_ORDERLINE.M_PRODUCT_ID) as PRODUCT_VALUE, M_ATTRIBUTESETINSTANCE.DESCRIPTION AS DESCRIPTION, M_ATTRIBUTESETINSTANCE.M_ATTRIBUTESETINSTANCE_ID AS ATTRIBUTEID, coalesce(c_orderline.aumqty, C_ORDERLINE.QTYORDERED) AS TOTAL_QTY, coalesce(c_orderline.aumqty, C_ORDERLINE.QTYORDERED) - round((SUM(COALESCE(M_MATCHPO.QTY, 0)) * round((coalesce(c_orderline.aumqty, C_ORDERLINE.QTYORDERED) / C_ORDERLINE.QTYORDERED), 20)), 2) AS QTYPENDING, case when prouti_getpropertyenabled (c_order.ad_client_id, c_order.ad_org_id, 'PROUTI_ShowPendingQty') = 'Y' then (C_ORDERLINE.QTYORDERED - SUM(COALESCE(M_MATCHPO.QTY, 0))) else 0 end as QTYORDERED, '-1' AS ISACTIVE, C_ORDERLINE.LINE, case when prouti_getpropertyenabled (c_order.ad_client_id, c_order.ad_org_id, 'Prouti_MultiStorageBin') = 'Y' then case when ( SELECT msb.m_locator_id FROM prouti_multi_storage_bin msb LEFT JOIN m_product prod on msb.m_product_id = prod.m_product_id LEFT JOIN c_order co on co.c_order_id = c_orderline.c_order_id LEFT JOIN m_warehouse ware on msb.m_warehouse_id = ware.m_warehouse_id WHERE prod.m_product_id = c_orderline.m_product_id and ware.m_warehouse_id = co.m_warehouse_id) is not null then ( SELECT msb.m_locator_id FROM prouti_multi_storage_bin msb LEFT JOIN m_product prod on msb.m_product_id = prod.m_product_id LEFT JOIN c_order co on co.c_order_id = c_orderline.c_order_id LEFT JOIN m_warehouse ware on msb.m_warehouse_id = ware.m_warehouse_id WHERE prod.m_product_id = c_orderline.m_product_id and ware.m_warehouse_id = co.m_warehouse_id) else ( SELECT loc.m_locator_id FROM m_locator loc WHERE loc.m_warehouse_id = c_order.m_warehouse_id and loc.IsDefault = 'Y' LIMIT 1) end else case when prouti_getpropertyenabled (c_order.ad_client_id, c_order.ad_org_id, 'Prouti_ShowDefaultStorageBin') = 'Y' then ( SELECT loc.m_locator_id FROM m_locator loc WHERE loc.m_warehouse_id = c_order.m_warehouse_id and loc.IsDefault = 'Y' LIMIT 1) else null end end as MLOCATORID, case when prouti_getpropertyenabled (c_order.ad_client_id, c_order.ad_org_id, 'Prouti_MultiStorageBin') = 'Y' then case when ( SELECT loc.value FROM prouti_multi_storage_bin msb LEFT JOIN m_locator loc on msb.m_locator_id = loc.m_locator_id LEFT JOIN m_product prod on msb.m_product_id = prod.m_product_id LEFT JOIN c_order co on co.c_order_id = c_orderline.c_order_id LEFT JOIN m_warehouse ware on msb.m_warehouse_id = ware.m_warehouse_id WHERE prod.m_product_id = c_orderline.m_product_id and ware.m_warehouse_id = co.m_warehouse_id) is not null then ( SELECT loc.value FROM prouti_multi_storage_bin msb LEFT JOIN m_locator loc on msb.m_locator_id = loc.m_locator_id LEFT JOIN m_product prod on msb.m_product_id = prod.m_product_id LEFT JOIN c_order co on co.c_order_id = c_orderline.c_order_id LEFT JOIN m_warehouse ware on msb.m_warehouse_id = ware.m_warehouse_id WHERE prod.m_product_id = c_orderline.m_product_id and ware.m_warehouse_id = co.m_warehouse_id) else ( SELECT loc.value || ' - ' || ware.name FROM m_locator loc left join m_warehouse ware on loc.m_warehouse_id = ware.m_warehouse_id WHERE loc.m_warehouse_id = c_order.m_warehouse_id and loc.IsDefault = 'Y' LIMIT 1) end else case when prouti_getpropertyenabled (c_order.ad_client_id, c_order.ad_org_id, 'Prouti_ShowDefaultStorageBin') = 'Y' then ( SELECT loc.value || ' - ' || ware.name FROM m_locator loc left join m_warehouse ware on loc.m_warehouse_id = ware.m_warehouse_id WHERE loc.m_warehouse_id = c_order.m_warehouse_id and loc.IsDefault = 'Y' LIMIT 1) else null end end as MLOCATORNAME, C_ORDERLINE.C_ORDERLINE_ID as ORDERLINEID, null as c_aum, c_orderline.c_uom_id, 1 as conversionrate FROM C_ORDERLINE left join M_MATCHPO on C_ORDERLINE.C_ORDERLINE_ID = M_MATCHPO.C_ORDERLINE_ID and M_MATCHPO.M_INOUTLINE_ID IS NOT NULL left join M_ATTRIBUTESETINSTANCE on C_ORDERLINE.M_ATTRIBUTESETINSTANCE_ID = M_ATTRIBUTESETINSTANCE.M_ATTRIBUTESETINSTANCE_ID, C_ORDER, C_BPARTNER, C_DOCTYPE WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_ORDERLINE.QTYORDERED != 0 AND C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID AND C_ORDER.AD_CLIENT_ID IN ('0', 'CFEDC17130E14D2BAE431B401DF89CF1') AND C_ORDER.AD_ORG_ID IN ('F7EA3492149E4357B7FCFAE16C7F027F') AND C_ORDER.ISSOTRX = 'N' AND C_ORDER.DOCUMENTNO LIKE '%' AND C_ORDER.DOCSTATUS = 'CO' AND C_ORDER.C_DOCTYPE_ID = C_DOCTYPE.C_DOCTYPE_ID AND C_DOCTYPE.ISRETURN = 'N' GROUP BY C_ORDERLINE.C_ORDERLINE_ID, C_ORDER.C_ORDER_ID, C_ORDER.DOCUMENTNO, C_ORDER.DATEORDERED, C_BPARTNER.C_BPARTNER_ID, C_BPARTNER.NAME, C_BPARTNER.NAME2, C_ORDERLINE.M_PRODUCT_ID, M_ATTRIBUTESETINSTANCE.DESCRIPTION, M_ATTRIBUTESETINSTANCE.M_ATTRIBUTESETINSTANCE_ID, C_ORDERLINE.QTYORDERED, C_ORDERLINE.LINE) A WHERE ( CASE WHEN Total_Qty < 0 THEN -1 ELSE 1 END) = ( CASE WHEN QTYPENDING < 0 THEN -1 ELSE 1 End) AND QTYPENDING <> 0 ORDER BY C_BPARTNER_ID, DOCUMENTNO, LINE;

Date: 2026-07-16 16:10:09
Duration: 8s902ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

SELECT ID, C_ORDER_ID, DOCUMENTNO, DATEORDERED, C_BPARTNER_ID, PARTNER_NAME, PRODUCT_VALUE, PRODUCT_ID, PRODUCT_NAME, DESCRIPTION, ATTRIBUTEID, TOTAL_QTY, QTYORDERED, MLOCATORID, MLOCATORNAME, ORDERLINEID, QTYPENDING, ISACTIVE, 'DD-MM-YYYY' AS DATE_FORMAT, coalesce(( select coalesce(c_uom_trl.name, c_uom.name) from c_uom left join c_uom_trl on c_uom_trl.c_uom_id = c_uom.c_uom_id and c_uom_trl.ad_language = 'es_ES' where c_uom.c_uom_id = coalesce(a.c_aum, a.c_uom_id, '')), '') as uomsymbol, conversionrate, c_aum as alternativeuom FROM ( SELECT C_ORDERLINE.C_ORDERLINE_ID AS ID, C_ORDER.C_ORDER_ID AS C_ORDER_ID, C_ORDER.DOCUMENTNO || ' - ' || TO_CHAR(C_ORDER.DATEORDERED, 'DD-MM-YYYY') || ' / ' || TO_CHAR(C_ORDER.DATEPROMISED, 'DD-MM-YYYY') AS DOCUMENTNO, C_ORDER.DATEORDERED AS DATEORDERED, C_BPARTNER.C_BPARTNER_ID AS C_BPARTNER_ID, C_BPARTNER.NAME || ' - ' || C_BPARTNER.NAME2 AS PARTNER_NAME, C_ORDERLINE.M_PRODUCT_ID AS PRODUCT_ID, AD_COLUMN_IDENTIFIER (TO_CHAR('M_Product'), TO_CHAR(C_ORDERLINE.M_PRODUCT_ID), TO_CHAR('es_ES')) AS PRODUCT_NAME, ( select VALUE from M_PRODUCT where M_PRODUCT_ID = C_ORDERLINE.M_PRODUCT_ID) as PRODUCT_VALUE, M_ATTRIBUTESETINSTANCE.DESCRIPTION AS DESCRIPTION, M_ATTRIBUTESETINSTANCE.M_ATTRIBUTESETINSTANCE_ID AS ATTRIBUTEID, coalesce(c_orderline.aumqty, C_ORDERLINE.QTYORDERED) AS TOTAL_QTY, coalesce(c_orderline.aumqty, C_ORDERLINE.QTYORDERED) - round((SUM(COALESCE(M_MATCHPO.QTY, 0)) * round((coalesce(c_orderline.aumqty, C_ORDERLINE.QTYORDERED) / C_ORDERLINE.QTYORDERED), 20)), 2) AS QTYPENDING, case when prouti_getpropertyenabled (c_order.ad_client_id, c_order.ad_org_id, 'PROUTI_ShowPendingQty') = 'Y' then (C_ORDERLINE.QTYORDERED - SUM(COALESCE(M_MATCHPO.QTY, 0))) else 0 end as QTYORDERED, '-1' AS ISACTIVE, C_ORDERLINE.LINE, case when prouti_getpropertyenabled (c_order.ad_client_id, c_order.ad_org_id, 'Prouti_MultiStorageBin') = 'Y' then case when ( SELECT msb.m_locator_id FROM prouti_multi_storage_bin msb LEFT JOIN m_product prod on msb.m_product_id = prod.m_product_id LEFT JOIN c_order co on co.c_order_id = c_orderline.c_order_id LEFT JOIN m_warehouse ware on msb.m_warehouse_id = ware.m_warehouse_id WHERE prod.m_product_id = c_orderline.m_product_id and ware.m_warehouse_id = co.m_warehouse_id) is not null then ( SELECT msb.m_locator_id FROM prouti_multi_storage_bin msb LEFT JOIN m_product prod on msb.m_product_id = prod.m_product_id LEFT JOIN c_order co on co.c_order_id = c_orderline.c_order_id LEFT JOIN m_warehouse ware on msb.m_warehouse_id = ware.m_warehouse_id WHERE prod.m_product_id = c_orderline.m_product_id and ware.m_warehouse_id = co.m_warehouse_id) else ( SELECT loc.m_locator_id FROM m_locator loc WHERE loc.m_warehouse_id = c_order.m_warehouse_id and loc.IsDefault = 'Y' LIMIT 1) end else case when prouti_getpropertyenabled (c_order.ad_client_id, c_order.ad_org_id, 'Prouti_ShowDefaultStorageBin') = 'Y' then ( SELECT loc.m_locator_id FROM m_locator loc WHERE loc.m_warehouse_id = c_order.m_warehouse_id and loc.IsDefault = 'Y' LIMIT 1) else null end end as MLOCATORID, case when prouti_getpropertyenabled (c_order.ad_client_id, c_order.ad_org_id, 'Prouti_MultiStorageBin') = 'Y' then case when ( SELECT loc.value FROM prouti_multi_storage_bin msb LEFT JOIN m_locator loc on msb.m_locator_id = loc.m_locator_id LEFT JOIN m_product prod on msb.m_product_id = prod.m_product_id LEFT JOIN c_order co on co.c_order_id = c_orderline.c_order_id LEFT JOIN m_warehouse ware on msb.m_warehouse_id = ware.m_warehouse_id WHERE prod.m_product_id = c_orderline.m_product_id and ware.m_warehouse_id = co.m_warehouse_id) is not null then ( SELECT loc.value FROM prouti_multi_storage_bin msb LEFT JOIN m_locator loc on msb.m_locator_id = loc.m_locator_id LEFT JOIN m_product prod on msb.m_product_id = prod.m_product_id LEFT JOIN c_order co on co.c_order_id = c_orderline.c_order_id LEFT JOIN m_warehouse ware on msb.m_warehouse_id = ware.m_warehouse_id WHERE prod.m_product_id = c_orderline.m_product_id and ware.m_warehouse_id = co.m_warehouse_id) else ( SELECT loc.value || ' - ' || ware.name FROM m_locator loc left join m_warehouse ware on loc.m_warehouse_id = ware.m_warehouse_id WHERE loc.m_warehouse_id = c_order.m_warehouse_id and loc.IsDefault = 'Y' LIMIT 1) end else case when prouti_getpropertyenabled (c_order.ad_client_id, c_order.ad_org_id, 'Prouti_ShowDefaultStorageBin') = 'Y' then ( SELECT loc.value || ' - ' || ware.name FROM m_locator loc left join m_warehouse ware on loc.m_warehouse_id = ware.m_warehouse_id WHERE loc.m_warehouse_id = c_order.m_warehouse_id and loc.IsDefault = 'Y' LIMIT 1) else null end end as MLOCATORNAME, C_ORDERLINE.C_ORDERLINE_ID as ORDERLINEID, null as c_aum, c_orderline.c_uom_id, 1 as conversionrate FROM C_ORDERLINE left join M_MATCHPO on C_ORDERLINE.C_ORDERLINE_ID = M_MATCHPO.C_ORDERLINE_ID and M_MATCHPO.M_INOUTLINE_ID IS NOT NULL left join M_ATTRIBUTESETINSTANCE on C_ORDERLINE.M_ATTRIBUTESETINSTANCE_ID = M_ATTRIBUTESETINSTANCE.M_ATTRIBUTESETINSTANCE_ID, C_ORDER, C_BPARTNER, C_DOCTYPE WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_ORDERLINE.QTYORDERED != 0 AND C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID AND C_ORDER.AD_CLIENT_ID IN ('0', 'CFEDC17130E14D2BAE431B401DF89CF1') AND C_ORDER.AD_ORG_ID IN ('F7EA3492149E4357B7FCFAE16C7F027F') AND C_ORDER.ISSOTRX = 'N' AND C_ORDER.DOCUMENTNO LIKE '%' AND C_ORDER.DOCSTATUS = 'CO' AND C_ORDER.C_DOCTYPE_ID = C_DOCTYPE.C_DOCTYPE_ID AND C_DOCTYPE.ISRETURN = 'N' GROUP BY C_ORDERLINE.C_ORDERLINE_ID, C_ORDER.C_ORDER_ID, C_ORDER.DOCUMENTNO, C_ORDER.DATEORDERED, C_BPARTNER.C_BPARTNER_ID, C_BPARTNER.NAME, C_BPARTNER.NAME2, C_ORDERLINE.M_PRODUCT_ID, M_ATTRIBUTESETINSTANCE.DESCRIPTION, M_ATTRIBUTESETINSTANCE.M_ATTRIBUTESETINSTANCE_ID, C_ORDERLINE.QTYORDERED, C_ORDERLINE.LINE) A WHERE ( CASE WHEN Total_Qty < 0 THEN -1 ELSE 1 END) = ( CASE WHEN QTYPENDING < 0 THEN -1 ELSE 1 End) AND QTYPENDING <> 0 ORDER BY C_BPARTNER_ID, DOCUMENTNO, LINE;

Date: 2026-07-16 16:04:53
Duration: 8s560ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

SELECT ID, C_ORDER_ID, DOCUMENTNO, DATEORDERED, C_BPARTNER_ID, PARTNER_NAME, PRODUCT_VALUE, PRODUCT_ID, PRODUCT_NAME, DESCRIPTION, ATTRIBUTEID, TOTAL_QTY, QTYORDERED, MLOCATORID, MLOCATORNAME, ORDERLINEID, QTYPENDING, ISACTIVE, 'DD-MM-YYYY' AS DATE_FORMAT, coalesce(( select coalesce(c_uom_trl.name, c_uom.name) from c_uom left join c_uom_trl on c_uom_trl.c_uom_id = c_uom.c_uom_id and c_uom_trl.ad_language = 'es_ES' where c_uom.c_uom_id = coalesce(a.c_aum, a.c_uom_id, '')), '') as uomsymbol, conversionrate, c_aum as alternativeuom FROM ( SELECT C_ORDERLINE.C_ORDERLINE_ID AS ID, C_ORDER.C_ORDER_ID AS C_ORDER_ID, C_ORDER.DOCUMENTNO || ' - ' || TO_CHAR(C_ORDER.DATEORDERED, 'DD-MM-YYYY') || ' / ' || TO_CHAR(C_ORDER.DATEPROMISED, 'DD-MM-YYYY') AS DOCUMENTNO, C_ORDER.DATEORDERED AS DATEORDERED, C_BPARTNER.C_BPARTNER_ID AS C_BPARTNER_ID, C_BPARTNER.NAME || ' - ' || C_BPARTNER.NAME2 AS PARTNER_NAME, C_ORDERLINE.M_PRODUCT_ID AS PRODUCT_ID, AD_COLUMN_IDENTIFIER (TO_CHAR('M_Product'), TO_CHAR(C_ORDERLINE.M_PRODUCT_ID), TO_CHAR('es_ES')) AS PRODUCT_NAME, ( select VALUE from M_PRODUCT where M_PRODUCT_ID = C_ORDERLINE.M_PRODUCT_ID) as PRODUCT_VALUE, M_ATTRIBUTESETINSTANCE.DESCRIPTION AS DESCRIPTION, M_ATTRIBUTESETINSTANCE.M_ATTRIBUTESETINSTANCE_ID AS ATTRIBUTEID, coalesce(c_orderline.aumqty, C_ORDERLINE.QTYORDERED) AS TOTAL_QTY, coalesce(c_orderline.aumqty, C_ORDERLINE.QTYORDERED) - round((SUM(COALESCE(M_MATCHPO.QTY, 0)) * round((coalesce(c_orderline.aumqty, C_ORDERLINE.QTYORDERED) / C_ORDERLINE.QTYORDERED), 20)), 2) AS QTYPENDING, case when prouti_getpropertyenabled (c_order.ad_client_id, c_order.ad_org_id, 'PROUTI_ShowPendingQty') = 'Y' then (C_ORDERLINE.QTYORDERED - SUM(COALESCE(M_MATCHPO.QTY, 0))) else 0 end as QTYORDERED, '-1' AS ISACTIVE, C_ORDERLINE.LINE, case when prouti_getpropertyenabled (c_order.ad_client_id, c_order.ad_org_id, 'Prouti_MultiStorageBin') = 'Y' then case when ( SELECT msb.m_locator_id FROM prouti_multi_storage_bin msb LEFT JOIN m_product prod on msb.m_product_id = prod.m_product_id LEFT JOIN c_order co on co.c_order_id = c_orderline.c_order_id LEFT JOIN m_warehouse ware on msb.m_warehouse_id = ware.m_warehouse_id WHERE prod.m_product_id = c_orderline.m_product_id and ware.m_warehouse_id = co.m_warehouse_id) is not null then ( SELECT msb.m_locator_id FROM prouti_multi_storage_bin msb LEFT JOIN m_product prod on msb.m_product_id = prod.m_product_id LEFT JOIN c_order co on co.c_order_id = c_orderline.c_order_id LEFT JOIN m_warehouse ware on msb.m_warehouse_id = ware.m_warehouse_id WHERE prod.m_product_id = c_orderline.m_product_id and ware.m_warehouse_id = co.m_warehouse_id) else ( SELECT loc.m_locator_id FROM m_locator loc WHERE loc.m_warehouse_id = c_order.m_warehouse_id and loc.IsDefault = 'Y' LIMIT 1) end else case when prouti_getpropertyenabled (c_order.ad_client_id, c_order.ad_org_id, 'Prouti_ShowDefaultStorageBin') = 'Y' then ( SELECT loc.m_locator_id FROM m_locator loc WHERE loc.m_warehouse_id = c_order.m_warehouse_id and loc.IsDefault = 'Y' LIMIT 1) else null end end as MLOCATORID, case when prouti_getpropertyenabled (c_order.ad_client_id, c_order.ad_org_id, 'Prouti_MultiStorageBin') = 'Y' then case when ( SELECT loc.value FROM prouti_multi_storage_bin msb LEFT JOIN m_locator loc on msb.m_locator_id = loc.m_locator_id LEFT JOIN m_product prod on msb.m_product_id = prod.m_product_id LEFT JOIN c_order co on co.c_order_id = c_orderline.c_order_id LEFT JOIN m_warehouse ware on msb.m_warehouse_id = ware.m_warehouse_id WHERE prod.m_product_id = c_orderline.m_product_id and ware.m_warehouse_id = co.m_warehouse_id) is not null then ( SELECT loc.value FROM prouti_multi_storage_bin msb LEFT JOIN m_locator loc on msb.m_locator_id = loc.m_locator_id LEFT JOIN m_product prod on msb.m_product_id = prod.m_product_id LEFT JOIN c_order co on co.c_order_id = c_orderline.c_order_id LEFT JOIN m_warehouse ware on msb.m_warehouse_id = ware.m_warehouse_id WHERE prod.m_product_id = c_orderline.m_product_id and ware.m_warehouse_id = co.m_warehouse_id) else ( SELECT loc.value || ' - ' || ware.name FROM m_locator loc left join m_warehouse ware on loc.m_warehouse_id = ware.m_warehouse_id WHERE loc.m_warehouse_id = c_order.m_warehouse_id and loc.IsDefault = 'Y' LIMIT 1) end else case when prouti_getpropertyenabled (c_order.ad_client_id, c_order.ad_org_id, 'Prouti_ShowDefaultStorageBin') = 'Y' then ( SELECT loc.value || ' - ' || ware.name FROM m_locator loc left join m_warehouse ware on loc.m_warehouse_id = ware.m_warehouse_id WHERE loc.m_warehouse_id = c_order.m_warehouse_id and loc.IsDefault = 'Y' LIMIT 1) else null end end as MLOCATORNAME, C_ORDERLINE.C_ORDERLINE_ID as ORDERLINEID, null as c_aum, c_orderline.c_uom_id, 1 as conversionrate FROM C_ORDERLINE left join M_MATCHPO on C_ORDERLINE.C_ORDERLINE_ID = M_MATCHPO.C_ORDERLINE_ID and M_MATCHPO.M_INOUTLINE_ID IS NOT NULL left join M_ATTRIBUTESETINSTANCE on C_ORDERLINE.M_ATTRIBUTESETINSTANCE_ID = M_ATTRIBUTESETINSTANCE.M_ATTRIBUTESETINSTANCE_ID, C_ORDER, C_BPARTNER, C_DOCTYPE WHERE C_ORDER.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID AND C_ORDERLINE.QTYORDERED != 0 AND C_ORDER.C_ORDER_ID = C_ORDERLINE.C_ORDER_ID AND C_ORDER.AD_CLIENT_ID IN ('0', 'CFEDC17130E14D2BAE431B401DF89CF1') AND C_ORDER.AD_ORG_ID IN ('F7EA3492149E4357B7FCFAE16C7F027F') AND C_ORDER.ISSOTRX = 'N' AND C_ORDER.DOCUMENTNO LIKE '%' AND C_ORDER.DOCSTATUS = 'CO' AND C_ORDER.C_DOCTYPE_ID = C_DOCTYPE.C_DOCTYPE_ID AND C_DOCTYPE.ISRETURN = 'N' GROUP BY C_ORDERLINE.C_ORDERLINE_ID, C_ORDER.C_ORDER_ID, C_ORDER.DOCUMENTNO, C_ORDER.DATEORDERED, C_BPARTNER.C_BPARTNER_ID, C_BPARTNER.NAME, C_BPARTNER.NAME2, C_ORDERLINE.M_PRODUCT_ID, M_ATTRIBUTESETINSTANCE.DESCRIPTION, M_ATTRIBUTESETINSTANCE.M_ATTRIBUTESETINSTANCE_ID, C_ORDERLINE.QTYORDERED, C_ORDERLINE.LINE) A WHERE ( CASE WHEN Total_Qty < 0 THEN -1 ELSE 1 END) = ( CASE WHEN QTYPENDING < 0 THEN -1 ELSE 1 End) AND QTYPENDING <> 0 ORDER BY C_BPARTNER_ID, DOCUMENTNO, LINE;

Date: 2026-07-16 15:44:28
Duration: 8s332ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo