ad_column_identifier ('fact_acct', fact_acct_id, 'en_US') AS record_id, 0 AS ad_role_id, NULL AS ad_user_id, to_char(fact_acct.dateacct, 'dd-MM-yyyy') || ' - Cuenta:' || fact_acct.acctvalue || ' importe: ' || greatest (fact_acct.amtacctdr, fact_acct.amtacctcr) || ' | Organización registro: ' || aoacct.name || ' Organización Cuenta: ' || aocelemtn.name AS description, 'Y' AS isActive, fact_acct.ad_org_id, fact_acct.ad_client_id, now() AS created, 0 AS createdBy, now() AS updated, 0 AS updatedBy FROM fact_acct left join c_elementvalue on fact_acct.account_id = c_elementvalue.c_elementvalue_id left join ad_org aoacct on ad_get_org_le_bu (fact_acct.ad_org_id, 'LE') = aoacct.ad_org_id left join ad_org aocelemtn on ad_get_org_le_bu (c_elementvalue.ad_org_id, 'LE') = aocelemtn.ad_org_id WHERE fact_acct.updated >= NOW() - 10 and aoacct.ad_org_id <> aocelemtn.ad_org_id) AAA where not exists ( select 1 from ad_alert a where a.ad_alertrule_id = $1 and a.referencekey_id = aaa.referencekey_id and coalesce(a.status, 'NEW') != 'SOLVED');

[ Date: 2026-07-14 10:32:33 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo ]

SELECT ADVMRP_PROCESSPLAN ('100', 'FF8081813423E947013423EFEB102832', 'FF8081813423E947013423ECBDFA0007', '2DEF91A5737E439997A9DDD82F9EB550', NULL, '365', '2026-07-14 07:20:00.006', '0') AS RESULT FROM DUAL;

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

SELECT ADVMRP_RUN_EXPLODE ('100', 'FF8081813423E947013423EFEB102832', 'FF8081813423E947013423ECBDFA0007', '2DEF91A5737E439997A9DDD82F9EB550', NULL, '365', '2026-07-14 07:20:00.006', '0') AS RESULT FROM DUAL;

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

SELECT ADVMRP_RUN_INITIALIZE('100','FF8081813423E947013423EFEB102832','FF8081813423E947013423ECBDFA0007','5B19FE31BE9A4FE7BEF21E5074D73B00',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-14 00:00:00','N',NULL,'N') AS RESULT FROM DUAL;

[ Date: 2026-07-14 07:24:39 - 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-14 12: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-14 10: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-14 20:02: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-14 10:02: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-14 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-14 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-14 17:42: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-14 16: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-14 20:42: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-14 12: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-14 16:02: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-14 16: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-14 14:02: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-14 15: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-14 18:12: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-14 19: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-14 17:02:40 - Database: etendo - User: tad - Remote: 127.0.0.1 - Application: openbravo - Bind query: yes ]