Oracle EBS-SQL (SYS-17):查询一张报表在哪个职责下面.sql
1.查询该报表的 concurrent_program_id SQL如下：SELECT t.application_id,
t.concurrent_program_id,
t.*
FROM FND_CONCURRENT_PROGRAMS_TL T
WHERE T.USER_CONCURRENT_PROGRAM_NAME LIKE '%采购%'
----------------------------------------------------------------------------------
2.查询该报表所在的application_id:
SELECT a.application_id,
a.*
FROM FND_REQUEST_GROUP_UNITS A
WHERE A.REQUEST_UNIT_ID=44250
----------------------------------------------------------------------------------
3.查询相应的职责:
SELECT aa.application_name,
aa.*
FROM FND_APPLICATION_TL AA
WHERE AA.APPLICATION_ID=X
页:
[1]