WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;

Date: 2026-07-17 11:38:19
Duration: 10s657ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;

Date: 2026-07-17 13:23:14
Duration: 10s39ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

WITH imgs_agrupadas AS ( SELECT vgf.opxdes_vehiculo_id, string_agg(dm.url_image || vgf.em_dlc_image_id, ',') AS imgs FROM public.opxdega_vehiculo_grupo_foto vgf CROSS JOIN public.dlcmkp_marketplace dm WHERE vgf.em_dlc_image_id IS NOT NULL GROUP BY vgf.opxdes_vehiculo_id ), vehiculos_unicos AS ( SELECT DISTINCT ov.opxdes_vehiculo_id, ov.etiqueta, ov.fecha_entrada, ov.bastidor, ov.matricula, ov.fecha_matricula, ov.color, ov.km, ov.estado_vehiculo, ov.em_opxpatr_modelo, ov.em_opxpatr_tipocomb, ov.em_opxpatr_marca, ov.em_opxpatr_version, ov.em_opxpatr_tipo_caja_cambios, ov.em_opxpatr_num_puertas FROM public.dlcmkp_marketplace_part dmp INNER JOIN public.opxdes_vehiculo ov ON ov.opxdes_vehiculo_id = dmp.opxdes_vehiculo_id WHERE COALESCE(ov.etiqueta, '') != '' ) SELECT vu.etiqueta AS codvehiculo, TO_CHAR(vu.fecha_entrada, 'DD-MM-YYYY') AS fechaentrada, NULL AS fechasalida, dlceco_format_text_to_file (COALESCE(mcv_marca.name, '')) AS marca, dlceco_format_text_to_file(COALESCE(ma_modelo.name, '')) AS modelo, dlceco_format_text_to_file (ma_version.name) AS motorversion, dlceco_format_text_to_file (ma_cajacambios.name) AS cambioversion, NULL AS anoversion, vu.bastidor AS bastidor, REPLACE(vu.matricula, '-', '') AS matricula, TO_CHAR(vu.fecha_matricula, 'DD-MM-YYYY') AS fechamatriculacion, NULL AS paismatriculacion, mcv_color.name AS color, COALESCE(CASE WHEN ma_numpuertas.value ~ '^\d+$' THEN ma_numpuertas.value ELSE '0' END, '0') AS puertas, vu.km AS kilometraje, NULL AS notapublica, NULL AS codigomotor, NULL AS codigocambio, COALESCE(ma_tipo_combustible.value, '') AS tipocombustible, mcv_estadoveh.name AS estadovehiculo, NULL AS localizacion, NULL AS usuario, NULL AS factualiza, img.imgs FROM vehiculos_unicos vu LEFT JOIN imgs_agrupadas img ON img.opxdes_vehiculo_id = vu.opxdes_vehiculo_id LEFT JOIN public.m_attributevalue ma_modelo ON ma_modelo.m_attributevalue_id = vu.em_opxpatr_modelo LEFT JOIN public.m_attributevalue ma_tipo_combustible ON ma_tipo_combustible.m_attributevalue_id = vu.em_opxpatr_tipocomb LEFT JOIN public.m_attributevalue mcv_marca ON mcv_marca.m_attributevalue_id = vu.em_opxpatr_marca LEFT JOIN public.m_attributevalue ma_version ON ma_version.m_attributevalue_id = vu.em_opxpatr_version LEFT JOIN public.m_attributevalue ma_cajacambios ON ma_cajacambios.m_attributevalue_id = vu.em_opxpatr_tipo_caja_cambios LEFT JOIN public.m_ch_value mcv_color ON mcv_color.m_ch_value_id = vu.color LEFT JOIN public.m_attributevalue ma_numpuertas ON ma_numpuertas.m_attributevalue_id = vu.em_opxpatr_num_puertas LEFT JOIN public.m_ch_value mcv_estadoveh ON mcv_estadoveh.m_ch_value_id = vu.estado_vehiculo;

Date: 2026-07-17 20:53:30
Duration: 10s2ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

select opxdvnt_wa0_.Obawo_Warehouseops_V_ID as obawo_wa1_983_, opxdvnt_wa0_.M_Product_ID as m_produc2_983_, opxdvnt_wa0_.M_Locator_ID as m_locato3_983_, opxdvnt_wa0_.M_Attributesetinstance_ID as m_attrib4_983_, opxdvnt_wa0_.C_Uom_ID as c_uom_id5_983_, opxdvnt_wa0_.M_Product_Uom_ID as m_produc6_983_, opxdvnt_wa0_.QtyOnHand as qtyonhan7_983_, opxdvnt_wa0_.QtyOrderOnHand as qtyorder8_983_, opxdvnt_wa0_.Datelastinventory as datelast9_983_, opxdvnt_wa0_.Preqtyonhand as preqtyo10_983_, opxdvnt_wa0_.Preqtyorderonhand as preqtyo11_983_, opxdvnt_wa0_.AD_Client_ID as ad_clie12_983_, opxdvnt_wa0_.AD_Org_ID as ad_org_13_983_, opxdvnt_wa0_.Isactive as isactiv14_983_, opxdvnt_wa0_.Created as created15_983_, opxdvnt_wa0_.Createdby as created16_983_, opxdvnt_wa0_.Updated as updated17_983_, opxdvnt_wa0_.Updatedby as updated18_983_, opxdvnt_wa0_.M_Storage_Detail_ID as m_stora19_983_, opxdvnt_wa0_.ReservedQty as reserve20_983_, opxdvnt_wa0_.Allocatedqty as allocat21_983_, opxdvnt_wa0_.Generate_Invprop as generat22_983_, opxdvnt_wa0_.Generate_Recount as generat23_983_, opxdvnt_wa0_.Move as move24_983_, opxdvnt_wa0_.Putaway as putaway25_983_, opxdvnt_wa0_.Change_Status as change_26_983_, opxdvnt_wa0_.Edit_attributes as edit_at27_983_, opxdvnt_wa0_.Insert_attributes as insert_28_983_, opxdvnt_wa0_.M_Warehouse_ID as m_wareh29_983_, opxdvnt_wa0_.Obawo_Locator_Group_ID as obawo_l30_983_, opxdvnt_wa0_.Obawo_Internal_Routing_Area_ID as obawo_i31_983_, opxdvnt_wa0_.M_Inventorystatus_ID as m_inven32_983_, opxdvnt_wa0_.BoxInPlanned as boxinpl33_983_, opxdvnt_wa0_.Unbox as unbox34_983_, opxdvnt_wa0_.M_Refinventory_ID as m_refin35_983_, opxdvnt_wa0_.Vincularstock as vincula36_983_, opxdvnt_wa0_.EM_Dlc_Descripcion_Sofinsa as em_dlc_37_983_, opxdvnt_wa0_.Stock_Menos_Uno as stock_m38_983_, opxdvnt_wa0_.Precio as precio39_983_, opxdvnt_wa0_.modelogt as modelog40_983_ from OPXDVNT_warehouseops_v opxdvnt_wa0_ cross join M_RefInventory materialmg1_ where opxdvnt_wa0_.M_Refinventory_ID = materialmg1_.M_RefInventory_ID and (upper(materialmg1_.EM_Dlc_Desc_Ri) like upper('%552%') escape '|') and (exists ( select 1 from AD_OrgInfo organizati2_ where organizati2_.AD_Org_ID = opxdvnt_wa0_.AD_Org_ID and organizati2_.EM_Obawo_Awo_Flow = 'Y')) and not (exists ( select 1 from M_RefInventory materialmg3_ where materialmg3_.EM_Dlcs_Excluir_Ventas = 'Y' and materialmg3_.M_RefInventory_ID = opxdvnt_wa0_.M_Refinventory_ID)) and (opxdvnt_wa0_.AD_Org_ID in ('0', 'C07C523C395944EA86E2D50143CC224D', 'BD36C0BC39FB4713AFE12D56E4978807', '98FA556DECF04AE3AFC5997715BE55A4', 'F41218E4BA9C4B4F9BD88E8C9E0AB2CE', '9FCE56724ABB4093A093A5EB9F4CAE04', '29B7D319C9E1472796E4F7A2EBB7A591', 'C4D181E98F054803B95AFDB0BDC04240')) and (opxdvnt_wa0_.AD_Client_ID in ('86F69592CF6F405E8E7004128655A71A', '0')) order by opxdvnt_wa0_.Updated desc, opxdvnt_wa0_.Obawo_Warehouseops_V_ID desc limit '101';

