select do_m_produ0_.DO_M_Product_Price_Warehouse_V_ID as DO_M_Pro1_346_, do_m_produ0_.AD_Client_ID as AD_Clien2_346_, do_m_produ0_.AD_Org_ID as AD_Org_I3_346_, do_m_produ0_.Isactive as Isactive4_346_, do_m_produ0_.Created as Created5_346_, do_m_produ0_.Createdby as Createdb6_346_, do_m_produ0_.Updated as Updated7_346_, do_m_produ0_.Updatedby as Updatedb8_346_, do_m_produ0_.M_Product_ID as M_Produc9_346_, do_m_produ0_.M_Attributesetinstance_ID as M_Attri10_346_, do_m_produ0_.Qtyonhand as Qtyonha11_346_, do_m_produ0_.Qtyorderonhand as Qtyorde12_346_, do_m_produ0_.Preqtyonhand as Preqtyo13_346_, do_m_produ0_.EM_Do_Codiproveedor as EM_Do_C14_346_, do_m_produ0_.Pricelist as Priceli15_346_, do_m_produ0_.Pricestd as Pricest16_346_, do_m_produ0_.Pricelimit as Priceli17_346_, do_m_produ0_.M_Warehouse_ID as M_Wareh18_346_, do_m_produ0_.M_Productprice_ID as M_Produ19_346_, do_m_produ0_.Hasstock as Hasstoc20_346_, do_m_produ0_.Isstocked as Isstock21_346_, do_m_produ0_.M_Locator_ID as M_Locat22_346_, do_m_produ0_.A as A23_346_, do_m_produ0_.QTY_Available as QTY_Ava24_346_, do_m_produ0_.QTY_Onhand as QTY_Onh25_346_, do_m_produ0_.QTY_Reserved as QTY_Res26_346_, do_m_produ0_.QTY_Ordered as QTY_Ord27_346_, do_m_produ0_.Orgwarehouse as Orgware28_346_, do_m_produ0_.Stocktotal as Stockto29_346_, do_m_produ0_.Qtyavaliable as Qtyaval30_346_ from do_m_product_price_warehouse_v do_m_produ0_ left outer join M_Product product1_ on do_m_produ0_.M_Product_ID = product1_.M_Product_ID left outer join M_Warehouse warehouse2_ on do_m_produ0_.M_Warehouse_ID = warehouse2_.M_Warehouse_ID left outer join M_AttributeSetInstance attributes3_ on do_m_produ0_.M_Attributesetinstance_ID = attributes3_.M_AttributeSetInstance_ID cross join M_ProductPrice pricingpro8_ where do_m_produ0_.M_Productprice_ID = pricingpro8_.M_ProductPrice_ID and (upper(warehouse2_.Name) like upper('86%') escape '|' or upper(product1_.Value) like upper('86%') escape '|' or upper((product1_.Value || ' - ' || coalesce(to_char(( select producttrl4_.Name from M_Product_Trl producttrl4_ where producttrl4_.M_Product_ID = product1_.M_Product_ID and producttrl4_.AD_Language = 'es_ES')), to_char(product1_.Name), '') || ' - ' || coalesce(to_char(product1_.EM_Do_Codiproveedor), '') || ' - ' || coalesce(to_char(product1_.UPC), ''))) like upper('86%') escape '|' or do_m_produ0_.Qtyavaliable = '86' or upper(attributes3_.Description) like upper('86%') escape '|' or upper(do_m_produ0_.EM_Do_Codiproveedor) like upper('86%') escape '|' or do_m_produ0_.Stocktotal = '86' or upper(product1_.Name) like upper('86%') escape '|') and (do_m_produ0_.AD_Org_ID in ('0', 'FF8081812FBA2641012FBA3528033423', 'A15AA70C8D23453DA93ACD1442681D80', 'FF8081812FBA2641012FBA2DCB5E001E', 'D8A3E616E25141988CBE2DC9CD7415EB')) and do_m_produ0_.Isactive = 'Y' and do_m_produ0_.AD_Client_ID = 'FF8081812FBA2641012FBA2AB5D20003' and case when ( select order5_.IsSOTrx from C_Order order5_ where order5_.C_Order_ID = '67F8CCD899D947428BB2676DF42E6AB2') = 'Y' then product1_.IsSold else product1_.IsPurchased end = 'Y' and pricingpro8_.M_PriceList_Version_ID = 'FF8081812FBA40E4012FBA619FB00011' and do_m_produ0_.M_Warehouse_ID = 'FF8081812FBB6FE4012FBB8A4239007A' and (do_m_produ0_.AD_Client_ID in ('FF8081812FBA2641012FBA2AB5D20003', '0')) and do_m_produ0_.Isactive = 'Y' order by product1_.Name, product1_.M_Product_ID limit '76';

