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