SELECT mt.m_transaction_id, mt.m_locator_id, ml.m_warehouse_id, mt.ad_client_id, mt.ad_org_id, mt.updated, mt.m_product_id, trunc(mt.trxprocessdate) as trxprocessdate, mt.movementtype as "Tipo Movimiento", mt.movementqty as "Cantidad Movimiento", mt.transactioncost as "€ Coste Transacción", m_get_cost (mt.m_product_id, mt.trxprocessdate, 'AVA', mt.ad_org_id, mt.ad_client_id, NULL, '102', '102') AS "€ Coste Medio Producto", coalesce(mi2."name", 'n-a') as "Nombre Inventario", coalesce(mi4."documentno", 'n-a') as "Documento Albaran Entrega", coalesce(o."documentno", 'n-a') as "Documento Pedido", coalesce(oa."name", 'n-a') as "TPV", coalesce(cd."name", 'n-a') as "Tipo Documento" FROM m_transaction mt LEFT JOIN m_locator ml on ml.m_locator_id = mt.m_locator_id left join m_inventoryline mi on mi.m_inventoryline_id = mt.m_inventoryline_id left join m_inventory mi2 on mi2.m_inventory_id = mi.m_inventory_id left join m_inoutline mi3 on mi3.m_inoutline_id = mt.m_inoutline_id left join m_inout mi4 on mi4.m_inout_id = mi3.m_inout_id left join c_orderline ol on ol.c_orderline_id = mi3.c_orderline_id left join c_order o on o.c_order_id = ol.c_order_id left join obpos_applications oa on o.em_obpos_applications_id = oa.obpos_applications_id left join c_doctype cd on cd.c_doctype_id = o.c_doctype_id WHERE mt.isactive = 'Y';

Date: 2026-06-30 12:37:54
Duration: 6m57s
Database: openbravo
User: tad
Remote: 10.0.0.13

SELECT mt.m_transaction_id, mt.m_locator_id, ml.m_warehouse_id, mt.ad_client_id, mt.ad_org_id, mt.updated, mt.m_product_id, trunc(mt.trxprocessdate) as trxprocessdate, mt.movementtype as "Tipo Movimiento", mt.movementqty as "Cantidad Movimiento", mt.transactioncost as "€ Coste Transacción", m_get_cost (mt.m_product_id, mt.trxprocessdate, 'AVA', mt.ad_org_id, mt.ad_client_id, NULL, '102', '102') AS "€ Coste Medio Producto", coalesce(mi2."name", 'n-a') as "Nombre Inventario", coalesce(mi4."documentno", 'n-a') as "Documento Albaran Entrega", coalesce(o."documentno", 'n-a') as "Documento Pedido", coalesce(oa."name", 'n-a') as "TPV", coalesce(cd."name", 'n-a') as "Tipo Documento" FROM m_transaction mt LEFT JOIN m_locator ml on ml.m_locator_id = mt.m_locator_id left join m_inventoryline mi on mi.m_inventoryline_id = mt.m_inventoryline_id left join m_inventory mi2 on mi2.m_inventory_id = mi.m_inventory_id left join m_inoutline mi3 on mi3.m_inoutline_id = mt.m_inoutline_id left join m_inout mi4 on mi4.m_inout_id = mi3.m_inout_id left join c_orderline ol on ol.c_orderline_id = mi3.c_orderline_id left join c_order o on o.c_order_id = ol.c_order_id left join obpos_applications oa on o.em_obpos_applications_id = oa.obpos_applications_id left join c_doctype cd on cd.c_doctype_id = o.c_doctype_id WHERE mt.isactive = 'Y';

Date: 2026-06-30 19:38:33
Duration: 6m31s
Database: openbravo
User: tad
Remote: 10.0.0.13