Date: 2026-07-17 16:31:08
Duration: 4s735ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select opxdvnt_wa0_.Obawo_Warehouseops_V_ID as obawo_wa1_983_, opxdvnt_wa0_.M_Product_ID as m_produc2_983_, opxdvnt_wa0_.M_Locator_ID as m_locato3_983_, opxdvnt_wa0_.M_Attributesetinstance_ID as m_attrib4_983_, opxdvnt_wa0_.C_Uom_ID as c_uom_id5_983_, opxdvnt_wa0_.M_Product_Uom_ID as m_produc6_983_, opxdvnt_wa0_.QtyOnHand as qtyonhan7_983_, opxdvnt_wa0_.QtyOrderOnHand as qtyorder8_983_, opxdvnt_wa0_.Datelastinventory as datelast9_983_, opxdvnt_wa0_.Preqtyonhand as preqtyo10_983_, opxdvnt_wa0_.Preqtyorderonhand as preqtyo11_983_, opxdvnt_wa0_.AD_Client_ID as ad_clie12_983_, opxdvnt_wa0_.AD_Org_ID as ad_org_13_983_, opxdvnt_wa0_.Isactive as isactiv14_983_, opxdvnt_wa0_.Created as created15_983_, opxdvnt_wa0_.Createdby as created16_983_, opxdvnt_wa0_.Updated as updated17_983_, opxdvnt_wa0_.Updatedby as updated18_983_, opxdvnt_wa0_.M_Storage_Detail_ID as m_stora19_983_, opxdvnt_wa0_.ReservedQty as reserve20_983_, opxdvnt_wa0_.Allocatedqty as allocat21_983_, opxdvnt_wa0_.Generate_Invprop as generat22_983_, opxdvnt_wa0_.Generate_Recount as generat23_983_, opxdvnt_wa0_.Move as move24_983_, opxdvnt_wa0_.Putaway as putaway25_983_, opxdvnt_wa0_.Change_Status as change_26_983_, opxdvnt_wa0_.Edit_attributes as edit_at27_983_, opxdvnt_wa0_.Insert_attributes as insert_28_983_, opxdvnt_wa0_.M_Warehouse_ID as m_wareh29_983_, opxdvnt_wa0_.Obawo_Locator_Group_ID as obawo_l30_983_, opxdvnt_wa0_.Obawo_Internal_Routing_Area_ID as obawo_i31_983_, opxdvnt_wa0_.M_Inventorystatus_ID as m_inven32_983_, opxdvnt_wa0_.BoxInPlanned as boxinpl33_983_, opxdvnt_wa0_.Unbox as unbox34_983_, opxdvnt_wa0_.M_Refinventory_ID as m_refin35_983_, opxdvnt_wa0_.Vincularstock as vincula36_983_, opxdvnt_wa0_.EM_Dlc_Descripcion_Sofinsa as em_dlc_37_983_, opxdvnt_wa0_.Stock_Menos_Uno as stock_m38_983_, opxdvnt_wa0_.Precio as precio39_983_, opxdvnt_wa0_.modelogt as modelog40_983_ from OPXDVNT_warehouseops_v opxdvnt_wa0_ cross join M_RefInventory materialmg1_ where opxdvnt_wa0_.M_Refinventory_ID = materialmg1_.M_RefInventory_ID and (upper(materialmg1_.EM_Dlc_Desc_Ri) like upper('%446%') escape '|') and (exists ( select 1 from AD_OrgInfo organizati2_ where organizati2_.AD_Org_ID = opxdvnt_wa0_.AD_Org_ID and organizati2_.EM_Obawo_Awo_Flow = 'Y')) and not (exists ( select 1 from M_RefInventory materialmg3_ where materialmg3_.EM_Dlcs_Excluir_Ventas = 'Y' and materialmg3_.M_RefInventory_ID = opxdvnt_wa0_.M_Refinventory_ID)) and (opxdvnt_wa0_.AD_Org_ID in ('0', 'C07C523C395944EA86E2D50143CC224D', 'BD36C0BC39FB4713AFE12D56E4978807', '98FA556DECF04AE3AFC5997715BE55A4', 'F41218E4BA9C4B4F9BD88E8C9E0AB2CE', '9FCE56724ABB4093A093A5EB9F4CAE04', '29B7D319C9E1472796E4F7A2EBB7A591', 'C4D181E98F054803B95AFDB0BDC04240')) and (opxdvnt_wa0_.AD_Client_ID in ('86F69592CF6F405E8E7004128655A71A', '0')) order by opxdvnt_wa0_.Updated desc, opxdvnt_wa0_.Obawo_Warehouseops_V_ID desc limit '101';

Date: 2026-07-17 16:26:02
Duration: 4s668ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select opxdvnt_wa0_.Obawo_Warehouseops_V_ID as obawo_wa1_983_, opxdvnt_wa0_.M_Product_ID as m_produc2_983_, opxdvnt_wa0_.M_Locator_ID as m_locato3_983_, opxdvnt_wa0_.M_Attributesetinstance_ID as m_attrib4_983_, opxdvnt_wa0_.C_Uom_ID as c_uom_id5_983_, opxdvnt_wa0_.M_Product_Uom_ID as m_produc6_983_, opxdvnt_wa0_.QtyOnHand as qtyonhan7_983_, opxdvnt_wa0_.QtyOrderOnHand as qtyorder8_983_, opxdvnt_wa0_.Datelastinventory as datelast9_983_, opxdvnt_wa0_.Preqtyonhand as preqtyo10_983_, opxdvnt_wa0_.Preqtyorderonhand as preqtyo11_983_, opxdvnt_wa0_.AD_Client_ID as ad_clie12_983_, opxdvnt_wa0_.AD_Org_ID as ad_org_13_983_, opxdvnt_wa0_.Isactive as isactiv14_983_, opxdvnt_wa0_.Created as created15_983_, opxdvnt_wa0_.Createdby as created16_983_, opxdvnt_wa0_.Updated as updated17_983_, opxdvnt_wa0_.Updatedby as updated18_983_, opxdvnt_wa0_.M_Storage_Detail_ID as m_stora19_983_, opxdvnt_wa0_.ReservedQty as reserve20_983_, opxdvnt_wa0_.Allocatedqty as allocat21_983_, opxdvnt_wa0_.Generate_Invprop as generat22_983_, opxdvnt_wa0_.Generate_Recount as generat23_983_, opxdvnt_wa0_.Move as move24_983_, opxdvnt_wa0_.Putaway as putaway25_983_, opxdvnt_wa0_.Change_Status as change_26_983_, opxdvnt_wa0_.Edit_attributes as edit_at27_983_, opxdvnt_wa0_.Insert_attributes as insert_28_983_, opxdvnt_wa0_.M_Warehouse_ID as m_wareh29_983_, opxdvnt_wa0_.Obawo_Locator_Group_ID as obawo_l30_983_, opxdvnt_wa0_.Obawo_Internal_Routing_Area_ID as obawo_i31_983_, opxdvnt_wa0_.M_Inventorystatus_ID as m_inven32_983_, opxdvnt_wa0_.BoxInPlanned as boxinpl33_983_, opxdvnt_wa0_.Unbox as unbox34_983_, opxdvnt_wa0_.M_Refinventory_ID as m_refin35_983_, opxdvnt_wa0_.Vincularstock as vincula36_983_, opxdvnt_wa0_.EM_Dlc_Descripcion_Sofinsa as em_dlc_37_983_, opxdvnt_wa0_.Stock_Menos_Uno as stock_m38_983_, opxdvnt_wa0_.Precio as precio39_983_, opxdvnt_wa0_.modelogt as modelog40_983_ from OPXDVNT_warehouseops_v opxdvnt_wa0_ cross join M_RefInventory materialmg1_ where opxdvnt_wa0_.M_Refinventory_ID = materialmg1_.M_RefInventory_ID and (upper(materialmg1_.EM_Dlc_Desc_Ri) like upper('%483%') escape '|') and (exists ( select 1 from AD_OrgInfo organizati2_ where organizati2_.AD_Org_ID = opxdvnt_wa0_.AD_Org_ID and organizati2_.EM_Obawo_Awo_Flow = 'Y')) and not (exists ( select 1 from M_RefInventory materialmg3_ where materialmg3_.EM_Dlcs_Excluir_Ventas = 'Y' and materialmg3_.M_RefInventory_ID = opxdvnt_wa0_.M_Refinventory_ID)) and (opxdvnt_wa0_.AD_Org_ID in ('0', 'C07C523C395944EA86E2D50143CC224D', 'BD36C0BC39FB4713AFE12D56E4978807', '98FA556DECF04AE3AFC5997715BE55A4', 'F41218E4BA9C4B4F9BD88E8C9E0AB2CE', '9FCE56724ABB4093A093A5EB9F4CAE04', '29B7D319C9E1472796E4F7A2EBB7A591', 'C4D181E98F054803B95AFDB0BDC04240')) and (opxdvnt_wa0_.AD_Client_ID in ('86F69592CF6F405E8E7004128655A71A', '0')) order by opxdvnt_wa0_.Updated desc, opxdvnt_wa0_.Obawo_Warehouseops_V_ID desc limit '101';

