SELECT * FROM OV_CALOCUPACION ($1);

Date: 2026-07-16 07:20:28
Duration: 0ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

select ov_balance0_.OV_Balanceinterno_V_ID as ov_balan1_874_, ov_balance0_.Created as created2_874_, ov_balance0_.Createdby as createdb3_874_, ov_balance0_.Updated as updated4_874_, ov_balance0_.Updatedby as updatedb5_874_, ov_balance0_.Isactive as isactive6_874_, ov_balance0_.AD_Client_ID as ad_clien7_874_, ov_balance0_.AD_Org_ID as ad_org_i8_874_, ov_balance0_.Total_Compra as total_co9_874_, ov_balance0_.Total_Compra1 as total_c10_874_, ov_balance0_.DTO_Compra as dto_com11_874_, ov_balance0_.Precio_Venta as precio_12_874_, ov_balance0_.DTO_Pago as dto_pag13_874_, ov_balance0_.Precio_Tarifa as precio_14_874_, ov_balance0_.Extras_Venta as extras_15_874_, ov_balance0_.Limpieza as limpiez16_874_, ov_balance0_.Extras_Compra as extras_17_874_, ov_balance0_.Dto as dto18_874_, ov_balance0_.Precio_Venta2 as precio_19_874_, ov_balance0_.Precio_Venta_Final as precio_20_874_, ov_balance0_.Resto1 as resto21_874_, ov_balance0_.Resto2 as resto22_874_, ov_balance0_.Resto_Neto as resto_n23_874_, ov_balance0_.Comision as comisio24_874_, ov_balance0_.Comision_To as comisio25_874_, ov_balance0_.Gasto_Actuaciones as gasto_a26_874_, ov_balance0_.Obre_Resource_ID as obre_re27_874_, ov_balance0_.C_Project_ID as c_proje28_874_, ov_balance0_.Calendario as calenda29_874_, ov_balance0_.Year as year30_874_, ov_balance0_.POR_Dto as por_dto31_874_, ov_balance0_.POR_Venta2 as por_ven32_874_, ov_balance0_.POR_To as por_to33_874_, ov_balance0_.POR_Agencia as por_age34_874_, ov_balance0_.POR_Venta_Final as por_ven35_874_, ov_balance0_.POR_Compra1 as por_com36_874_, ov_balance0_.POR_Resto1 as por_res37_874_, ov_balance0_.POR_Dto_Compra as por_dto38_874_, ov_balance0_.POR_Total_Compra as por_tot39_874_, ov_balance0_.POR_Resto2 as por_res40_874_, ov_balance0_.POR_Resto_Neto as por_res41_874_, ov_balance0_.Oferta as oferta42_874_, ov_balance0_.Lm as lm43_874_, ov_balance0_.Varios as varios44_874_, ov_balance0_.Early as early45_874_, ov_balance0_.DTO_Pc as dto_pc46_874_, ov_balance0_.Otros as otros47_874_, ov_balance0_.Aire as aire48_874_, ov_balance0_.Calefaccion as calefac49_874_, ov_balance0_.Cuna as cuna50_874_, ov_balance0_.Silla as silla51_874_, ov_balance0_.Cama as cama52_874_, ov_balance0_.Late as late53_874_, ov_balance0_.Mascotas as mascota54_874_, ov_balance0_.Anulacion as anulaci55_874_, ov_balance0_.Contract_Type_ID as contrac56_874_, ov_balance0_.Garantia as garanti57_874_, ov_balance0_.Calefaccion_Compra as calefac58_874_, ov_balance0_.Aire_Compra as aire_co59_874_, ov_balance0_.Gastosadmin as gastosa60_874_, ov_balance0_.Gastosadmin_Compra as gastosa61_874_, ov_balance0_.Flexible as flexibl62_874_, ov_balance0_.Flexible_Compra as flexibl63_874_, ov_balance0_.Seguridad as segurid64_874_, ov_balance0_.Seguridad_Compra as segurid65_874_, ov_balance0_.POR_Calefaccion as por_cal66_874_, ov_balance0_.POR_Aire as por_air67_874_, ov_balance0_.Portarifa as portari68_874_, ov_balance0_.Aumentotarifa as aumento69_874_, ov_balance0_.Anyo as anyo70_874_, ov_balance0_.Tarifa_Agencia as tarifa_71_874_, ov_balance0_.Precio_Venta0 as precio_72_874_, ov_balance0_.DTO_Oferta as dto_ofe73_874_, ov_balance0_.Ajuste_Abahana as ajuste_74_874_, ov_balance0_.POR_Dto_Oferta as por_dto75_874_, ov_balance0_.POR_Ajuste_Oferta as por_aju76_874_, ov_balance0_.Resto0 as resto77_874_, ov_balance0_.POR_Resto0 as por_res78_874_, ov_balance0_.Resto_Final as resto_f79_874_, ov_balance0_.POR_Resto_Final as por_res80_874_ from ov_balanceinterno_v ov_balance0_ cross join OBRE_Resource obre_resou1_ where ov_balance0_.Obre_Resource_ID = obre_resou1_.Obre_Resource_ID and (upper(obre_resou1_.Name) like upper('%olimpia%') escape '|') and (ov_balance0_.AD_Org_ID in ('0', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '5847CA8D7F684511BBD9AB15187E28BF', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_balance0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) order by ov_balance0_.Year desc, ov_balance0_.OV_Balanceinterno_V_ID desc limit '101';

Date: 2026-07-16 08:30:53
Duration: 3s691ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select ov_balance0_.OV_Balanceinterno_V_ID as ov_balan1_874_, ov_balance0_.Created as created2_874_, ov_balance0_.Createdby as createdb3_874_, ov_balance0_.Updated as updated4_874_, ov_balance0_.Updatedby as updatedb5_874_, ov_balance0_.Isactive as isactive6_874_, ov_balance0_.AD_Client_ID as ad_clien7_874_, ov_balance0_.AD_Org_ID as ad_org_i8_874_, ov_balance0_.Total_Compra as total_co9_874_, ov_balance0_.Total_Compra1 as total_c10_874_, ov_balance0_.DTO_Compra as dto_com11_874_, ov_balance0_.Precio_Venta as precio_12_874_, ov_balance0_.DTO_Pago as dto_pag13_874_, ov_balance0_.Precio_Tarifa as precio_14_874_, ov_balance0_.Extras_Venta as extras_15_874_, ov_balance0_.Limpieza as limpiez16_874_, ov_balance0_.Extras_Compra as extras_17_874_, ov_balance0_.Dto as dto18_874_, ov_balance0_.Precio_Venta2 as precio_19_874_, ov_balance0_.Precio_Venta_Final as precio_20_874_, ov_balance0_.Resto1 as resto21_874_, ov_balance0_.Resto2 as resto22_874_, ov_balance0_.Resto_Neto as resto_n23_874_, ov_balance0_.Comision as comisio24_874_, ov_balance0_.Comision_To as comisio25_874_, ov_balance0_.Gasto_Actuaciones as gasto_a26_874_, ov_balance0_.Obre_Resource_ID as obre_re27_874_, ov_balance0_.C_Project_ID as c_proje28_874_, ov_balance0_.Calendario as calenda29_874_, ov_balance0_.Year as year30_874_, ov_balance0_.POR_Dto as por_dto31_874_, ov_balance0_.POR_Venta2 as por_ven32_874_, ov_balance0_.POR_To as por_to33_874_, ov_balance0_.POR_Agencia as por_age34_874_, ov_balance0_.POR_Venta_Final as por_ven35_874_, ov_balance0_.POR_Compra1 as por_com36_874_, ov_balance0_.POR_Resto1 as por_res37_874_, ov_balance0_.POR_Dto_Compra as por_dto38_874_, ov_balance0_.POR_Total_Compra as por_tot39_874_, ov_balance0_.POR_Resto2 as por_res40_874_, ov_balance0_.POR_Resto_Neto as por_res41_874_, ov_balance0_.Oferta as oferta42_874_, ov_balance0_.Lm as lm43_874_, ov_balance0_.Varios as varios44_874_, ov_balance0_.Early as early45_874_, ov_balance0_.DTO_Pc as dto_pc46_874_, ov_balance0_.Otros as otros47_874_, ov_balance0_.Aire as aire48_874_, ov_balance0_.Calefaccion as calefac49_874_, ov_balance0_.Cuna as cuna50_874_, ov_balance0_.Silla as silla51_874_, ov_balance0_.Cama as cama52_874_, ov_balance0_.Late as late53_874_, ov_balance0_.Mascotas as mascota54_874_, ov_balance0_.Anulacion as anulaci55_874_, ov_balance0_.Contract_Type_ID as contrac56_874_, ov_balance0_.Garantia as garanti57_874_, ov_balance0_.Calefaccion_Compra as calefac58_874_, ov_balance0_.Aire_Compra as aire_co59_874_, ov_balance0_.Gastosadmin as gastosa60_874_, ov_balance0_.Gastosadmin_Compra as gastosa61_874_, ov_balance0_.Flexible as flexibl62_874_, ov_balance0_.Flexible_Compra as flexibl63_874_, ov_balance0_.Seguridad as segurid64_874_, ov_balance0_.Seguridad_Compra as segurid65_874_, ov_balance0_.POR_Calefaccion as por_cal66_874_, ov_balance0_.POR_Aire as por_air67_874_, ov_balance0_.Portarifa as portari68_874_, ov_balance0_.Aumentotarifa as aumento69_874_, ov_balance0_.Anyo as anyo70_874_, ov_balance0_.Tarifa_Agencia as tarifa_71_874_, ov_balance0_.Precio_Venta0 as precio_72_874_, ov_balance0_.DTO_Oferta as dto_ofe73_874_, ov_balance0_.Ajuste_Abahana as ajuste_74_874_, ov_balance0_.POR_Dto_Oferta as por_dto75_874_, ov_balance0_.POR_Ajuste_Oferta as por_aju76_874_, ov_balance0_.Resto0 as resto77_874_, ov_balance0_.POR_Resto0 as por_res78_874_, ov_balance0_.Resto_Final as resto_f79_874_, ov_balance0_.POR_Resto_Final as por_res80_874_ from ov_balanceinterno_v ov_balance0_ cross join OBRE_Resource obre_resou1_ where ov_balance0_.Obre_Resource_ID = obre_resou1_.Obre_Resource_ID and (upper(obre_resou1_.Name) like upper('%dauphin%') escape '|') and (ov_balance0_.AD_Org_ID in ('0', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '5847CA8D7F684511BBD9AB15187E28BF', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_balance0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) order by ov_balance0_.Year desc, ov_balance0_.OV_Balanceinterno_V_ID desc limit '101';

Date: 2026-07-16 09:37:41
Duration: 3s670ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select ov_balance0_.OV_Balanceinterno_V_ID as ov_balan1_874_, ov_balance0_.Created as created2_874_, ov_balance0_.Createdby as createdb3_874_, ov_balance0_.Updated as updated4_874_, ov_balance0_.Updatedby as updatedb5_874_, ov_balance0_.Isactive as isactive6_874_, ov_balance0_.AD_Client_ID as ad_clien7_874_, ov_balance0_.AD_Org_ID as ad_org_i8_874_, ov_balance0_.Total_Compra as total_co9_874_, ov_balance0_.Total_Compra1 as total_c10_874_, ov_balance0_.DTO_Compra as dto_com11_874_, ov_balance0_.Precio_Venta as precio_12_874_, ov_balance0_.DTO_Pago as dto_pag13_874_, ov_balance0_.Precio_Tarifa as precio_14_874_, ov_balance0_.Extras_Venta as extras_15_874_, ov_balance0_.Limpieza as limpiez16_874_, ov_balance0_.Extras_Compra as extras_17_874_, ov_balance0_.Dto as dto18_874_, ov_balance0_.Precio_Venta2 as precio_19_874_, ov_balance0_.Precio_Venta_Final as precio_20_874_, ov_balance0_.Resto1 as resto21_874_, ov_balance0_.Resto2 as resto22_874_, ov_balance0_.Resto_Neto as resto_n23_874_, ov_balance0_.Comision as comisio24_874_, ov_balance0_.Comision_To as comisio25_874_, ov_balance0_.Gasto_Actuaciones as gasto_a26_874_, ov_balance0_.Obre_Resource_ID as obre_re27_874_, ov_balance0_.C_Project_ID as c_proje28_874_, ov_balance0_.Calendario as calenda29_874_, ov_balance0_.Year as year30_874_, ov_balance0_.POR_Dto as por_dto31_874_, ov_balance0_.POR_Venta2 as por_ven32_874_, ov_balance0_.POR_To as por_to33_874_, ov_balance0_.POR_Agencia as por_age34_874_, ov_balance0_.POR_Venta_Final as por_ven35_874_, ov_balance0_.POR_Compra1 as por_com36_874_, ov_balance0_.POR_Resto1 as por_res37_874_, ov_balance0_.POR_Dto_Compra as por_dto38_874_, ov_balance0_.POR_Total_Compra as por_tot39_874_, ov_balance0_.POR_Resto2 as por_res40_874_, ov_balance0_.POR_Resto_Neto as por_res41_874_, ov_balance0_.Oferta as oferta42_874_, ov_balance0_.Lm as lm43_874_, ov_balance0_.Varios as varios44_874_, ov_balance0_.Early as early45_874_, ov_balance0_.DTO_Pc as dto_pc46_874_, ov_balance0_.Otros as otros47_874_, ov_balance0_.Aire as aire48_874_, ov_balance0_.Calefaccion as calefac49_874_, ov_balance0_.Cuna as cuna50_874_, ov_balance0_.Silla as silla51_874_, ov_balance0_.Cama as cama52_874_, ov_balance0_.Late as late53_874_, ov_balance0_.Mascotas as mascota54_874_, ov_balance0_.Anulacion as anulaci55_874_, ov_balance0_.Contract_Type_ID as contrac56_874_, ov_balance0_.Garantia as garanti57_874_, ov_balance0_.Calefaccion_Compra as calefac58_874_, ov_balance0_.Aire_Compra as aire_co59_874_, ov_balance0_.Gastosadmin as gastosa60_874_, ov_balance0_.Gastosadmin_Compra as gastosa61_874_, ov_balance0_.Flexible as flexibl62_874_, ov_balance0_.Flexible_Compra as flexibl63_874_, ov_balance0_.Seguridad as segurid64_874_, ov_balance0_.Seguridad_Compra as segurid65_874_, ov_balance0_.POR_Calefaccion as por_cal66_874_, ov_balance0_.POR_Aire as por_air67_874_, ov_balance0_.Portarifa as portari68_874_, ov_balance0_.Aumentotarifa as aumento69_874_, ov_balance0_.Anyo as anyo70_874_, ov_balance0_.Tarifa_Agencia as tarifa_71_874_, ov_balance0_.Precio_Venta0 as precio_72_874_, ov_balance0_.DTO_Oferta as dto_ofe73_874_, ov_balance0_.Ajuste_Abahana as ajuste_74_874_, ov_balance0_.POR_Dto_Oferta as por_dto75_874_, ov_balance0_.POR_Ajuste_Oferta as por_aju76_874_, ov_balance0_.Resto0 as resto77_874_, ov_balance0_.POR_Resto0 as por_res78_874_, ov_balance0_.Resto_Final as resto_f79_874_, ov_balance0_.POR_Resto_Final as por_res80_874_ from ov_balanceinterno_v ov_balance0_ cross join OBRE_Resource obre_resou1_ where ov_balance0_.Obre_Resource_ID = obre_resou1_.Obre_Resource_ID and (upper(obre_resou1_.Name) like upper('%olimpia%') escape '|') and (ov_balance0_.AD_Org_ID in ('0', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '5847CA8D7F684511BBD9AB15187E28BF', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_balance0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) order by ov_balance0_.Year desc, ov_balance0_.OV_Balanceinterno_V_ID desc limit '101';

Date: 2026-07-16 08:30:55
Duration: 2s982ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

SELECT * FROM OV_CALOFERTAS ($1);

Date: 2026-07-16 14:22:41
Duration: 0ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

select ov_balance0_.OV_Balanceinterno_V_ID as ov_balan1_874_, ov_balance0_.Created as created2_874_, ov_balance0_.Createdby as createdb3_874_, ov_balance0_.Updated as updated4_874_, ov_balance0_.Updatedby as updatedb5_874_, ov_balance0_.Isactive as isactive6_874_, ov_balance0_.AD_Client_ID as ad_clien7_874_, ov_balance0_.AD_Org_ID as ad_org_i8_874_, ov_balance0_.Total_Compra as total_co9_874_, ov_balance0_.Total_Compra1 as total_c10_874_, ov_balance0_.DTO_Compra as dto_com11_874_, ov_balance0_.Precio_Venta as precio_12_874_, ov_balance0_.DTO_Pago as dto_pag13_874_, ov_balance0_.Precio_Tarifa as precio_14_874_, ov_balance0_.Extras_Venta as extras_15_874_, ov_balance0_.Limpieza as limpiez16_874_, ov_balance0_.Extras_Compra as extras_17_874_, ov_balance0_.Dto as dto18_874_, ov_balance0_.Precio_Venta2 as precio_19_874_, ov_balance0_.Precio_Venta_Final as precio_20_874_, ov_balance0_.Resto1 as resto21_874_, ov_balance0_.Resto2 as resto22_874_, ov_balance0_.Resto_Neto as resto_n23_874_, ov_balance0_.Comision as comisio24_874_, ov_balance0_.Comision_To as comisio25_874_, ov_balance0_.Gasto_Actuaciones as gasto_a26_874_, ov_balance0_.Obre_Resource_ID as obre_re27_874_, ov_balance0_.C_Project_ID as c_proje28_874_, ov_balance0_.Calendario as calenda29_874_, ov_balance0_.Year as year30_874_, ov_balance0_.POR_Dto as por_dto31_874_, ov_balance0_.POR_Venta2 as por_ven32_874_, ov_balance0_.POR_To as por_to33_874_, ov_balance0_.POR_Agencia as por_age34_874_, ov_balance0_.POR_Venta_Final as por_ven35_874_, ov_balance0_.POR_Compra1 as por_com36_874_, ov_balance0_.POR_Resto1 as por_res37_874_, ov_balance0_.POR_Dto_Compra as por_dto38_874_, ov_balance0_.POR_Total_Compra as por_tot39_874_, ov_balance0_.POR_Resto2 as por_res40_874_, ov_balance0_.POR_Resto_Neto as por_res41_874_, ov_balance0_.Oferta as oferta42_874_, ov_balance0_.Lm as lm43_874_, ov_balance0_.Varios as varios44_874_, ov_balance0_.Early as early45_874_, ov_balance0_.DTO_Pc as dto_pc46_874_, ov_balance0_.Otros as otros47_874_, ov_balance0_.Aire as aire48_874_, ov_balance0_.Calefaccion as calefac49_874_, ov_balance0_.Cuna as cuna50_874_, ov_balance0_.Silla as silla51_874_, ov_balance0_.Cama as cama52_874_, ov_balance0_.Late as late53_874_, ov_balance0_.Mascotas as mascota54_874_, ov_balance0_.Anulacion as anulaci55_874_, ov_balance0_.Contract_Type_ID as contrac56_874_, ov_balance0_.Garantia as garanti57_874_, ov_balance0_.Calefaccion_Compra as calefac58_874_, ov_balance0_.Aire_Compra as aire_co59_874_, ov_balance0_.Gastosadmin as gastosa60_874_, ov_balance0_.Gastosadmin_Compra as gastosa61_874_, ov_balance0_.Flexible as flexibl62_874_, ov_balance0_.Flexible_Compra as flexibl63_874_, ov_balance0_.Seguridad as segurid64_874_, ov_balance0_.Seguridad_Compra as segurid65_874_, ov_balance0_.POR_Calefaccion as por_cal66_874_, ov_balance0_.POR_Aire as por_air67_874_, ov_balance0_.Portarifa as portari68_874_, ov_balance0_.Aumentotarifa as aumento69_874_, ov_balance0_.Anyo as anyo70_874_, ov_balance0_.Tarifa_Agencia as tarifa_71_874_, ov_balance0_.Precio_Venta0 as precio_72_874_, ov_balance0_.DTO_Oferta as dto_ofe73_874_, ov_balance0_.Ajuste_Abahana as ajuste_74_874_, ov_balance0_.POR_Dto_Oferta as por_dto75_874_, ov_balance0_.POR_Ajuste_Oferta as por_aju76_874_, ov_balance0_.Resto0 as resto77_874_, ov_balance0_.POR_Resto0 as por_res78_874_, ov_balance0_.Resto_Final as resto_f79_874_, ov_balance0_.POR_Resto_Final as por_res80_874_ from ov_balanceinterno_v ov_balance0_ left outer join OBRE_Resource obre_resou1_ on ov_balance0_.Obre_Resource_ID = obre_resou1_.Obre_Resource_ID where (upper(obre_resou1_.Name) like upper('%olimpia%') escape '|') and (ov_balance0_.AD_Org_ID in ('0', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '5847CA8D7F684511BBD9AB15187E28BF', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (ov_balance0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) order by obre_resou1_.Name, ov_balance0_.OV_Balanceinterno_V_ID limit '101';

Date: 2026-07-16 08:30:51
Duration: 3s641ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

select order0_.C_Order_ID as c_order_1_263_, order0_.AD_Client_ID as ad_clien2_263_, order0_.AD_Org_ID as ad_org_i3_263_, order0_.IsActive as isactive4_263_, order0_.Created as created5_263_, order0_.CreatedBy as createdb6_263_, order0_.Updated as updated7_263_, order0_.UpdatedBy as updatedb8_263_, order0_.IsSOTrx as issotrx9_263_, order0_.DocumentNo as documen10_263_, order0_.DocStatus as docstat11_263_, order0_.DocAction as docacti12_263_, order0_.Processing as process13_263_, order0_.Processed as process14_263_, order0_.C_DocType_ID as c_docty15_263_, order0_.C_DocTypeTarget_ID as c_docty16_263_, order0_.Description as descrip17_263_, order0_.IsDelivered as isdeliv18_263_, order0_.IsInvoiced as isinvoi19_263_, order0_.IsPrinted as isprint20_263_, order0_.IsSelected as isselec21_263_, order0_.SalesRep_ID as salesre22_263_, order0_.DateOrdered as dateord23_263_, order0_.DatePromised as datepro24_263_, order0_.DatePrinted as datepri25_263_, order0_.DateAcct as dateacc26_263_, order0_.C_BPartner_ID as c_bpart27_263_, order0_.BillTo_ID as billto_28_263_, order0_.C_BPartner_Location_ID as c_bpart29_263_, order0_.POReference as porefer30_263_, order0_.IsDiscountPrinted as isdisco31_263_, order0_.C_Currency_ID as c_curre32_263_, order0_.PaymentRule as payment33_263_, order0_.C_PaymentTerm_ID as c_payme34_263_, order0_.InvoiceRule as invoice35_263_, order0_.DeliveryRule as deliver36_263_, order0_.FreightCostRule as freight37_263_, order0_.FreightAmt as freight38_263_, order0_.DeliveryViaRule as deliver39_263_, order0_.M_Shipper_ID as m_shipp40_263_, order0_.C_Charge_ID as c_charg41_263_, order0_.ChargeAmt as chargea42_263_, order0_.PriorityRule as priorit43_263_, order0_.TotalLines as totalli44_263_, order0_.GrandTotal as grandto45_263_, order0_.M_Warehouse_ID as m_wareh46_263_, order0_.M_PriceList_ID as m_price47_263_, order0_.IsTaxIncluded as istaxin48_263_, order0_.C_Campaign_ID as c_campa49_263_, order0_.C_Project_ID as c_proje50_263_, order0_.C_Activity_ID as c_activ51_263_, order0_.Posted as posted52_263_, order0_.AD_User_ID as ad_user53_263_, order0_.CopyFrom as copyfro54_263_, order0_.DropShip_BPartner_ID as dropshi55_263_, order0_.DropShip_Location_ID as dropshi56_263_, order0_.DropShip_User_ID as dropshi57_263_, order0_.IsSelfService as isselfs58_263_, order0_.AD_OrgTrx_ID as ad_orgt59_263_, order0_.User1_ID as user60_263_, order0_.User2_ID as user61_263_, order0_.Deliverynotes as deliver62_263_, order0_.C_Incoterms_ID as c_incot63_263_, order0_.Incotermsdescription as incoter64_263_, order0_.Generatetemplate as generat65_263_, order0_.Delivery_Location_ID as deliver66_263_, order0_.CopyFromPO as copyfro67_263_, order0_.FIN_Paymentmethod_ID as fin_pay68_263_, order0_.FIN_Payment_Priority_ID as fin_pay69_263_, order0_.RM_PickFromShipment as rm_pick70_263_, order0_.RM_ReceiveMaterials as rm_rece71_263_, order0_.EM_Obcma_C_Poc_Email_ID as em_obcm72_263_, order0_.RM_CreateInvoice as rm_crea73_263_, order0_.C_Return_Reason_ID as c_retur74_263_, order0_.RM_AddOrphanLine as rm_addo75_263_, order0_.A_Asset_ID as a_asset76_263_, order0_.EM_OBSCNTR_Billing_Group_ID as em_obsc77_263_, order0_.Calculate_Promotions as calcula78_263_, order0_.EM_OBSCNTR_Processorder as em_obsc79_263_, order0_.C_Costcenter_ID as c_costc80_263_, order0_.Convertquotation as convert81_263_, order0_.C_Reject_Reason_ID as c_rejec82_263_, order0_.validuntil as validun83_263_, order0_.Quotation_ID as quotati84_263_, order0_.SO_Res_Status as so_res_85_263_, order0_.Create_POLines as create_86_263_, order0_.Iscashvat as iscashv87_263_, order0_.EM_OBMFM_Selectfreight as em_obmf88_263_, order0_.EM_OBMFM_Delivery_Period_ID as em_obmf89_263_, order0_.RM_Pickfromreceipt as rm_pick90_263_, order0_.Cancelandreplace as cancela91_263_, order0_.EM_APRM_AddPayment as em_aprm92_263_, order0_.EM_OBMFM_Delivery_Charges as em_obmf93_263_, order0_.EM_Opxdes_Nota_Salida as em_opxd94_263_, order0_.EM_OBMFM_Freight_ID as em_obmf95_263_, order0_.EM_Obwpl_Generatepicking as em_obwp96_263_, order0_.EM_Opxdes_Nota_Cliente as em_opxd97_263_, order0_.EM_OBMFM_Weight as em_obmf98_263_, order0_.EM_Obwpl_Isinpickinglist as em_obwp99_263_, order0_.EM_Opxdes_Nota_Entrada as em_opx100_263_, order0_.EM_Obwpl_Readypl as em_obw101_263_, order0_.EM_Opxdes_Esreserva as em_opx102_263_, order0_.EM_Opxdes_Huesped_ID as em_opx103_263_, order0_.EM_OBMFM_Weight_Uom_ID as em_obm104_263_, order0_.EM_Opxdes_C_Order_ID as em_opx105_263_, order0_.EM_OBMFM_Set_Weight as em_obm106_263_, order0_.EM_Opxdes_Tipo as em_opx107_263_, order0_.EM_Aeatsii_Fecha_Operacion as em_aea108_263_, order0_.EM_Opxdes_Resource_ID as em_opx109_263_, order0_.Confirmcancelandreplace as confir110_263_, order0_.EM_Aeatsii_Descripcion_Sii as em_aea111_263_, order0_.EM_Etabam_Bankaccount_ID as em_eta112_263_, order0_.EM_Etpr_Remove_Payment as em_etp113_263_, order0_.EM_Opxdes_Limp_In_ID as em_opx114_263_, order0_.EM_Opxdes_Limp_Out_ID as em_opx115_263_, order0_.EM_Abhtem_Datein as em_abh116_263_, order0_.EM_Etvfac_Reversed_Invoice as em_etv117_263_, order0_.EM_Opxdes_Gen_Venc as em_opx118_263_, order0_.Cancelledorder_id as cancel119_263_, order0_.EM_Abhtem_Dateout as em_abh120_263_, order0_.EM_Etblkc_Bulkcompletion as em_etb121_263_, order0_.EM_Opxdes_Calendario as em_opx122_263_, order0_.EM_Opxdes_Pax as em_opx123_263_, order0_.Replacedorder_id as replac124_263_, order0_.EM_Opxdes_Registrar as em_opx125_263_, order0_.EM_Opxdes_Reactivar as em_opx126_263_, order0_.EM_Opxdes_Anular as em_opx127_263_, order0_.Iscancelled as iscanc128_263_, order0_.Replacementorder_ID as replac129_263_, order0_.EM_Opxdis_Winterrental as em_opx130_263_, order0_.EM_Etafdp_Undoclose as em_eta131_263_, order0_.EM_Etinter_Interco_Orig as em_eti132_263_, order0_.BPartner_ExtRef as bpartn133_263_, order0_.EM_Ov_Pax_Prod as em_ov_134_263_, order0_.EM_Ov_Product_ID as em_ov_135_263_, order0_.EM_Ov_Genpagos as em_ov_136_263_, order0_.EM_Ov_Reservar as em_ov_137_263_, order0_.EM_Ov_Agencia_ID as em_ov_138_263_, order0_.EM_Ov_Propietario_ID as em_ov_139_263_, order0_.EM_Opxws_Iswebsrv as em_opx140_263_, order0_.EM_Ov_Addseguro as em_ov_141_263_, order0_.EM_Opxdes_Actualizar as em_opx142_263_, order0_.EM_Opxdes_Fecha_Anulacion as em_opx143_263_, order0_.EM_Opxdes_Impr_Fact as em_opx144_263_, order0_.EM_Opxdes_Deposito as em_opx145_263_, order0_.EM_Prpres_Reference as em_prp146_263_, order0_.EM_Prpres_Void_Order as em_prp147_263_, order0_.EM_Prpres_Gross_Total as em_prp148_263_, order0_.EM_Opxdes_Inc_ID as em_opx149_263_, order0_.EM_Prpres_Net_Total as em_prp150_263_, order0_.EM_Opxdes_Actuacion as em_opx151_263_, order0_.EM_Opxdes_Importe_Fact as em_opx152_263_, order0_.EM_Opxdes_Facturacion as em_opx153_263_, order0_.EM_Opxdes_Mov_Saldo as em_opx154_263_, order0_.EM_Opxdes_Es_Presupuesto as em_opx155_263_, order0_.EM_Opxdes_Btn_Generar_Abono as em_opx156_263_, order0_.EM_Opxdes_Priceactual as em_opx157_263_, order0_.EM_Ov_Enviarmail as em_ov_158_263_, order0_.EM_Opxdes_M_Product_ID as em_opx159_263_, order0_.EM_Ov_Adultpax as em_ov_160_263_, order0_.EM_Prpres_Isgift as em_prp161_263_, order0_.EM_Ov_Childpax as em_ov_162_263_, order0_.EM_Prpres_Giftmessage as em_prp163_263_, order0_.EM_Ov_Envmail as em_ov_164_263_, order0_.EM_Prpres_Id_Cart as em_prp165_263_, order0_.EM_Ov_Horallegada as em_ov_166_263_, order0_.EM_Ov_Estado as em_ov_167_263_, order0_.EM_Ov_Bono_ID as em_ov_168_263_, order0_.EM_Prpres_Id_Paym_Transaction as em_prp169_263_, order0_.EM_Ov_Btnpurchase as em_ov_170_263_, order0_.EM_Ov_Btnworkparts as em_ov_171_263_, order0_.EM_Ovjch_Responsable_ID as em_ovj172_263_, order0_.EM_Ovjch_Hora as em_ovj173_263_, order0_.EM_Ovjch_Estadoreserva as em_ovj174_263_, order0_.EM_Ovjch_Fechadevengo as em_ovj175_263_, order0_.EM_Abpr_Createinvoice as em_abp176_263_, order0_.EM_Ovjch_Checkin as em_ovj177_263_, order0_.EM_Ovjch_Checkout as em_ovj178_263_, order0_.EM_Ovjch_Altoriesgo as em_ovj179_263_, order0_.EM_Ovjch_Btnactuaciones as em_ovj180_263_, order0_.EM_Ovjch_Incidencia as em_ovj181_263_, order0_.EM_Ovjch_Prereserva as em_ovj182_263_, order0_.EM_Prpres_Processing as em_prp183_263_, order0_.EM_Ovjch_Idordercheckin as em_ovj184_263_, order0_.EM_Prpres_Generatepicking as em_prp185_263_, order0_.EM_Ovjch_Urlcheckin as em_ovj186_263_, order0_.EM_Ovjch_Updatelastdate as em_ovj187_263_, order0_.EM_Ovjch_M_Pricelist_ID as em_ovj188_263_, order0_.EM_Abpr_Reasignpayments as em_abp189_263_, order0_.EM_Pruti_Ignoreminqty as em_pru190_263_, order0_.EM_Prpres_C_Order_ID as em_prp191_263_, order0_.EM_Ovavt_Idorderavantio as em_ova192_263_, order0_.EM_Ovavt_Btnavantio as em_ova193_263_, order0_.EM_Prenu_Reservationid as em_pre194_263_, order0_.EM_Prenu_Creator as em_pre195_263_, order0_.EM_Prenu_Pmsreservationid as em_pre196_263_, order0_.EM_Prenu_Cancelationtype as em_pre197_263_, order0_.EM_Ovjch_Checkinrealizado as em_ovj198_263_, order0_.EM_Prenu_Xmlresponse as em_pre199_263_, order0_.EM_Ovjch_Pedido_As as em_ovj200_263_, order0_.EM_Ovjch_Clientenuevo as em_ovj201_263_, order0_.EM_Ovjch_Bpgroup_ID as em_ovj202_263_, order0_.EM_Ovjch_Btnprop as em_ovj203_263_, order0_.EM_Ovjch_Hp_Rsv_ID as em_ovj204_263_, order0_.EM_Abthan_Booking_ID as em_abt205_263_, order0_.EM_ABTHAN_BOOKED_ACCOMM_ID as em_abt206_263_, order0_.EM_Ov_Tipoestancia as em_ov_207_263_, order0_.EM_Ovjch_Promocode as em_ovj208_263_, order0_.EM_Ov_Numpets as em_ov_209_263_, order0_.EM_Tica_Subtipo as em_tic210_263_, order0_.EM_Tica_Update_Avt_Date as em_tic211_263_ from C_Order order0_ inner join M_Warehouse warehouse1_ on order0_.M_Warehouse_ID = warehouse1_.M_Warehouse_ID cross join C_DocType documentty2_ where order0_.C_DocTypeTarget_ID = documentty2_.C_DocType_ID and (upper(order0_.DocumentNo) like upper('%202%') escape '|') and order0_.IsSOTrx = 'Y' and documentty2_.IsReturn = 'N' and (documentty2_.DocSubTypeSO not like 'OB') and order0_.AD_Org_ID = 'A773FA4025394EA8A1E37364E1DE3D47' and (order0_.AD_Org_ID in ('0', 'D15E3537625542F4A3182F2AE6BB880C', '7D3682EF1F0A49B6B90995EE82BF046A', '89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '919E20F189814C66BE91193B76A59A56', '5847CA8D7F684511BBD9AB15187E28BF', '09DC0E69DADB44818631243019495A05', 'F98ECEDD4DF64E26978135CB845D0735', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and (order0_.AD_Client_ID in ('6FE3A72599634D659D297CBCADC03261', '0')) order by warehouse1_.Name, order0_.C_Order_ID limit '101';

Date: 2026-07-16 14:28:17
Duration: 2s632ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

select fin_paymen0_.FIN_Payment_Scheduledetail_ID as col_0_0_, coalesce(fin_paymen4_.Fin_Payment_Schedule_ID, fin_paymen9_.Fin_Payment_Schedule_ID) as col_1_0_, organizati2_.AD_Org_ID as col_2_0_, adclient3_.AD_Client_ID as col_3_0_, invoice5_.DocumentNo as col_4_0_, order10_.DocumentNo as col_5_0_, coalesce(currency7_.ISO_Code, currency12_.ISO_Code) as col_6_0_, coalesce(businesspa1_.Name, '') as col_7_0_, coalesce(fin_paymen6_.Name, fin_paymen11_.Name) as col_8_0_, coalesce(businesspa8_.AccountNo, businesspa13_.AccountNo) as col_9_0_, coalesce(fin_paymen4_.ExpectedDate, fin_paymen9_.ExpectedDate) as col_10_0_, coalesce(fin_paymen4_.Duedate, fin_paymen9_.Duedate) as col_11_0_, sum(fin_paymen0_.Amount) as col_12_0_, sum(fin_paymen0_.Amount) as col_13_0_, case when rem_remitt14_.REM_Remittanceline_ID is not null then sum(rem_remitt14_.Amount) else sum(fin_paymen0_.Amount) end as col_14_0_, sum(fin_paymen0_.Amount-fin_paymen0_.Amount) as col_15_0_, '' as col_16_0_, case coalesce(invoice5_.IsSOTrx, order10_.IsSOTrx) when 'Y' then 'Cobro' else 'Pago' end as col_17_0_, case when rem_remitt14_.REM_Remittanceline_ID is not null then true else false end as col_18_0_ from FIN_Payment_ScheduleDetail fin_paymen0_ inner join C_BPartner businesspa1_ on fin_paymen0_.C_Bpartner_ID = businesspa1_.C_BPartner_ID left outer join AD_Org organizati2_ on fin_paymen0_.AD_Org_ID = organizati2_.AD_Org_ID left outer join AD_Client adclient3_ on fin_paymen0_.AD_Client_ID = adclient3_.AD_Client_ID left outer join FIN_Payment_Schedule fin_paymen4_ on fin_paymen0_.FIN_Payment_Schedule_Invoice = fin_paymen4_.Fin_Payment_Schedule_ID left outer join C_Invoice invoice5_ on fin_paymen4_.C_Invoice_ID = invoice5_.C_Invoice_ID left outer join FIN_PaymentMethod fin_paymen6_ on fin_paymen4_.Fin_Paymentmethod_ID = fin_paymen6_.Fin_Paymentmethod_ID left outer join C_Currency currency7_ on invoice5_.C_Currency_ID = currency7_.C_Currency_ID left outer join C_BP_BankAccount businesspa8_ on invoice5_.EM_Etabam_Bankaccount_ID = businesspa8_.C_BP_BankAccount_ID left outer join FIN_Payment_Schedule fin_paymen9_ on fin_paymen0_.FIN_Payment_Schedule_Order = fin_paymen9_.Fin_Payment_Schedule_ID left outer join C_Order order10_ on fin_paymen9_.C_Order_ID = order10_.C_Order_ID left outer join FIN_PaymentMethod fin_paymen11_ on fin_paymen9_.Fin_Paymentmethod_ID = fin_paymen11_.Fin_Paymentmethod_ID left outer join C_Currency currency12_ on order10_.C_Currency_ID = currency12_.C_Currency_ID left outer join C_BP_BankAccount businesspa13_ on order10_.EM_Etabam_Bankaccount_ID = businesspa13_.C_BP_BankAccount_ID left outer join REM_RemittanceLine rem_remitt14_ on (rem_remitt14_.FIN_Payment_Scheduledetail_ID = fin_paymen0_.FIN_Payment_Scheduledetail_ID and rem_remitt14_.REM_Remittance_ID = 'E33A69BCC4894755B34BCB12D888D33B') where (fin_paymen0_.FIN_Payment_Detail_ID is null) and (coalesce(fin_paymen4_.Fin_Payment_Schedule_ID, fin_paymen9_.Fin_Payment_Schedule_ID) is not null) and (fin_paymen0_.AD_Org_ID in ('89AC9B7D5FB043308093F1C33A2A9F96', 'A773FA4025394EA8A1E37364E1DE3D47', '5847CA8D7F684511BBD9AB15187E28BF', '7AB72DD7A7784226A90579E5C8F052D2', 'B0E9F2AD91584B3CAFC131D865DC766F')) and coalesce(fin_paymen4_.ExpectedDate, fin_paymen9_.ExpectedDate) <= to_date('17-07-2026') group by fin_paymen0_.FIN_Payment_Scheduledetail_ID, coalesce(fin_paymen4_.Fin_Payment_Schedule_ID, fin_paymen9_.Fin_Payment_Schedule_ID), organizati2_.AD_Org_ID, adclient3_.AD_Client_ID, order10_.DocumentNo, invoice5_.DocumentNo, coalesce(currency7_.ISO_Code, currency12_.ISO_Code), businesspa1_.Name, coalesce(fin_paymen6_.Name, fin_paymen11_.Name), coalesce(businesspa8_.AccountNo, businesspa13_.AccountNo), coalesce(fin_paymen4_.ExpectedDate, fin_paymen9_.ExpectedDate), coalesce(fin_paymen4_.Duedate, fin_paymen9_.Duedate), invoice5_.IsSOTrx, order10_.IsSOTrx, fin_paymen0_.FIN_Payment_Scheduledetail_ID, rem_remitt14_.REM_Remittanceline_ID order by col_18_0_ desc, invoice5_.DocumentNo asc limit '283';

Date: 2026-07-16 12:32:05
Duration: 1s89ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide