select "_"."c_order_id" as "c_order_id", ;

[ Date: 2026-07-18 06:06:16 - Database: etendo - User: tad - Remote: 51.38.221.201 - Application: Mashup Engine ]

select "_"."c_order_id" as "c_order_id", ;

[ Date: 2026-07-18 07:34:53 - Database: etendo - User: tad - Remote: 51.38.221.201 - Application: Mashup Engine ]

select "_"."c_order_id" as "c_order_id", ;

[ Date: 2026-07-18 07:36:10 - Database: etendo - User: tad - Remote: 51.38.221.201 - Application: Mashup Engine ]

select "_"."c_order_id" as "c_order_id", ;

[ Date: 2026-07-18 08:10:34 - Database: etendo - User: tad - Remote: 51.38.221.201 - Application: Mashup Engine ]

select "_"."c_order_id" as "c_order_id", ;

[ Date: 2026-07-18 09:11:38 - Database: etendo - User: tad - Remote: 51.38.221.201 - Application: Mashup Engine ]

select "_"."c_order_id" as "c_order_id", ;

[ Date: 2026-07-18 13:13:02 - Database: etendo - User: tad - Remote: 51.38.221.201 - Application: Mashup Engine ]

select "_"."c_order_id" as "c_order_id", ;

[ Date: 2026-07-18 16:10:42 - Database: etendo - User: tad - Remote: 51.38.221.201 - Application: Mashup Engine ]

select "_"."c_order_id" as "c_order_id", ;

[ Date: 2026-07-18 07:35:28 - Database: etendo - User: tad - Remote: 51.38.221.201 - Application: Mashup Engine ]

select "_"."c_order_id" as "c_order_id", ;

[ Date: 2026-07-18 14:07:55 - Database: etendo - User: tad - Remote: 51.38.221.201 - Application: Mashup Engine ]

INSERT INTO ma_processplan_tot_aux (ma_processplan_tot_aux_id, ma_processplan_id, ma_processplan_version_id, dependantproduct, depqty, produced, proqty) SELECT get_uuid (), ma_processplan_id, ma_processplan_version_id, dependantproduct, depqty, produced, proqty FROM ma_processplan_totalized where ma_processplan_version_id = advmrp_get_pp_version (ma_processplan_id, trunc(to_date('18-07-2026', 'dd-MM-yyyy')));

[ Date: 2026-07-18 06:03:14 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]

INSERT INTO ma_processplan_tot_aux (ma_processplan_tot_aux_id, ma_processplan_id, ma_processplan_version_id, dependantproduct, depqty, produced, proqty) SELECT get_uuid (), ma_processplan_id, ma_processplan_version_id, dependantproduct, depqty, produced, proqty FROM ma_processplan_totalized where ma_processplan_version_id = advmrp_get_pp_version (ma_processplan_id, trunc(to_date('18-07-2026', 'dd-MM-yyyy')));

[ Date: 2026-07-18 06:03:14 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]

select "_"."m_inout_id" as "m_inout_id", ;

[ Date: 2026-07-18 07:35:27 - Database: etendo - User: tad - Remote: 51.38.221.201 - Application: Mashup Engine ]

select "_"."m_inout_id" as "m_inout_id", ;

[ Date: 2026-07-18 14:07:37 - Database: etendo - User: tad - Remote: 51.38.221.201 - Application: Mashup Engine ]

