Oracle EBS 统计我们客制的报表

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 'AG%'  --报表的缩写以"AG"开头的

ORDER BY t.user_concurrent_program_name

 

 

 

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 t.user_concurrent_program_name LIKE 'AG%'  --报表的名称以"AG"开头的

ORDER BY t.user_concurrent_program_name