[ORACLE EBS]3. Get the concurrent request information

 
查询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 描述： （这里有3个Normal, 但并不相同，前面分别没有空格,有一个空格，两个空格，Wating也是两个，也一样情况，不知道隐藏了什么秘密?）

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     Suspended
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 描述：

CP_PHASE_CODE     C     Completed
CP_PHASE_CODE     I     Inactive
CP_PHASE_CODE     P     Pending
CP_PHASE_CODE     R     Running

其他主要TABLE 和 View:

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;