Date: 2026-07-17 13:03:45
Duration: 4s643ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

select dlc_piezas0_.DLC_Piezas_V_ID as dlc_piez1_367_, dlc_piezas0_.AD_Org_ID as ad_org_i2_367_, dlc_piezas0_.AD_Client_ID as ad_clien3_367_, dlc_piezas0_.Isactive as isactive4_367_, dlc_piezas0_.Created as created5_367_, dlc_piezas0_.Createdby as createdb6_367_, dlc_piezas0_.Updated as updated7_367_, dlc_piezas0_.Updatedby as updatedb8_367_, dlc_piezas0_.M_Product_ID as m_produc9_367_, dlc_piezas0_.EM_Dlc_Sofinsa as em_dlc_10_367_, dlc_piezas0_.EM_Dlc_Descripcion_Sofinsa as em_dlc_11_367_, dlc_piezas0_.M_Product_Category_ID as m_produ12_367_, dlc_piezas0_.Etiqueta_Rfid as etiquet13_367_, dlc_piezas0_.EM_Dlc_Matricula as em_dlc_14_367_, dlc_piezas0_.M_Attributesetinstance_ID as m_attri15_367_, dlc_piezas0_.Precio_Generico as precio_16_367_, dlc_piezas0_.Precio_Nuevo as precio_17_367_, dlc_piezas0_.Precio_Pieza as precio_18_367_, dlc_piezas0_.DTO_Pieza as dto_pie19_367_, dlc_piezas0_.Pieza_Verificada as pieza_v20_367_, dlc_piezas0_.M_Storage_Detail_ID as m_stora21_367_, dlc_piezas0_.Referencia_Ian as referen22_367_, dlc_piezas0_.Referencia_Oem as referen23_367_, dlc_piezas0_.Modificar_Precios as modific24_367_, dlc_piezas0_.Verificar_Pieza as verific25_367_, dlc_piezas0_.Modificar_Referencia as modific26_367_, dlc_piezas0_.Stock_Pna as stock_p27_367_, dlc_piezas0_.Stock_Bcn as stock_b28_367_, dlc_piezas0_.Ventas_Dos_Anos as ventas_29_367_, dlc_piezas0_.M_Warehouse_ID as m_wareh30_367_, dlc_piezas0_.NUM_Fotos as num_fot31_367_, dlc_piezas0_.Observaciones as observa32_367_, dlc_piezas0_.Modificar_Modelo as modific33_367_, dlc_piezas0_.M_Locator_ID as m_locat34_367_, dlc_piezas0_.Modificar_Producto as modific35_367_, dlc_piezas0_.Preciogt as preciog36_367_, dlc_piezas0_.dlc_descuento_id as dlc_des37_367_, dlc_piezas0_.dtoeuros as dtoeuro38_367_, dlc_piezas0_.dtoPercentatge as dtoperc39_367_, dlc_piezas0_.opxdes_vehiculo_id as opxdes_40_367_ from dlc_piezas_v dlc_piezas0_ left outer join M_Product product1_ on dlc_piezas0_.M_Product_ID = product1_.M_Product_ID where dlc_piezas0_.NUM_Fotos > '0' and dlc_piezas0_.M_Warehouse_ID = 'FCA81F56E9E643E096E86F5F379459FB' and (dlc_piezas0_.AD_Org_ID in ('0', 'C07C523C395944EA86E2D50143CC224D', 'BD36C0BC39FB4713AFE12D56E4978807', '98FA556DECF04AE3AFC5997715BE55A4', 'F41218E4BA9C4B4F9BD88E8C9E0AB2CE', '9FCE56724ABB4093A093A5EB9F4CAE04', '29B7D319C9E1472796E4F7A2EBB7A591', 'C4D181E98F054803B95AFDB0BDC04240')) and (dlc_piezas0_.AD_Client_ID in ('86F69592CF6F405E8E7004128655A71A', '0')) order by product1_.Name desc, product1_.Value desc, dlc_piezas0_.DLC_Piezas_V_ID desc limit '101';

Date: 2026-07-17 09:02:00
Duration: 19s285ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select dlc_piezas0_.DLC_Piezas_V_ID as dlc_piez1_367_, dlc_piezas0_.AD_Org_ID as ad_org_i2_367_, dlc_piezas0_.AD_Client_ID as ad_clien3_367_, dlc_piezas0_.Isactive as isactive4_367_, dlc_piezas0_.Created as created5_367_, dlc_piezas0_.Createdby as createdb6_367_, dlc_piezas0_.Updated as updated7_367_, dlc_piezas0_.Updatedby as updatedb8_367_, dlc_piezas0_.M_Product_ID as m_produc9_367_, dlc_piezas0_.EM_Dlc_Sofinsa as em_dlc_10_367_, dlc_piezas0_.EM_Dlc_Descripcion_Sofinsa as em_dlc_11_367_, dlc_piezas0_.M_Product_Category_ID as m_produ12_367_, dlc_piezas0_.Etiqueta_Rfid as etiquet13_367_, dlc_piezas0_.EM_Dlc_Matricula as em_dlc_14_367_, dlc_piezas0_.M_Attributesetinstance_ID as m_attri15_367_, dlc_piezas0_.Precio_Generico as precio_16_367_, dlc_piezas0_.Precio_Nuevo as precio_17_367_, dlc_piezas0_.Precio_Pieza as precio_18_367_, dlc_piezas0_.DTO_Pieza as dto_pie19_367_, dlc_piezas0_.Pieza_Verificada as pieza_v20_367_, dlc_piezas0_.M_Storage_Detail_ID as m_stora21_367_, dlc_piezas0_.Referencia_Ian as referen22_367_, dlc_piezas0_.Referencia_Oem as referen23_367_, dlc_piezas0_.Modificar_Precios as modific24_367_, dlc_piezas0_.Verificar_Pieza as verific25_367_, dlc_piezas0_.Modificar_Referencia as modific26_367_, dlc_piezas0_.Stock_Pna as stock_p27_367_, dlc_piezas0_.Stock_Bcn as stock_b28_367_, dlc_piezas0_.Ventas_Dos_Anos as ventas_29_367_, dlc_piezas0_.M_Warehouse_ID as m_wareh30_367_, dlc_piezas0_.NUM_Fotos as num_fot31_367_, dlc_piezas0_.Observaciones as observa32_367_, dlc_piezas0_.Modificar_Modelo as modific33_367_, dlc_piezas0_.M_Locator_ID as m_locat34_367_, dlc_piezas0_.Modificar_Producto as modific35_367_, dlc_piezas0_.Preciogt as preciog36_367_, dlc_piezas0_.dlc_descuento_id as dlc_des37_367_, dlc_piezas0_.dtoeuros as dtoeuro38_367_, dlc_piezas0_.dtoPercentatge as dtoperc39_367_, dlc_piezas0_.opxdes_vehiculo_id as opxdes_40_367_ from dlc_piezas_v dlc_piezas0_ left outer join M_Product product1_ on dlc_piezas0_.M_Product_ID = product1_.M_Product_ID where dlc_piezas0_.NUM_Fotos > '0' and dlc_piezas0_.M_Warehouse_ID = 'FCA81F56E9E643E096E86F5F379459FB' and (dlc_piezas0_.AD_Org_ID in ('0', 'C07C523C395944EA86E2D50143CC224D', 'BD36C0BC39FB4713AFE12D56E4978807', '98FA556DECF04AE3AFC5997715BE55A4', 'F41218E4BA9C4B4F9BD88E8C9E0AB2CE', '9FCE56724ABB4093A093A5EB9F4CAE04', '29B7D319C9E1472796E4F7A2EBB7A591', 'C4D181E98F054803B95AFDB0BDC04240')) and (dlc_piezas0_.AD_Client_ID in ('86F69592CF6F405E8E7004128655A71A', '0')) order by product1_.Name desc, product1_.Value desc, dlc_piezas0_.DLC_Piezas_V_ID desc limit '101';