SELECT mt.m_transaction_id, mt.m_locator_id, ml.m_warehouse_id, mt.ad_client_id, mt.ad_org_id, mt.updated, mt.m_product_id, trunc(mt.trxprocessdate) as trxprocessdate, mt.movementtype as "Tipo Movimiento", mt.movementqty as "Cantidad Movimiento", mt.transactioncost as "€ Coste Transacción", m_get_cost (mt.m_product_id, mt.trxprocessdate, 'AVA', mt.ad_org_id, mt.ad_client_id, NULL, '102', '102') AS "€ Coste Medio Producto", coalesce(mi2."name", 'n-a') as "Nombre Inventario", coalesce(mi4."documentno", 'n-a') as "Documento Albaran Entrega", coalesce(o."documentno", 'n-a') as "Documento Pedido", coalesce(oa."name", 'n-a') as "TPV", coalesce(cd."name", 'n-a') as "Tipo Documento" FROM m_transaction mt LEFT JOIN m_locator ml on ml.m_locator_id = mt.m_locator_id left join m_inventoryline mi on mi.m_inventoryline_id = mt.m_inventoryline_id left join m_inventory mi2 on mi2.m_inventory_id = mi.m_inventory_id left join m_inoutline mi3 on mi3.m_inoutline_id = mt.m_inoutline_id left join m_inout mi4 on mi4.m_inout_id = mi3.m_inout_id left join c_orderline ol on ol.c_orderline_id = mi3.c_orderline_id left join c_order o on o.c_order_id = ol.c_order_id left join obpos_applications oa on o.em_obpos_applications_id = oa.obpos_applications_id left join c_doctype cd on cd.c_doctype_id = o.c_doctype_id WHERE mt.isactive = 'Y';

Date: 2026-06-30 12:33:22
Duration: 0ms
Database: openbravo
User: tad
Remote: 10.0.0.13
Application: Mashup Engine SSL enabled (protocol=TLSv1.2, cipher=ECDHE-RSA-AES128-GCM-SHA256, bits=128)

x Hide

UPDATE AD_ALERT SET STATUS = 'SOLVED', UPDATED = NOW(), UPDATEDBY = 0 WHERE AD_ALERTRULE_ID = $1 AND COALESCE(STATUS, 'NEW') != 'SOLVED' AND NOT EXISTS ( SELECT 1 FROM ( select f.c_invoice_id as referencekey_id, '0' as ad_role_id, null as ad_user_id, 'Factura: ' || f.documentno || ' duplicada' as description, 'Y' as isActive, f.ad_org_id, f.ad_client_id, now() as created, '0' as createdBy, now() as updated, '0' as updatedBy, ad_column_identifier ('c_invoice', f.c_invoice_id, 'es_ES') AS RECORD_ID FROM ( select ci.documentno, max(dateinvoiced) as dateinvoiced, max(ci.c_invoice_id) as c_invoice_id, max(ci.ad_org_id) as ad_org_id, max(ci.ad_client_id) as ad_client_id from c_invoice ci join c_order co on co.c_order_id = ci.c_order_id where ci.issotrx = 'Y' and co.em_obpos_applications_id is not null group by ci.documentno, EXTRACT(YEAR FROM dateinvoiced), ci.c_doctype_id having count(ci.documentno) > 1 order by max(dateinvoiced) desc) as f) A WHERE 1 = 1 AND A.REFERENCEKEY_ID = AD_ALERT.REFERENCEKEY_ID);

Date: 2026-06-29 22:00:00
Duration: 0ms
Database: openbravo
User: tad
Remote: 10.3.1.9

x Hide