Date: 2026-07-13 09:48:09
Duration: 6s903ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select do_m_produ0_.DO_M_Product_Price_Warehouse_V_ID as DO_M_Pro1_346_, do_m_produ0_.AD_Client_ID as AD_Clien2_346_, do_m_produ0_.AD_Org_ID as AD_Org_I3_346_, do_m_produ0_.Isactive as Isactive4_346_, do_m_produ0_.Created as Created5_346_, do_m_produ0_.Createdby as Createdb6_346_, do_m_produ0_.Updated as Updated7_346_, do_m_produ0_.Updatedby as Updatedb8_346_, do_m_produ0_.M_Product_ID as M_Produc9_346_, do_m_produ0_.M_Attributesetinstance_ID as M_Attri10_346_, do_m_produ0_.Qtyonhand as Qtyonha11_346_, do_m_produ0_.Qtyorderonhand as Qtyorde12_346_, do_m_produ0_.Preqtyonhand as Preqtyo13_346_, do_m_produ0_.EM_Do_Codiproveedor as EM_Do_C14_346_, do_m_produ0_.Pricelist as Priceli15_346_, do_m_produ0_.Pricestd as Pricest16_346_, do_m_produ0_.Pricelimit as Priceli17_346_, do_m_produ0_.M_Warehouse_ID as M_Wareh18_346_, do_m_produ0_.M_Productprice_ID as M_Produ19_346_, do_m_produ0_.Hasstock as Hasstoc20_346_, do_m_produ0_.Isstocked as Isstock21_346_, do_m_produ0_.M_Locator_ID as M_Locat22_346_, do_m_produ0_.A as A23_346_, do_m_produ0_.QTY_Available as QTY_Ava24_346_, do_m_produ0_.QTY_Onhand as QTY_Onh25_346_, do_m_produ0_.QTY_Reserved as QTY_Res26_346_, do_m_produ0_.QTY_Ordered as QTY_Ord27_346_, do_m_produ0_.Orgwarehouse as Orgware28_346_, do_m_produ0_.Stocktotal as Stockto29_346_, do_m_produ0_.Qtyavaliable as Qtyaval30_346_ from do_m_product_price_warehouse_v do_m_produ0_ left outer join M_Product product1_ on do_m_produ0_.M_Product_ID = product1_.M_Product_ID left outer join M_Warehouse warehouse2_ on do_m_produ0_.M_Warehouse_ID = warehouse2_.M_Warehouse_ID left outer join M_AttributeSetInstance attributes3_ on do_m_produ0_.M_Attributesetinstance_ID = attributes3_.M_AttributeSetInstance_ID cross join M_ProductPrice pricingpro8_ where do_m_produ0_.M_Productprice_ID = pricingpro8_.M_ProductPrice_ID and (upper(warehouse2_.Name) like upper('0%') escape '|' or upper(product1_.Value) like upper('0%') escape '|' or upper((product1_.Value || ' - ' || coalesce(to_char(( select producttrl4_.Name from M_Product_Trl producttrl4_ where producttrl4_.M_Product_ID = product1_.M_Product_ID and producttrl4_.AD_Language = 'es_ES')), to_char(product1_.Name), '') || ' - ' || coalesce(to_char(product1_.EM_Do_Codiproveedor), '') || ' - ' || coalesce(to_char(product1_.UPC), ''))) like upper('0%') escape '|' or do_m_produ0_.Qtyavaliable = '0' or upper(attributes3_.Description) like upper('0%') escape '|' or upper(do_m_produ0_.EM_Do_Codiproveedor) like upper('0%') escape '|' or do_m_produ0_.Stocktotal = '0' or upper(product1_.Name) like upper('0%') escape '|') and (do_m_produ0_.AD_Org_ID in ('0', 'FF8081812FBA2641012FBA3528033423', 'A15AA70C8D23453DA93ACD1442681D80', 'FF8081812FBA2641012FBA2DCB5E001E', 'D8A3E616E25141988CBE2DC9CD7415EB')) and do_m_produ0_.Isactive = 'Y' and do_m_produ0_.AD_Client_ID = 'FF8081812FBA2641012FBA2AB5D20003' and case when ( select order5_.IsSOTrx from C_Order order5_ where order5_.C_Order_ID = 'E5E99DACFD9644D8803970FDDB557068') = 'Y' then product1_.IsSold else product1_.IsPurchased end = 'Y' and pricingpro8_.M_PriceList_Version_ID = 'FF8081812FBA40E4012FBA619FB00011' and do_m_produ0_.M_Warehouse_ID = 'FF8081812FBB6FE4012FBB8A4239007A' and (do_m_produ0_.AD_Client_ID in ('FF8081812FBA2641012FBA2AB5D20003', '0')) and do_m_produ0_.Isactive = 'Y' order by product1_.Name, product1_.M_Product_ID limit '76';