Date: 2026-07-17 09:02:00
Duration: 17s757ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select dlc_piezas0_.DLC_Piezas_V_ID as dlc_piez1_367_, dlc_piezas0_.AD_Org_ID as ad_org_i2_367_, dlc_piezas0_.AD_Client_ID as ad_clien3_367_, dlc_piezas0_.Isactive as isactive4_367_, dlc_piezas0_.Created as created5_367_, dlc_piezas0_.Createdby as createdb6_367_, dlc_piezas0_.Updated as updated7_367_, dlc_piezas0_.Updatedby as updatedb8_367_, dlc_piezas0_.M_Product_ID as m_produc9_367_, dlc_piezas0_.EM_Dlc_Sofinsa as em_dlc_10_367_, dlc_piezas0_.EM_Dlc_Descripcion_Sofinsa as em_dlc_11_367_, dlc_piezas0_.M_Product_Category_ID as m_produ12_367_, dlc_piezas0_.Etiqueta_Rfid as etiquet13_367_, dlc_piezas0_.EM_Dlc_Matricula as em_dlc_14_367_, dlc_piezas0_.M_Attributesetinstance_ID as m_attri15_367_, dlc_piezas0_.Precio_Generico as precio_16_367_, dlc_piezas0_.Precio_Nuevo as precio_17_367_, dlc_piezas0_.Precio_Pieza as precio_18_367_, dlc_piezas0_.DTO_Pieza as dto_pie19_367_, dlc_piezas0_.Pieza_Verificada as pieza_v20_367_, dlc_piezas0_.M_Storage_Detail_ID as m_stora21_367_, dlc_piezas0_.Referencia_Ian as referen22_367_, dlc_piezas0_.Referencia_Oem as referen23_367_, dlc_piezas0_.Modificar_Precios as modific24_367_, dlc_piezas0_.Verificar_Pieza as verific25_367_, dlc_piezas0_.Modificar_Referencia as modific26_367_, dlc_piezas0_.Stock_Pna as stock_p27_367_, dlc_piezas0_.Stock_Bcn as stock_b28_367_, dlc_piezas0_.Ventas_Dos_Anos as ventas_29_367_, dlc_piezas0_.M_Warehouse_ID as m_wareh30_367_, dlc_piezas0_.NUM_Fotos as num_fot31_367_, dlc_piezas0_.Observaciones as observa32_367_, dlc_piezas0_.Modificar_Modelo as modific33_367_, dlc_piezas0_.M_Locator_ID as m_locat34_367_, dlc_piezas0_.Modificar_Producto as modific35_367_, dlc_piezas0_.Preciogt as preciog36_367_, dlc_piezas0_.dlc_descuento_id as dlc_des37_367_, dlc_piezas0_.dtoeuros as dtoeuro38_367_, dlc_piezas0_.dtoPercentatge as dtoperc39_367_, dlc_piezas0_.opxdes_vehiculo_id as opxdes_40_367_ from dlc_piezas_v dlc_piezas0_ left outer join M_Product product1_ on dlc_piezas0_.M_Product_ID = product1_.M_Product_ID where dlc_piezas0_.NUM_Fotos > '0' and dlc_piezas0_.M_Warehouse_ID = 'FCA81F56E9E643E096E86F5F379459FB' and (dlc_piezas0_.AD_Org_ID in ('0', 'C07C523C395944EA86E2D50143CC224D', 'BD36C0BC39FB4713AFE12D56E4978807', '98FA556DECF04AE3AFC5997715BE55A4', 'F41218E4BA9C4B4F9BD88E8C9E0AB2CE', '9FCE56724ABB4093A093A5EB9F4CAE04', '29B7D319C9E1472796E4F7A2EBB7A591', 'C4D181E98F054803B95AFDB0BDC04240')) and (dlc_piezas0_.AD_Client_ID in ('86F69592CF6F405E8E7004128655A71A', '0')) order by product1_.Name desc, product1_.Value desc, dlc_piezas0_.DLC_Piezas_V_ID desc limit '101';

Date: 2026-07-17 09:02:00
Duration: 16s143ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

select opxdvnt_wa0_.Obawo_Warehouseops_V_ID as obawo_wa1_983_, opxdvnt_wa0_.M_Product_ID as m_produc2_983_, opxdvnt_wa0_.M_Locator_ID as m_locato3_983_, opxdvnt_wa0_.M_Attributesetinstance_ID as m_attrib4_983_, opxdvnt_wa0_.C_Uom_ID as c_uom_id5_983_, opxdvnt_wa0_.M_Product_Uom_ID as m_produc6_983_, opxdvnt_wa0_.QtyOnHand as qtyonhan7_983_, opxdvnt_wa0_.QtyOrderOnHand as qtyorder8_983_, opxdvnt_wa0_.Datelastinventory as datelast9_983_, opxdvnt_wa0_.Preqtyonhand as preqtyo10_983_, opxdvnt_wa0_.Preqtyorderonhand as preqtyo11_983_, opxdvnt_wa0_.AD_Client_ID as ad_clie12_983_, opxdvnt_wa0_.AD_Org_ID as ad_org_13_983_, opxdvnt_wa0_.Isactive as isactiv14_983_, opxdvnt_wa0_.Created as created15_983_, opxdvnt_wa0_.Createdby as created16_983_, opxdvnt_wa0_.Updated as updated17_983_, opxdvnt_wa0_.Updatedby as updated18_983_, opxdvnt_wa0_.M_Storage_Detail_ID as m_stora19_983_, opxdvnt_wa0_.ReservedQty as reserve20_983_, opxdvnt_wa0_.Allocatedqty as allocat21_983_, opxdvnt_wa0_.Generate_Invprop as generat22_983_, opxdvnt_wa0_.Generate_Recount as generat23_983_, opxdvnt_wa0_.Move as move24_983_, opxdvnt_wa0_.Putaway as putaway25_983_, opxdvnt_wa0_.Change_Status as change_26_983_, opxdvnt_wa0_.Edit_attributes as edit_at27_983_, opxdvnt_wa0_.Insert_attributes as insert_28_983_, opxdvnt_wa0_.M_Warehouse_ID as m_wareh29_983_, opxdvnt_wa0_.Obawo_Locator_Group_ID as obawo_l30_983_, opxdvnt_wa0_.Obawo_Internal_Routing_Area_ID as obawo_i31_983_, opxdvnt_wa0_.M_Inventorystatus_ID as m_inven32_983_, opxdvnt_wa0_.BoxInPlanned as boxinpl33_983_, opxdvnt_wa0_.Unbox as unbox34_983_, opxdvnt_wa0_.M_Refinventory_ID as m_refin35_983_, opxdvnt_wa0_.Vincularstock as vincula36_983_, opxdvnt_wa0_.EM_Dlc_Descripcion_Sofinsa as em_dlc_37_983_, opxdvnt_wa0_.Stock_Menos_Uno as stock_m38_983_, opxdvnt_wa0_.Precio as precio39_983_, opxdvnt_wa0_.modelogt as modelog40_983_ from OPXDVNT_warehouseops_v opxdvnt_wa0_ cross join M_Storage_Detail materialmg1_ where opxdvnt_wa0_.M_Storage_Detail_ID = materialmg1_.M_Storage_Detail_ID and (upper(materialmg1_.EM_Dlc_Etiqueta) like upper('%2021%') escape '|') and (exists ( select 1 from AD_OrgInfo organizati2_ where organizati2_.AD_Org_ID = opxdvnt_wa0_.AD_Org_ID and organizati2_.EM_Obawo_Awo_Flow = 'Y')) and not (exists ( select 1 from M_RefInventory materialmg3_ where materialmg3_.EM_Dlcs_Excluir_Ventas = 'Y' and materialmg3_.M_RefInventory_ID = opxdvnt_wa0_.M_Refinventory_ID)) and (opxdvnt_wa0_.AD_Org_ID in ('0', 'C07C523C395944EA86E2D50143CC224D', 'BD36C0BC39FB4713AFE12D56E4978807', '98FA556DECF04AE3AFC5997715BE55A4', 'F41218E4BA9C4B4F9BD88E8C9E0AB2CE', '9FCE56724ABB4093A093A5EB9F4CAE04', '29B7D319C9E1472796E4F7A2EBB7A591', 'C4D181E98F054803B95AFDB0BDC04240')) and (opxdvnt_wa0_.AD_Client_ID in ('86F69592CF6F405E8E7004128655A71A', '0')) order by opxdvnt_wa0_.Updated desc, opxdvnt_wa0_.Obawo_Warehouseops_V_ID desc limit '101';