select order0_.EM_Obpos_Islayaway as col_0_0_, ( select coalesce(sum(fin_paymen6_.Paidamt), 0) from FIN_Payment_Schedule fin_paymen6_ where fin_paymen6_.C_Order_ID = order0_.C_Order_ID) as col_1_0_, order0_.EM_Obpos2_Isdraftorder as col_2_0_, order0_.EM_Obpos2_Queueno as col_3_0_, order0_.EM_Obpos2_Created_In_Pos as col_4_0_, case when documentty1_.IsReturn = 'Y' then to_char('Refunded') when documentty1_.DocSubTypeSO = 'OB' then to_char('UnderEvaluation') when order0_.Iscancelled = 'Y' then to_char('Cancelled') when order0_.GrandTotal > 0 and ( select coalesce(sum(fin_paymen9_.Paidamt), 0) from FIN_Payment_Schedule fin_paymen9_ where fin_paymen9_.C_Order_ID = order0_.C_Order_ID) = 0 then to_char('UnPaid') when order0_.GrandTotal > 0 and ( select coalesce(sum(fin_paymen10_.Paidamt), 0) from FIN_Payment_Schedule fin_paymen10_ where fin_paymen10_.C_Order_ID = order0_.C_Order_ID) & lt; order0_.GrandTotal then to_char('PartiallyPaid') else to_char('Paid') end as col_5_0_, obpos_appl4_.Obpos_Applications_ID as col_6_0_, exists ( select 1 from C_InvoiceLine invoicelin11_ inner join C_Invoice invoice12_ on invoicelin11_.C_Invoice_ID = invoice12_.C_Invoice_ID inner join C_OrderLine orderline13_ on invoicelin11_.C_OrderLine_ID = orderline13_.C_OrderLine_ID inner join C_Order order14_ on orderline13_.C_Order_ID = order14_.C_Order_ID where order14_.C_Order_ID = order0_.C_Order_ID and invoice12_.EM_Obpos_Sequencename = 'simplifiedinvoiceslastassignednum') as col_7_0_, ( select case when count(orderline15_.C_OrderLine_ID) > 0 then true else false end from C_OrderLine orderline15_ inner join M_InOutLine materialmg16_ on orderline15_.M_Inoutline_ID = materialmg16_.M_InOutLine_ID inner join C_OrderLine orderline17_ on materialmg16_.C_OrderLine_ID = orderline17_.C_OrderLine_ID cross join C_Order order18_ where orderline15_.C_Order_ID = order18_.C_Order_ID and orderline17_.C_Order_ID = order0_.C_Order_ID and order18_.EM_Obpos2_Isvoid = 'N') as col_8_0_, ( select case when count(orderline19_.C_OrderLine_ID) > 0 then true else false end from C_OrderLine orderline19_ inner join M_InOutLine materialmg20_ on orderline19_.M_Inoutline_ID = materialmg20_.M_InOutLine_ID inner join C_OrderLine orderline21_ on materialmg20_.C_OrderLine_ID = orderline21_.C_OrderLine_ID cross join C_Order order22_ where orderline19_.C_Order_ID = order22_.C_Order_ID and orderline21_.C_Order_ID = order0_.C_Order_ID and order22_.EM_Obpos2_Isvoid = 'Y') as col_9_0_, case when exists ( select 1 from C_OrderLine orderline23_ where orderline23_.C_Order_ID = order0_.C_Order_ID and orderline23_.QtyOrdered < 0) then true else false end as col_10_0_, case when order0_.Quotation_ID is not null then true else false end as col_11_0_, exists ( select 1 from C_OrderLine orderline24_ inner join C_Order order25_ on orderline24_.C_Order_ID = order25_.C_Order_ID where order25_.C_Order_ID = order0_.C_Order_ID and (orderline24_.EM_Obpos_Cancellableqty is null or orderline24_.EM_Obpos_Cancellableqty <> 0)) as col_12_0_, case when order0_.EM_Cfis_Fiscalization_Result is not null then true else false end as col_13_0_, ( select etxf_tax_f26_.TAX_Free_Number from ETXF_Tax_Free_Form etxf_tax_f26_ where etxf_tax_f26_.Etxf_Tax_Free_Form_ID = order0_.EM_Etxf_Tax_Free_Form_ID) as col_14_0_, order0_.EM_Prpgr_Ticketno as col_15_0_, case when documentty1_.C_DocType_ID = organizati3_.EM_Gcnv_C_Doctypegcard_ID then 'GCNV_GiftCard' else case when documentty1_.IsReturn = 'Y' then 'RET' when documentty1_.DocSubTypeSO = 'OB' then 'QT' when order0_.EM_Obpos_Islayaway = 'Y' then 'LAY' else 'ORD' end end as col_16_0_, order0_.C_Order_ID as col_17_0_, documentty1_.C_DocType_ID as col_18_0_, order0_.DocStatus as col_19_0_, order0_.DocumentNo as col_20_0_, order0_.Created as col_21_0_, order0_.DateOrdered as col_22_0_, order0_.DateOrdered as col_23_0_, order0_.DateOrdered as col_24_0_, businesspa2_.C_BPartner_ID as col_25_0_, businesspa2_.Name as col_26_0_, order0_.GrandTotal as col_27_0_, order0_.GrandTotal as col_28_0_, order0_.GrandTotal as col_29_0_, order0_.Iscancelled as col_30_0_, organizati3_.AD_Org_ID as col_31_0_, organizati3_.Value as col_32_0_, organizati3_.Name as col_33_0_, organizati5_.AD_Org_ID as col_34_0_, organizati5_.Name as col_35_0_, order0_.IsDelivered as col_36_0_, order0_.BPartner_ExtRef as col_37_0_, ( select coalesce(max(orderline29_.EM_Obrdm_Delivery_Mode), 'PickAndCarry') from C_OrderLine orderline29_ where order0_.C_Order_ID = orderline29_.C_Order_ID and orderline29_.EM_Obpos_Isdeleted = 'N') as col_38_0_, ( select min( case when orderline30_.EM_Obrdm_Delivery_Date is null or orderline30_.EM_Obrdm_Delivery_Time is null then null else to_timestamp((to_char(orderline30_.EM_Obrdm_Delivery_Date, 'YYYY') || '-' || to_char(orderline30_.EM_Obrdm_Delivery_Date, 'MM') || '-' || to_char(orderline30_.EM_Obrdm_Delivery_Date, 'DD') || ' ' || to_char(orderline30_.EM_Obrdm_Delivery_Time, 'HH24') || ':' || to_char(orderline30_.EM_Obrdm_Delivery_Time, 'MI')), 'YYYY-MM-DD HH24:MI') end) from C_OrderLine orderline30_ where order0_.C_Order_ID = orderline30_.C_Order_ID) as col_39_0_, order0_.InvoiceRule as col_40_0_, order0_.EM_OBPOS_IsFullInvoice as col_41_0_, case when order0_.BPartner_ExtRef is not null then false when (obpos_appl4_.C_Bpartner_ID is not null) and obpos_appl4_.C_Bpartner_ID = businesspa2_.C_BPartner_ID then true when (organizati3_.EM_Obretco_C_Bpartner_ID is not null) and organizati3_.EM_Obretco_C_Bpartner_ID = businesspa2_.C_BPartner_ID then true else false end as col_42_0_ from C_Order order0_ inner join C_DocType documentty1_ on order0_.C_DocType_ID = documentty1_.C_DocType_ID inner join C_BPartner businesspa2_ on order0_.C_BPartner_ID = businesspa2_.C_BPartner_ID inner join AD_Org organizati3_ on order0_.AD_Org_ID = organizati3_.AD_Org_ID inner join OBPOS_APPLICATIONS obpos_appl4_ on order0_.EM_Obpos_Applications_ID = obpos_appl4_.Obpos_Applications_ID left outer join AD_Org organizati5_ on order0_.AD_OrgTrx_ID = organizati5_.AD_Org_ID where 1 = 1 and 1 = 1 and order0_.DateOrdered >= to_date('2016-07-02', 'yyyy-MM-dd') and order0_.AD_Client_ID = '9032A5586FD74B7AA85361E71EEB6E37' and order0_.AD_OrgTrx_ID = 'A2E03C755D4B42CEA6267EF3A4F9212D' and order0_.EM_Obpos_Isdeleted = 'N' and (order0_.DocStatus not in ('CJ', 'CA', 'NC', 'AE', 'ME')) and (order0_.DocStatus <> 'CL' or order0_.Iscancelled = 'Y') order by col_21_0_ desc, col_20_0_ desc limit '50';