Date: 2026-07-13 09:52:24
Duration: 6s546ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select do_m_produ0_.DO_M_Product_Price_Warehouse_V_ID as DO_M_Pro1_346_, do_m_produ0_.AD_Client_ID as AD_Clien2_346_, do_m_produ0_.AD_Org_ID as AD_Org_I3_346_, do_m_produ0_.Isactive as Isactive4_346_, do_m_produ0_.Created as Created5_346_, do_m_produ0_.Createdby as Createdb6_346_, do_m_produ0_.Updated as Updated7_346_, do_m_produ0_.Updatedby as Updatedb8_346_, do_m_produ0_.M_Product_ID as M_Produc9_346_, do_m_produ0_.M_Attributesetinstance_ID as M_Attri10_346_, do_m_produ0_.Qtyonhand as Qtyonha11_346_, do_m_produ0_.Qtyorderonhand as Qtyorde12_346_, do_m_produ0_.Preqtyonhand as Preqtyo13_346_, do_m_produ0_.EM_Do_Codiproveedor as EM_Do_C14_346_, do_m_produ0_.Pricelist as Priceli15_346_, do_m_produ0_.Pricestd as Pricest16_346_, do_m_produ0_.Pricelimit as Priceli17_346_, do_m_produ0_.M_Warehouse_ID as M_Wareh18_346_, do_m_produ0_.M_Productprice_ID as M_Produ19_346_, do_m_produ0_.Hasstock as Hasstoc20_346_, do_m_produ0_.Isstocked as Isstock21_346_, do_m_produ0_.M_Locator_ID as M_Locat22_346_, do_m_produ0_.A as A23_346_, do_m_produ0_.QTY_Available as QTY_Ava24_346_, do_m_produ0_.QTY_Onhand as QTY_Onh25_346_, do_m_produ0_.QTY_Reserved as QTY_Res26_346_, do_m_produ0_.QTY_Ordered as QTY_Ord27_346_, do_m_produ0_.Orgwarehouse as Orgware28_346_, do_m_produ0_.Stocktotal as Stockto29_346_, do_m_produ0_.Qtyavaliable as Qtyaval30_346_ from do_m_product_price_warehouse_v do_m_produ0_ left outer join M_Product product1_ on do_m_produ0_.M_Product_ID = product1_.M_Product_ID left outer join M_Warehouse warehouse2_ on do_m_produ0_.M_Warehouse_ID = warehouse2_.M_Warehouse_ID left outer join M_AttributeSetInstance attributes3_ on do_m_produ0_.M_Attributesetinstance_ID = attributes3_.M_AttributeSetInstance_ID cross join M_ProductPrice pricingpro8_ where do_m_produ0_.M_Productprice_ID = pricingpro8_.M_ProductPrice_ID and (upper(warehouse2_.Name) like upper('00%') escape '|' or upper(product1_.Value) like upper('00%') escape '|' or upper((product1_.Value || ' - ' || coalesce(to_char(( select producttrl4_.Name from M_Product_Trl producttrl4_ where producttrl4_.M_Product_ID = product1_.M_Product_ID and producttrl4_.AD_Language = 'es_ES')), to_char(product1_.Name), '') || ' - ' || coalesce(to_char(product1_.EM_Do_Codiproveedor), '') || ' - ' || coalesce(to_char(product1_.UPC), ''))) like upper('00%') escape '|' or do_m_produ0_.Qtyavaliable = '0' or upper(attributes3_.Description) like upper('00%') escape '|' or upper(do_m_produ0_.EM_Do_Codiproveedor) like upper('00%') escape '|' or do_m_produ0_.Stocktotal = '0' or upper(product1_.Name) like upper('00%') escape '|') and (do_m_produ0_.AD_Org_ID in ('0', 'FF8081812FBA2641012FBA3528033423', 'A15AA70C8D23453DA93ACD1442681D80', 'FF8081812FBA2641012FBA2DCB5E001E', 'D8A3E616E25141988CBE2DC9CD7415EB')) and do_m_produ0_.Isactive = 'Y' and do_m_produ0_.AD_Client_ID = 'FF8081812FBA2641012FBA2AB5D20003' and case when ( select order5_.IsSOTrx from C_Order order5_ where order5_.C_Order_ID = 'E5E99DACFD9644D8803970FDDB557068') = 'Y' then product1_.IsSold else product1_.IsPurchased end = 'Y' and pricingpro8_.M_PriceList_Version_ID = 'FF8081812FBA40E4012FBA619FB00011' and do_m_produ0_.M_Warehouse_ID = 'FF8081812FBB6FE4012FBB8A4239007A' and (do_m_produ0_.AD_Client_ID in ('FF8081812FBA2641012FBA2AB5D20003', '0')) and do_m_produ0_.Isactive = 'Y' order by product1_.Name, product1_.M_Product_ID limit '76';

Date: 2026-07-13 09:51:58
Duration: 6s542ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

