Query tasks and tasks status done on sales order.
hello,
I want to query the tasks, tasks status, start date,end date done on sales order. task types like Pick,Putaway,Cycle Count,Replenish,Move Order Transfer... and task status like
Pending,Suspended,Aborted,Cancelled,Queued,Dispatched,Loaded,Error....
I know i should use these tables :wms_dispatched_tasks,wms_dispatched_tasks_history. But i am only getting the last task. I need all the task done(history)
Note: EBS version is 12.4
Regards,
Jad Al youssef