Date: 2026-07-17 10:46:21
Duration: 1s524ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select opxdvnt_wa0_.Obawo_Warehouseops_V_ID as obawo_wa1_983_, opxdvnt_wa0_.M_Product_ID as m_produc2_983_, opxdvnt_wa0_.M_Locator_ID as m_locato3_983_, opxdvnt_wa0_.M_Attributesetinstance_ID as m_attrib4_983_, opxdvnt_wa0_.C_Uom_ID as c_uom_id5_983_, opxdvnt_wa0_.M_Product_Uom_ID as m_produc6_983_, opxdvnt_wa0_.QtyOnHand as qtyonhan7_983_, opxdvnt_wa0_.QtyOrderOnHand as qtyorder8_983_, opxdvnt_wa0_.Datelastinventory as datelast9_983_, opxdvnt_wa0_.Preqtyonhand as preqtyo10_983_, opxdvnt_wa0_.Preqtyorderonhand as preqtyo11_983_, opxdvnt_wa0_.AD_Client_ID as ad_clie12_983_, opxdvnt_wa0_.AD_Org_ID as ad_org_13_983_, opxdvnt_wa0_.Isactive as isactiv14_983_, opxdvnt_wa0_.Created as created15_983_, opxdvnt_wa0_.Createdby as created16_983_, opxdvnt_wa0_.Updated as updated17_983_, opxdvnt_wa0_.Updatedby as updated18_983_, opxdvnt_wa0_.M_Storage_Detail_ID as m_stora19_983_, opxdvnt_wa0_.ReservedQty as reserve20_983_, opxdvnt_wa0_.Allocatedqty as allocat21_983_, opxdvnt_wa0_.Generate_Invprop as generat22_983_, opxdvnt_wa0_.Generate_Recount as generat23_983_, opxdvnt_wa0_.Move as move24_983_, opxdvnt_wa0_.Putaway as putaway25_983_, opxdvnt_wa0_.Change_Status as change_26_983_, opxdvnt_wa0_.Edit_attributes as edit_at27_983_, opxdvnt_wa0_.Insert_attributes as insert_28_983_, opxdvnt_wa0_.M_Warehouse_ID as m_wareh29_983_, opxdvnt_wa0_.Obawo_Locator_Group_ID as obawo_l30_983_, opxdvnt_wa0_.Obawo_Internal_Routing_Area_ID as obawo_i31_983_, opxdvnt_wa0_.M_Inventorystatus_ID as m_inven32_983_, opxdvnt_wa0_.BoxInPlanned as boxinpl33_983_, opxdvnt_wa0_.Unbox as unbox34_983_, opxdvnt_wa0_.M_Refinventory_ID as m_refin35_983_, opxdvnt_wa0_.Vincularstock as vincula36_983_, opxdvnt_wa0_.EM_Dlc_Descripcion_Sofinsa as em_dlc_37_983_, opxdvnt_wa0_.Stock_Menos_Uno as stock_m38_983_, opxdvnt_wa0_.Precio as precio39_983_, opxdvnt_wa0_.modelogt as modelog40_983_ from OPXDVNT_warehouseops_v opxdvnt_wa0_ cross join M_Storage_Detail materialmg1_ where opxdvnt_wa0_.M_Storage_Detail_ID = materialmg1_.M_Storage_Detail_ID and (upper(materialmg1_.EM_Dlc_Etiqueta) like upper('%2003%') escape '|') and (exists ( select 1 from AD_OrgInfo organizati2_ where organizati2_.AD_Org_ID = opxdvnt_wa0_.AD_Org_ID and organizati2_.EM_Obawo_Awo_Flow = 'Y')) and not (exists ( select 1 from M_RefInventory materialmg3_ where materialmg3_.EM_Dlcs_Excluir_Ventas = 'Y' and materialmg3_.M_RefInventory_ID = opxdvnt_wa0_.M_Refinventory_ID)) and (opxdvnt_wa0_.AD_Org_ID in ('0', 'C07C523C395944EA86E2D50143CC224D', 'BD36C0BC39FB4713AFE12D56E4978807', '98FA556DECF04AE3AFC5997715BE55A4', 'F41218E4BA9C4B4F9BD88E8C9E0AB2CE', '9FCE56724ABB4093A093A5EB9F4CAE04', '29B7D319C9E1472796E4F7A2EBB7A591', 'C4D181E98F054803B95AFDB0BDC04240')) and (opxdvnt_wa0_.AD_Client_ID in ('86F69592CF6F405E8E7004128655A71A', '0')) order by opxdvnt_wa0_.Updated desc, opxdvnt_wa0_.Obawo_Warehouseops_V_ID desc limit '101';

Date: 2026-07-17 09:53:01
Duration: 1s522ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select opxdvnt_wa0_.Obawo_Warehouseops_V_ID as obawo_wa1_983_, opxdvnt_wa0_.M_Product_ID as m_produc2_983_, opxdvnt_wa0_.M_Locator_ID as m_locato3_983_, opxdvnt_wa0_.M_Attributesetinstance_ID as m_attrib4_983_, opxdvnt_wa0_.C_Uom_ID as c_uom_id5_983_, opxdvnt_wa0_.M_Product_Uom_ID as m_produc6_983_, opxdvnt_wa0_.QtyOnHand as qtyonhan7_983_, opxdvnt_wa0_.QtyOrderOnHand as qtyorder8_983_, opxdvnt_wa0_.Datelastinventory as datelast9_983_, opxdvnt_wa0_.Preqtyonhand as preqtyo10_983_, opxdvnt_wa0_.Preqtyorderonhand as preqtyo11_983_, opxdvnt_wa0_.AD_Client_ID as ad_clie12_983_, opxdvnt_wa0_.AD_Org_ID as ad_org_13_983_, opxdvnt_wa0_.Isactive as isactiv14_983_, opxdvnt_wa0_.Created as created15_983_, opxdvnt_wa0_.Createdby as created16_983_, opxdvnt_wa0_.Updated as updated17_983_, opxdvnt_wa0_.Updatedby as updated18_983_, opxdvnt_wa0_.M_Storage_Detail_ID as m_stora19_983_, opxdvnt_wa0_.ReservedQty as reserve20_983_, opxdvnt_wa0_.Allocatedqty as allocat21_983_, opxdvnt_wa0_.Generate_Invprop as generat22_983_, opxdvnt_wa0_.Generate_Recount as generat23_983_, opxdvnt_wa0_.Move as move24_983_, opxdvnt_wa0_.Putaway as putaway25_983_, opxdvnt_wa0_.Change_Status as change_26_983_, opxdvnt_wa0_.Edit_attributes as edit_at27_983_, opxdvnt_wa0_.Insert_attributes as insert_28_983_, opxdvnt_wa0_.M_Warehouse_ID as m_wareh29_983_, opxdvnt_wa0_.Obawo_Locator_Group_ID as obawo_l30_983_, opxdvnt_wa0_.Obawo_Internal_Routing_Area_ID as obawo_i31_983_, opxdvnt_wa0_.M_Inventorystatus_ID as m_inven32_983_, opxdvnt_wa0_.BoxInPlanned as boxinpl33_983_, opxdvnt_wa0_.Unbox as unbox34_983_, opxdvnt_wa0_.M_Refinventory_ID as m_refin35_983_, opxdvnt_wa0_.Vincularstock as vincula36_983_, opxdvnt_wa0_.EM_Dlc_Descripcion_Sofinsa as em_dlc_37_983_, opxdvnt_wa0_.Stock_Menos_Uno as stock_m38_983_, opxdvnt_wa0_.Precio as precio39_983_, opxdvnt_wa0_.modelogt as modelog40_983_ from OPXDVNT_warehouseops_v opxdvnt_wa0_ cross join M_Storage_Detail materialmg1_ where opxdvnt_wa0_.M_Storage_Detail_ID = materialmg1_.M_Storage_Detail_ID and (upper(materialmg1_.EM_Dlc_Etiqueta) like upper('%2230%') escape '|') and (exists ( select 1 from AD_OrgInfo organizati2_ where organizati2_.AD_Org_ID = opxdvnt_wa0_.AD_Org_ID and organizati2_.EM_Obawo_Awo_Flow = 'Y')) and not (exists ( select 1 from M_RefInventory materialmg3_ where materialmg3_.EM_Dlcs_Excluir_Ventas = 'Y' and materialmg3_.M_RefInventory_ID = opxdvnt_wa0_.M_Refinventory_ID)) and (opxdvnt_wa0_.AD_Org_ID in ('0', 'C07C523C395944EA86E2D50143CC224D', 'BD36C0BC39FB4713AFE12D56E4978807', '98FA556DECF04AE3AFC5997715BE55A4', 'F41218E4BA9C4B4F9BD88E8C9E0AB2CE', '9FCE56724ABB4093A093A5EB9F4CAE04', '29B7D319C9E1472796E4F7A2EBB7A591', 'C4D181E98F054803B95AFDB0BDC04240')) and (opxdvnt_wa0_.AD_Client_ID in ('86F69592CF6F405E8E7004128655A71A', '0')) order by opxdvnt_wa0_.Updated desc, opxdvnt_wa0_.Obawo_Warehouseops_V_ID desc limit '101';