select do_m_produ0_.DO_M_Product_Price_Warehouse_V_ID as DO_M_Pro1_346_, do_m_produ0_.AD_Client_ID as AD_Clien2_346_, do_m_produ0_.AD_Org_ID as AD_Org_I3_346_, do_m_produ0_.Isactive as Isactive4_346_, do_m_produ0_.Created as Created5_346_, do_m_produ0_.Createdby as Createdb6_346_, do_m_produ0_.Updated as Updated7_346_, do_m_produ0_.Updatedby as Updatedb8_346_, do_m_produ0_.M_Product_ID as M_Produc9_346_, do_m_produ0_.M_Attributesetinstance_ID as M_Attri10_346_, do_m_produ0_.Qtyonhand as Qtyonha11_346_, do_m_produ0_.Qtyorderonhand as Qtyorde12_346_, do_m_produ0_.Preqtyonhand as Preqtyo13_346_, do_m_produ0_.EM_Do_Codiproveedor as EM_Do_C14_346_, do_m_produ0_.Pricelist as Priceli15_346_, do_m_produ0_.Pricestd as Pricest16_346_, do_m_produ0_.Pricelimit as Priceli17_346_, do_m_produ0_.M_Warehouse_ID as M_Wareh18_346_, do_m_produ0_.M_Productprice_ID as M_Produ19_346_, do_m_produ0_.Hasstock as Hasstoc20_346_, do_m_produ0_.Isstocked as Isstock21_346_, do_m_produ0_.M_Locator_ID as M_Locat22_346_, do_m_produ0_.A as A23_346_, do_m_produ0_.QTY_Available as QTY_Ava24_346_, do_m_produ0_.QTY_Onhand as QTY_Onh25_346_, do_m_produ0_.QTY_Reserved as QTY_Res26_346_, do_m_produ0_.QTY_Ordered as QTY_Ord27_346_, do_m_produ0_.Orgwarehouse as Orgware28_346_, do_m_produ0_.Stocktotal as Stockto29_346_, do_m_produ0_.Qtyavaliable as Qtyaval30_346_ from do_m_product_price_warehouse_v do_m_produ0_ left outer join M_Product product1_ on do_m_produ0_.M_Product_ID = product1_.M_Product_ID left outer join M_Warehouse warehouse2_ on do_m_produ0_.M_Warehouse_ID = warehouse2_.M_Warehouse_ID left outer join M_AttributeSetInstance attributes3_ on do_m_produ0_.M_Attributesetinstance_ID = attributes3_.M_AttributeSetInstance_ID cross join M_ProductPrice pricingpro8_ where do_m_produ0_.M_Productprice_ID = pricingpro8_.M_ProductPrice_ID and (upper(warehouse2_.Name) like upper('76%') escape '|' or upper(product1_.Value) like upper('76%') escape '|' or upper((product1_.Value || ' - ' || coalesce(to_char(( select producttrl4_.Name from M_Product_Trl producttrl4_ where producttrl4_.M_Product_ID = product1_.M_Product_ID and producttrl4_.AD_Language = 'es_ES')), to_char(product1_.Name), '') || ' - ' || coalesce(to_char(product1_.EM_Do_Codiproveedor), '') || ' - ' || coalesce(to_char(product1_.UPC), ''))) like upper('76%') escape '|' or do_m_produ0_.Qtyavaliable = '76' or upper(attributes3_.Description) like upper('76%') escape '|' or upper(do_m_produ0_.EM_Do_Codiproveedor) like upper('76%') escape '|' or do_m_produ0_.Stocktotal = '76' or upper(product1_.Name) like upper('76%') escape '|') and (do_m_produ0_.AD_Org_ID in ('0', 'FF8081812FBA2641012FBA3528033423', 'A15AA70C8D23453DA93ACD1442681D80', 'FF8081812FBA2641012FBA2DCB5E001E', 'D8A3E616E25141988CBE2DC9CD7415EB')) and do_m_produ0_.Isactive = 'Y' and do_m_produ0_.AD_Client_ID = 'FF8081812FBA2641012FBA2AB5D20003' and case when ( select order5_.IsSOTrx from C_Order order5_ where order5_.C_Order_ID = '5EB110A014D947679E1409B0EC463145') = 'Y' then product1_.IsSold else product1_.IsPurchased end = 'Y' and pricingpro8_.M_PriceList_Version_ID = 'FF808181309287D001309309FC030155' and (do_m_produ0_.AD_Client_ID in ('FF8081812FBA2641012FBA2AB5D20003', '0')) and do_m_produ0_.Isactive = 'Y' order by product1_.Name, product1_.M_Product_ID limit '76';

