===========================================================
===========================================================
在Oracle EBS 统计我们客制化的报表
作者: moonsoft(http://moonsoft.itpub.net)发表于: 2006.06.09 11:28
分类: EBS , reports
出处: http://moonsoft.itpub.net/post/15182/112361
---------------------------------------------------------------
直接去我们挂报表的地方找table ,写sql
直接去我们挂报表的地方找:
/* Formatted on 2006/06/09 10:51 (Formatter Plus v
SELECT
t.user_concurrent_program_name, b.concurrent_program_name
FROM fnd_concurrent_programs_tl t,
fnd_concurrent_programs b
WHERE b.application_id = t.application_id
AND b.concurrent_program_id = t.concurrent_program_id
AND ( b.concurrent_program_name LIKE 'TCT%'
–这里面是客制化报表的前面编码
--OR
b.concurrent_program_name LIKE 'TOM%'
--OR
b.concurrent_program_name LIKE 'TOM%'
--OR b.concurrent_program_name LIKE 'WIP%'
-- OR b.concurrent_program_name like 'TCT%'
-- OR b.concurrent_program_name LIKE 'TCT%'
)
ORDER BY t.user_concurrent_program_name