Date: 2026-07-17 12:51:28
Duration: 1s460ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

select dlcep_sele0_.Dlcep_Selectlineasgrid_V_ID as dlcep_se1_377_, dlcep_sele0_.Qtyonhand as qtyonhan2_377_, dlcep_sele0_.M_Warehouse_ID as m_wareho3_377_, dlcep_sele0_.M_Product_ID as m_produc4_377_, dlcep_sele0_.Descripcion_Sofinsa as descripc5_377_, dlcep_sele0_.Precio as precio6_377_, dlcep_sele0_.M_Storage_Detail_ID as m_storag7_377_, dlcep_sele0_.Origin as origin8_377_, dlcep_sele0_.M_Attributesetinstance_ID as m_attrib9_377_, dlcep_sele0_.AD_Client_ID as ad_clie10_377_, dlcep_sele0_.AD_Org_ID as ad_org_11_377_, dlcep_sele0_.Isactive as isactiv12_377_, dlcep_sele0_.Created as created13_377_, dlcep_sele0_.Createdby as created14_377_, dlcep_sele0_.Updated as updated15_377_, dlcep_sele0_.Updatedby as updated16_377_, dlcep_sele0_.Etiqueta as etiquet17_377_, dlcep_sele0_.Description as descrip18_377_, dlcep_sele0_.Referencia_Ian as referen19_377_, dlcep_sele0_.Referencia_Oem as referen20_377_, dlcep_sele0_.Tipo_Motor as tipo_mo21_377_, dlcep_sele0_.Marca as marca22_377_, dlcep_sele0_.Modelo as modelo23_377_, dlcep_sele0_.Version as version24_377_, dlcep_sele0_.Matricula as matricu25_377_, dlcep_sele0_.verificada as verific26_377_, dlcep_sele0_.EM_Dlc_Carac_Sofinsa as em_dlc_27_377_, dlcep_sele0_.ModeloGTMotive as modelog28_377_, dlcep_sele0_.apply_dto as apply_d29_377_ from dlcep_selectlineasgrid_v dlcep_sele0_ where (dlcep_sele0_.AD_Org_ID in ('0', 'C07C523C395944EA86E2D50143CC224D', 'BD36C0BC39FB4713AFE12D56E4978807', '98FA556DECF04AE3AFC5997715BE55A4', 'F41218E4BA9C4B4F9BD88E8C9E0AB2CE', '9FCE56724ABB4093A093A5EB9F4CAE04', '29B7D319C9E1472796E4F7A2EBB7A591', 'C4D181E98F054803B95AFDB0BDC04240')) and (dlcep_sele0_.AD_Client_ID in ('86F69592CF6F405E8E7004128655A71A', '0')) and dlcep_sele0_.Isactive = 'Y' order by dlcep_sele0_.Qtyonhand desc, dlcep_sele0_.Updated desc, dlcep_sele0_.Dlcep_Selectlineasgrid_V_ID desc limit '76';

Date: 2026-07-17 13:23:04
Duration: 3s458ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select dlcep_sele0_.Dlcep_Selectlineasgrid_V_ID as dlcep_se1_377_, dlcep_sele0_.Qtyonhand as qtyonhan2_377_, dlcep_sele0_.M_Warehouse_ID as m_wareho3_377_, dlcep_sele0_.M_Product_ID as m_produc4_377_, dlcep_sele0_.Descripcion_Sofinsa as descripc5_377_, dlcep_sele0_.Precio as precio6_377_, dlcep_sele0_.M_Storage_Detail_ID as m_storag7_377_, dlcep_sele0_.Origin as origin8_377_, dlcep_sele0_.M_Attributesetinstance_ID as m_attrib9_377_, dlcep_sele0_.AD_Client_ID as ad_clie10_377_, dlcep_sele0_.AD_Org_ID as ad_org_11_377_, dlcep_sele0_.Isactive as isactiv12_377_, dlcep_sele0_.Created as created13_377_, dlcep_sele0_.Createdby as created14_377_, dlcep_sele0_.Updated as updated15_377_, dlcep_sele0_.Updatedby as updated16_377_, dlcep_sele0_.Etiqueta as etiquet17_377_, dlcep_sele0_.Description as descrip18_377_, dlcep_sele0_.Referencia_Ian as referen19_377_, dlcep_sele0_.Referencia_Oem as referen20_377_, dlcep_sele0_.Tipo_Motor as tipo_mo21_377_, dlcep_sele0_.Marca as marca22_377_, dlcep_sele0_.Modelo as modelo23_377_, dlcep_sele0_.Version as version24_377_, dlcep_sele0_.Matricula as matricu25_377_, dlcep_sele0_.verificada as verific26_377_, dlcep_sele0_.EM_Dlc_Carac_Sofinsa as em_dlc_27_377_, dlcep_sele0_.ModeloGTMotive as modelog28_377_, dlcep_sele0_.apply_dto as apply_d29_377_ from dlcep_selectlineasgrid_v dlcep_sele0_ where (dlcep_sele0_.AD_Org_ID in ('0', 'C07C523C395944EA86E2D50143CC224D', 'BD36C0BC39FB4713AFE12D56E4978807', '98FA556DECF04AE3AFC5997715BE55A4', 'F41218E4BA9C4B4F9BD88E8C9E0AB2CE', '9FCE56724ABB4093A093A5EB9F4CAE04', '29B7D319C9E1472796E4F7A2EBB7A591', 'C4D181E98F054803B95AFDB0BDC04240')) and (dlcep_sele0_.AD_Client_ID in ('86F69592CF6F405E8E7004128655A71A', '0')) and dlcep_sele0_.Isactive = 'Y' order by dlcep_sele0_.Qtyonhand desc, dlcep_sele0_.Updated desc, dlcep_sele0_.Dlcep_Selectlineasgrid_V_ID desc limit '76';

