SA Concurrent -schedule details & <STATUS_CODE & PHASE

Concurrent program schedule details

select req.request_id
      ,decode(prg.user_concurrent_program_name
             ,'Report Set'
             ,'Report Set:' || req.description
             ,prg.user_concurrent_program_name) as name
      ,argument_text as parameters
      ,req.resubmit_interval
      ,nvl2(req.resubmit_interval
           ,'Periodically'
           ,nvl2(req.release_class_id
                ,'On specific days'
                ,'Once')) as schedule_type
      ,decode(nvl2(req.resubmit_interval,'Periodically'
                  ,nvl2(req.release_class_id,'On specific days','Once'))
             ,'Periodically','Every ' || req.resubmit_interval || ' ' ||
              lower(req.resubmit_interval_unit_code) || ' from ' ||
              lower(req.resubmit_interval_type_code) || ' of previous run'
             ,'Once','At :' || to_char(req.requested_start_date
                                     ,'yyyy-mm-dd HH24:MI'--,'DD-MON-RR HH24:MI'
                                      )
             ,'Every: ' || crc.class_info) as schedule
      ,fus.user_name as owner
      ,to_char(requested_start_date
              ,'yyyy-mm-dd HH24:MI:SS'
              --,'DD-MON-YYYY HH24:MI:SS'
              ) as next_submission
from   apps.fnd_concurrent_programs_tl prg
      ,apps.fnd_concurrent_requests    req
      ,apps.fnd_user                   fus
      ,apps.fnd_conc_release_classes   crc
where 1 = 1
and    prg.application_id = req.program_application_id
and    prg.concurrent_program_id = req.concurrent_program_id
and    req.requested_by = fus.user_id
and    req.phase_code = 'P'
and    req.requested_start_date > sysdate
and    prg.language = 'US'
and    crc.release_class_id(+) = req.release_class_id
and    crc.application_id(+) = req.release_class_app_id
order by name

Checked for relevance on 14-Apr-2010
Application Install - Version: 11.5.10 to 12.2

      
      goal: What are the meaning of the codes in the status_code and phase_code 
columns of the FND_CONCURRENT_REQUESTS table?
fact: Oracle Application Object Library


fix:

STATUS_CODE Column:
A Waiting
B Resuming
C Normal
D Cancelled
E Error
F Scheduled
G Warning
H On Hold
I Normal
M No Manager
Q Standby
R Normal
S Suspended
T Terminating
U Disabled
W Paused
X Terminated
Z Waiting
.
PHASE_CODE column
C Completed
I Inactive
P Pending
R Running