本文介绍了一个使用Oracle E-Business Suite的FND框架进行SQL查询的例子，该查询旨在筛选出所有名称或缩写以AG开头的并发程序（报表）。通过连接两个表fnd_concurrent_programs_tlt和fnd_concurrent_programs并根据特定条件筛选记录。
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
扫一扫
3883
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
