查询系统内的计划请求（转）

原文地址：SQL语句 - 查询系统内的计划请求

SELECT t.program_short_name,
       f.responsibility_name,
       p.user_concurrent_program_name,
       t.REQUESTED_START_DATE,
       t.ARGUMENT_TEXT,
       t.REQUESTED_BY,
       u.user_name
  FROM fnd_conc_req_summary_v     t,
       fnd_responsibility_tl      f,
       fnd_concurrent_programs_tl p,
       fnd_user                   u
 WHERE f.responsibility_id = t.responsibility_id
   and u.user_id = t.REQUESTED_BY
   AND f.language = 'ZHS'
   AND t.phase_code = 'P'
   AND p.concurrent_program_id = t.concurrent_program_id
   AND p.language = 'ZHS'
   AND t.status_code IN ('I',
                       'Q')