Dear all,
We have the below query :
column queue_name format a15
column max_processes format 999
column target_node format a10
column actual_processes format 999
column pending format 999
column running format 999
column onhold format 999
column scheduled format 999
column phase_code format a10
column user_concurrent_program_name format a60
column responsibility_name format a45
column status_code format a15
column requestor format a20
column actual_completion_date format a25
column completion_text format a120
column execution_time_in_minutes format 999999.99
column is_it_scheduled format a15
SELECT request_id,
user_concurrent_program_name|| NVL2(fcrsv.description, ' (' || fcrsv.description || ')', NULL) conc_prog,
fcrsv.requestor
,Case
when fcrsv.requested_start_date > fcrsv.request_date Then 'YES' Else 'NO' End is_it_scheduled
FROM fnd_conc_req_summary_v fcrsv, fnd_responsibility_tl frt
WHERE fcrsv.responsibility_application_id = frt.application_id AND fcrsv.responsibility_id = frt.responsibility_id AND status_code = 'E'
AND actual_start_date > SYSDATE - 1
ORDER BY NVL (actual_start_date, actual_completion_date) DESC;
which is displaying the output like below :
REQUEST_ID CONC_PROG REQUESTOR IS_IT_SCHEDULED
---------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------- ---------------
32906957 Receipt Import GMOTIS NO
32906857 Receipt Import GMOTIS NO
The gap between the column CONC_PROG AND requestor is high , we need to have no normal gap such that the complete output can be seen in
a single screen.
Please advise
Kai