Date: 2026-07-17 11:36:50
Duration: 3s417ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select dlcep_sele0_.Dlcep_Selectlineasgrid_V_ID as dlcep_se1_377_, dlcep_sele0_.Qtyonhand as qtyonhan2_377_, dlcep_sele0_.M_Warehouse_ID as m_wareho3_377_, dlcep_sele0_.M_Product_ID as m_produc4_377_, dlcep_sele0_.Descripcion_Sofinsa as descripc5_377_, dlcep_sele0_.Precio as precio6_377_, dlcep_sele0_.M_Storage_Detail_ID as m_storag7_377_, dlcep_sele0_.Origin as origin8_377_, dlcep_sele0_.M_Attributesetinstance_ID as m_attrib9_377_, dlcep_sele0_.AD_Client_ID as ad_clie10_377_, dlcep_sele0_.AD_Org_ID as ad_org_11_377_, dlcep_sele0_.Isactive as isactiv12_377_, dlcep_sele0_.Created as created13_377_, dlcep_sele0_.Createdby as created14_377_, dlcep_sele0_.Updated as updated15_377_, dlcep_sele0_.Updatedby as updated16_377_, dlcep_sele0_.Etiqueta as etiquet17_377_, dlcep_sele0_.Description as descrip18_377_, dlcep_sele0_.Referencia_Ian as referen19_377_, dlcep_sele0_.Referencia_Oem as referen20_377_, dlcep_sele0_.Tipo_Motor as tipo_mo21_377_, dlcep_sele0_.Marca as marca22_377_, dlcep_sele0_.Modelo as modelo23_377_, dlcep_sele0_.Version as version24_377_, dlcep_sele0_.Matricula as matricu25_377_, dlcep_sele0_.verificada as verific26_377_, dlcep_sele0_.EM_Dlc_Carac_Sofinsa as em_dlc_27_377_, dlcep_sele0_.ModeloGTMotive as modelog28_377_, dlcep_sele0_.apply_dto as apply_d29_377_ from dlcep_selectlineasgrid_v dlcep_sele0_ where (dlcep_sele0_.AD_Org_ID in ('0', 'C07C523C395944EA86E2D50143CC224D', 'BD36C0BC39FB4713AFE12D56E4978807', '98FA556DECF04AE3AFC5997715BE55A4', 'F41218E4BA9C4B4F9BD88E8C9E0AB2CE', '9FCE56724ABB4093A093A5EB9F4CAE04', '29B7D319C9E1472796E4F7A2EBB7A591', 'C4D181E98F054803B95AFDB0BDC04240')) and (dlcep_sele0_.AD_Client_ID in ('86F69592CF6F405E8E7004128655A71A', '0')) and dlcep_sele0_.Isactive = 'Y' order by dlcep_sele0_.Qtyonhand desc, dlcep_sele0_.Updated desc, dlcep_sele0_.Dlcep_Selectlineasgrid_V_ID desc limit '76';

Date: 2026-07-17 09:11:01
Duration: 3s404ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

x Hide

select opxdvnt_wa0_.Obawo_Warehouseops_V_ID as obawo_wa1_983_, opxdvnt_wa0_.M_Product_ID as m_produc2_983_, opxdvnt_wa0_.M_Locator_ID as m_locato3_983_, opxdvnt_wa0_.M_Attributesetinstance_ID as m_attrib4_983_, opxdvnt_wa0_.C_Uom_ID as c_uom_id5_983_, opxdvnt_wa0_.M_Product_Uom_ID as m_produc6_983_, opxdvnt_wa0_.QtyOnHand as qtyonhan7_983_, opxdvnt_wa0_.QtyOrderOnHand as qtyorder8_983_, opxdvnt_wa0_.Datelastinventory as datelast9_983_, opxdvnt_wa0_.Preqtyonhand as preqtyo10_983_, opxdvnt_wa0_.Preqtyorderonhand as preqtyo11_983_, opxdvnt_wa0_.AD_Client_ID as ad_clie12_983_, opxdvnt_wa0_.AD_Org_ID as ad_org_13_983_, opxdvnt_wa0_.Isactive as isactiv14_983_, opxdvnt_wa0_.Created as created15_983_, opxdvnt_wa0_.Createdby as created16_983_, opxdvnt_wa0_.Updated as updated17_983_, opxdvnt_wa0_.Updatedby as updated18_983_, opxdvnt_wa0_.M_Storage_Detail_ID as m_stora19_983_, opxdvnt_wa0_.ReservedQty as reserve20_983_, opxdvnt_wa0_.Allocatedqty as allocat21_983_, opxdvnt_wa0_.Generate_Invprop as generat22_983_, opxdvnt_wa0_.Generate_Recount as generat23_983_, opxdvnt_wa0_.Move as move24_983_, opxdvnt_wa0_.Putaway as putaway25_983_, opxdvnt_wa0_.Change_Status as change_26_983_, opxdvnt_wa0_.Edit_attributes as edit_at27_983_, opxdvnt_wa0_.Insert_attributes as insert_28_983_, opxdvnt_wa0_.M_Warehouse_ID as m_wareh29_983_, opxdvnt_wa0_.Obawo_Locator_Group_ID as obawo_l30_983_, opxdvnt_wa0_.Obawo_Internal_Routing_Area_ID as obawo_i31_983_, opxdvnt_wa0_.M_Inventorystatus_ID as m_inven32_983_, opxdvnt_wa0_.BoxInPlanned as boxinpl33_983_, opxdvnt_wa0_.Unbox as unbox34_983_, opxdvnt_wa0_.M_Refinventory_ID as m_refin35_983_, opxdvnt_wa0_.Vincularstock as vincula36_983_, opxdvnt_wa0_.EM_Dlc_Descripcion_Sofinsa as em_dlc_37_983_, opxdvnt_wa0_.Stock_Menos_Uno as stock_m38_983_, opxdvnt_wa0_.Precio as precio39_983_, opxdvnt_wa0_.modelogt as modelog40_983_ from OPXDVNT_warehouseops_v opxdvnt_wa0_ left outer join M_Storage_Detail materialmg1_ on opxdvnt_wa0_.M_Storage_Detail_ID = materialmg1_.M_Storage_Detail_ID where (exists ( select 1 from AD_OrgInfo organizati2_ where organizati2_.AD_Org_ID = opxdvnt_wa0_.AD_Org_ID and organizati2_.EM_Obawo_Awo_Flow = 'Y')) and not (exists ( select 1 from M_RefInventory materialmg3_ where materialmg3_.EM_Dlcs_Excluir_Ventas = 'Y' and materialmg3_.M_RefInventory_ID = opxdvnt_wa0_.M_Refinventory_ID)) and opxdvnt_wa0_.M_Warehouse_ID = 'FCA81F56E9E643E096E86F5F379459FB' and (opxdvnt_wa0_.AD_Org_ID in ('0', 'C07C523C395944EA86E2D50143CC224D', 'BD36C0BC39FB4713AFE12D56E4978807', '98FA556DECF04AE3AFC5997715BE55A4', 'F41218E4BA9C4B4F9BD88E8C9E0AB2CE', '9FCE56724ABB4093A093A5EB9F4CAE04', '29B7D319C9E1472796E4F7A2EBB7A591', 'C4D181E98F054803B95AFDB0BDC04240')) and (opxdvnt_wa0_.AD_Client_ID in ('86F69592CF6F405E8E7004128655A71A', '0')) order by materialmg1_.EM_Dlc_Etiqueta, opxdvnt_wa0_.Obawo_Warehouseops_V_ID limit '101';

