Example: the below query return all the concurrent request list which is running more than 1 hours...
SELECT request_id, actual_start_date, TRUNC((SYSDATE - actual_start_date) * 24, 1) "time in hours"
FROM fnd_concurrent_requests
WHERE actual_start_date LIKE SYSDATE
AND (SYSDATE - actual_start_date) * 24 > 1
AND status_code ='R'
AND phase_code ='R';
1 comment:
An interesting discussion is worth comment. There's no doubt that that you should write more about this subject matter, it might not be a taboo matter but generally people do not speak about such subjects. To the next! Kind regards!!
Feel free to visit my page ... her explanation
Post a Comment