Sql to view the code in running concurrent requests 2014-10-29

There are several occasions when a developer needs to find out the part of the package/procedure/function that is being executed at that moment, Execute the following SQL to get the details of all the concurrent requests. The caveat here is that the requests which are running standard programs do not show the code.