Date: 2026-07-13 08:50:59
Duration: 7s312ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select do_m_produ0_.DO_M_Product_Price_Warehouse_V_ID as DO_M_Pro1_346_, do_m_produ0_.AD_Client_ID as AD_Clien2_346_, do_m_produ0_.AD_Org_ID as AD_Org_I3_346_, do_m_produ0_.Isactive as Isactive4_346_, do_m_produ0_.Created as Created5_346_, do_m_produ0_.Createdby as Createdb6_346_, do_m_produ0_.Updated as Updated7_346_, do_m_produ0_.Updatedby as Updatedb8_346_, do_m_produ0_.M_Product_ID as M_Produc9_346_, do_m_produ0_.M_Attributesetinstance_ID as M_Attri10_346_, do_m_produ0_.Qtyonhand as Qtyonha11_346_, do_m_produ0_.Qtyorderonhand as Qtyorde12_346_, do_m_produ0_.Preqtyonhand as Preqtyo13_346_, do_m_produ0_.EM_Do_Codiproveedor as EM_Do_C14_346_, do_m_produ0_.Pricelist as Priceli15_346_, do_m_produ0_.Pricestd as Pricest16_346_, do_m_produ0_.Pricelimit as Priceli17_346_, do_m_produ0_.M_Warehouse_ID as M_Wareh18_346_, do_m_produ0_.M_Productprice_ID as M_Produ19_346_, do_m_produ0_.Hasstock as Hasstoc20_346_, do_m_produ0_.Isstocked as Isstock21_346_, do_m_produ0_.M_Locator_ID as M_Locat22_346_, do_m_produ0_.A as A23_346_, do_m_produ0_.QTY_Available as QTY_Ava24_346_, do_m_produ0_.QTY_Onhand as QTY_Onh25_346_, do_m_produ0_.QTY_Reserved as QTY_Res26_346_, do_m_produ0_.QTY_Ordered as QTY_Ord27_346_, do_m_produ0_.Orgwarehouse as Orgware28_346_, do_m_produ0_.Stocktotal as Stockto29_346_, do_m_produ0_.Qtyavaliable as Qtyaval30_346_ from do_m_product_price_warehouse_v do_m_produ0_ left outer join M_Product product1_ on do_m_produ0_.M_Product_ID = product1_.M_Product_ID left outer join M_Warehouse warehouse2_ on do_m_produ0_.M_Warehouse_ID = warehouse2_.M_Warehouse_ID left outer join M_AttributeSetInstance attributes3_ on do_m_produ0_.M_Attributesetinstance_ID = attributes3_.M_AttributeSetInstance_ID cross join M_ProductPrice pricingpro8_ where do_m_produ0_.M_Productprice_ID = pricingpro8_.M_ProductPrice_ID and (upper(warehouse2_.Name) like upper('7610310%') escape '|' or upper(product1_.Value) like upper('7610310%') escape '|' or upper((product1_.Value || ' - ' || coalesce(to_char(( select producttrl4_.Name from M_Product_Trl producttrl4_ where producttrl4_.M_Product_ID = product1_.M_Product_ID and producttrl4_.AD_Language = 'es_ES')), to_char(product1_.Name), '') || ' - ' || coalesce(to_char(product1_.EM_Do_Codiproveedor), '') || ' - ' || coalesce(to_char(product1_.UPC), ''))) like upper('7610310%') escape '|' or do_m_produ0_.Qtyavaliable = '7610310' or upper(attributes3_.Description) like upper('7610310%') escape '|' or upper(do_m_produ0_.EM_Do_Codiproveedor) like upper('7610310%') escape '|' or do_m_produ0_.Stocktotal = '7610310' or upper(product1_.Name) like upper('7610310%') escape '|') and (do_m_produ0_.AD_Org_ID in ('0', 'FF8081812FBA2641012FBA3528033423', 'A15AA70C8D23453DA93ACD1442681D80', 'FF8081812FBA2641012FBA2DCB5E001E', 'D8A3E616E25141988CBE2DC9CD7415EB')) and do_m_produ0_.Isactive = 'Y' and do_m_produ0_.AD_Client_ID = 'FF8081812FBA2641012FBA2AB5D20003' and case when ( select order5_.IsSOTrx from C_Order order5_ where order5_.C_Order_ID = '5EB110A014D947679E1409B0EC463145') = 'Y' then product1_.IsSold else product1_.IsPurchased end = 'Y' and pricingpro8_.M_PriceList_Version_ID = 'FF808181309287D001309309FC030155' and (do_m_produ0_.AD_Client_ID in ('FF8081812FBA2641012FBA2AB5D20003', '0')) and do_m_produ0_.Isactive = 'Y' order by product1_.Name, product1_.M_Product_ID limit '76';

