SELECT ADVMRP_PROCESSPLAN ('100', 'FF8081813423E947013423EFEB102832', 'FF8081813423E947013423ECBDFA0007', 'D5966A743237437AB7FA9CD30819C213', NULL, '365', '2026-07-15 07:20:00.007', '0') AS RESULT FROM DUAL;

[ Date: 2026-07-15 07:24:16 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

SELECT ADVMRP_RUN_EXPLODE ('100', 'FF8081813423E947013423EFEB102832', 'FF8081813423E947013423ECBDFA0007', 'D5966A743237437AB7FA9CD30819C213', NULL, '365', '2026-07-15 07:20:00.007', '0') AS RESULT FROM DUAL;

[ Date: 2026-07-15 07:20:29 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

SELECT B.* FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, SUM(AMOUNT) AS AMOUNT, SUM(QTY) AS QTY, SUM(WEIGHT) AS WEIGHT, SUM( COST) AS COST, SUM(AMOUNTREF) AS AMOUNTREF, SUM(QTYREF) AS QTYREF, SUM(WEIGHTREF) AS WEIGHTREF, SUM(CONVAMOUNT) AS CONVAMOUNT, CASE WHEN SUM(COSTCALCULATED) = 0 THEN SUM(CONVCOST) WHEN SUM(GROUPCOUNT) <> SUM(COSTCALCULATED) THEN SUM(CONVCOST) WHEN SUM(COSTEDAMT) = 0 AND SUM(CONVCOST) > 0 THEN SUM(CONVCOST) WHEN SUM( CASE WHEN GROUPCOUNT = COSTCALCULATED THEN 0 ELSE CONVAMOUNT END) = 0 THEN SUM(CONVCOST) ELSE SUM(CONVCOST) * SUM(CONVAMOUNT) / SUM( CASE WHEN GROUPCOUNT = COSTCALCULATED THEN 0 ELSE CONVAMOUNT END) END AS CONVCOST, SUM(CONVAMOUNTREF) AS CONVAMOUNTREF, SUM(CONVCOSTREF) AS CONVCOSTREF, C_CURRENCY_SYMBOL ('102', 0, 'Y') AS CONVSYM, C_CURRENCY_ISOSYM ('102') AS CONVISOSYM, SUM(ZZ.COSTCALCULATED) AS COSTCALCULATED FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, SUM(LINENETAMT) AS AMOUNT, SUM(QTYINVOICED) AS QTY, SUM(WEIGHT) AS WEIGHT, SUM( COST) AS COST, SUM(LINENETREF) AS AMOUNTREF, SUM(QTYINVOICEDREF) AS QTYREF, SUM(WEIGHT_REF) AS WEIGHTREF, C_CURRENCY_CONVERT (SUM(LINENETAMT), TRCURRENCYID, '102', TO_DATE(TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNT, CASE WHEN SUM(COSTCALCULATED) >= 0 THEN SUM( COST) WHEN SUM(COSTEDAMT) = 0 AND SUM( COST) > 0 THEN SUM( COST) ELSE SUM( COST) * SUM(LINENETAMT) / SUM(COSTEDAMT) END AS CONVCOST, 0 AS CONVAMOUNTREF, 0 AS CONVCOSTREF, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID, SUM(AA.COSTCALCULATED) as COSTCALCULATED, C_CURRENCY_CONVERT (SUM(COSTEDAMT), TRCURRENCYID, '102', TO_DATE(TRDATE), NULL, TRCLIENTID, TRORGID) AS costedamt, COUNT(*) AS GROUPCOUNT FROM ( SELECT to_char(AD_COLUMN_IDENTIFIER (to_char('M_Product'), to_char(M_PRODUCT.M_PRODUCT_ID), to_char('es_ES')) || CASE WHEN uomsymbol IS NULL THEN '' ELSE to_char(' (' || uomsymbol || ')') END) AS NIVEL1, to_char('') AS NIVEL2, to_char('') AS NIVEL3, to_char('') AS NIVEL4, to_char('') AS NIVEL5, to_char('') AS NIVEL6, to_char('') AS NIVEL7, to_char('') AS NIVEL8, to_char('') AS NIVEL9, to_char('') AS NIVEL10, CASE WHEN C_DOCTYPE.DOCBASETYPE = 'ARC' THEN C_INVOICELINE.LINENETAMT * -1 ELSE C_INVOICELINE.LINENETAMT END AS LINENETAMT, CASE WHEN c_doctype.docbasetype = 'ARC' THEN c_invoiceline.qtyinvoiced * -1 ELSE c_invoiceline.qtyinvoiced END AS QTYINVOICED, C_INVOICELINE.QTYINVOICED * M_PRODUCT.WEIGHT AS WEIGHT, 0 AS LINENETREF, 0 AS QTYINVOICEDREF, 0 AS WEIGHT_REF, C_UOM.UOMSYMBOL, C_INVOICE.C_CURRENCY_ID AS TRCURRENCYID, TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())) AS TRDATE, C_INVOICELINE.AD_CLIENT_ID AS TRCLIENTID, C_INVOICELINE.AD_ORG_ID AS TRORGID, CASE WHEN sum(trxcost.total_cost) is null AND m_product.isstocked = 'Y' AND m_product.producttype = 'I' THEN 1 ELSE 0 END AS COSTCALCULATED, CASE WHEN M_PRODUCT.ISSTOCKED = 'Y' AND M_PRODUCT.PRODUCTTYPE = 'I' THEN CASE WHEN C_INVOICELINE.M_INOUTLINE_ID IS NULL THEN COALESCE(M_GET_NO_TRX_PRD_COST_LATEST (M_PRODUCT.M_PRODUCT_ID, C_INVOICE.DATEINVOICED, AD_ORG.AD_ORG_ID, NULL, C_INVOICE.C_CURRENCY_ID, 'N'), 0) * ( CASE WHEN C_DOCTYPE.DOCBASETYPE = 'ARC' THEN C_INVOICELINE.QTYINVOICED * -1 ELSE C_INVOICELINE.QTYINVOICED END) WHEN TRX.MOVEMENTQTY = 0 THEN 0 ELSE CASE WHEN C_DOCTYPE.DOCBASETYPE = 'ARC' THEN -1 * COALESCE(C_CURRENCY_CONVERT_PRECISION (ROUND(MAX(trxcost.total_cost), C_GET_CURRENCY_PRECISION (MAX(trxcost.c_currency_id), 'C')), MAX(trxcost.c_currency_id), '102', TRX.MOVEMENTDATE, NULL, TRX.AD_CLIENT_ID, TRX.AD_ORG_ID, 'C'), 0) ELSE COALESCE(C_CURRENCY_CONVERT_PRECISION (ROUND(MAX(trxcost.total_cost), C_GET_CURRENCY_PRECISION (MAX(trxcost.c_currency_id), 'C')), MAX(trxcost.c_currency_id), '102', TRX.MOVEMENTDATE, NULL, TRX.AD_CLIENT_ID, TRX.AD_ORG_ID, 'C'), 0) END END ELSE COALESCE(M_GET_NO_TRX_PRD_COST_LATEST (M_PRODUCT.M_PRODUCT_ID, C_INVOICE.DATEINVOICED, AD_ORG.AD_ORG_ID, NULL, C_INVOICE.C_CURRENCY_ID, 'N'), 0) * ( CASE WHEN C_DOCTYPE.DOCBASETYPE = 'ARC' THEN C_INVOICELINE.QTYINVOICED * -1 ELSE C_INVOICELINE.QTYINVOICED END) END AS COST, CASE WHEN sum(trxcost.total_cost) is null AND m_product.isstocked = 'Y' AND m_product.producttype = 'I' THEN 0 ELSE CASE WHEN C_DOCTYPE.DOCBASETYPE = 'ARC' THEN C_INVOICELINE.LINENETAMT * -1 ELSE C_INVOICELINE.LINENETAMT END END AS COSTEDAMT FROM C_INVOICELINE join C_INVOICE on C_INVOICE.C_INVOICE_ID = C_INVOICELINE.C_INVOICE_ID join C_BPARTNER on C_INVOICE.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID join C_BP_GROUP on C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID join AD_ORG on C_INVOICE.AD_ORG_ID = AD_ORG.AD_ORG_ID left join C_BPARTNER CB on C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID left join AD_USER on C_INVOICE.SALESREP_ID = AD_USER.AD_USER_ID left join C_PROJECT on C_INVOICE.C_PROJECT_ID = C_PROJECT.C_PROJECT_ID left join C_DOCTYPE on C_INVOICE.C_DOCTYPE_ID = C_DOCTYPE.C_DOCTYPE_ID left join M_PRODUCT on C_INVOICELINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID left join C_UOM on C_INVOICELINE.C_UOM_ID = C_UOM.C_UOM_ID left join M_PRODUCT_CATEGORY on M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID left join M_INOUTLINE on C_INVOICELINE.M_INOUTLINE_ID = M_INOUTLINE.M_INOUTLINE_ID left join M_INOUT ON M_INOUTLINE.M_INOUT_ID = M_INOUT.M_INOUT_ID left join m_transaction trx ON trx.m_inoutline_id = m_inoutline.m_inoutline_id left join ( SELECT m_transaction_id, SUM( cost) AS total_cost, MAX(c_currency_id) AS c_currency_id FROM m_transaction_cost GROUP BY m_transaction_id) trxcost ON trx.m_transaction_id = trxcost.m_transaction_id WHERE C_INVOICE.ISSOTRX = 'Y' AND C_INVOICE.PROCESSED = 'Y' AND C_INVOICE.AD_ORG_ID IN ('FF8081813423E947013423F42CCA3157', 'FF8081813423E947013423EFEB102832', 'DFDEC8E26EDB4A8181BD1474EB430170', '2001450B323A4350A796F79C4825BC9A', '1CA80FD69EA743B0AA5417572352A6CF') AND C_INVOICE.AD_CLIENT_ID IN ('0', 'FF8081813423E947013423ECBDFA0007') AND 1 = 1 AND C_INVOICE.DATEINVOICED >= to_date('01-01-2025') AND C_INVOICE.DATEINVOICED < to_date('01-01-2026') GROUP BY trxcost.m_transaction_id, C_INVOICELINE.C_INVOICELINE_ID, C_BPARTNER.C_BPARTNER_ID, M_PRODUCT_CATEGORY.NAME, C_INVOICE.DOCUMENTNO, AD_ORG.NAME, AD_USER.AD_USER_ID, C_PROJECT.NAME, AD_USER.FIRSTNAME, AD_USER.LASTNAME, C_BP_GROUP.NAME, M_INOUT.C_BPARTNER_LOCATION_ID, C_INVOICELINE.AD_CLIENT_ID, C_INVOICELINE.AD_ORG_ID, C_INVOICELINE.LINENETAMT, C_INVOICELINE.QTYINVOICED, C_UOM.UOMSYMBOL, c_doctype.docbasetype, ad_org.ad_org_id, C_INVOICE.C_CURRENCY_ID, C_INVOICE.DATEINVOICED, trx.movementqty, trx.movementdate, trx.ad_client_id, trx.ad_org_id, M_PRODUCT.WEIGHT, M_PRODUCT.M_PRODUCT_ID, M_PRODUCT.ISSTOCKED, M_PRODUCT.PRODUCTTYPE, C_INVOICELINE.M_INOUTLINE_ID ORDER BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10) AA GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID) ZZ GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10 ORDER BY CONVAMOUNT DESC) B LIMIT 100001;

