#=======================================================================
# Writer
: Lokanadham Thandlam
#=======================================================================
/* Formatted on 6/6/2014
4:48:27 PM (QP5 v5.163.1008.3004) */
SELECT request_id,
user_concurrent_program_name Concurrent_Program_Full_Name,
program_short_name Concurrent_Program_Short_Name,
actual_start_date,
actual_completion_date,
FLOOR (
( (actual_completion_date - actual_start_date) * 24 * 60 * 60)
/ 3600)
|| 'HOURS'
|| FLOOR (
( ( (actual_completion_date - actual_start_date) * 24 * 60 * 60)
- FLOOR (
( (actual_completion_date
- actual_start_date)
* 24
* 60
* 60)
/ 3600)
* 3600)
/ 60)
|| 'MINUTES'
|| ROUND (
( ( (actual_completion_date - actual_start_date) * 24 * 60 * 60)
- FLOOR (
( (actual_completion_date
- actual_start_date)
* 24
* 60
* 60)
/ 3600)
* 3600
- (FLOOR (
( ( (actual_completion_date
- actual_start_date)
* 24
* 60
* 60)
- FLOOR (
( (actual_completion_date
- actual_start_date)
* 24
* 60
* 60)
/ 3600)
* 3600)
/ 60)
* 60)))
|| 'SECS'
time_difference,
argument_text Parameter,
requestor submited_by,
status_code,
phase_code
FROM FND_CONC_REQ_SUMMARY_V
ORDER BY request_id DESC