Date: 2026-07-13 08:51:00
Duration: 7s158ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select do_m_produ0_.DO_M_Product_Price_Warehouse_V_ID as DO_M_Pro1_346_, do_m_produ0_.AD_Client_ID as AD_Clien2_346_, do_m_produ0_.AD_Org_ID as AD_Org_I3_346_, do_m_produ0_.Isactive as Isactive4_346_, do_m_produ0_.Created as Created5_346_, do_m_produ0_.Createdby as Createdb6_346_, do_m_produ0_.Updated as Updated7_346_, do_m_produ0_.Updatedby as Updatedb8_346_, do_m_produ0_.M_Product_ID as M_Produc9_346_, do_m_produ0_.M_Attributesetinstance_ID as M_Attri10_346_, do_m_produ0_.Qtyonhand as Qtyonha11_346_, do_m_produ0_.Qtyorderonhand as Qtyorde12_346_, do_m_produ0_.Preqtyonhand as Preqtyo13_346_, do_m_produ0_.EM_Do_Codiproveedor as EM_Do_C14_346_, do_m_produ0_.Pricelist as Priceli15_346_, do_m_produ0_.Pricestd as Pricest16_346_, do_m_produ0_.Pricelimit as Priceli17_346_, do_m_produ0_.M_Warehouse_ID as M_Wareh18_346_, do_m_produ0_.M_Productprice_ID as M_Produ19_346_, do_m_produ0_.Hasstock as Hasstoc20_346_, do_m_produ0_.Isstocked as Isstock21_346_, do_m_produ0_.M_Locator_ID as M_Locat22_346_, do_m_produ0_.A as A23_346_, do_m_produ0_.QTY_Available as QTY_Ava24_346_, do_m_produ0_.QTY_Onhand as QTY_Onh25_346_, do_m_produ0_.QTY_Reserved as QTY_Res26_346_, do_m_produ0_.QTY_Ordered as QTY_Ord27_346_, do_m_produ0_.Orgwarehouse as Orgware28_346_, do_m_produ0_.Stocktotal as Stockto29_346_, do_m_produ0_.Qtyavaliable as Qtyaval30_346_ from do_m_product_price_warehouse_v do_m_produ0_ left outer join M_Product product1_ on do_m_produ0_.M_Product_ID = product1_.M_Product_ID left outer join M_Warehouse warehouse2_ on do_m_produ0_.M_Warehouse_ID = warehouse2_.M_Warehouse_ID left outer join M_AttributeSetInstance attributes3_ on do_m_produ0_.M_Attributesetinstance_ID = attributes3_.M_AttributeSetInstance_ID cross join M_ProductPrice pricingpro8_ where do_m_produ0_.M_Productprice_ID = pricingpro8_.M_ProductPrice_ID and (upper(warehouse2_.Name) like upper('7610%') escape '|' or upper(product1_.Value) like upper('7610%') escape '|' or upper((product1_.Value || ' - ' || coalesce(to_char(( select producttrl4_.Name from M_Product_Trl producttrl4_ where producttrl4_.M_Product_ID = product1_.M_Product_ID and producttrl4_.AD_Language = 'es_ES')), to_char(product1_.Name), '') || ' - ' || coalesce(to_char(product1_.EM_Do_Codiproveedor), '') || ' - ' || coalesce(to_char(product1_.UPC), ''))) like upper('7610%') escape '|' or do_m_produ0_.Qtyavaliable = '7610' or upper(attributes3_.Description) like upper('7610%') escape '|' or upper(do_m_produ0_.EM_Do_Codiproveedor) like upper('7610%') escape '|' or do_m_produ0_.Stocktotal = '7610' or upper(product1_.Name) like upper('7610%') escape '|') and (do_m_produ0_.AD_Org_ID in ('0', 'FF8081812FBA2641012FBA3528033423', 'A15AA70C8D23453DA93ACD1442681D80', 'FF8081812FBA2641012FBA2DCB5E001E', 'D8A3E616E25141988CBE2DC9CD7415EB')) and do_m_produ0_.Isactive = 'Y' and do_m_produ0_.AD_Client_ID = 'FF8081812FBA2641012FBA2AB5D20003' and case when ( select order5_.IsSOTrx from C_Order order5_ where order5_.C_Order_ID = '5EB110A014D947679E1409B0EC463145') = 'Y' then product1_.IsSold else product1_.IsPurchased end = 'Y' and pricingpro8_.M_PriceList_Version_ID = 'FF808181309287D001309309FC030155' and (do_m_produ0_.AD_Client_ID in ('FF8081812FBA2641012FBA2AB5D20003', '0')) and do_m_produ0_.Isactive = 'Y' order by product1_.Name, product1_.M_Product_ID limit '76';

Date: 2026-07-13 08:50:59
Duration: 7s142ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

SELECT fin_payment.created, c_invoice.dateinvoiced as "dataFactura", c_invoice.documentno as "numFactura", fin_paymentmethod.name as "tipoCobro", c_bpartner.value as "valuePartner", c_bpartner.name as "namePartner", max(FIN_Payment_Sched_Inv_V.duedate) as "fechaVencimiento", c_invoice.grandtotal as "total", c_invoice.totalpaid as "totalPagado", case when count(*) = 1 then 'A' when count(*) = 2 then 'B' when count(*) = 3 then 'C' else '-' END as "rebut", c_invoice.ispaid as "pagado", ad_sequence.prefix as "prefijo", sum(fin_payment_detail_v.Paidamt) as "paidamt", fin_payment_detail_v.Paymentdate from c_invoice LEFT JOIN FIN_Payment_Sched_Inv_V ON FIN_Payment_Sched_Inv_V.c_invoice_id = c_invoice.c_invoice_id left join c_bpartner on c_bpartner.c_bpartner_id = c_invoice.c_bpartner_id left join c_doctype on c_doctype.c_doctype_id = c_invoice.c_doctype_id left join ad_sequence on ad_sequence.ad_sequence_id = c_doctype.docnosequence_id left join fin_payment_detail_v on fin_payment_detail_v.fin_payment_sched_inv_id = fin_payment_sched_inv_V.fin_payment_sched_inv_v_id left join fin_paymentmethod on fin_paymentmethod.fin_paymentmethod_id = fin_payment_detail_v.fin_paymentmethod_id left join fin_payment on fin_payment.fin_payment_id = fin_payment_detail_v.fin_payment_id where isreceipt = 'Y' and c_invoice.ad_client_id = $1 and c_invoice.ad_org_id in ('FF8081812FBA2641012FBA3528033423', 'FF8081812FBA2641012FBA2DCB5E001E', 'A15AA70C8D23453DA93ACD1442681D80') and to_date(to_char(fin_payment.created, 'dd-mm-yyyy'), 'dd-mm-yyyy') <= to_date('10-07-2026', 'dd-mm-yyyy') and to_date(to_char(fin_payment.created, 'dd-mm-yyyy'), 'dd-mm-yyyy') >= to_date('10-07-2026', 'dd-mm-yyyy') and c_doctype.name != 'Factura D' and c_doctype.name != 'Factura N' group by c_invoice.dateinvoiced, c_invoice.documentno, fin_paymentmethod.name, c_bpartner.value, c_bpartner.name, c_invoice.grandtotal, c_invoice.totalpaid, c_invoice.ispaid, ad_sequence.prefix, fin_payment_detail_v.Paymentdate, fin_payment.created order by ad_sequence.prefix, c_invoice.dateinvoiced, c_invoice.documentno;