Date: 2026-06-30 07:41:41
Duration: 10s809ms
Database: openbravo
User: tad
Remote: 10.3.1.9

select order0_.EM_Obpos_Islayaway as col_0_0_, ( select coalesce(sum(fin_paymen6_.Paidamt), 0) from FIN_Payment_Schedule fin_paymen6_ where fin_paymen6_.C_Order_ID = order0_.C_Order_ID) as col_1_0_, order0_.EM_Obpos2_Isdraftorder as col_2_0_, order0_.EM_Obpos2_Queueno as col_3_0_, order0_.EM_Obpos2_Created_In_Pos as col_4_0_, case when documentty1_.IsReturn = 'Y' then to_char('Refunded') when documentty1_.DocSubTypeSO = 'OB' then to_char('UnderEvaluation') when order0_.Iscancelled = 'Y' then to_char('Cancelled') when order0_.GrandTotal > 0 and ( select coalesce(sum(fin_paymen9_.Paidamt), 0) from FIN_Payment_Schedule fin_paymen9_ where fin_paymen9_.C_Order_ID = order0_.C_Order_ID) = 0 then to_char('UnPaid') when order0_.GrandTotal > 0 and ( select coalesce(sum(fin_paymen10_.Paidamt), 0) from FIN_Payment_Schedule fin_paymen10_ where fin_paymen10_.C_Order_ID = order0_.C_Order_ID) & lt; order0_.GrandTotal then to_char('PartiallyPaid') else to_char('Paid') end as col_5_0_, obpos_appl4_.Obpos_Applications_ID as col_6_0_, exists ( select 1 from C_InvoiceLine invoicelin11_ inner join C_Invoice invoice12_ on invoicelin11_.C_Invoice_ID = invoice12_.C_Invoice_ID inner join C_OrderLine orderline13_ on invoicelin11_.C_OrderLine_ID = orderline13_.C_OrderLine_ID inner join C_Order order14_ on orderline13_.C_Order_ID = order14_.C_Order_ID where order14_.C_Order_ID = order0_.C_Order_ID and invoice12_.EM_Obpos_Sequencename = 'simplifiedinvoiceslastassignednum') as col_7_0_, ( select case when count(orderline15_.C_OrderLine_ID) > 0 then true else false end from C_OrderLine orderline15_ inner join M_InOutLine materialmg16_ on orderline15_.M_Inoutline_ID = materialmg16_.M_InOutLine_ID inner join C_OrderLine orderline17_ on materialmg16_.C_OrderLine_ID = orderline17_.C_OrderLine_ID cross join C_Order order18_ where orderline15_.C_Order_ID = order18_.C_Order_ID and orderline17_.C_Order_ID = order0_.C_Order_ID and order18_.EM_Obpos2_Isvoid = 'N') as col_8_0_, ( select case when count(orderline19_.C_OrderLine_ID) > 0 then true else false end from C_OrderLine orderline19_ inner join M_InOutLine materialmg20_ on orderline19_.M_Inoutline_ID = materialmg20_.M_InOutLine_ID inner join C_OrderLine orderline21_ on materialmg20_.C_OrderLine_ID = orderline21_.C_OrderLine_ID cross join C_Order order22_ where orderline19_.C_Order_ID = order22_.C_Order_ID and orderline21_.C_Order_ID = order0_.C_Order_ID and order22_.EM_Obpos2_Isvoid = 'Y') as col_9_0_, case when exists ( select 1 from C_OrderLine orderline23_ where orderline23_.C_Order_ID = order0_.C_Order_ID and orderline23_.QtyOrdered < 0) then true else false end as col_10_0_, case when order0_.Quotation_ID is not null then true else false end as col_11_0_, exists ( select 1 from C_OrderLine orderline24_ inner join C_Order order25_ on orderline24_.C_Order_ID = order25_.C_Order_ID where order25_.C_Order_ID = order0_.C_Order_ID and (orderline24_.EM_Obpos_Cancellableqty is null or orderline24_.EM_Obpos_Cancellableqty <> 0)) as col_12_0_, case when order0_.EM_Cfis_Fiscalization_Result is not null then true else false end as col_13_0_, ( select etxf_tax_f26_.TAX_Free_Number from ETXF_Tax_Free_Form etxf_tax_f26_ where etxf_tax_f26_.Etxf_Tax_Free_Form_ID = order0_.EM_Etxf_Tax_Free_Form_ID) as col_14_0_, order0_.EM_Prpgr_Ticketno as col_15_0_, case when documentty1_.C_DocType_ID = organizati3_.EM_Gcnv_C_Doctypegcard_ID then 'GCNV_GiftCard' else case when documentty1_.IsReturn = 'Y' then 'RET' when documentty1_.DocSubTypeSO = 'OB' then 'QT' when order0_.EM_Obpos_Islayaway = 'Y' then 'LAY' else 'ORD' end end as col_16_0_, order0_.C_Order_ID as col_17_0_, documentty1_.C_DocType_ID as col_18_0_, order0_.DocStatus as col_19_0_, order0_.DocumentNo as col_20_0_, order0_.Created as col_21_0_, order0_.DateOrdered as col_22_0_, order0_.DateOrdered as col_23_0_, order0_.DateOrdered as col_24_0_, businesspa2_.C_BPartner_ID as col_25_0_, businesspa2_.Name as col_26_0_, order0_.GrandTotal as col_27_0_, order0_.GrandTotal as col_28_0_, order0_.GrandTotal as col_29_0_, order0_.Iscancelled as col_30_0_, organizati3_.AD_Org_ID as col_31_0_, organizati3_.Value as col_32_0_, organizati3_.Name as col_33_0_, organizati5_.AD_Org_ID as col_34_0_, organizati5_.Name as col_35_0_, order0_.IsDelivered as col_36_0_, order0_.BPartner_ExtRef as col_37_0_, ( select coalesce(max(orderline29_.EM_Obrdm_Delivery_Mode), 'PickAndCarry') from C_OrderLine orderline29_ where order0_.C_Order_ID = orderline29_.C_Order_ID and orderline29_.EM_Obpos_Isdeleted = 'N') as col_38_0_, ( select min( case when orderline30_.EM_Obrdm_Delivery_Date is null or orderline30_.EM_Obrdm_Delivery_Time is null then null else to_timestamp((to_char(orderline30_.EM_Obrdm_Delivery_Date, 'YYYY') || '-' || to_char(orderline30_.EM_Obrdm_Delivery_Date, 'MM') || '-' || to_char(orderline30_.EM_Obrdm_Delivery_Date, 'DD') || ' ' || to_char(orderline30_.EM_Obrdm_Delivery_Time, 'HH24') || ':' || to_char(orderline30_.EM_Obrdm_Delivery_Time, 'MI')), 'YYYY-MM-DD HH24:MI') end) from C_OrderLine orderline30_ where order0_.C_Order_ID = orderline30_.C_Order_ID) as col_39_0_, order0_.InvoiceRule as col_40_0_, order0_.EM_OBPOS_IsFullInvoice as col_41_0_, case when order0_.BPartner_ExtRef is not null then false when (obpos_appl4_.C_Bpartner_ID is not null) and obpos_appl4_.C_Bpartner_ID = businesspa2_.C_BPartner_ID then true when (organizati3_.EM_Obretco_C_Bpartner_ID is not null) and organizati3_.EM_Obretco_C_Bpartner_ID = businesspa2_.C_BPartner_ID then true else false end as col_42_0_ from C_Order order0_ inner join C_DocType documentty1_ on order0_.C_DocType_ID = documentty1_.C_DocType_ID inner join C_BPartner businesspa2_ on order0_.C_BPartner_ID = businesspa2_.C_BPartner_ID inner join AD_Org organizati3_ on order0_.AD_Org_ID = organizati3_.AD_Org_ID inner join OBPOS_APPLICATIONS obpos_appl4_ on order0_.EM_Obpos_Applications_ID = obpos_appl4_.Obpos_Applications_ID left outer join AD_Org organizati5_ on order0_.AD_OrgTrx_ID = organizati5_.AD_Org_ID where 1 = 1 and 1 = 1 and order0_.DateOrdered >= to_date('2016-07-02', 'yyyy-MM-dd') and order0_.AD_Client_ID = '9032A5586FD74B7AA85361E71EEB6E37' and order0_.AD_OrgTrx_ID = 'A2E03C755D4B42CEA6267EF3A4F9212D' and order0_.EM_Obpos_Isdeleted = 'N' and (order0_.DocStatus not in ('CJ', 'CA', 'NC', 'AE', 'ME')) and (order0_.DocStatus <> 'CL' or order0_.Iscancelled = 'Y') order by col_21_0_ desc, col_20_0_ desc limit '50';

