[Oracle EBS] 3. Get the concurrent request information

Query SQL:

Select R. request_id,
TL. user_concurrent_program_name
| Decode (R. Description, null, '', '-' | r. Description) request_name,
RTL. responsibility_name, R. resubmit_interval,
Resubmit_interval_unit_code as time_unit,
R. argument_text as argument,
R. requested_start_date,
R. actual_start_date,
R. actual_completion_date,
R. status_code, l1.meaning as status_meaning,
U. user_name, R. request_date,
R. phase_code, l2.meaning as phase_meaning,
R. responsibility_id, R. hold_flag
From apps. fnd_concurrent_requests R,
Apps. fnd_concurrent_programs_tl TL,
Apps. fnd_user U,
Apps. fnd_responsibility res,
Apps. fnd_responsibility_tl RTL,
Apps. fnd_lookups L1,
Apps. fnd_lookups L2
Where R. concurrent_program_id = tl. concurrent_program_id
And R. requested_by = U. user_id
And res. responsibility_id = R. responsibility_id
And RTL. responsibility_id = res. responsibility_id
And R. status_code = l1.lookup _ code
And l1.lookup _ type = 'cp _ status_code'
And R. phase_code = l2.lookup _ code
And l2.lookup _ type = 'cp _ phase_code'

Status Code Description: (here there are three normal, but not the same. There is no space in front, there is one space, two spaces, and wating is also two. The same is true, do not know what secrets are hidden ?) Cp_status_code a waiting
Cp_status_code B resuming
Cp_status_code C normal
Cp_status_code D cancelled
Cp_status_code e Error
Cp_status_code g warning
Cp_status_code h on hold
Cp_status_code I normal
Cp_status_code m no manager
Cp_status_code P scheduled
Cp_status_code Q standby
Cp_status_code r normal
Cp_status_code s suincluded
Cp_status_code t terminating
Cp_status_code U disabled
Cp_status_code W paused
Cp_status_code x terminated
Cp_status_code Z waiting

Phase Code Description: cp_phase_code C completed
Cp_phase_code I inactive
Cp_phase_code P pending
Cp_phase_code R running

Other major tables and views: Select *
From fnd_conc_requests_form_v;
Select *
From fnd_conc_req_summary_v;
Select *
From fnd_concurrent_programs;
Select *
From fnd_concurrent_programs_tl;
Select *
From fnd_concurrent_programs_vl;