ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Concurrent Programs EBS

Concurrent Programs EBS

原创 Linux操作系统 作者:Elison_Wang 时间:2012-06-21 23:16:22 0 删除 编辑
SELECT DISTINCT FCR.REQUEST_ID 
      ,FCP.USER_CONCURRENT_PROGRAM_NAME 
      ,fcr.argument_text 
   ,fcr.description 
    ,FCR.HOLD_FLAG
   ,FR.RESPONSIBILITY_NAME 
   --,FCR.REQUEST_ID 
   ,FCR.ACTUAL_COMPLETION_DATE 
 ,fu.user_name 
 --   ,FCR.* 
  FROM APPS.FND_CONCURRENT_REQUESTS FCR 
      ,APPS.FND_CONCURRENT_PROGRAMS_TL FCP 
   ,APPS.FND_RESPONSIBILITY_TL FR 
   ,APPS.fnd_user fu 
  WHERE FCR.CONCURRENT_PROGRAM_ID=FCP.CONCURRENT_PROGRAM_ID 
    AND FCP.LANGUAGE='US' 
 AND FCR.RESPONSIBILITY_ID=FR.RESPONSIBILITY_ID 
 AND FR.LANGUAGE='US' 
 AND FCP.USER_CONCURRENT_PROGRAM_NAME IN ('') 
-- AND fcr.description LIKE 'GEPS%Auto%Invoice%' 
-- and fcr.description like 
 AND FCR.PHASE_CODE='P' 
-- AND FCR.STATUS_CODE='C' 
 AND fr.responsibility_name IN ('') 
-- AND fcr.argument15 IN (10094,10095) 
 AND fu.user_id=fcr.requested_by 
 AND FCR.HOLD_FLAG = 'Y' 
-- AND FCR.REQUEST_ID=24111243 
-- AND FU.USER_NAME='$UNIVERSEPA' 
 --and (fu.end_date>sysdate or fu.end_date is null) 
-- AND FCR.ARGUMENT1='PS_IFS_GE_Timecard' 
  ORDER BY FCP.USER_CONCURRENT_PROGRAM_NAME,FR.RESPONSIBILITY_NAME DESC

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24220135/viewspace-733601/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2010-07-10

  • 博文量
    2
  • 访问量
    1556