[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;