Need SQL query to fetch list of Workflows whose schedule and periods are active

Discussion created by DeepakChatrath604743 on Aug 11, 2017
Need  SQL query to fetch a list of all the workflows which are active (Means whose schedule and period are active) and are running in UC4. It should also gives us the corresponding Oracle concurrent Program name whcih are present in that workflows and the notification objects attached to that workflows