select ad_column_identifier_std ('ad_org', '5E01F0FAFDBD4F0ABC82A5B031723084') as ad_org, fash_lobparent, fash_lob, collection, campaign, nameproduct, case when aextenguir = 'Y' then concat('*', ad_column_identifier_std ('m_product', m_product_id)) else ad_column_identifier_std ('m_product', m_product_id) end as m_product, pendienteprendas, stock, characteristic_desc, productonombre, stock - pendienteprendas as saldocartera, greatest (productproduction, 0) as productproduction, consumption, greatest (pendientecompras, 0) as pendientecompras, (stock - pendienteprendas) + greatest (productproduction, 0) + greatest (pendientecompras, 0) - consumption as saldoprod, bass_tejidocalculo ('5E01F0FAFDBD4F0ABC82A5B031723084', m_product_id, 0) as mes0, to_char(add_months (TO_DATE(NOW()), 0), 'Month') as namemes0, bass_tejidocalculo ('5E01F0FAFDBD4F0ABC82A5B031723084', m_product_id, -1) as mes1, to_char(add_months (TO_DATE(NOW()), -1), 'Month') as namemes1, bass_tejidocalculo ('5E01F0FAFDBD4F0ABC82A5B031723084', m_product_id, -2) as mes2, to_char(add_months (TO_DATE(NOW()), -2), 'Month') as namemes2, bass_tejidocalculo ('5E01F0FAFDBD4F0ABC82A5B031723084', m_product_id, -3) as mes3, to_char(add_months (TO_DATE(NOW()), -3), 'Month') as namemes3, bass_tejidocalculo ('5E01F0FAFDBD4F0ABC82A5B031723084', m_product_id, -4) as mes4, to_char(add_months (TO_DATE(NOW()), -4), 'Month') as namemes4, bass_tejidocalculo ('5E01F0FAFDBD4F0ABC82A5B031723084', m_product_id, -5) as mes5, to_char(add_months (TO_DATE(NOW()), -5), 'Month') as namemes5, bass_tejidocalculo ('5E01F0FAFDBD4F0ABC82A5B031723084', m_product_id, -6) as mes6, to_char(add_months (TO_DATE(NOW()), -6), 'Month') as namemes6, bass_tejidocalculo ('5E01F0FAFDBD4F0ABC82A5B031723084', m_product_id, -7) as mes7, to_char(add_months (TO_DATE(NOW()), -7), 'Month') as namemes7, bass_tejidocalculo ('5E01F0FAFDBD4F0ABC82A5B031723084', m_product_id, -8) as mes8, to_char(add_months (TO_DATE(NOW()), -8), 'Month') as namemes8, bass_tejidocalculo ('5E01F0FAFDBD4F0ABC82A5B031723084', m_product_id, -9) as mes9, to_char(add_months (TO_DATE(NOW()), -9), 'Month') as namemes9, bass_tejidocalculo ('5E01F0FAFDBD4F0ABC82A5B031723084', m_product_id, -10) as mes10, to_char(add_months (TO_DATE(NOW()), -10), 'Month') as namemes10, bass_tejidocalculo ('5E01F0FAFDBD4F0ABC82A5B031723084', m_product_id, -11) as mes11, to_char(add_months (TO_DATE(NOW()), -11), 'Month') as namemes11, bass_tejidocalculo ('5E01F0FAFDBD4F0ABC82A5B031723084', m_product_id, -12) as mes12, to_char(add_months (TO_DATE(NOW()), -12), 'Month') as namemes12, bass_tejidocalculoperiodo ('5E01F0FAFDBD4F0ABC82A5B031723084', m_product_id, '01-' || to_number(to_char(NOW(), 'YYYY')) - 1, '12-' || to_number(to_char(NOW(), 'YYYY')) - 1) as anoanterior, bass_tejidocalculoperiodo ('5E01F0FAFDBD4F0ABC82A5B031723084', m_product_id, '01-' || to_number(to_char(NOW(), 'YYYY')), '12-' || to_number(to_char(NOW(), 'YYYY'))) as anoactual, minpr from ( select case when fash_lob_parent.name is null then fash_lob.name else fash_lob_parent.name end as fash_lobparent, fash_lob.name as fash_lob, fash_collection.name as collection, c_campaign.name as campaign, m_product.m_product_id, m_product.upc, (m_product.name || ' - ' || m_product_category.value) as nameproduct, m_product.characteristic_desc, m_product.name as productonombre, round(bass_pendienteprenda (m_product.m_product_id, '5E01F0FAFDBD4F0ABC82A5B031723084'), 2) as pendienteprendas, coalesce(( select sum(a) from ( select sum((advpro2_outsourcing_phase.quantity - ( select coalesce(sum(productionqty), 0) from m_productionplan where m_productionplan_id in ( select m_productionplan_id from advpro2_outsourcing_plan where advpro2_outsourcing_phase_id = advpro2_outsourcing_phase.advpro2_outsourcing_phase_id))) * ma_wrphaseproduct.movementqty) as a, ma_wrphaseproduct.m_product_id from advpro2_outsourcing inner join advpro2_outsourcing_phase on advpro2_outsourcing.advpro2_outsourcing_id = advpro2_outsourcing_phase.advpro2_outsourcing_id inner join c_bpartner on advpro2_outsourcing.c_bpartner_id = c_bpartner.c_bpartner_id --and c_bpartner.em_bass_workshoptype='A' left join ma_wrphase on advpro2_outsourcing_phase.ma_wrphase_id = ma_wrphase.ma_wrphase_id left join ma_wrphaseproduct on ma_wrphase.ma_wrphase_id = ma_wrphaseproduct.ma_wrphase_id and ma_wrphaseproduct.productiontype = '+' where advpro2_outsourcing.status in ('DE', 'PL') and advpro2_outsourcing.ad_org_id in ( select org.ad_org_id from ad_org org where AD_ISORGINCLUDED (org.ad_org_id, 'ABB79999997E423B85B205975E7A9BD8', org.ad_client_id) > 0) group by ma_wrphaseproduct.m_product_id) as ab where ab.m_product_id = m_product.m_product_id group by ab.m_product_id), 0) as productproduction, coalesce(round(( select sum(movementqty) from m_transaction where m_transaction.m_product_id = m_product.m_product_id and m_locator_id in ( select m_locator_id from m_locator where m_warehouse_id in ( select distinct m_warehouse_id from ad_org_warehouse where ad_org_warehouse.ad_org_id in ( select org.ad_org_id from ad_org org where AD_ISORGINCLUDED (org.ad_org_id, 'ABB79999997E423B85B205975E7A9BD8', org.ad_client_id) > 0)))), 3), 0) as stock, coalesce(round(( select sum(pending) from ( select (c_orderline.qtyordered - coalesce(sum(m_inoutline.movementqty), 0)) pending, c_orderline.m_product_id, c_orderline.c_orderline_id from c_orderline inner join c_order on c_orderline.c_order_id = c_order.c_order_id and c_order.issotrx = 'N' and c_order.docstatus = 'CO' left join m_inoutline on c_orderline.c_orderline_id = m_inoutline.c_orderline_id where c_order.ad_org_id in ( select org.ad_org_id from ad_org org where AD_ISORGINCLUDED (org.ad_org_id, 'ABB79999997E423B85B205975E7A9BD8', org.ad_client_id) > 0) group by c_orderline.m_product_id, c_orderline.c_orderline_id, c_orderline.qtyordered having coalesce(sum(movementqty), 0) & lt; qtyordered) as a where a.m_product_id = m_product.m_product_id group by a.m_product_id), 3), 0) as pendientecompras, round(coalesce(( select sum(a) from ( select sum((advpro2_outsourcing_phase.quantity - ( select coalesce(sum(productionqty), 0) from m_productionplan where m_productionplan_id in ( select m_productionplan_id from advpro2_outsourcing_plan where advpro2_outsourcing_phase_id = advpro2_outsourcing_phase.advpro2_outsourcing_phase_id))) * ma_wrphaseproduct.movementqty) as a, ma_wrphaseproduct.m_product_id from advpro2_outsourcing inner join advpro2_outsourcing_phase on advpro2_outsourcing.advpro2_outsourcing_id = advpro2_outsourcing_phase.advpro2_outsourcing_id and quantity > ( select coalesce(sum(pp.productionqty), 0) from advpro2_outsourcing_plan p left join m_productionplan pp ON pp.m_productionplan_id = p.m_productionplan_id where p.advpro2_outsourcing_phase_id = advpro2_outsourcing_phase.advpro2_outsourcing_phase_id) inner join c_bpartner on advpro2_outsourcing.c_bpartner_id = c_bpartner.c_bpartner_id --and c_bpartner.em_bass_workshoptype in ('A','C') left join ma_wrphase on advpro2_outsourcing_phase.ma_wrphase_id = ma_wrphase.ma_wrphase_id left join ma_wrphaseproduct on ma_wrphase.ma_wrphase_id = ma_wrphaseproduct.ma_wrphase_id and ma_wrphaseproduct.productiontype = '-' where advpro2_outsourcing.status in ('DE', 'PL') and advpro2_outsourcing.ad_org_id in ( select org.ad_org_id from ad_org org where AD_ISORGINCLUDED (org.ad_org_id, 'ABB79999997E423B85B205975E7A9BD8', org.ad_client_id) > 0) group by ma_wrphaseproduct.m_product_id) as ab where ab.m_product_id = m_product.m_product_id group by ab.m_product_id), 0), 2) as consumption, m_product.em_bass_isextinct as aextenguir, coalesce(( select sm.stockmin from bass_stockmin_product sm where sm.m_product_id = m_product.m_product_id and sm.typestockmin = 'PROD'), ( select sm.stockmin from bass_stockmin_product sm where sm.m_product_id = m_product.generic_product_id and sm.typestockmin = 'PROD')) as minpr from m_product left join m_product_category on m_product.m_product_category_id = m_product_category.m_product_category_id left join fash_lob on m_product.em_fash_lob_id = fash_lob.fash_lob_id left join fash_lob as fash_lob_parent on fash_lob.fash_lob_parent_id = fash_lob_parent.fash_lob_id left join fash_collection on m_product.em_fash_collection_id = fash_collection.fash_collection_id left join c_campaign on m_product.em_fash_campaign_id = c_campaign.c_campaign_id inner join fash_product_group on m_product.em_fash_product_group_id = fash_product_group.fash_product_group_id and fash_product_group.value in ('T', 'H') left join m_product_org on m_product_org.m_product_id = m_product.m_product_id where 1 = 1 and fash_product_group.fash_product_group_id = '64A90E24B2CD40329E49EA983AA21E7C' and m_product.m_product_id not in ( select m_product.m_product_id from m_product inner join ma_processplan on m_product.ma_processplan_id = ma_processplan.ma_processplan_id inner join ma_processplan_version on ma_processplan.ma_processplan_id = ma_processplan_version.ma_processplan_id inner join ma_sequence on ma_processplan_version.ma_processplan_version_id = ma_sequence.ma_processplan_version_id inner join ma_sequenceproduct on ma_sequence.ma_sequence_id = ma_sequenceproduct.ma_sequence_id and productiontype = '-' where m_product.ma_processplan_id is not null and m_product.m_product_id = ma_sequenceproduct.m_product_id) and ( case when 'active' = 'active' then m_product.isactive = 'Y' when 'active' = 'nonactive' then m_product.isactive = 'N' else 2 = 2 end) and ( case when '5E01F0FAFDBD4F0ABC82A5B031723084' = 'ABB79999997E423B85B205975E7A9BD8' then coalesce(m_product_org.EM_Advmrp_Org_ID, '') not in ('7394B891BC824F24821ACCEBC3A06829') else 1 = 1 end)) as nv where (nv.pendienteprendas + nv.productproduction + nv.stock + nv.pendientecompras + nv.consumption + coalesce((bass_tejidocalculoperiodo ('5E01F0FAFDBD4F0ABC82A5B031723084', m_product_id, '01-' || to_number(to_char(NOW(), 'YYYY')) - 1, '12-' || to_number(to_char(NOW(), 'YYYY')) - 1)), 0) + coalesce((bass_tejidocalculoperiodo ('5E01F0FAFDBD4F0ABC82A5B031723084', m_product_id, '01-' || to_number(to_char(NOW(), 'YYYY')), '12-' || to_number(to_char(NOW(), 'YYYY')))), 0)) <> 0 order by collection, campaign, fash_lobparent, fash_lob, productonombre, nameproduct, characteristic_desc;

