根据需要修改PO的客制报表,所以,首先需要把相关的客制报表先查找出来.下面是查找PO客制报表的过程:

SELECT APPLICATION_ID FROM FND_APPLICATION_TL where APPLICATION_NAME = 'Purchasing'

select * from FND_CONCURRENT_PROGRAMS_TL
WHERE APPLICATION_ID = 201
AND LAST_UPDATE_LOGIN NOT IN (0)
ORDER BY LAST_UPDATE_DATE DESC

SELECT * FROM FND_CONCURRENT_PROGRAMS
WHERE APPLICATION_ID = 201
AND LAST_UPDATE_LOGIN NOT IN (0)
ORDER BY LAST_UPDATE_DATE DESC

最后使用的语句:

SELECT a.user_concurrent_program_name program_name,
b.concurrent_program_name short_name
from FND_CONCURRENT_PROGRAMS_TL a,
FND_CONCURRENT_PROGRAMS b
where a.CONCURRENT_PROGRAM_ID = b.CONCURRENT_PROGRAM_ID
and a.APPLICATION_ID = b.APPLICATION_ID
and b.APPLICATION_ID = 201
AND a.LAST_UPDATE_LOGIN = b.LAST_UPDATE_LOGIN
and b.LAST_UPDATE_LOGIN NOT IN (0)
ORDER BY a.LAST_UPDATE_DATE DESC

[@more@]

ITPub博客

查看PO中客制的报表过程

最新文章