Date: 2026-07-17 10:50:56
Duration: 2s669ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select opxdvnt_wa0_.Obawo_Warehouseops_V_ID as obawo_wa1_983_, opxdvnt_wa0_.M_Product_ID as m_produc2_983_, opxdvnt_wa0_.M_Locator_ID as m_locato3_983_, opxdvnt_wa0_.M_Attributesetinstance_ID as m_attrib4_983_, opxdvnt_wa0_.C_Uom_ID as c_uom_id5_983_, opxdvnt_wa0_.M_Product_Uom_ID as m_produc6_983_, opxdvnt_wa0_.QtyOnHand as qtyonhan7_983_, opxdvnt_wa0_.QtyOrderOnHand as qtyorder8_983_, opxdvnt_wa0_.Datelastinventory as datelast9_983_, opxdvnt_wa0_.Preqtyonhand as preqtyo10_983_, opxdvnt_wa0_.Preqtyorderonhand as preqtyo11_983_, opxdvnt_wa0_.AD_Client_ID as ad_clie12_983_, opxdvnt_wa0_.AD_Org_ID as ad_org_13_983_, opxdvnt_wa0_.Isactive as isactiv14_983_, opxdvnt_wa0_.Created as created15_983_, opxdvnt_wa0_.Createdby as created16_983_, opxdvnt_wa0_.Updated as updated17_983_, opxdvnt_wa0_.Updatedby as updated18_983_, opxdvnt_wa0_.M_Storage_Detail_ID as m_stora19_983_, opxdvnt_wa0_.ReservedQty as reserve20_983_, opxdvnt_wa0_.Allocatedqty as allocat21_983_, opxdvnt_wa0_.Generate_Invprop as generat22_983_, opxdvnt_wa0_.Generate_Recount as generat23_983_, opxdvnt_wa0_.Move as move24_983_, opxdvnt_wa0_.Putaway as putaway25_983_, opxdvnt_wa0_.Change_Status as change_26_983_, opxdvnt_wa0_.Edit_attributes as edit_at27_983_, opxdvnt_wa0_.Insert_attributes as insert_28_983_, opxdvnt_wa0_.M_Warehouse_ID as m_wareh29_983_, opxdvnt_wa0_.Obawo_Locator_Group_ID as obawo_l30_983_, opxdvnt_wa0_.Obawo_Internal_Routing_Area_ID as obawo_i31_983_, opxdvnt_wa0_.M_Inventorystatus_ID as m_inven32_983_, opxdvnt_wa0_.BoxInPlanned as boxinpl33_983_, opxdvnt_wa0_.Unbox as unbox34_983_, opxdvnt_wa0_.M_Refinventory_ID as m_refin35_983_, opxdvnt_wa0_.Vincularstock as vincula36_983_, opxdvnt_wa0_.EM_Dlc_Descripcion_Sofinsa as em_dlc_37_983_, opxdvnt_wa0_.Stock_Menos_Uno as stock_m38_983_, opxdvnt_wa0_.Precio as precio39_983_, opxdvnt_wa0_.modelogt as modelog40_983_ from OPXDVNT_warehouseops_v opxdvnt_wa0_ left outer join M_Storage_Detail materialmg1_ on opxdvnt_wa0_.M_Storage_Detail_ID = materialmg1_.M_Storage_Detail_ID where (exists ( select 1 from AD_OrgInfo organizati2_ where organizati2_.AD_Org_ID = opxdvnt_wa0_.AD_Org_ID and organizati2_.EM_Obawo_Awo_Flow = 'Y')) and not (exists ( select 1 from M_RefInventory materialmg3_ where materialmg3_.EM_Dlcs_Excluir_Ventas = 'Y' and materialmg3_.M_RefInventory_ID = opxdvnt_wa0_.M_Refinventory_ID)) and opxdvnt_wa0_.M_Warehouse_ID = 'FCA81F56E9E643E096E86F5F379459FB' and (opxdvnt_wa0_.AD_Org_ID in ('0', 'C07C523C395944EA86E2D50143CC224D', 'BD36C0BC39FB4713AFE12D56E4978807', '98FA556DECF04AE3AFC5997715BE55A4', 'F41218E4BA9C4B4F9BD88E8C9E0AB2CE', '9FCE56724ABB4093A093A5EB9F4CAE04', '29B7D319C9E1472796E4F7A2EBB7A591', 'C4D181E98F054803B95AFDB0BDC04240')) and (opxdvnt_wa0_.AD_Client_ID in ('86F69592CF6F405E8E7004128655A71A', '0')) order by materialmg1_.EM_Dlc_Etiqueta, opxdvnt_wa0_.Obawo_Warehouseops_V_ID limit '101';

Date: 2026-07-17 13:55:40
Duration: 2s479ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo

select opxdvnt_wa0_.Obawo_Warehouseops_V_ID as obawo_wa1_983_, opxdvnt_wa0_.M_Product_ID as m_produc2_983_, opxdvnt_wa0_.M_Locator_ID as m_locato3_983_, opxdvnt_wa0_.M_Attributesetinstance_ID as m_attrib4_983_, opxdvnt_wa0_.C_Uom_ID as c_uom_id5_983_, opxdvnt_wa0_.M_Product_Uom_ID as m_produc6_983_, opxdvnt_wa0_.QtyOnHand as qtyonhan7_983_, opxdvnt_wa0_.QtyOrderOnHand as qtyorder8_983_, opxdvnt_wa0_.Datelastinventory as datelast9_983_, opxdvnt_wa0_.Preqtyonhand as preqtyo10_983_, opxdvnt_wa0_.Preqtyorderonhand as preqtyo11_983_, opxdvnt_wa0_.AD_Client_ID as ad_clie12_983_, opxdvnt_wa0_.AD_Org_ID as ad_org_13_983_, opxdvnt_wa0_.Isactive as isactiv14_983_, opxdvnt_wa0_.Created as created15_983_, opxdvnt_wa0_.Createdby as created16_983_, opxdvnt_wa0_.Updated as updated17_983_, opxdvnt_wa0_.Updatedby as updated18_983_, opxdvnt_wa0_.M_Storage_Detail_ID as m_stora19_983_, opxdvnt_wa0_.ReservedQty as reserve20_983_, opxdvnt_wa0_.Allocatedqty as allocat21_983_, opxdvnt_wa0_.Generate_Invprop as generat22_983_, opxdvnt_wa0_.Generate_Recount as generat23_983_, opxdvnt_wa0_.Move as move24_983_, opxdvnt_wa0_.Putaway as putaway25_983_, opxdvnt_wa0_.Change_Status as change_26_983_, opxdvnt_wa0_.Edit_attributes as edit_at27_983_, opxdvnt_wa0_.Insert_attributes as insert_28_983_, opxdvnt_wa0_.M_Warehouse_ID as m_wareh29_983_, opxdvnt_wa0_.Obawo_Locator_Group_ID as obawo_l30_983_, opxdvnt_wa0_.Obawo_Internal_Routing_Area_ID as obawo_i31_983_, opxdvnt_wa0_.M_Inventorystatus_ID as m_inven32_983_, opxdvnt_wa0_.BoxInPlanned as boxinpl33_983_, opxdvnt_wa0_.Unbox as unbox34_983_, opxdvnt_wa0_.M_Refinventory_ID as m_refin35_983_, opxdvnt_wa0_.Vincularstock as vincula36_983_, opxdvnt_wa0_.EM_Dlc_Descripcion_Sofinsa as em_dlc_37_983_, opxdvnt_wa0_.Stock_Menos_Uno as stock_m38_983_, opxdvnt_wa0_.Precio as precio39_983_, opxdvnt_wa0_.modelogt as modelog40_983_ from OPXDVNT_warehouseops_v opxdvnt_wa0_ left outer join M_Storage_Detail materialmg1_ on opxdvnt_wa0_.M_Storage_Detail_ID = materialmg1_.M_Storage_Detail_ID where (exists ( select 1 from AD_OrgInfo organizati2_ where organizati2_.AD_Org_ID = opxdvnt_wa0_.AD_Org_ID and organizati2_.EM_Obawo_Awo_Flow = 'Y')) and not (exists ( select 1 from M_RefInventory materialmg3_ where materialmg3_.EM_Dlcs_Excluir_Ventas = 'Y' and materialmg3_.M_RefInventory_ID = opxdvnt_wa0_.M_Refinventory_ID)) and opxdvnt_wa0_.M_Warehouse_ID = 'FCA81F56E9E643E096E86F5F379459FB' and (opxdvnt_wa0_.AD_Org_ID in ('0', 'C07C523C395944EA86E2D50143CC224D', 'BD36C0BC39FB4713AFE12D56E4978807', '98FA556DECF04AE3AFC5997715BE55A4', 'F41218E4BA9C4B4F9BD88E8C9E0AB2CE', '9FCE56724ABB4093A093A5EB9F4CAE04', '29B7D319C9E1472796E4F7A2EBB7A591', 'C4D181E98F054803B95AFDB0BDC04240')) and (opxdvnt_wa0_.AD_Client_ID in ('86F69592CF6F405E8E7004128655A71A', '0')) order by materialmg1_.EM_Dlc_Etiqueta, opxdvnt_wa0_.Obawo_Warehouseops_V_ID limit '101';

Date: 2026-07-17 14:25:23
Duration: 2s468ms
Database: etendo
User: tad
Remote: 127.0.0.1
Application: openbravo