ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Request program

Request program

原创 Linux操作系统 作者:jarli 时间:2019-05-14 12:00:04 0 删除 编辑
此SQL查看系统中一些报表和程序的运行情况

SELECT R.REQUEST_ID, PB.CONCURRENT_PROGRAM_NAME,
PT.USER_CONCURRENT_PROGRAM_NAME,
FU.USER_NAME,
FL.MEANING PHASE_CODE,
FL1.MEANING STATUS_CODE,
R.ARGUMENT_TEXT PARAMETERS,
R.REQUEST_DATE,
R.ACTUAL_START_DATE,
R.ACTUAL_COMPLETION_DATE
FROM FND_CONCURRENT_PROGRAMS_TL PT,
FND_CONCURRENT_PROGRAMS PB,
FND_CONCURRENT_REQUESTS R,
FND_LOOKUPS FL,
FND_LOOKUPS FL1,
FND_USER FU
WHERE 1=1
AND PB.APPLICATION_ID = PT.APPLICATION_ID
AND PB.CONCURRENT_PROGRAM_ID = PT.CONCURRENT_PROGRAM_ID
AND PT.LANGUAGE = USERENV ('LANG')
AND PB.APPLICATION_ID = R.PROGRAM_APPLICATION_ID
AND PB.CONCURRENT_PROGRAM_ID = R.CONCURRENT_PROGRAM_ID
AND FL.LOOKUP_TYPE='CP_PHASE_CODE'
AND FL.LOOKUP_CODE=R.PHASE_CODE
AND FL1.LOOKUP_TYPE='CP_STATUS_CODE'
AND FL1.LOOKUP_CODE=R.STATUS_CODE
AND R.REQUESTED_BY=FU.USER_ID
AND PB.CONCURRENT_PROGRAM_NAME='BOMR018'

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

上一篇: System profile
下一篇: User&Responsibility
请登录后发表评论 登录
全部评论

注册时间:2003-03-27

  • 博文量
    123
  • 访问量
    91673