Date: 2026-06-30 15:19:03
Duration: 9s11ms
Database: openbravo
User: tad
Remote: 10.3.1.9

select order0_.EM_Obpos_Islayaway as col_0_0_, ( select coalesce(sum(fin_paymen6_.Paidamt), 0) from FIN_Payment_Schedule fin_paymen6_ where fin_paymen6_.C_Order_ID = order0_.C_Order_ID) as col_1_0_, order0_.EM_Obpos2_Isdraftorder as col_2_0_, order0_.EM_Obpos2_Queueno as col_3_0_, order0_.EM_Obpos2_Created_In_Pos as col_4_0_, case when documentty1_.IsReturn = 'Y' then to_char('Refunded') when documentty1_.DocSubTypeSO = 'OB' then to_char('UnderEvaluation') when order0_.Iscancelled = 'Y' then to_char('Cancelled') when order0_.GrandTotal > 0 and ( select coalesce(sum(fin_paymen9_.Paidamt), 0) from FIN_Payment_Schedule fin_paymen9_ where fin_paymen9_.C_Order_ID = order0_.C_Order_ID) = 0 then to_char('UnPaid') when order0_.GrandTotal > 0 and ( select coalesce(sum(fin_paymen10_.Paidamt), 0) from FIN_Payment_Schedule fin_paymen10_ where fin_paymen10_.C_Order_ID = order0_.C_Order_ID) & lt; order0_.GrandTotal then to_char('PartiallyPaid') else to_char('Paid') end as col_5_0_, obpos_appl4_.Obpos_Applications_ID as col_6_0_, exists ( select 1 from C_InvoiceLine invoicelin11_ inner join C_Invoice invoice12_ on invoicelin11_.C_Invoice_ID = invoice12_.C_Invoice_ID inner join C_OrderLine orderline13_ on invoicelin11_.C_OrderLine_ID = orderline13_.C_OrderLine_ID inner join C_Order order14_ on orderline13_.C_Order_ID = order14_.C_Order_ID where order14_.C_Order_ID = order0_.C_Order_ID and invoice12_.EM_Obpos_Sequencename = 'simplifiedinvoiceslastassignednum') as col_7_0_, ( select case when count(orderline15_.C_OrderLine_ID) > 0 then true else false end from C_OrderLine orderline15_ inner join M_InOutLine materialmg16_ on orderline15_.M_Inoutline_ID = materialmg16_.M_InOutLine_ID inner join C_OrderLine orderline17_ on materialmg16_.C_OrderLine_ID = orderline17_.C_OrderLine_ID cross join C_Order order18_ where orderline15_.C_Order_ID = order18_.C_Order_ID and orderline17_.C_Order_ID = order0_.C_Order_ID and order18_.EM_Obpos2_Isvoid = 'N') as col_8_0_, ( select case when count(orderline19_.C_OrderLine_ID) > 0 then true else false end from C_OrderLine orderline19_ inner join M_InOutLine materialmg20_ on orderline19_.M_Inoutline_ID = materialmg20_.M_InOutLine_ID inner join C_OrderLine orderline21_ on materialmg20_.C_OrderLine_ID = orderline21_.C_OrderLine_ID cross join C_Order order22_ where orderline19_.C_Order_ID = order22_.C_Order_ID and orderline21_.C_Order_ID = order0_.C_Order_ID and order22_.EM_Obpos2_Isvoid = 'Y') as col_9_0_, case when exists ( select 1 from C_OrderLine orderline23_ where orderline23_.C_Order_ID = order0_.C_Order_ID and orderline23_.QtyOrdered < 0) then true else false end as col_10_0_, case when order0_.Quotation_ID is not null then true else false end as col_11_0_, exists ( select 1 from C_OrderLine orderline24_ inner join C_Order order25_ on orderline24_.C_Order_ID = order25_.C_Order_ID where order25_.C_Order_ID = order0_.C_Order_ID and (orderline24_.EM_Obpos_Cancellableqty is null or orderline24_.EM_Obpos_Cancellableqty <> 0)) as col_12_0_, case when order0_.EM_Cfis_Fiscalization_Result is not null then true else false end as col_13_0_, ( select etxf_tax_f26_.TAX_Free_Number from ETXF_Tax_Free_Form etxf_tax_f26_ where etxf_tax_f26_.Etxf_Tax_Free_Form_ID = order0_.EM_Etxf_Tax_Free_Form_ID) as col_14_0_, order0_.EM_Prpgr_Ticketno as col_15_0_, case when documentty1_.C_DocType_ID = organizati3_.EM_Gcnv_C_Doctypegcard_ID then 'GCNV_GiftCard' else case when documentty1_.IsReturn = 'Y' then 'RET' when documentty1_.DocSubTypeSO = 'OB' then 'QT' when order0_.EM_Obpos_Islayaway = 'Y' then 'LAY' else 'ORD' end end as col_16_0_, order0_.C_Order_ID as col_17_0_, documentty1_.C_DocType_ID as col_18_0_, order0_.DocStatus as col_19_0_, order0_.DocumentNo as col_20_0_, order0_.Created as col_21_0_, order0_.DateOrdered as col_22_0_, order0_.DateOrdered as col_23_0_, order0_.DateOrdered as col_24_0_, businesspa2_.C_BPartner_ID as col_25_0_, businesspa2_.Name as col_26_0_, order0_.GrandTotal as col_27_0_, order0_.GrandTotal as col_28_0_, order0_.GrandTotal as col_29_0_, order0_.Iscancelled as col_30_0_, organizati3_.AD_Org_ID as col_31_0_, organizati3_.Value as col_32_0_, organizati3_.Name as col_33_0_, organizati5_.AD_Org_ID as col_34_0_, organizati5_.Name as col_35_0_, order0_.IsDelivered as col_36_0_, order0_.BPartner_ExtRef as col_37_0_, ( select coalesce(max(orderline29_.EM_Obrdm_Delivery_Mode), 'PickAndCarry') from C_OrderLine orderline29_ where order0_.C_Order_ID = orderline29_.C_Order_ID and orderline29_.EM_Obpos_Isdeleted = 'N') as col_38_0_, ( select min( case when orderline30_.EM_Obrdm_Delivery_Date is null or orderline30_.EM_Obrdm_Delivery_Time is null then null else to_timestamp((to_char(orderline30_.EM_Obrdm_Delivery_Date, 'YYYY') || '-' || to_char(orderline30_.EM_Obrdm_Delivery_Date, 'MM') || '-' || to_char(orderline30_.EM_Obrdm_Delivery_Date, 'DD') || ' ' || to_char(orderline30_.EM_Obrdm_Delivery_Time, 'HH24') || ':' || to_char(orderline30_.EM_Obrdm_Delivery_Time, 'MI')), 'YYYY-MM-DD HH24:MI') end) from C_OrderLine orderline30_ where order0_.C_Order_ID = orderline30_.C_Order_ID) as col_39_0_, order0_.InvoiceRule as col_40_0_, order0_.EM_OBPOS_IsFullInvoice as col_41_0_, case when order0_.BPartner_ExtRef is not null then false when (obpos_appl4_.C_Bpartner_ID is not null) and obpos_appl4_.C_Bpartner_ID = businesspa2_.C_BPartner_ID then true when (organizati3_.EM_Obretco_C_Bpartner_ID is not null) and organizati3_.EM_Obretco_C_Bpartner_ID = businesspa2_.C_BPartner_ID then true else false end as col_42_0_ from C_Order order0_ inner join C_DocType documentty1_ on order0_.C_DocType_ID = documentty1_.C_DocType_ID inner join C_BPartner businesspa2_ on order0_.C_BPartner_ID = businesspa2_.C_BPartner_ID inner join AD_Org organizati3_ on order0_.AD_Org_ID = organizati3_.AD_Org_ID inner join OBPOS_APPLICATIONS obpos_appl4_ on order0_.EM_Obpos_Applications_ID = obpos_appl4_.Obpos_Applications_ID left outer join AD_Org organizati5_ on order0_.AD_OrgTrx_ID = organizati5_.AD_Org_ID where 1 = 1 and 1 = 1 and order0_.DateOrdered >= to_date('2016-07-02', 'yyyy-MM-dd') and order0_.AD_Client_ID = '9032A5586FD74B7AA85361E71EEB6E37' and order0_.AD_OrgTrx_ID = $1 and order0_.EM_Obpos_Isdeleted = 'N' and (order0_.DocStatus not in ('CJ', 'CA', 'NC', 'AE', 'ME')) and (order0_.DocStatus <> 'CL' or order0_.Iscancelled = 'Y') order by col_21_0_ desc, col_20_0_ desc limit $2;

Date: 2026-06-30 07:41:40
Duration: 0ms
Database: openbravo
User: tad
Remote: 10.3.1.9

x Hide