Date: 2026-07-13 07:12:39
Duration: 0ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

SELECT fin_payment.created, c_invoice.dateinvoiced as "dataFactura", c_invoice.documentno as "numFactura", fin_paymentmethod.name as "tipoCobro", c_bpartner.value as "valuePartner", c_bpartner.name as "namePartner", max(FIN_Payment_Sched_Inv_V.duedate) as "fechaVencimiento", c_invoice.grandtotal as "total", c_invoice.totalpaid as "totalPagado", case when count(*) = 1 then 'A' when count(*) = 2 then 'B' when count(*) = 3 then 'C' else '-' END as "rebut", c_invoice.ispaid as "pagado", ad_sequence.prefix as "prefijo", sum(fin_payment_detail_v.Paidamt) as "paidamt", fin_payment_detail_v.Paymentdate from c_invoice LEFT JOIN FIN_Payment_Sched_Inv_V ON FIN_Payment_Sched_Inv_V.c_invoice_id = c_invoice.c_invoice_id left join c_bpartner on c_bpartner.c_bpartner_id = c_invoice.c_bpartner_id left join c_doctype on c_doctype.c_doctype_id = c_invoice.c_doctype_id left join ad_sequence on ad_sequence.ad_sequence_id = c_doctype.docnosequence_id left join fin_payment_detail_v on fin_payment_detail_v.fin_payment_sched_inv_id = fin_payment_sched_inv_V.fin_payment_sched_inv_v_id left join fin_paymentmethod on fin_paymentmethod.fin_paymentmethod_id = fin_payment_detail_v.fin_paymentmethod_id left join fin_payment on fin_payment.fin_payment_id = fin_payment_detail_v.fin_payment_id where 1 = 1 --and isreceipt='Y' and c_invoice.ad_client_id = $1 and c_invoice.ad_org_id in ('FF8081813510684B01354402F76B59F3') and to_date(to_char(fin_payment.created, 'dd-mm-yyyy'), 'dd-mm-yyyy') <= to_date('10-07-2026', 'dd-mm-yyyy') and to_date(to_char(fin_payment.created, 'dd-mm-yyyy'), 'dd-mm-yyyy') >= to_date('10-07-2026', 'dd-mm-yyyy') and (c_doctype.name = 'Factura D' or c_doctype.name = 'Factura N' or c_doctype.name = 'Factura P3D' or c_doctype.name = 'Factura P3N' or c_doctype.name = 'Factura Compra') group by c_invoice.dateinvoiced, c_invoice.documentno, fin_paymentmethod.name, c_bpartner.value, c_bpartner.name, c_invoice.grandtotal, c_invoice.totalpaid, c_invoice.ispaid, ad_sequence.prefix, fin_payment_detail_v.Paymentdate, fin_payment.created order by ad_sequence.prefix, c_invoice.dateinvoiced, c_invoice.documentno;

Date: 2026-07-13 07:12:42
Duration: 0ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