[ Date: 2026-07-18 07:09:13 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

SELECT ADVMRP_RUN_INITIALIZE2 ('7DD4A9542681481FBA6B1F37D04D4BBB', 'ABB79999997E423B85B205975E7A9BD8', '7E3CD157DC6246718BFBF101DCDC4016', 'A329EC7554E14ECFBD131CF0BA23BD8F', NULL, NULL, NULL, NULL, NULL, NULL, '180', '2026-07-18 00:00:00', 'Y', NULL, 'GPP', 'N') AS RESULT FROM DUAL;

[ Date: 2026-07-18 06:02:56 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

SELECT M_INITIALIZE_STOCK_VALUATION ('7E3CD157DC6246718BFBF101DCDC4016', 'ABB79999997E423B85B205975E7A9BD8', NULL) AS RESULT FROM DUAL;

[ Date: 2026-07-18 07:01:58 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

SELECT OL.c_orderline_id, O.documentno, OL.c_order_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, OL.c_currency_id, OL.m_product_id, OL.m_warehouse_id, P.m_product_category_id, P."name" as "Product Name", mpc.name as "Category Name", fpc.name as "Product Composition Name", cc.name as "Product Campaign Name", fc.name as "Product Collection Name", fl.name as "Product LOB Name", ( select m_ch_value.name from m_product_ch_value left join m_ch_value on m_ch_value.m_ch_value_id = m_product_ch_value.m_ch_value_id where m_product_ch_value.m_product_id = p.m_product_id and m_product_ch_value.m_characteristic_id = 'C6144F9D37094292AE20EFC8CC3D1E25') as talla, ( select m_ch_value.name from m_product_ch_value left join m_ch_value on m_ch_value.m_ch_value_id = m_product_ch_value.m_ch_value_id where m_product_ch_value.m_product_id = p.m_product_id and m_product_ch_value.m_characteristic_id = 'B4BB8A1747D74B978E73E5F18F8E1BD0') as color, OL.line, OL.dateordered as "Fecha Pedido", OL.datepromised as "Fecha Comprometida", O.datepromised as "Fecha Comprometida Ped", OL.datedelivered as "Fecha Enviada", OL.description as "Descripción", OL.qtyordered "Cantidad Pedido", OL.qtydelivered "Cantidad Enviada", OL.pricelist "Precio Lista", OL.priceactual "Precio Actual", OL.pricelimit "Precio Limite", OL.linenetamt "Importe Linea", OL.discount as "Descuento", ( SELECT SUM(movementqty) FROM m_inoutline IOL WHERE IOL.c_orderline_id = OL.c_orderline_id) as "Cantidad Enviada Alb", ( SELECT MAX(movementdate) FROM m_inoutline IOL INNER JOIN m_inout IO on IO.m_inout_id = IOL.m_inout_id WHERE IOL.c_orderline_id = OL.c_orderline_id) as "Fecha Ultimo Envio" FROM c_orderline OL LEFT JOIN c_order O on O.c_order_id = OL.c_order_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id left join c_doctype on c_doctype.c_doctype_id = O.c_doctypetarget_id left join m_product_category mpc on mpc.m_product_category_id = P.m_product_category_id left join fash_prod_composition fpc on fpc.fash_prod_composition_id = P.em_fash_prod_composition_id left join c_campaign cc on cc.c_campaign_id = P.em_fash_campaign_id left join fash_collection fc on fc.fash_collection_id = P.em_fash_collection_id left join fash_lob fl on fl.fash_lob_id = P.em_fash_lob_id WHERE 1 = 1 and O.dateordered between to_date('01-01-2018', 'dd-mm-yyyy') and to_date(current_date) and O.issotrx = 'Y' and O.docstatus in ('CO', 'CL') --and c_doctype.isreturn = 'N' and c_doctype.docsubtypeso not in ('OB', 'ON');

[ Date: 2026-07-18 07:35:58 - Database: etendo - User: tad - Remote: 51.38.221.201 - Application: Mashup Engine - Bind query: yes ]

select "_"."c_orderline_id" as "c_orderline_id", "_"."documentno" as "documentno", "_"."c_order_id" as "c_order_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."Product Name" as "Product Name", "_"."Category Name" as "Category Name", "_"."Product Composition Name" as "Product Composition Name", "_"."Product Campaign Name" as "Product Campaign Name", "_"."Product Collection Name" as "Product Collection Name", "_"."Product LOB Name" as "Product LOB Name", "_"."line" as "line", cast("_"."Fecha Pedido" as date) as "Fecha Pedido", "_"."Fecha Comprometida" as "Fecha Comprometida", "_"."Fecha Comprometida Ped" as "Fecha Comprometida Ped", "_"."Fecha Enviada" as "Fecha Enviada", "_"."Descripción" as "Descripción", "_"."Cantidad Pedido" as "Cantidad Pedido", "_"."Cantidad Enviada" as "Cantidad Enviada", "_"."Precio Lista" as "Precio Lista", "_"."Precio Actual" as "Precio Actual", "_"."Precio Limite" as "Precio Limite", "_"."Importe Linea" as "Importe Linea", "_"."Importe Inicial L" as "Importe Inicial L", "_"."Descuento" as "Descuento" from ( SELECT OL.c_orderline_id, O.documentno, OL.c_order_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, OL.c_currency_id, OL.m_product_id, OL.m_warehouse_id, P.m_product_category_id, P."name" as "Product Name", mpc.name as "Category Name", fpc.name as "Product Composition Name", cc.name as "Product Campaign Name", fc.name as "Product Collection Name", fl.name as "Product LOB Name", OL.line, OL.dateordered as "Fecha Pedido", OL.datepromised as "Fecha Comprometida", O.datepromised as "Fecha Comprometida Ped", OL.datedelivered as "Fecha Enviada", OL.description as "Descripción", OL.qtyordered "Cantidad Pedido", OL.qtydelivered "Cantidad Enviada", OL.pricelist "Precio Lista", OL.priceactual "Precio Actual", OL.pricelimit "Precio Limite", OL.linenetamt "Importe Linea", OL.em_prouti_linenetamtinitial "Importe Inicial L", OL.discount as "Descuento" FROM c_orderline OL LEFT JOIN c_order O on O.c_order_id = OL.c_order_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id left join c_doctype on c_doctype.c_doctype_id = O.c_doctypetarget_id left join m_product_category mpc on mpc.m_product_category_id = P.m_product_category_id left join fash_prod_composition fpc on fpc.fash_prod_composition_id = P.em_fash_prod_composition_id left join c_campaign cc on cc.c_campaign_id = P.em_fash_campaign_id left join fash_collection fc on fc.fash_collection_id = P.em_fash_collection_id left join fash_lob fl on fl.fash_lob_id = P.em_fash_lob_id WHERE 1 = 1 and O.dateordered between to_date('01-01-2018', 'dd-mm-yyyy') and to_date(current_date) and O.issotrx = 'Y' and c_doctype.docsubtypeso not in ('OB', 'ON') and c_doctype.isreturn = 'N' and O.docstatus in ('CL', 'CO') union all SELECT OL.c_orderline_id, O.documentno, OL.c_order_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, OL.c_currency_id, OL.m_product_id, OL.m_warehouse_id, P.m_product_category_id, P."name" as "Product Name", mpc.name as "Category Name", fpc.name as "Product Composition Name", cc.name as "Product Campaign Name", fc.name as "Product Collection Name", fl.name as "Product LOB Name", OL.line, OL.dateordered as "Fecha Pedido", OL.datepromised as "Fecha Comprometida", O.datepromised as "Fecha Comprometida Ped", OL.datedelivered as "Fecha Enviada", OL.description as "Descripción", OL.qtyordered "Cantidad Pedido", OL.qtydelivered "Cantidad Enviada", OL.pricelist "Precio Lista", OL.priceactual "Precio Actual", OL.pricelimit "Precio Limite", OL.linenetamt "Importe Linea", OL.linenetamt "Importe Inicial L", OL.discount as "Descuento" FROM c_orderline OL LEFT JOIN c_order O on O.c_order_id = OL.c_order_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id left join c_doctype on c_doctype.c_doctype_id = O.c_doctypetarget_id left join m_product_category mpc on mpc.m_product_category_id = P.m_product_category_id left join fash_prod_composition fpc on fpc.fash_prod_composition_id = P.em_fash_prod_composition_id left join c_campaign cc on cc.c_campaign_id = P.em_fash_campaign_id left join fash_collection fc on fc.fash_collection_id = P.em_fash_collection_id left join fash_lob fl on fl.fash_lob_id = P.em_fash_lob_id WHERE 1 = 1 and O.dateordered between to_date('01-01-2018', 'dd-mm-yyyy') and to_date(current_date) and O.issotrx = 'Y' and c_doctype.docsubtypeso not in ('OB', 'ON') and c_doctype.isreturn = 'Y' and O.docstatus in ('CL', 'CO')) "_";

[ Date: 2026-07-18 07:35:40 - Database: etendo - User: tad - Remote: 51.38.221.201 - Application: Mashup Engine - Bind query: yes ]

select "_"."c_orderline_id" as "c_orderline_id", "_"."documentno" as "documentno", "_"."c_order_id" as "c_order_id", "_"."ad_org_id" as "ad_org_id", "_"."isactive" as "isactive", "_"."issotrx" as "issotrx", "_"."c_bpartner_id" as "c_bpartner_id", "_"."c_currency_id" as "c_currency_id", "_"."m_product_id" as "m_product_id", "_"."m_warehouse_id" as "m_warehouse_id", "_"."m_product_category_id" as "m_product_category_id", "_"."Product Name" as "Product Name", "_"."Category Name" as "Category Name", "_"."Product Composition Name" as "Product Composition Name", "_"."Product Campaign Name" as "Product Campaign Name", "_"."Product Collection Name" as "Product Collection Name", "_"."Product LOB Name" as "Product LOB Name", "_"."line" as "line", cast("_"."Fecha Pedido" as date) as "Fecha Pedido", "_"."Fecha Comprometida" as "Fecha Comprometida", "_"."Fecha Comprometida Ped" as "Fecha Comprometida Ped", "_"."Fecha Enviada" as "Fecha Enviada", "_"."Descripción" as "Descripción", "_"."Cantidad Pedido" as "Cantidad Pedido", "_"."Cantidad Enviada" as "Cantidad Enviada", "_"."Precio Lista" as "Precio Lista", "_"."Precio Actual" as "Precio Actual", "_"."Precio Limite" as "Precio Limite", "_"."Importe Linea" as "Importe Linea", "_"."Importe Inicial L" as "Importe Inicial L", "_"."Descuento" as "Descuento", "_"."Agente" as "Agente", "_"."em_bass_bpclasification_id" as "em_bass_bpclasification_id", "_"."Clasificaciion" as "Clasificaciion" from ( SELECT OL.c_orderline_id, O.documentno, OL.c_order_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, OL.c_currency_id, OL.m_product_id, OL.m_warehouse_id, P.m_product_category_id, P."name" as "Product Name", mpc.name as "Category Name", fpc.name as "Product Composition Name", cc.name as "Product Campaign Name", fc.name as "Product Collection Name", fl.name as "Product LOB Name", OL.line, OL.dateordered as "Fecha Pedido", OL.datepromised as "Fecha Comprometida", O.datepromised as "Fecha Comprometida Ped", OL.datedelivered as "Fecha Enviada", OL.description as "Descripción", ROUND(OL.qtyordered, 2) as "Cantidad Pedido", ROUND(OL.qtydelivered, 2) as "Cantidad Enviada", OL.pricelist "Precio Lista", OL.priceactual "Precio Actual", OL.pricelimit "Precio Limite", OL.linenetamt "Importe Linea", OL.em_prouti_linenetamtinitial "Importe Inicial L", OL.discount as "Descuento", O.salesrep_id as "Agente", cbl.em_bass_bpclasification_id, CLAS."name" as "Clasificaciion" FROM c_orderline OL LEFT JOIN c_order O on O.c_order_id = OL.c_order_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id left join c_doctype on c_doctype.c_doctype_id = O.c_doctypetarget_id left join m_product_category mpc on mpc.m_product_category_id = P.m_product_category_id left join fash_prod_composition fpc on fpc.fash_prod_composition_id = P.em_fash_prod_composition_id left join c_campaign cc on cc.c_campaign_id = P.em_fash_campaign_id left join fash_collection fc on fc.fash_collection_id = P.em_fash_collection_id left join fash_lob fl on fl.fash_lob_id = P.em_fash_lob_id LEFT JOIN c_bpartner_location cbl on cbl.c_bpartner_location_id = O.c_bpartner_location_id LEFT JOIN bass_bpclasification CLAS on CLAS.bass_bpclasification_id = cbl.em_bass_bpclasification_id WHERE 1 = 1 and O.dateordered between to_date('01-01-2018', 'dd-mm-yyyy') and to_date(current_date) and O.issotrx = 'Y' and c_doctype.docsubtypeso not in ('OB', 'ON') and c_doctype.isreturn = 'N' and O.docstatus in ('CL', 'CO') union all SELECT OL.c_orderline_id, O.documentno, OL.c_order_id, OL.ad_org_id, OL.isactive, O.issotrx, O.c_bpartner_id, OL.c_currency_id, OL.m_product_id, OL.m_warehouse_id, P.m_product_category_id, P."name" as "Product Name", mpc.name as "Category Name", fpc.name as "Product Composition Name", cc.name as "Product Campaign Name", fc.name as "Product Collection Name", fl.name as "Product LOB Name", OL.line, OL.dateordered as "Fecha Pedido", OL.datepromised as "Fecha Comprometida", O.datepromised as "Fecha Comprometida Ped", OL.datedelivered as "Fecha Enviada", OL.description as "Descripción", OL.qtyordered "Cantidad Pedido", OL.qtydelivered "Cantidad Enviada", OL.pricelist "Precio Lista", OL.priceactual "Precio Actual", OL.pricelimit "Precio Limite", OL.linenetamt "Importe Linea", OL.linenetamt "Importe Inicial L", OL.discount as "Descuento", O.salesrep_id as "Agente", cbl.em_bass_bpclasification_id, CLAS."name" as "Clasificaciion" FROM c_orderline OL LEFT JOIN c_order O on O.c_order_id = OL.c_order_id LEFT JOIN m_product P on P.m_product_id = OL.m_product_id left join c_doctype on c_doctype.c_doctype_id = O.c_doctypetarget_id left join m_product_category mpc on mpc.m_product_category_id = P.m_product_category_id left join fash_prod_composition fpc on fpc.fash_prod_composition_id = P.em_fash_prod_composition_id left join c_campaign cc on cc.c_campaign_id = P.em_fash_campaign_id left join fash_collection fc on fc.fash_collection_id = P.em_fash_collection_id left join fash_lob fl on fl.fash_lob_id = P.em_fash_lob_id LEFT JOIN c_bpartner_location cbl on cbl.c_bpartner_location_id = O.c_bpartner_location_id LEFT JOIN bass_bpclasification CLAS on CLAS.bass_bpclasification_id = cbl.em_bass_bpclasification_id WHERE 1 = 1 and O.dateordered between to_date('01-01-2018', 'dd-mm-yyyy') and to_date(current_date) and O.issotrx = 'Y' and c_doctype.docsubtypeso not in ('OB', 'ON') and c_doctype.isreturn = 'Y' and O.docstatus in ('CL', 'CO')) "_";