[ Date: 2026-07-15 13:34:36 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

SELECT B.* FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, SUM(AMOUNT) AS AMOUNT, SUM(QTY) AS QTY, SUM(WEIGHT) AS WEIGHT, SUM( COST) AS COST, SUM(AMOUNTREF) AS AMOUNTREF, SUM(QTYREF) AS QTYREF, SUM(WEIGHTREF) AS WEIGHTREF, SUM(CONVAMOUNT) AS CONVAMOUNT, CASE WHEN SUM(COSTCALCULATED) = 0 THEN SUM(CONVCOST) WHEN SUM(GROUPCOUNT) <> SUM(COSTCALCULATED) THEN SUM(CONVCOST) WHEN SUM(COSTEDAMT) = 0 AND SUM(CONVCOST) > 0 THEN SUM(CONVCOST) WHEN SUM( CASE WHEN GROUPCOUNT = COSTCALCULATED THEN 0 ELSE CONVAMOUNT END) = 0 THEN SUM(CONVCOST) ELSE SUM(CONVCOST) * SUM(CONVAMOUNT) / SUM( CASE WHEN GROUPCOUNT = COSTCALCULATED THEN 0 ELSE CONVAMOUNT END) END AS CONVCOST, SUM(CONVAMOUNTREF) AS CONVAMOUNTREF, SUM(CONVCOSTREF) AS CONVCOSTREF, C_CURRENCY_SYMBOL ('102', 0, 'Y') AS CONVSYM, C_CURRENCY_ISOSYM ('102') AS CONVISOSYM, SUM(ZZ.COSTCALCULATED) AS COSTCALCULATED FROM ( SELECT NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, SUM(LINENETAMT) AS AMOUNT, SUM(QTYINVOICED) AS QTY, SUM(WEIGHT) AS WEIGHT, SUM( COST) AS COST, SUM(LINENETREF) AS AMOUNTREF, SUM(QTYINVOICEDREF) AS QTYREF, SUM(WEIGHT_REF) AS WEIGHTREF, C_CURRENCY_CONVERT (SUM(LINENETAMT), TRCURRENCYID, '102', TO_DATE(TRDATE), NULL, TRCLIENTID, TRORGID) AS CONVAMOUNT, CASE WHEN SUM(COSTCALCULATED) >= 0 THEN SUM( COST) WHEN SUM(COSTEDAMT) = 0 AND SUM( COST) > 0 THEN SUM( COST) ELSE SUM( COST) * SUM(LINENETAMT) / SUM(COSTEDAMT) END AS CONVCOST, 0 AS CONVAMOUNTREF, 0 AS CONVCOSTREF, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID, SUM(AA.COSTCALCULATED) as COSTCALCULATED, C_CURRENCY_CONVERT (SUM(COSTEDAMT), TRCURRENCYID, '102', TO_DATE(TRDATE), NULL, TRCLIENTID, TRORGID) AS costedamt, COUNT(*) AS GROUPCOUNT FROM ( SELECT to_char(AD_COLUMN_IDENTIFIER (to_char('M_Product'), to_char(M_PRODUCT.M_PRODUCT_ID), to_char('es_ES')) || CASE WHEN uomsymbol IS NULL THEN '' ELSE to_char(' (' || uomsymbol || ')') END) AS NIVEL1, to_char('') AS NIVEL2, to_char('') AS NIVEL3, to_char('') AS NIVEL4, to_char('') AS NIVEL5, to_char('') AS NIVEL6, to_char('') AS NIVEL7, to_char('') AS NIVEL8, to_char('') AS NIVEL9, to_char('') AS NIVEL10, CASE WHEN C_DOCTYPE.DOCBASETYPE = 'ARC' THEN C_INVOICELINE.LINENETAMT * -1 ELSE C_INVOICELINE.LINENETAMT END AS LINENETAMT, CASE WHEN c_doctype.docbasetype = 'ARC' THEN c_invoiceline.qtyinvoiced * -1 ELSE c_invoiceline.qtyinvoiced END AS QTYINVOICED, C_INVOICELINE.QTYINVOICED * M_PRODUCT.WEIGHT AS WEIGHT, 0 AS LINENETREF, 0 AS QTYINVOICEDREF, 0 AS WEIGHT_REF, C_UOM.UOMSYMBOL, C_INVOICE.C_CURRENCY_ID AS TRCURRENCYID, TO_DATE(COALESCE(C_INVOICE.DATEINVOICED, NOW())) AS TRDATE, C_INVOICELINE.AD_CLIENT_ID AS TRCLIENTID, C_INVOICELINE.AD_ORG_ID AS TRORGID, CASE WHEN sum(trxcost.total_cost) is null AND m_product.isstocked = 'Y' AND m_product.producttype = 'I' THEN 1 ELSE 0 END AS COSTCALCULATED, CASE WHEN M_PRODUCT.ISSTOCKED = 'Y' AND M_PRODUCT.PRODUCTTYPE = 'I' THEN CASE WHEN C_INVOICELINE.M_INOUTLINE_ID IS NULL THEN COALESCE(M_GET_NO_TRX_PRD_COST_LATEST (M_PRODUCT.M_PRODUCT_ID, C_INVOICE.DATEINVOICED, AD_ORG.AD_ORG_ID, NULL, C_INVOICE.C_CURRENCY_ID, 'N'), 0) * ( CASE WHEN C_DOCTYPE.DOCBASETYPE = 'ARC' THEN C_INVOICELINE.QTYINVOICED * -1 ELSE C_INVOICELINE.QTYINVOICED END) WHEN TRX.MOVEMENTQTY = 0 THEN 0 ELSE CASE WHEN C_DOCTYPE.DOCBASETYPE = 'ARC' THEN -1 * COALESCE(C_CURRENCY_CONVERT_PRECISION (ROUND(MAX(trxcost.total_cost), C_GET_CURRENCY_PRECISION (MAX(trxcost.c_currency_id), 'C')), MAX(trxcost.c_currency_id), '102', TRX.MOVEMENTDATE, NULL, TRX.AD_CLIENT_ID, TRX.AD_ORG_ID, 'C'), 0) ELSE COALESCE(C_CURRENCY_CONVERT_PRECISION (ROUND(MAX(trxcost.total_cost), C_GET_CURRENCY_PRECISION (MAX(trxcost.c_currency_id), 'C')), MAX(trxcost.c_currency_id), '102', TRX.MOVEMENTDATE, NULL, TRX.AD_CLIENT_ID, TRX.AD_ORG_ID, 'C'), 0) END END ELSE COALESCE(M_GET_NO_TRX_PRD_COST_LATEST (M_PRODUCT.M_PRODUCT_ID, C_INVOICE.DATEINVOICED, AD_ORG.AD_ORG_ID, NULL, C_INVOICE.C_CURRENCY_ID, 'N'), 0) * ( CASE WHEN C_DOCTYPE.DOCBASETYPE = 'ARC' THEN C_INVOICELINE.QTYINVOICED * -1 ELSE C_INVOICELINE.QTYINVOICED END) END AS COST, CASE WHEN sum(trxcost.total_cost) is null AND m_product.isstocked = 'Y' AND m_product.producttype = 'I' THEN 0 ELSE CASE WHEN C_DOCTYPE.DOCBASETYPE = 'ARC' THEN C_INVOICELINE.LINENETAMT * -1 ELSE C_INVOICELINE.LINENETAMT END END AS COSTEDAMT FROM C_INVOICELINE join C_INVOICE on C_INVOICE.C_INVOICE_ID = C_INVOICELINE.C_INVOICE_ID join C_BPARTNER on C_INVOICE.C_BPARTNER_ID = C_BPARTNER.C_BPARTNER_ID join C_BP_GROUP on C_BPARTNER.C_BP_GROUP_ID = C_BP_GROUP.C_BP_GROUP_ID join AD_ORG on C_INVOICE.AD_ORG_ID = AD_ORG.AD_ORG_ID left join C_BPARTNER CB on C_BPARTNER.SALESREP_ID = CB.C_BPARTNER_ID left join AD_USER on C_INVOICE.SALESREP_ID = AD_USER.AD_USER_ID left join C_PROJECT on C_INVOICE.C_PROJECT_ID = C_PROJECT.C_PROJECT_ID left join C_DOCTYPE on C_INVOICE.C_DOCTYPE_ID = C_DOCTYPE.C_DOCTYPE_ID left join M_PRODUCT on C_INVOICELINE.M_PRODUCT_ID = M_PRODUCT.M_PRODUCT_ID left join C_UOM on C_INVOICELINE.C_UOM_ID = C_UOM.C_UOM_ID left join M_PRODUCT_CATEGORY on M_PRODUCT.M_PRODUCT_CATEGORY_ID = M_PRODUCT_CATEGORY.M_PRODUCT_CATEGORY_ID left join M_INOUTLINE on C_INVOICELINE.M_INOUTLINE_ID = M_INOUTLINE.M_INOUTLINE_ID left join M_INOUT ON M_INOUTLINE.M_INOUT_ID = M_INOUT.M_INOUT_ID left join m_transaction trx ON trx.m_inoutline_id = m_inoutline.m_inoutline_id left join ( SELECT m_transaction_id, SUM( cost) AS total_cost, MAX(c_currency_id) AS c_currency_id FROM m_transaction_cost GROUP BY m_transaction_id) trxcost ON trx.m_transaction_id = trxcost.m_transaction_id WHERE C_INVOICE.ISSOTRX = 'Y' AND C_INVOICE.PROCESSED = 'Y' AND C_INVOICE.AD_ORG_ID IN ('FF8081813423E947013423F42CCA3157', 'FF8081813423E947013423EFEB102832', 'DFDEC8E26EDB4A8181BD1474EB430170', '2001450B323A4350A796F79C4825BC9A', '1CA80FD69EA743B0AA5417572352A6CF') AND C_INVOICE.AD_CLIENT_ID IN ('0', 'FF8081813423E947013423ECBDFA0007') AND 1 = 1 AND C_INVOICE.DATEINVOICED >= to_date('01-01-2026') AND C_INVOICE.DATEINVOICED < to_date('16-07-2026') GROUP BY trxcost.m_transaction_id, C_INVOICELINE.C_INVOICELINE_ID, C_BPARTNER.C_BPARTNER_ID, M_PRODUCT_CATEGORY.NAME, C_INVOICE.DOCUMENTNO, AD_ORG.NAME, AD_USER.AD_USER_ID, C_PROJECT.NAME, AD_USER.FIRSTNAME, AD_USER.LASTNAME, C_BP_GROUP.NAME, M_INOUT.C_BPARTNER_LOCATION_ID, C_INVOICELINE.AD_CLIENT_ID, C_INVOICELINE.AD_ORG_ID, C_INVOICELINE.LINENETAMT, C_INVOICELINE.QTYINVOICED, C_UOM.UOMSYMBOL, c_doctype.docbasetype, ad_org.ad_org_id, C_INVOICE.C_CURRENCY_ID, C_INVOICE.DATEINVOICED, trx.movementqty, trx.movementdate, trx.ad_client_id, trx.ad_org_id, M_PRODUCT.WEIGHT, M_PRODUCT.M_PRODUCT_ID, M_PRODUCT.ISSTOCKED, M_PRODUCT.PRODUCTTYPE, C_INVOICELINE.M_INOUTLINE_ID ORDER BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10) AA GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10, TRCURRENCYID, TRDATE, TRCLIENTID, TRORGID) ZZ GROUP BY NIVEL1, NIVEL2, NIVEL3, NIVEL4, NIVEL5, NIVEL6, NIVEL7, NIVEL8, NIVEL9, NIVEL10 ORDER BY CONVAMOUNT DESC) B LIMIT 100001;