select documentty0_.C_DocType_ID as C_DocTyp1_224_, documentty0_.AD_Client_ID as AD_Clien2_224_, documentty0_.AD_Org_ID as AD_Org_I3_224_, documentty0_.IsActive as IsActive4_224_, documentty0_.Created as Created5_224_, documentty0_.CreatedBy as CreatedB6_224_, documentty0_.Updated as Updated7_224_, documentty0_.UpdatedBy as UpdatedB8_224_, documentty0_.Name as Name9_224_, documentty0_.PrintName as PrintNa10_224_, documentty0_.Description as Descrip11_224_, documentty0_.DocBaseType as DocBase12_224_, documentty0_.IsSOTrx as IsSOTrx13_224_, documentty0_.DocSubTypeSO as DocSubT14_224_, documentty0_.C_DocTypeShipment_ID as C_DocTy15_224_, documentty0_.C_DocTypeInvoice_ID as C_DocTy16_224_, documentty0_.IsDocNoControlled as IsDocNo17_224_, documentty0_.DocNoSequence_ID as DocNoSe18_224_, documentty0_.GL_Category_ID as GL_Cate19_224_, documentty0_.DocumentNote as Documen20_224_, documentty0_.IsDefault as IsDefau21_224_, documentty0_.DocumentCopies as Documen22_224_, documentty0_.AD_Table_ID as AD_Tabl23_224_, documentty0_.Orgfiltered as Orgfilt24_224_, documentty0_.C_Doctype_Reversed_ID as C_Docty25_224_, documentty0_.EM_Intr_Transaction_Type as EM_Intr26_224_, documentty0_.IsExpense as IsExpen27_224_, documentty0_.EM_Intr_Statistical_Regime as EM_Intr28_224_, documentty0_.Isreversal as Isrever29_224_, documentty0_.IsReturn as IsRetur30_224_, documentty0_.C_Doctypeorder_ID as C_Docty31_224_, documentty0_.C_Doctypesimpinvoice_ID as C_Docty32_224_, documentty0_.EM_Do_Ventaindirecta as EM_Do_V33_224_, documentty0_.EM_OBWPL_Useoutbound as EM_OBWP34_224_, documentty0_.EM_Prouti_C_Doctypeorder_ID as EM_Prou35_224_, documentty0_.C_Doctypeaggrinvoice_ID as C_Docty36_224_, documentty0_.EM_Do_Controlmedioenvio as EM_Do_C37_224_, documentty0_.EM_OBWPL_IsGroup as EM_OBWP38_224_, documentty0_.EM_Do_Usrcontrol as EM_Do_U39_224_, documentty0_.EM_OBWPL_GenerateShipment as EM_OBWP40_224_, documentty0_.EM_Do_Image_ID as EM_Do_I41_224_, documentty0_.EM_OBWPL_Shipmentdoctype_ID as EM_OBWP42_224_, documentty0_.EM_Prsii_Clave_Tipo as EM_Prsi43_224_, documentty0_.EM_Prsii_Clave_Tipo_Fc as EM_Prsi44_224_, documentty0_.EM_Do_Generar_Ldm_Aut as EM_Do_G45_224_, documentty0_.EM_Prsii_Motivo_Rectif as EM_Prsi46_224_, documentty0_.EM_Prsii_Tipo_Rectif as EM_Prsi47_224_, documentty0_.EM_Pruti_Inforeport2 as EM_Prut48_224_, documentty0_.EM_Pruti_Inforeport as EM_Prut49_224_, documentty0_.EM_Prsii_Forzar_Clave_Tipo as EM_Prsi50_224_ from C_DocType documentty0_ where exists ( select 1 from C_Order order1_ inner join C_DocType documentty2_ on order1_.C_DocTypeTarget_ID = documentty2_.C_DocType_ID where (upper(coalesce(to_char(( select documentty3_.Name from C_DocType_Trl documentty3_ where documentty3_.C_DocType_ID = order1_.C_DocTypeTarget_ID and documentty3_.AD_Language = 'es_ES')), to_char(documentty2_.Name), '')) like upper($1) escape '|') and order1_.IsSOTrx = 'Y' and documentty2_.IsReturn = 'N' and (documentty2_.DocSubTypeSO not like 'OB') and documentty2_.C_DocType_ID = documentty0_.C_DocType_ID and (order1_.AD_Org_ID in ('0', 'FF8081812FBA2641012FBA3528033423', 'A15AA70C8D23453DA93ACD1442681D80', 'FF8081812FBA2641012FBA2DCB5E001E', 'D8A3E616E25141988CBE2DC9CD7415EB')) and (order1_.AD_Client_ID in ('FF8081812FBA2641012FBA2AB5D20003', '0'))) order by documentty0_.Name limit $2;

Date: 2026-07-13 09:59:33
Duration: 0ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

update C_Order set Updated = $1, TotalLines = $2, GrandTotal = $3, EM_Do_Albaranvalorado = $4, EM_Prouti_Grandtotalinitial = $5, EM_Prouti_Totallinesinitial = $6 where C_Order_ID = $7;

Date: 2026-07-13 09:23:14
Duration: 0ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

insert into C_Order (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, IsSOTrx, DocumentNo, DocStatus, DocAction, Processing, Processed, C_DocType_ID, C_DocTypeTarget_ID, IsDelivered, IsInvoiced, IsPrinted, IsSelected, DateOrdered, DatePromised, DateAcct, C_BPartner_ID, BillTo_ID, C_BPartner_Location_ID, IsDiscountPrinted, C_Currency_ID, PaymentRule, C_PaymentTerm_ID, InvoiceRule, DeliveryRule, FreightCostRule, FreightAmt, DeliveryViaRule, ChargeAmt, PriorityRule, TotalLines, GrandTotal, M_Warehouse_ID, M_PriceList_ID, IsTaxIncluded, Posted, CopyFrom, IsSelfService, Generatetemplate, Delivery_Location_ID, CopyFromPO, FIN_Paymentmethod_ID, RM_PickFromShipment, RM_ReceiveMaterials, RM_CreateInvoice, RM_AddOrphanLine, Calculate_Promotions, Convertquotation, Create_POLines, Iscashvat, RM_Pickfromreceipt, Cancelandreplace, EM_APRM_AddPayment, EM_Obwpl_Generatepicking, EM_Obwpl_Isinpickinglist, EM_Obwpl_Readypl, Confirmcancelandreplace, Iscancelled, EM_Do_Portes, EM_Do_Albaranvalorado, EM_Prouti_Order_Stock, EM_Prouti_Pregenerate_Minout, EM_Prouti_Sotopo, EM_Do_Entregado, EM_Prouti_Generate_Pick_Inv, EM_Do_Esinterno, EM_Do_Aceptaprecios, EM_Do_Preparado, EM_Prouti_Changebpartner, EM_Prouti_Recalculate_Price, EM_Do_Createinout, EM_Prouti_Reactiveorder, EM_Do_Inoutdone, em_prouti_Invoiced, EM_Do_Tercerocontado, em_prouti_Received, EM_Do_Crearpedidooferta, EM_Pbsp_Sigcaptured, em_prouti_initial_received, EM_Do_Mediosenvio_ID, EM_Do_Cierrepedido, em_do_validate_usr_processing, EM_Do_Issended, EM_Do_Resend, EM_Prouti_Status_Of_Review, EM_Prouti_Validate_Order, EM_Prouti_Start_Review, EM_Pr592_Exclude_Tax, C_Order_ID) values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95);

Date: 2026-07-13 09:37:50
Duration: 0ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide