2019-04-15 10:27:32.840 CEST [17885] tad@desguacesAWO LOG:  duration: 15789.956 ms  execute <unnamed>/C_296: select distinct case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then obawo_task0_.OBAWO_Task_ID else coalesce(obawo_task0_.OBAWO_Receptionlist_ID, obawo_task0_.OBAWO_Pickinglist_ID) end as col_0_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then obawo_task0_.Created else obawo_rece1_.Created end as col_1_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then obawo_task0_.M_Product_ID else null end as col_2_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then ad_column_identifier_std('m_product', product22_.M_Product_ID) else null end as col_3_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then trim(product22_.UPC) else null end as col_4_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then uom17_.C_UOM_ID else null end as col_5_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then obawo_getauomgtin(uom17_.C_UOM_ID, product22_.M_Product_ID) else null end as col_6_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then obawo_getauomconversionrate(uom17_.C_UOM_ID, product22_.M_Product_ID) else null end as col_7_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then uom24_.C_UOM_ID else null end as col_8_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then attributes26_.M_AttributeSet_ID else null end as col_9_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then attributes11_.M_AttributeSetInstance_ID else null end as col_10_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then attributes11_.Description else null end as col_11_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then m_getjsondescription(attributes11_.M_AttributeSetInstance_ID, 'Y', '140') else null end as col_12_0_, cast(null as char(1)) as col_13_0_, cast(null as char(1)) as col_14_0_, cast(null as char(1)) as col_15_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then obawo_task0_.Expected_Qty else null end as col_16_0_, cast(null as char(1)) as col_17_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then obawo_task0_.Expected_Locator_To_ID else null end as col_18_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then locator5_.Value else null end as col_19_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then locator5_.Barcode else null end as col_20_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then locator6_.M_Locator_ID else null end as col_21_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then locator6_.Value else null end as col_22_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then locator6_.Barcode else null end as col_23_0_, cast(null as char(1)) as col_24_0_, cast(null as char(1)) as col_25_0_, cast(null as char(1)) as col_26_0_, cast(null as char(1)) as col_27_0_, cast(null as char(1)) as col_28_0_, cast(null as char(1)) as col_29_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then obawo_task0_.Expected_M_Refinventory_ID else null end as col_30_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then materialmg15_.Value else null end as col_31_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then obawo_task0_.Confirmed_M_Refinventory_ID else null end as col_32_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then materialmg16_.Value else null end as col_33_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then materialmg10_.M_RefInventory_ID else null end as col_34_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then materialmg10_.Value else null end as col_35_0_, obawo_inte12_.IsExternalRouting as col_36_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then obawo_inte12_.Externalwarehouse_Scope else null end as col_37_0_, obawo_inte12_.IsRemoveReference as col_38_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then obawo_inte19_.OBAWO_Internal_Routing_Area_ID else null end as col_39_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then obawo_inte21_.OBAWO_Internal_Routing_Area_ID else null end as col_40_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then obawo_inte12_.OBAWO_Internal_Routing_ID else null end as col_41_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then obawo_task0_.Obawo_Inv_Tran_Type_ID else null end as col_42_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then false else true end as col_43_0_, case when obawo_task0_.BehaveAsGroupWithRI='N' then false else true end as col_44_0_, obawo_task13_.OBAWO_Task_Type_ID as col_45_0_, obawo_task13_.Color as col_46_0_, obawo_task13_.Name as col_47_0_, obawo_task13_.Value as col_48_0_, obawo_task13_.Obawo_Base_Task_Type_ID as col_49_0_, obawo_base14_.Value as col_50_0_, obawo_base14_.Name as col_51_0_, obawo_batc2_.Obawo_Batchoftasks_ID as col_52_0_, obawo_batc2_.Documentno as col_53_0_, obawo_batc2_.Created as col_54_0_, obawo_rece1_.Obawo_Receptionlist_ID as col_55_0_, obawo_rece1_.Documentno as col_56_0_, obawo_rece1_.Created as col_57_0_, obawo_rece1_.Issotrx as col_58_0_, obawo_pick3_.Obawo_Pickinglist_ID as col_59_0_, obawo_pick3_.Documentno as col_60_0_, obawo_pick3_.Created as col_61_0_, materialmg4_.M_RefInventory_ID as col_62_0_, materialmg4_.Value as col_63_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then false else true end as col_64_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then obawo_task0_.Priority else obawo_getchildtaskmaxpriority(coalesce(obawo_task0_.OBAWO_Receptionlist_ID, obawo_task0_.OBAWO_Pickinglist_ID), '100') end as col_65_0_, case when obawo_task0_.Behaveasgroup='N' and obawo_task0_.BehaveAsGroupWithRI='N' then obawo_task0_.Obawo_Travel_Sequence else '000000000' end as col_66_0_, coalesce(obawo_task0_.Document_Info, ' ') as col_67_0_ from OBAWO_task obawo_task0_ left outer join OBAWO_receptionlist obawo_rece1_ on obawo_task0_.OBAWO_Receptionlist_ID=obawo_rece1_.Obawo_Receptionlist_ID left outer join OBAWO_BatchOfTasks obawo_batc2_ on obawo_task0_.OBAWO_Batchoftasks_ID=obawo_batc2_.Obawo_Batchoftasks_ID left outer join OBAWO_Pickinglist obawo_pick3_ on obawo_task0_.OBAWO_Pickinglist_ID=obawo_pick3_.Obawo_Pickinglist_ID left outer join M_RefInventory materialmg4_ on obawo_pick3_.M_Refinventory_ID=materialmg4_.M_RefInventory_ID left outer join M_Locator locator5_ on obawo_task0_.Expected_Locator_To_ID=locator5_.M_Locator_ID left outer join M_Locator locator6_ on obawo_task0_.Expected_Locator_From_ID=locator6_.M_Locator_ID left outer join M_Locator locator7_ on obawo_task0_.Confirmed_Locator_To_ID=locator7_.M_Locator_ID left outer join M_Locator locator8_ on obawo_task0_.Confirmed_Locator_From_ID=locator8_.M_Locator_ID left outer join M_Storage_Detail materialmg9_ on obawo_task0_.M_Storage_Detail_ID=materialmg9_.M_Storage_Detail_ID left outer join M_RefInventory materialmg10_ on materialmg9_.M_RefInventory_ID=materialmg10_.M_RefInventory_ID left outer join M_AttributeSetInstance attributes11_ on obawo_task0_.Expected_Attribute_ID=attributes11_.M_AttributeSetInstance_ID left outer join OBAWO_internal_routing obawo_inte12_ on obawo_task0_.OBAWO_Internal_Routing_ID=obawo_inte12_.OBAWO_Internal_Routing_ID inner join OBAWO_task_type obawo_task13_ on obawo_task0_.OBAWO_Task_Type_ID=obawo_task13_.OBAWO_Task_Type_ID inner join OBAWO_base_task_type obawo_base14_ on obawo_task13_.Obawo_Base_Task_Type_ID=obawo_base14_.OBAWO_Base_Task_Type_ID left outer join M_RefInventory materialmg15_ on obawo_task0_.Expected_M_Refinventory_ID=materialmg15_.M_RefInventory_ID left outer join M_RefInventory materialmg16_ on obawo_task0_.Confirmed_M_Refinventory_ID=materialmg16_.M_RefInventory_ID left outer join C_UOM uom17_ on obawo_task0_.C_Aum=uom17_.C_UOM_ID left outer join OBAWO_internal_routing obawo_inte18_ on obawo_task0_.OBAWO_Internal_Routing_ID=obawo_inte18_.OBAWO_Internal_Routing_ID left outer join OBAWO_internal_routing_area obawo_inte19_ on obawo_inte18_.Internal_Routing_Area_From_ID=obawo_inte19_.OBAWO_Internal_Routing_Area_ID left outer join OBAWO_internal_routing obawo_inte20_ on obawo_task0_.OBAWO_Internal_Routing_ID=obawo_inte20_.OBAWO_Internal_Routing_ID left outer join OBAWO_internal_routing_area obawo_inte21_ on obawo_inte20_.Internal_Routing_Area_To_ID=obawo_inte21_.OBAWO_Internal_Routing_Area_ID left outer join M_Product product22_ on obawo_task0_.M_Product_ID=product22_.M_Product_ID left outer join M_Product product23_ on obawo_task0_.M_Product_ID=product23_.M_Product_ID left outer join C_UOM uom24_ on product23_.C_UOM_ID=uom24_.C_UOM_ID left outer join M_Product product25_ on obawo_task0_.M_Product_ID=product25_.M_Product_ID left outer join M_AttributeSet attributes26_ on product25_.M_AttributeSet_ID=attributes26_.M_AttributeSet_ID where obawo_task0_.AD_User_ID='100' and (obawo_task0_.OBAWO_Receptionlist_ID is null or obawo_task0_.OBAWO_Receptionlist_ID in ('3B4350AE39A64FA5A6846856E49810AC' , '4749FBD65E524807BABA3745FD27984C' , 'E68EAFE01FA64637B43DD34558E804BE' , 'EFDDA798E48F43D69FEC679B63477913')) and  not (exists (select 1 from OBAWO_Error_Task obawo_erro27_ cross join OBAWO_errors obawo_erro28_ where obawo_erro27_.Obawo_Errors_ID=obawo_erro28_.Obawo_Errors_ID and obawo_erro27_.Obawo_Task_ID=obawo_task0_.OBAWO_Task_ID and obawo_erro28_.Taskstatus='N' and obawo_erro28_.Blocks='Y')) and obawo_task0_.M_Warehouse_ID='FCA81F56E9E643E096E86F5F379459FB' and obawo_task0_.Status='AV' order by col_65_0_ desc, col_66_0_, col_22_0_ asc, col_19_0_ asc, col_1_0_ asc limit '100'
2019-04-15 10:27:32.840 CEST [17885] tad@desguacesAWO DETAIL:  parameters: $1 = '100', $2 = '100', $3 = '3B4350AE39A64FA5A6846856E49810AC', $4 = '4749FBD65E524807BABA3745FD27984C', $5 = 'E68EAFE01FA64637B43DD34558E804BE', $6 = 'EFDDA798E48F43D69FEC679B63477913', $7 = 'FCA81F56E9E643E096E86F5F379459FB', $8 = 'AV', $9 = '100'