[ Date: 2026-07-15 13:33:49 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

SELECT ADVMRP_RUN_INITIALIZE('100','FF8081813423E947013423EFEB102832','FF8081813423E947013423ECBDFA0007','E01229FDBF9342E799F3E08FDF838B0D',NULL,'006D1F54BDDB4D0281D4F10ED951E161,00B3C57EA9284BEAA619BBBE854F6D33,00EFEE638D904D8DA6F83317DDF49370,01787C5F539C4E24A1437A48A097D5F7,01A8BBA9E7004A7F9FBFBB64D92C90B3,01C69134C2814FD186D8486A3E21AC21,01FBE6FE352C4060AD881347439233C6,024F136AACAB4CBD869EB023D08A850C,02718AA2CBD24367A98E3B579B133B58,0336990733784B6A8F68D33A3132E148,03B9B5FDF1B9425296AD279648D0F491,03CCBF2DE0CD4CDDB384F02FC2C4DC22,0421735BB7704097A007248121B4D354,048C4CB5B82E4DDB992452BD1F583790,04E553FA7CC347348D911576E07A505F,05184C22D74A48E28553A88E5C655C82,0526DDACE0A7459A93B066CA43E9F5B7,054B2114870E45EC9120B30CD1C2C58C,0576AEEBFB0D414B9259363CADCAE859,06DDC93E61674E5D90258F679FEBD0A6,06DE06ACECAE42C7AC647ABD6142C4F9,07154CF2941841A6B2EB0F699B14BD69,07D94E3BEDBB408CA87E644A0DA49FED,083A886C6B714706AF51A3D23EE53C59,085D97B140714E1BAB90B114A2E65085,0889C7999A514A409417E1DA3541EBD6,08B91E60F88641BB8C8A7057DC2C9123,08E82CAA265D42D2B59A4FF0D21F5D26,099C936D6B394A1EA24AA0FE691423E0,0B864C6E040D48DFA4B4B0A5C38C1BD4,0B8A3BC981C34EE0A7AE826347D6E19A,0B9B334B0794452D82C93236145CE1B5,0BBB8EFC880245B3B4DE64223C4BDFC6,0BFA739BD382415DB2D69EB64604E823,0C48AB504B874657B63C6E023F68B4CC,0C517F0E99AD460AB99A71F87F9FD37C,0C7A009F8F1F4594949D2BFD60FA95BD,0C80D35805B14686BCDF160BD1B2D8C1,0C956520241247368A9A69A79C0B5392,0CD58BBA4D434E6A88948DC4182FFD1E,0D029D210B7C43628256F0C8B9FFE8F0,0D2352BF24F0499F971B7D710D190F47,0D2BFB93358D4DF0BDC7C9F1A75376D1,0D568D5728504382AEEA1CDDF62432E3,0D65B0924B1640BAAED8B2A042632C1B,0D716680870040F6BA8CF71B0ED7595C,0DD76FF4FFFB4CF28263E9B28405AC27,0DDA30463009416EB645972E9643B3B1,0EE9F3589F3D4B52AE18AB7D129EDFEE,0F56D8EFE51C48A98B81459E945BCC40,0F954F8412D842E1AD850A935115E499,0FD2B9B9D0724ADFB11C4258BCEA9E64,0FFB79B10B79476987D4D9738A4C7815,101D56F89EDA4B87A4168FBDBEB75A21,105B6425DF37491CBEF774F33FEAEE89,10DAE53D4B3846C18F78712DC02D6E85,10FEBE26060C4F7DAFA16342488D705E,111B9508BF8148539D8C874F1E3F7A81,11A016CE406F48F49BC6BE6FA3B4367B,11A6D4DD4966400FAC0C3ACF37549AFE,1203A06BBC674B37A755E9384BC3331F,1246B42AF95440D19EA73BF758436E4B,12948B863B11402F9A1D69020B26C9B8,1320682917934F4FBBC8C7694C552239,13788CE9D41D4ACE98D5D980B0FB0742,13DE5C07EE0F49C980E18622CFFF4EDA,14069801E2884E22B5255CDA4C5F5CB7,14F0AF78BB9542A8809CDDCCA9977C65,150BCF31091B44C49930CD2D24D188D6,150D6EDAC5C443BE977CB3F02DD3AB4D,157E42C57E224D3FBBFE08FBE1C5F5CC,15973D1817814458A088D349857F5B58,15DCCB865A324E7BBC9116030A21463A,15EDB35A1F3248E3AA86FFC0A4F1932D,161562F1E2DB496CAC286C0745649C62,1647EBB28BE3463BA917C06B2F249409,16BAE93695BB499F8D0920873A98D68F,16CB5961F2BE47118643E2DDA682A4E7,16F712EC889B44539124BC9677BFD4FB,17046F717FC84C7CB7F4ED9FB45A0625,172268EB8E6C483182CAF87F049165AB,17479A5291D44FBCBCFFA5A439BEA94B,1760209291BD441782B5F5E61B40D852,17CB635E6AC441B0A6DFAAA82556CD86,17EFB00B58D84EF39F30F35CD83386B8,183E0E0B8C20410FAD9EB08F28950B53,18628B1418E74383B4CEBD175CB2DE28,18666B62276D4E1FBFE6C2C49E4C0492,188406B8FBC84891BA20B66ED81B3C28,18959D0D8ACA46F3B9FA7508970FAC60,194E191CE3A04A2CB4905EC4722AC0B6,19AE6EE0C76E4F938B2E7CA8CAF11E26,19BF06918FF44BE09ADC508285985DED,19DC0CD5234B44BF9434AD29697AD11D,1A970079452D4CF1BF938A6F7CD9C035,1AA5A12BF8C443219D115816E444A7F8,1AE0B96D20DC49BDB4076948068F6B63,1B09FF8F6FBE4818A8365CAA478926E0,1B396DBEA6014087A1F3E79781652B44,1B5A4252B889468CBE4B400D21052A19,1B5DBA846A854AFF977C3F58DD4F2743,1B8469BAC0B8491A88568B6BE1B35BEE,1B8CB1516327454CA39EEE86733A05B2,1BB734A9525E4B6984FD38C8FD863808,1BC596DE222B470FB284F72890C0271D,1BE225EE71B941FE86AD81C8AE0A3BE5,1BFD5FE51BBE49D4871EDBA367D49784,1C0F182EACAE43F097A633F2F2CE2000,1C6D3BC1E2904E9FBB939B42742C0CC8,1C912272450F4E8F93886BECB9D0CDB4,1D285F35268E45EFA16AF4FE2C1087C1,1D643A323AAA447A95427EBA853E8794,1E2126FF1F944B26BEBF7B0C1A0CD94E,1E860D65D1D84E4B930653262C9F8A43,1E9314049B6E47A6BBF1C2B7A28BB37B,1E94E6B1349E46D9B5218B92C8F9D221,1EB1039271C4499192BEA978C7B2392F,1F66752530D84DF29317060F39DDED66,1FB092BAC29C4461BB3A89F41D97A391,2089A1AF9157491D84884464189474FF,2101CC200128460E9855D5CDC4B49E0D,210F1E71BE7D41F7BFD54958490E29AC,214FC8BECD2D4E129265D8507E35C927,2170A67427354C3482FAC01BEBADC91E,21A70CFA14CF4C5D8F597F14FB6C7098,21C2B48B2722450D944BE5E01357A82B,22147BCF34744A28A87DE58FC2A1ABD0,22D47B564A1A4ACCB1FCF91B21479ADC,22D81D7D0DAA40AC84922D0349CE4CB0,22D8C02F8810403F82AFFCFDF2647D4A,230275967A4649BCA02887E5E89F2348,23074DA3E7EB43839A21DAA5898914D9,2313A1A99735453CBA4C2D2BE5101BC8,23169BBF40F94C74B78982B61FFABC30,23750303DD634355B8D810E4A83779D7,23B21C5A740741D8BDC8BFC1CD0D6C45,23C8F3A8C28D4B45BF470BE3C657EB62,242262C1C5A34099A8DA50A11FACDC19,2477B696C00B4D12B9AA0916DF97EB21,24D57E1D653B4D60BD8A8B32B634797F,2561D68C1EA441D9A4BA9F700AB66809,25F6763D2571422A87A79551CC3E54CA,265079B092444913A9A20BE5CFC214E4,26A77C7C3C554D28A00992E881317DC7,27159A517DAF48C1A3D27A5EA7F8F3FD,272F35D6AC2F41E5ADDA7F907611DDFB,2773A115E92C4BFB83E1DD97CF70D621,27ACD66C143D4ACCA8C121DC53AC0F56,27F145DD8875451EB5299F8F22837B57,27F393EA624C434A9E457B1497A2C9BA,280ABAC8997D4718A52F7165F4EA3090,28AB7121C92647CEAF5976B01A9F2F77,28D63619F0424D39B63D108B4D9F5393,28E1E07B279C40C7BB6C7A266EAA7010,29FDA92B8C7B44F7A8823ED43E06AD00,2A3FDADABEB846F6977F69F593F1FD86,2A5CD961A181492A84FBBF2BC5CDD4CC,2A6CE8878B1741809C50F0D917CA2E4B,2A6D3BAD24994D87B6C674EAF4FAB008,2A73AB82E4CE4A1E888E4ABD4D5FE0B4,2A89ACF8F36D41FB9B79309CE96DC687,2AA25216E4324FF69D2F70A02EFBA1CE,2B2DB21F61794E0AB6A97DB37837A3EF,2B4284D881334B20BCA31AFAA5E1E580,2B5684484EAC4EF1AD6FF4869CE88CF3,2B579619BDEE46838DD1D42FB5D0FBBD,2B71B5D85E844CE698E27AA73E41F09F,2BEA084BC06D4CFFB8D3503371D265E3,2BF867DCC1E144D083136BEF4C778D8E,2BFAA2C920424404947053419E6D29CE,2C0F37410C1A4DDF992402A4E836CE2A,2C3C892F341E484CAAFDA03365BE0BE5,2C7A16F12AD8486EBD85F34E78983AAB,2C9AFB9F22BA4B2680560810121674A1,2D1DAB8115D8456CA957302085EF674A,2D1EA0FF86624FE4AACA594F0EA39519,2D5B66D751504D74A14DDFACB86608E0,2D9A11F6E5ED47F9919B1C54D093841B,2DD181554E584523A50A284D4D5164BB,2DE0548243F84174958EC84525CFA1E7,2DE6C3554F0545C48AB70FFF334BBE1C,2E6C3D44D4D14A349930AB9429A646E6,2E7B3236A28244B3B1D6AC679F6F5A7B,2EC01B837EC844FC8ECFE37DAC453CF6,2EF82E507AD84196B7FDA3BF9789B0C1,2F012419CA284BD496550EF0B3A78A2E,2F051FADABED4601801C4AC490F4030D,2F21672F738D425D9771AB0206A1A62D,2F375D5D2E0145FEB88277A2B570D6E5,2F4D3B58D7B8420C8702EE4F688EE154,304F1B3F80534A828772118A2C80279D,3079C833062649BC832977EB5E719D9A,30904522AF19433EBE3B9EB1B88F30C2,30BEF8A38D6A433D8FCCB6D4F2418967,3199CEC5EFE940308FA85090729B5707,31EDBAFB4B3F497087E352CF8C959F8A,3214152A9D394FF793CC11FA5008CBEF,3241C5AB31B347009C48E593FB996394,32780EA3D2894C1899DFB292CCCC7ADB,32869ACCAC9040628EF294F9C5ED0EA1,32BD1E5AACEB468AA4F70A1A233A1AC4,331C46D30F7149FB9A130D444245BEB6,335742A76B82418AB567DA39DF37945C,3357D1B90C584957980DBE6746623039,33856E52FAA64F8DBDEB51CD60AF9F28,33C2646A20AD4F13A6499C44EAC1CBB9,3413D40071754E83881BCE36943B1AF6,34386E6B9783492C946518DF7A4B729C,349DF2BFFD804D61AAEA9EFCA971F47E,34B20372C3BB4FAF9730770C79D7124E,350EBDAE1EA746359A4C7B51E5739C7A,3556530A265848FCB621CF787E45CC4A,35B87D295ED34A918B0231D9D6A83CCC,35EFD0CE593C4B33B42DB0B0C6F48869,367657CFDBFB4B9892F1BEF18E6ADE6A,3678F231B5004D319EC76B48A2B31887,369045BF2DF643F2899C3D57A2F6CE3A,36AE529F5274415BA3D516BCE3805DA7,37997E2B65F743A9863C1B2D694BC12B,38A7EC6954664CD0AACFDBB535AE270C,38B1934F06474E68AB8770A71FFEBE6E,39415CB89D5041E5B559B8F4D1D7698B,394A2830368245A3A04434649787AE8C,398E0B81F08E40B4B1FC7047F7BC44D8,3A022A419236407284F837EBDA149BF9,3A7A5E2D896144C586BB0978EE061350,3B4E4A33AE2C4F8980F2422938CD5D99,3B5246C3BC9B454FA13BB5455F43104B,3B9D9C81999D415BB59AFFF205939E08,3BD24B4549A64106A23623E7A987C2B0,3BDFFA1A52D84F868253134236232EF2,3C99C32FF0EB4F34A1BB203ECC66A21E,3D48C5DA972649C1848A30996FFCB277,3D5AA51DAF9244ECB4CA8979FD387E88,3D98DCE01A834BF4A39ACECC152E1C13,3DA197D2797D4FAAA42DF92F84A6CD74,3DB5AE1E340142EA90D05D8F18559390,3DCFAD4081224583BA1AA7E18AC062FD,3DD108F860CE4A3B98D4BF50290C6F9A,3DD82F7C48BE40E988955FBA1244BD1C,3DEEC69F87CA4BDD9E3F051BD706C823,3E854694862A4D93BAE40E920E42E9B9,3EACEC66630D40CBB7C9B9A0936B3187,3EDBEE2EF9174357B9E5C214563770FE,3F1BE4A481454F4CA8BAE030F406D60A,3F401574671A4C6A95663BCEE519C517,3FD41CA95D0441CAAB832EF1348A34BE,3FF6334EE8794E6EA19BDDC7A9C3223B,4025535AF0A643F19427E6083D34779E,403994872A8E4467B9AAD04617812D7F,40506111289F44EFB91487AA82AD9705,405FC8D3136A481AADD850EF9D50D62B,406A0F52DD04456487F1A77307134C4B,408960931D8B47648A5BD5C8B0DAF827,41655749FA904797870C604DEFA3859C,41BF54B42BD04C798F6BCCCD9B5F412D,42452AE1BBD74EA09133FFF4A24CB3F5,42CCCAAB923B4C3A8125E34C5EAFE50C,42DFBE7EEAE4476BAC2D3698B6999BBA,43085D9068C54253A36FD609CFC40919,431807C5976B4B4782D725CF50CA2ED2,431FD2F00C974A35B230C56282E64C8A,43512EEB340E421783E2A5E16117A0C8,4354735342F3430AB1787BD07A74C89E,436852FE7E6E4EEE936A0868BC8B23B8,439F2E1D6B8D423FB72061C3CC895F6C,43B299EBFF1A425182928ED4A9F8BD6A,43C7BB28C6904440852D344D57C45071,44086D89F7404DC090E21C017A526D94,449E4B82FE7D4186A18598883FF72EE1,44C8A889EB864A448B58BFB0FB84AFE5,44E02F8CFECC4E47A175B2901D832223,44E5895A06254D56B2D67B9A5DFF7184,456C2CE0763C49EE9C8BE9CC61667C83,45BA1D7E13E94FA5979D03A60B440991,46006317A2AA4C8DBC87C36A68C8A47D,460F93C9A4D749BFB0B86FE05290D23C,465956EF86BA47B78679DC651DA2F1A3,4676B2DD633349F486F4ADCC43C5BC13,46797E2C01F04A4DB86FE0BE40A62D1E,468F273BF95046118EEA3AD8C2937D8E,46DE26E0001D45CEA04691B3EC9A196B,478866ECCAD3405FB0919F62CBB0AD48,47A2C5858F93474DB168C7AF13EECFBC,47B6B1A7335E487A964F5C3899548215,47CACDF752554CCF8163D055F4404600,47EF67685B3142B2997DDF4C8E8382E9,4818AD94FF524181982EA50B1D5329C4,4832FF7DE00D4B36BF63F2ED71995785,4833E3A367B14C5BA7F76C9910992076,484550FE8C5F480EB4B95598C5B630BB,488965E4D80E4AE99A764F88D22B80FD,48A231147AA3455E9C2982DBF49279E0,48C5292BE2864B409D5C6723BCEC8050,48C7A1607CAC4596A7809BDA7BAB30FC,492FB326B960444AB0A77A84F9458E3D,49EC386AC9B742BDACAE90FE04B29CCF,49EF3FEF6D6343238E6A876BE30ABF9F,4A1EF932C5EF4A5C87041699B32D6509,4B03B9E8BAB5476E81ABE3689532649C,4C32C52C04204F8C8825A2BEDE2024E0,4C3AAF757B624A77809F2C37FA4FCED8,4CB8E5B0698E43A5AD8A6DE09ABC4A09,4D1658ACBF794CDEA1E16200CB84258B,4D22159033724F2BBBE280CE4E6732C4,4D4C136127CE401888E4B4F5E9B3649A,4D5A7A0363DE48A7B83E5A92457E3CDA,4D71DAFA92594659B76A2D760D32C3C6,4D8041234148459184DE819936BCAE0E,4DE117AAEDD24C9D8FECAF40BB53A4C4,4DE7B4ABE62F461EACAF88CE10D8257F,4E2EAA2D3A3B4ECEB8AF3710F0C7CD94,4E46FB3F91C04EBEA9CFB4603A13B765,4E5F1C1BB17B4273B2F3D647ACDBDC43,4E7EB7D401BD4DC8BC47FB7935FC7D6B,4E8499E71F984D65BAC49A500836044E,4E8F1158BEB64E95BBF4BF74701CEE2E,4E9E920A4C1E489C8F2C85D1AF46B812,4EB83AAAB119484A9792D0852C4E1732,4F12A0B76E8E4DCDB7774B755225B2C7,4F12B33093D94BBA86FAEFCBC71A1E87,4F16784044AF43F18A73D47C52093320,4FAB92D0885645E9BCCBF8511517D0B7,4FED3555C0EB4A02A657E9AF6AB29E46,5013A52A0D5B46C98C9CFB3D5F838261,50D8BB89AC9B4639864A8ECC9171F1FB,5146358A6C284E329DCFBFA4E7FDAFEC,5254264D8D134E39AA9F7BE9515B9365,52D3E599DB4640B2B74AD5AC99D85E83,531464C08EDF4CFCB15F7410F9519BE8,5338AFF5F227454280AE6D733CB7C6B7,5347DB70CBBB42AC87D6ECD325CFFF96,53B9D1D693B24BFDA3E6DDA0CB2029CD,54208CC624AE450BA1B7BBF30FAF114D,5424062E2161494398C98F782EA9B5E1,5439016F512043899403230F0A44F602,54445159A22E485F9F3644A0946D4CCC,54BC345382344375B228105BADDEE232,54E80E0988304375BC3FA022833BD099,5500BF48853F4EE2A285B450B74047F0,5532EF5864714F6894E121AB9AEF2E07,5536118439EE4C5BAC683BA8C4B8C53C,55DED420E59649F191323E7587E7DF5F,564A3C8DB8DD4C0FAA206CA5238B5DF2,56543CD39D904CD1AC1F3984F981CE30,567468FD3AF4415F88ED9AB2961FD236,56F50D83AE6B4B2685C3EF50633A1E6E,570BEB9DF2384F2CA46FDA61A4E6C151,5727E4C81C674588999E0265C035C251,5766D6B6A01142F6A88476BC161A17A9,5799FB97893C4B4D950E6E2A67EE8D4D,57A0251D53644362B139A79E98679456,57CBB6B37DB14B60A40A3E9746C76439,57F4DB2BF2CB44F0B04CE4CEB379679D,57F9F07F7A4E4A7897A9AA04D41839AC,584D19A881DE4B31A060C3955A82394B,586B950AC81F4484B32CD4302BD2326B,58ABA20A35624959910491B515D208E7,58AC8181A59140C99B04F2B5689F6DAB,58B2359826EA4E3E95F28A332DBA4A73,58D5949A6DB949C18CE2D596EEAC9C2F,59211F82961C4C3D93C8DEF1745CA662,59502C56164847DBBDE391D4FF9C2785,599870FF16E9417D83D7633B51DD1D23,599FBB2CEE3943DCBB2E5CCA8143669C,5A27DC61B610450DA354DB01691C76DC,5A54C0D1D7F64C0BA3E134F9AF5F6AED,5ADD5BE6A307497382BBA1DAF9A076F3,5B01C10C1D544B42A6CA863901E518CC,5B154BF3EABA442FAFA8895769449642,5B5F2B13394F478FA6C23D71D5734EB9,5BFA29269E924CAE93CE1CF8DFF46C8C,5C1E3B8EEE6844BA8E1C8B26053CEB93,5C1E8E53163E486DB4C417454153CD5E,5C7AB049BD7D45D6914425733640F409,5C974C5AB67644C58B7B52E14AC65BAA,5CA8FC6975D6498C9C771D34CAA4EB98,5D092D5AC4E641028D9098D1FC8A2B4A,5D2B20EF08F640719A9189907A5E370D,5DD34955640C477E8E111392F7FBBFA2,5DDFAA21BB7F46BC82A9F9396512F8A7,5E0CE65935874933989919BEC7093246,5E2BFB00336944F094327C578E20B030,5E8BDDDAFBFB4A5794326522DA46BD10,5E9D90C57FF344618180A1718DB9BCF3,5EF0291664AE485AA3A787708FD319C8,60077B74182C447A88F0F57232B655BD,602B3150A07849A9953FD7883BCAF469,60A138A58B44417A82A1D765AFE31C28,60D7BC76F05D47D19E8A56B193374C27,60FA5F322BD6492F90ADE46301DC9952,610EBF1820A34D1E9B6AA95D89ADD2A8,6127D2C525F6469FBB36C0BC067A3E76,613D99653B0B40CEBC0D68B49B688C45,616EA3FC1F0C41E189306C513628ECFF,6198AAE6AFA841EAAA191C993406E47F,61A729AF65C24604A174ABDC2951977B,61D8F0104C7844D486A660124A829AD8,61F250951824496E94D835785D5182E6,6253C63DB01E47DBAD01FB3DCEB831FB,626230AB18ED46EC854EE0F8CAA16F27,627BE0BCFCA14D3AB4D5B9F29646CA51,6299C5A88B3B4F50A682C6CF1BF01747,635660AD6F8540ABBCFBFE8111463CAB,6362DCF5A89C4D57877B2F89ECA479AE,64EDBABC360344B2AF958BE1127F508F,653524F3F8A84112AEDA7EB968A3C326,653AF7CEF97B4E288CEBC1F44F438801,6540BDB951514EF9AC347EFECD6770EB,663A19FF3D8842168211558E84E58781,664D789F63C9487E96C58162135AF60D,666752D6B7AB4DD9A93CDFFE8566523A,66AA42427F724CD38501061B859663C7,66BD1C09646D421A9A999889D7C96BEB,671E9A7F47F541D2BEF7C334A2A726A5,67694E6D50D649E29D524248F9A41270,67F8AAF1D38640738EA539DA5D64FBBC,68680FE49E204E608E9FD4F8B4DD6BB7,68EF28F586AE492BB42A38C0584CBC43,690E8B93AAF3469C8309035146D7D7CA,6951809F6F9549689C6C9247496356F4,69AF50B2CBD747BBB68D9F04F8384102,69C5C690DBA844959DC0EDDFABFA6754,69C63FC03B194C25B7EEDE2E67ED11BD,69D0BFBEE2124D0CA426FEB4CFAC71E8,69F8C1D1797546F795E1EDE30DFE515B,6AB496AA345445B4A69ECCFE7C9E8AA2,6B051780BA124178A46BD2037650B381,6B1603BBC9634EFA9E2C882CEB342317,6B4DCA0376CF44FDBF999875AE78147E,6B750134C05F49D4878015CB263A8EE9,6B8EBB414B5B468C8EB86F9B356DE04D,6BA3309D266E45C0894F393092971E0C,6C5BA2BD42B74DC3A07BB9FE8124A9B8,6C7F1D41AA724E0AB097B8EA928E88BC,6CA6E8D15B324AD896E05FACCDBA0986,6CC7CE353BF34C8DB99B32B965CC0426,6D22412BAF154BDCA4FAD70382DC3632,6D257C8F1132431C9CD8386979D65FE0,6D2C84EAD1BB40CEB570FB96383C1FAA,6D43CAFF3E7E45C19A1EBCD8D57F09FA,6D776D38C5D6403889E407A65B77049C,6D8698FCF6484C6ABF8DD1ADD5ED4EEF,6DB4FCB4D4D74F6E9E725B4AD5112AB7,6DB93019480B42A4A05757C858884518,6DC787AEA57548A687CF3E4E969FA59C,6DF871FC232043DE8898335627AB8268,6E857374E6ED4EA6B9DC373BD3148496,6EB93FADCDA14FFAB9E39A1E909E3ADE,6EBA30F42DF64F539BB46014B1921DB8,6ED53317EF3C43CDA048D5807B4738A5,6F1AE83728B84BDAA126801FA7EDF95C,6F2F550971064F73844626BD96F77869,6F71A34C777543B4A8B0CE932B6B1897,6F7BD5BF708342159A43F99EEC5AADBE,6F8139A2790E46329516DAA43CF0DCE2,6FA290631BC24625941AC3C46F5B7780,70737E415B0240AA9C9037573C77871B,7076889EA8A3469FA6F0D7C8F3727694,70B82469D105427BAA03B144E12D1CF2,70B8A3FC4F774877BC43407F75D75113,70FC14B8773B4E95A97414341CCA96C4,71002CBD468B4A04AE6E9A8B6571E719,7106C9DBE53D4856BC5BA2EFBCB0576D,7275E073ED8E4BC9983E9C195932B064,7287B3E0163247F6876503998E39B146,72D28D6215694B14B738C104FCC32C68,732690B2FEF34968835B9DCF45A7C5CD,733D6F79963347B3959D013D8C7D46BA,73604F983D7344DA995A26E4179BE02F,736A59AE391B40B49FE6A6B5428088D4,73C5808FE3C847F3846F2432D849241A,743349B4BFEB4590B16F7904ADE3DDF3,746EA18B83C440AC8EC0E86E073501CC,747240A2CE194E729E68E71449ED43DC,74916467583D4363BE93422581B2CC0D,749DFE81262C4AB0A59E380FE12B8A57,74DB4FBB8C5346C2B3C93365B2E93B58,7515D508C5D546C4BE1DE4744775F3B3,757A4AAE48F9420A84DA360B5101575A,75842A755765460BBEB2E7432EA4FC11,75BFD7BDC65A4301BBEC14299D19030D,75F18315B0464E558CC777F7BEF31A2F,7643AA6B7B4C4879ADBBEE0F13FABC43,7737226341B644DC961409B36E0FDE7D,7743AEAB712E4CA4B4419B7A9A1BAF71,77AC90F1932E4F839EA8E65AE4144AEA,77E761516A094F089F51FB57AB4CEB17,780993B4200B4263849AA62CC55C78E5,782B335A1E9D416AA848C8F601A1AE30,785F0059B7C24586BD8DCE8CC135954F,7865C83CAED34711BF069A7650F262FC,78AA036B05B3493997D49E2ECE7B35DE,78E2A32B6B3A4D2389B3BDDDB60E14C5,78F4E5F26BF74E13A3F91D6142B69D03,790747F562D1444A8FADFB408DF684F3,790C3B8ACC974E1F947B0D0B1E4BA363,79562745FE5E481F9B31530FDC75A10D,795CAE3CCF2A435883CA2E445F893355,79608E65DE4C4A3392D5486AE7CD681F,79B97A13011642A0A231F92D0D04B744,79F0AE3EDF8A4656B6BAADD5CC7F2DE3,79F8FE21212047A2AF4EE810633F4FFF,7A0C9F98AE334C4B897273C880E0C313,7AA8E773B3944456BAB8F5F709361109,7AC8B866E71D4355968A9515B31DBBB4,7AD329A2E1EA42078BA4BBBA23EDC71B,7AEC7D598F474B50B6BB9CD3A6612A1D,7AED32CF757A4CE89FADF66DFAB7186C,7B5C2CE39D944BC9A523BB62F2A92FDA,7B82AA54C5204E1C91527683158B98D6,7BBB767CCA4B4139BB6CCA9E786330C6,7C5B1DA9F0BD4E7A924087B112E842DB,7C5FC905463944468B3BB793950870F2,7D100B9980244B9CB283418D79B00A97,7D159BB50923467E871A5B10D3C27401,7DCB3D82A5B44B9ABDA1501401A29230,7DD2844E58E94F27AC9AA159D2398980,7DDCD2FE1FF04107A51C7B58AC07B5C8,7E2A890402C94F4FB4B346B745D94841,7E8D600139224388A3ED5F697F6B14DB,7EE25437CB944E138F504E4CD19ED638,7EE63C44D4CB4CF78C318CAB8A8E9FDE,7F2EC28F1FDD4506AEF09F8F065AE347,8019ACC804CF4737A73A64038CDFCF4C,803C1F6EFCA24264A545D4A6CDB3BE00,8068002240C7483CB35BFF450AD88D1B,80800C5F4FF347B7A7DB5087B8134E17,811C668C63BE49B6B0C1BE69142A61C7,812280E18D774037A437C83DEBA778EC,81462C5F748B4A988F5897C7E86B8ED9,816D09F430F345F7BE6F6491AA0379AA,818542E819184C988613124A8526B3CD,819B989E3403450D84ECFCB299305EE4,824D5A76627F45B98975A12E0A469E38,829DAFABF1C04454BA4C797CBC3E9042,82B0540EB29843D28C1DB514169DB42A,82B1283BE8804513AF4CD7C10D5EE059,83DC32E5E2544949866C5DDFD181C07E,83E3171F43DE4CE7A48A54771B9D0B83,83E4EC5638934C38963FAC5BAFD90E11,84322CA4F43D48DD9FFE2047151A8E57,84460DA6D7C5437B8EFDBF60EBA0BCFA,847C76BCF489416E8597AFEC47401F01,84A985C180874E7DAA0ECF8751EA523C,84C51D6FFFE140139E9F085435299E50,84D545E48FF0447B859A2A180F378EFE,8519F6298B0A4FBB9E62683447F82164,851CB8D299EC402898A200B44D828CE3,8585B025A50948A3968C8381A2BD94E0,85E179495FBD4DCCA686B2E30AEDCC81,861925381EF847E783B5A32677B9120D,86B8C64EBD3047F3897311121AE3DBC0,86D19BF9DB844D77B88BDFC7200993B4,86E2A8F75B164DBFA776F0466C6ACA27,86EF57F5D4AE4B829D92B4146B7DBBFF,8700466B9E6B4522A9A64F2645E7C9B0,870CB374008D4006BC087E36E5364912,8735E0E1E7324FD89B0E5A1E840F545A,87526D1DC7DB4F11B6B9868E0017694F,8763E87666DD42E8BEC082D718D3F004,876D0CBA4B4D4D68846D8E7176E71DC0,87D50D916736494A9185668026D37491,883C592C02B341C9A5BFA222A72764B0,8881DA072E8E49AE8801B8EF0C2E877D,88875D63725A477A9CD803440C3EFA6A,88ECE86351AD419AB27F51D4E26DFFEE,8917984AA9384DF09AB6F75D24072491,893EF0CD08DF4144BCA929154320789C,8A05788214664808AAAD1364F64DD91A,8AE0D55EB0F14A4196711AB47CE19FAF,8AFFFE16EBFB4BF88415423A50116EA8,8B3ABE1DB16C4F4B82F1F3E4A2DBC129,8B84FC72F5D1486087B87F4C228070EB,8BAFCE96099240F6915889B9B4E582AA,8BC9070BE1284C3BA570F9555B578B97,8BCAA76F08CA4356BC493D9EE939BAEF,8C70612A6D994252A1DD9184E7E77A4A,8C7478CF84BA4DFCB59122C95DE6ED8A,8C93995F0A64420F8DAFA97EAE7FF95C,8CC4502277CD44E98B85B5B0079DFE5B,8CE8A1C1588045A29003DF89A5E3D02A,8D095E557C384E878E129A136ABAD044,8D0A1AA072274AF5B7763A8FC04C8EC1,8D10E73D6ADF41D0BAD140E36D8039CA,8D1B05FC185F49868A3B0AEB9837E336,8D26B79CA0D7462FAADB0A1A8429523E,8D5712868E884709BDDA89FE47831608,8D916D032402432DB4298A2F5759F47A,8DD366C4695E4A1D9BCFE54DCA2E7C29,8DEF421F571C4BC2A9733EBA0BE9E3F0,8DFBA8510B3C4616AC17BC922AB62321,8E988AEF850842B58488BFD6EF53EFC1,8EF87305A1804C95BFDB79F3652EC2BE,8F0CB95132FA4E6FB90BE91CC2EFF3CE,8F5B2512215C41D79A7623A9EF70CC6C,8F957B6B24F64D3E87F6A898DAE9DD21,8FA8C5231899499DB907DC5A8972B165,8FBA15438D5C4F569AC5C6CDD031ACDC,8FDB3E32454F4C678F1ADB4E7C9E276E,8FE77361FBA644399996736FB62975BD,9000D403493D4ADCBCFF35CA7623B5A9,90473E77D37C4E179C569717433CD51E,9060DF551A73448ABDE5FE22BAED0703,906EBED4E49A476489BBB0678CF78D74,90A2A7CB71404604B4747A1E67BA7BC9,90BA4882892945C8A6F661E1C557B7C6,90E2EFE2FFD04C35AAD712D5762AE229,90ED8495B5F947CA88BE89590309B1D6,90EDCB4A43334C63A38ABCD14351E7EC,915F93F7D0134FE5B998DEE89745F55F,917EFCE843514378A19061ED5016C97E,9219FB8E3D414A83A448BB9019530893,92710DDD02C64AAA83015E52E35EA9D1,9285F92BBFA64483BCA5BEAA6D42BDD5,92BA04CDAFBA4E1DAA9061BF5EDC64C7,9329AE24C91941E68DC301FBB2E50884,934B125794F04ED1B6523FFCCCB384E3,935B31D825244588B4EFC11B3303A514,936076986FD740E5BA8B882FFD336B33,938CC0FF42FD43FDA50D028503C1F65A,93A1F5171A6D46F3A33BC2D66B8A8259,93D66BFE93604ADFA11557BC515B2E70,93FD26EC67F84E5A8B1BB82210BD986C,941BF7F91C094DBAA74DF8E048CD7BC7,946DB59AA53245A3A8033487F57C03C0,94B6133607244CCCB8372CF9F770AF8E,94E964944F7D4A57BF713B14787F6A91,952691F7F6DF41ACAD2619911B38C571,9529B8487FD34D5082E607D814A4A1FB,953BF75BACFB4133A6C10CEB7987CE92,95A36BA96526424FA5F81161D101A734,95B28FF775954E5B9C8103C11C3C95BD,95C4D85103284AD58F84D11AD2B3C639,95F4F2BEA5B24B4C87F1C82A098FA74F,95F66F2955A849688CAA61EE62CA2628,968680AEBE154B4DB67CE54C92B93321,96CFF035AC25448ABB980F0EFF8753E4,970EBE50D5E844319FEFF1AFE3BE227A,973D94CB6EC442889D6828AAF42802C4,975B9A46202D4EBA9900F738B6228DFA,978900BFA426430A8D846B0985998B2C,9801BBCA2B194A04B39501BF07724042,98150A479C3B4838BD0DD942ABFC5131,9830A387600C41BC9DD609D2CDEFE68A,98673ECA8509418BBA269C8B0D071ED3,98E865F2B96B483BB072C387F0644270,98FF0FBCE6AF49C6BCAA1BC0CBC927CE,9928F5E0C07342FCA8B7F1E1166A2F67,994C8FE8C3AF44C88D20F80635F7C928,995386361D8B4E69A7304323184C11D3,9977932F77404038B7218421319823F3,999BCBF3EED04F2F931821178126BD6F,99BB0EF359CF41F89C84176852D30931,9A37E03BFDC94F0A9E3B46F29AD78CCB,9A5D17C0AE6F4121B1983E6EC2DE5BD3,9B0D7671382448A29E96C17FFC8B54BF,9BB52A73F85749D7A626799659CAAD86,9BF54E045AC845D4B3D6B9BCD44A0997,9C51F2FBBC504067834115FC73EEAD3F,9C5DB1A17FD94B059AFA684430476FBE,9C6130967CE24ED58F5167E5AD9C9DE2,9C644E9A58264A6F84BFD1F90898CD5B,9C6A659A72464CC6858422A99B288D42,9C88FEAA000D464EBF633CB74E1A534F,9C9CDB928AAC4C659899DA8C50EAD527,9CC20DD50047481794E10A4DE61991DB,9CDD1F0582D24973B4E8DC9891B37AE7,9D46CE0C96724582B10BA171B4F85786,9D7F0026FA34421286313F4CCCDA68FB,9D9F1D3D83ED49869B6474D6F967282E,9DD98CBC610D428191A4F13A54DA41B9,9E00370570D34310B260CA8D3B6C0D8B,9E102A979ECD495290ADB8D2D63C89E2,9E3D16586D334BF4A709B0953F6192E6,9E6844B1674A4D3EA2DAF2F170644F27,9E7652A2114249F9A1BFFCF108E4D0EA,9F7CF0D0071B42C4AB1371E332BBFACB,9F9ACC0D74774FF1996AFB8B6D3AA975,9FFF360A4543424BAF9D98D739E7AE26,A012FA40E60E48ACBA0207E7A53229BC,A04D9236A41D4D7A8DDA6C5558F6B3EF,A0658A17C9514A8AB26307C3B7DEEA51,A075F58DE2994C469805E71A2EE252AD,A0AB94A930574431ABDC2DF03A19DAEF,A0DA9FB095D145A38FBC425F483B7336,A0E86C204D6E4435BE774E8B39F7F12F,A123D18869BA4B78A33AABCCC46F042C,A14DB9BCBF8346A3A45B9EC96A05B26F,A1CBF6316BCA47CABD13DFB95C034FA1,A1DA4278252C4B5E8AE7B6403763BAF9,A1FEBEEE3FB445BA8BDEB4C2670B7CDB,A231FB70F5BA4D5A948D3AC361EE2608,A236FC19249E49E8A94E56532A2AE243,A25C691AF5624892A40DBA3D40AA6F79,A2917F6A74294C908F2521BE02B24C45,A2EBA9D5E06A4178A6D661C558DB19D3,A2EBE627EF79407695D39AD0F30E76AB,A2EF04B8AB374E3695984F4C30EAEFE1,A2F5262332794AB38347BC6151D1585B,A30A6ED3753A487FB7E55CA2FF879E2E,A31C1D2CF09A497FADA05744A420543C,A3419AF855F241348483202BB419B374,A3EC943BC90F4A3B8A996F6FB17B0D65,A43A362CBA3245C195066B2D8C7CD0F6,A49B71244827488895B49DC0CDC34EA9,A52B7D5737694384B9D5B16598B83507,A541657FE1904F36BCB68704C834F28F,A54AF58F62DE4D8C925E4DCBC97B099F,A65125B0F78B4158A3C4C789E532C4EB,A65EAE8F52BB483384F1A03A9D73F5AB,A68789FBBB4646B88CAFA2504B311699,A68D586E2AE54CABB8E3976B52A94C91,A6A56E88F115469EAB274F72D3B08990,A6BD28DDA9684E9E898D5313EE86CB35,A74774EFBDED485B9B27ECD4826CFDE7,A795A262D7464EB290B9A26A967B8433,A7A9272385584555898BF549F08CB382,A7AB2DA83CB64349A16514AF0F773448,A864031B10EE4C21B376E9D4689D957F,A880FBAF34CB43768B6F18DB8C4C5A1F,A886C5C3ABAA4C31B5DFF5C05C982C41,A8AB66C0A4844D5FB390C94FF6CD7677,A8DA0C7270BF445AB0BAE9364BDFD5DA,A8FCF0DD05EB44748D6A107331957B28,A9139277C1984207B118502B19F6F8BF,A92F9A1D85A34C398EB2E27920533617,A948DBE4ACEB4126AC839335B75FC291,A95DC781F9A84FE9AFB5FB2FA6B4A6B6,A9EF7959847D4D3D8C6084279328D815,AA0C2583AF024521B9EBDCFC7439CD83,AA1D68A4D27441ECACC67D629738D31B,AA251B4861AF4C67942527B786FE9083,AA705649638243FA9BA673139D7C70AF,AA77DC019C2C42DD9015D3E3DF0AF3B4,AABF449CB66442B79D8972C5BC80042F,AB4E17A282B84FFEB48B0364C1A94465,AB71024503814FC0AECE6024BDA337AD,ABB52A9CD8C34C06B257560FF07BA404,AC219935054F48E189B9E0662FF90930,AC41192BA8DB42F78A3887D929615686,ACC7EC83D0F941269C6750A79BD0636B,ACEE8D274C6449108C4469E97603B5AC,ADEF30DF7F534B21846E31C261828497,AE033A6922A140388F6F3C9AA321A638,AE158D3CC4A44C7484E5D2D54537FF68,AE2048CB7237421DB18FB5A8B912B5DF,AE481F52AEA0407095DB71A1E28FF684,AE894B93403E4FFA979BB1D7D2B3C613,AEAF61CD5CDB4CBB9868B07FC4A38EE2,AEB64B85EB424AF0B633751571DC6D49,AEE1AE7C9C52476AB099E0C99FD116D6,AF1BB751C3B24B60B675A377C968A26A,AF39F902563A4E8B8444CCCAEBFB0F88,AFB3098BEB534D2CA243806EB966A330,B0049E9ED26D4D1C8AAF092A282CB7BE,B03A0ABD05FE4FABBB746A1341E776E5,B06D7270CB5645919B91D687FC6EC431,B0E135870A264077A8D79FFA64A725C7,B1E8BCFB9D44436FAC54C5721EEC0D0B,B231381A5FFE4ECBAD9D4B50DC166BEA,B254015EDE694D5A9CC2643C3A94BA3E,B2920784C8A54B6BA596E50CBEA1A8B0,B2B371E1CAD246998EEB64BD44AF2CB2,B3467CE52FB945AF9D921C67795F2E3E,B36759EF00D54524ACAC7EC8DCFEF282,B3717D93079C43AA8C37FA7F163DAF50,B3F35D5CDF574A1CB9CF8A0E0BD064F3,B475A7D5D23249D6A9AC428CC3C7E1A3,B47BE2B56F8B405999FAF15F2B9E42F0,B4A96DF6FEE7466DB02B9D110B6F136E,B4B283102F794D1ABDF9CC5F10402255,B4E4B05AE3F64BBFBC1645FCE98C7717,B4F9DE54520C457B90E25A59ADC5FA77,B51519B6ECEB4EB0B017E1D56B27B77D,B5624449C0E14281A21A97CFA5035D35,B57CAD69961B469EBDF95FD7E668D665,B5826359B1094897B2DD9185ED0BFA0B,B5DAF423595E4084934CD68E00D4F1B8,B5ED55B62B784CA7A617CC93A8D25AA7,B60FFC0C584E45018C84FDC63B22707E,B618FAC546E14CACB78008AB1DFA5B55,B6D2A232104440A9B62F28D7B966B925,B6F99D0CED3F4AA7A931B85B817047D3,B71F7207B20C4BF8B683AD442DC5DF94,B7339FEFF8D14E9A9A365864FAF3CF7E,B7675384F75B4E938A020103A4E6E81A,B79B96E1D9474B9F8D0782BF5EDC1A9D,B7B135DC0D514191884CF3793F04779B,B7B4130BE51B49D1ABB506E7F9D8AFCD,B7B86476E3934ECCA75E0BD5B743F322,B7F2C6749555428BB6954D29C9889F50,B8159B8874894D5F99C497B1A2126F33,B8D4671EFE0C499BA9951E1A0587FA2E,B905AC3A0562446EAA4DE90C7294C649,B90A031DA3BD482087A0FC4068442E53,B92FD1E110844EB1A3BA79D7F9B0BD52,B93510B2AF184073A5DC94430C38F5D3,B9507C845D894877A927267E12A73AFD,B9DB8F2986914DAD9C32ABA72E3A9604,B9EDFC192F5B43F4A9BD39B096E64B7C,BA30E5DE28D84F4897EB2F50AC13C7E5,BA3A2D330F834C3B8BF8021C24BFE46D,BA7748FED29D47E680375DA007BB20EF,BAA0C8D735F9493FB848FE4A98CAF5A2,BB35E0B1BBAE4CC386FE926C628113A7,BB56B5E10509471EA5A7C249576A124E,BB8E26242B1943868FA2746123EFCAF8,BB985A20164E4784B9B655A091DE030F,BC0AA0AC5C344571BE859F5554ADCBBA,BC48F1E47D464500A9127B430DB6E8C6,BC497226357F4113833B8C307DE5752E,BC7155516F8D4A96B1500F1FB3C55C9F,BC8E8D89F38B4A04A2EB7F245A36A1D8,BD47CFE106E748AA8653BDA6F80E271A,BD550E01214D405DB5DB61428BD1BEB5,BE2A83678991488FA6947EFFA11097A9,BE8E1FA23A564FF98BE416CC9BAE6602,BE9A6CC3085743A68E88AF177E6A2F81,BEECAF08E21F45A59FB3996D91D9D7EF,BF09649F970C4A46A5DFA48D03546BBA,BF6B9677B81B4905924A9D75F156BB33,BF7EE37131534C7EB65A6C818448B5BC,BF94DF3632964832B006EC08971FC0E7,BFFEE2DAF63A4B3AA229A8C90B69C266,C007DC9653494EACBD84CE6ADDD6AA3A,C02FAAD0113448D5B82C4C0375715717,C034248E723E4E61BECBBE8D6BC6479F,C0CAC959B7CB4DC7B1DCD0E333FEEC8D,C10C95D9D67C46CA8933DF3723942035,C132E33773754FDEA7AF33357AFC3BE7,C1667592649B4BFFAD009989407DAD54,C1857301B5C24AEEB5E5309D9DC06C94,C1D629DD8AF746859A0F7AAE6099B082,C22769557C6D4930AA3D2C4493F4AC83,C2B4BC6FF7254A4896B184278BE71483,C2FAFDD8BA0E4090B558BDE256F69B1B,C31EEF6C03874A8096E3D533034EE9D1,C34150A7A63E49B69644B7D63A933783,C3998BB9BA1F45D6812A005652CBFBDD,C3AEB22BCA284441979F4DB28D6318FE,C3C25809F0AB4543B4E96229CF77EC56,C40EEE2580CD4AB6BDBACDB71CC80879,C416042B4FE84191BE9BD22114469448,C43FB852A2AC4BFCB16DD62709D3A122,C45C033A3B52448A8B6BC69B671207AD,C4AE163291D04BA59AF8F8796D2BDF1B,C5698695DEE8489C801E96E2980F43B4,C59A7470091F4953ADDE54EE3F2A53BF,C5A958555923402397A10053C347ACB5,C5B794EABADA4398B6325199CD9B30E4,C5DF0E173A5745DD9DC0DF576809F788,C6044645C379494EA26839537AEB70EB,C655C955702C48E6934C3A9D2E72D7CD,C67D9F42B37744F986A69374FCD9F98D,C6D4E59BCB074239947B971432A3E75E,C718BF1842DE41D6BA33B48192C88B43,C7268DCDF7FE472D95B9ABE97EF7FB00,C73DF7EE5F894B1C9BDBF042EACAD3BC,C7447C26C9A346B78B14E8829A7A58E5,C8AD8CE745D94B68BE7B922F0826245D,C8EF46A9713B441590FEED88C57DF4ED,C8FCD3DF4F504D43BFE17F73FE571A15,C919E7BE4865478F9AB88FB73C9E39EA,C91A10641E4A4A89AC8D258E7CE6099B,C9403AE835CA4157AAE895C48D9AF04D,C97C40D5B5214994809326720DF44943,C9A96719125640FD927421479627E18B,C9B04B68968C4841A35CAE15B1C01BCD,CA03F459B75047F0B9F1DBBD047FE73C,CA1918C3DB144CB6BDE202621247DB42,CA87813D38404C0B85D558AE562420AB,CB34B5F78048433A818A9168CF2F34EF,CB66EAC08ED44CC4A1F9E622E82CFB73,CB819BDBB9DA4219AA6516733EAD7848,CB8A380A8C1341AAB8E1574DEC3C348C,CBBB46DE153043C8BBE445CB5EA60515,CBD867E7CF444F7980B482EE34E4DD88,CC369546C02644CBACC312CDDD254A82,CC882B856A2241B787702D6720BA0FB7,CCAA87C6EAC8422A9BF68789FDF1B37F,CCD6071BF14C413EAF0F2724D4E052CC,CCEC1E81F06C4C569E3CA169EFADE217,CD5866C02C464CB29FD0A3986D91683F,CE663F587D5F4BE5822399F24D874623,CE9736FE01E54B8092D4812B062D3AE3,CF425AD97B2646D5BE5FD8ED97DEB4FA,CFD3264B008B4E8D84FA18341FAF30A2,D00629A3B81C4EB6ADAD4EB5D4B99CCB,D0803A3CADF24388A837C541FCB82B2F,D0B352524F2E4AEFAE131F32AAA79C6B,D14914B4E39140EA885C5564BA459FB5,D177124B607B4C8385D353EAED6CC010,D17A98B163084844BFEFE8331F58E9CF,D1FA53C7396B46FAA36723BEB0A267CA,D2C3D90BA21448EFBDFD7036F1F162FB,D2F12E5781F242469AB709AAEEE58518,D2F8DB30071D44B483AE6E432CFEC3FA,D39CA2F361774EE49315529C9F2A1A38,D39F407B7F65479E95A03174D03F013C,D3CB7DE6B3C34E50AEC2E90279BC4838,D412C047203E4BE09E460CA46A8D6EC9,D42D2059375B454F9D0EED9ADE1AE873,D433C8A0B8C842EBA6D36FCC2764ABF2,D4353C88AB8241ECA37BD5E779CD5691,D47BAE98DE0D487BA5DA91AB44820DA2,D48C5FDB4F904764815A5E251C79C084,D4D2CE61D62647359FE0A8477F71E5A0,D4EB6BFD982249EDAA2E7C559045EB15,D5334D024006426A8D157E8911A9A53C,D55D5723530A4AF8A174F1A7B87BD2C9,D5A35682A56F44B4843D244E40DDDD83,D609DC3CDE494906AA087EAAB9A0D839,D6409B041D2B44ED91F0548F0DC09EE5,D6919636B38F485E844C39C6B9707894,D6A2030F574A456FA59F024FDF617A5B,D6C09427D3F94372AFAAEE53EFCB37EC,D6C2E9EE84B54EEE85D1DC8836C0B1AA,D6F92EBA48A4435890FCC3A34DEA6C12,D71E60AA5FB5486F97F993E37FB639FC,D7327F10909D4C6B99F6876FEAC6787F,D75727961E464A1984617ED5BCF5E673,D76DC05647D44146ACCEDB274B439C16,D780E2E301064794A200456F9EB1A69D,D7A19E20B4E04961A19E01A766CB3F34,D7C4E39DD75844A7AA1B216A1D8B24AB,D7D60688BA8F47BDBA6CD06DC9C31636,D8156198A817464BACE933AE14BB43B7,D81BFB0F195E4E5E867FC1CABD6C4777,D896AC529A4946449B4EB755590C9287,D8B979B4E15D48C090FD34C7A394072A,D8C30224236A4A7EBD59703CDA279A31,D9698DEB48B74831BBAD621B4D78C519,D98FA7FF1883438E8D91C01AE7A6D961,D99D1B84EAC248FEB5CC08D1ACA23E96,D9E72DDEB6F74573969A77534DBE60E4,DA0C6F859F064371B9F7392AD565E58F,DA16649BCDBF401C92E313FCE563F958,DA37D87B9987485EA296D6D87046EFC8,DA47C243B2994730B422BEED016633B5,DA6D31DC47B44B00A097D916B62F51BD,DB323D297BEF4ABE84B92F2F947AE9EA,DB372A4AA188454DB5178CB0A7E0E004,DB64641545F841BCAE3FCCBC401AB6E4,DB72634E18534C89B946D8A6AFA1332B,DB74939C094740DF994075421E5D953A,DBA00545EDAE4BC8BE68AFD9A302244B,DBDD0FE12FA548CCBDE14C8A0ABFFA77,DBE89226E08140EAAD4D021A9A0231FC,DC2CA4ACB4434E5ABD2E3F63DE8EBD72,DC58D786C3854471ABB1FDB18D917681,DCBF4DB029E24AFAA80320D5428B8288,DCC600AE9F8544BC8EC65D3C78634DAF,DE3CC5B3B8094EBDAB26B2105250C227,DE777BA43BFA4A6FACCF5DD61DE0A5F4,DED1139D9A8B47BC83CBAD9BB6E034EA,DF15E85AA39344F8A669582492529407,DF6C6229A5F64823B76CB2DB32908DD7,DFED6ADC66244087A61D44D393A18CF2,E027D1F8CCC94F29B09B71448D042CCE,E06E3FF8CC85483EBF7622B6083AA267,E093212B04B645D5918268494C5F8DC2,E09D1D3C49AC4027BB4A045BA413A463,E0A48E8DF9944C7EA124C9390DA01DD4,E0F420C5A3DC41B7974CBB1D1F97E907,E1375AF1BC4C4E19A286122EB9EC023E,E140C17090BD4763AA4425652A35C10A,E143245F4FB846B2B7BF418D0A08082E,E162A771A3554AED9DE6232282BEE059,E1A89863A96B4B0FA8BA15F84C08DDFE,E1D6E008AD534EB4B3DAF59FF518619B,E2175664AA964C3DBB4AEDA0BB9644D7,E23BD4DE22894CD290AE55FF91C9F0DD,E24F09AFFE0F48ABB43AC24E3F482B15,E25A0CB0CD5348DB8A544760BCFA6827,E28AE033443440BDBD14483F6F9290C0,E2AE6E128438455084652C528296ED4B,E2E4E0936CEE4F6085F5FE8117776795,E469C8467EE3434D9CF7EB2BF2951BD9,E4AE6D0D7B7146248564E63E6836F7A8,E4DCF61DF88B4F7A9D1A1EEBB9077B37,E504908743AE4A09989D9655FE49E8E0,E507B4A8DDCB42A0B408842024E213EB,E52438D1D33D4C0ABF8CF02DB9EE3432,E5E6F55064154875B9091F489814BE1A,E6046FAB784D4980A52D6B1E50F2688C,E694D32A058342BC9808D10099FDA3C8,E6A7CE2438B642CEA89C23B5FC85AE3A,E6AE47D3DF654890BC166D2E50E4F659,E6B0087B5597456FAB7551548F58D88F,E6D109018D244FB4A5954ACEAA8DB71C,E6E5AF03B0C341BD949D2AA8179A9763,E70991795CDC42D8BF9A603747981773,E70DBC5B77D64E34AF652E2E7ADBFC9F,E7187843105045889CF73ECB04D2D148,E71E70322C734EABACF52F5CB52E409E,E72B88469906459291B0D52CCC683BC1,E7581ED142F44587BB1DE4A3138C1A8F,E767DE14C7874E7ABAAD8EAA7D8CE2BD,E78551B36FD841D1A6BC938CD39C4EDD',NULL,NULL,NULL,NULL,'365','2026-07-15 00:00:00','N',NULL,'N') AS RESULT FROM DUAL;

[ Date: 2026-07-15 07:24:28 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

[ Date: 2026-07-15 08:12:42 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

[ Date: 2026-07-15 20:52:42 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

[ Date: 2026-07-15 13:32:41 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

[ Date: 2026-07-15 08:52:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

[ Date: 2026-07-15 08:32:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

[ Date: 2026-07-15 10:32:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

[ Date: 2026-07-15 11:22:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

[ Date: 2026-07-15 10:22:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]

SELECT * FROM ( SELECT op.obwpack_packingh_id AS referencekey_id, ad_column_identifier ('obwpack_packingh', op.obwpack_packingh_id, 'es_ES') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, 'Numero de bulto repetido para misma caja padre o caja hija ' || op.documentno AS description, 'Y' AS isActive, op.ad_org_id, op.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM obwpack_packingh op WHERE op.created > '2026-05-11' AND EXISTS ( SELECT 1 FROM prpp_box pb WHERE pb.obwpack_packingh_id = op.obwpack_packingh_id GROUP BY pb.boxno, CASE WHEN pb.parent_box_id IS NULL THEN 1 ELSE 0 END HAVING COUNT(*) > 1)) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = '7E21C8FC0F75407DBB14F8FB7B03A48D' and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

[ Date: 2026-07-15 13:12:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]