SELECT DISTINCT fa.application_short_name 模块,
                b.responsibility_name 职责名称, fa.application_name 应用产品,
                b.responsibility_key 责任关键字, b.description 说明,
                DECODE (b.data_group_id, 0, ‘标准‘, ‘‘) 数据组,
                fa3.application_name 数据组应用产品, fmv.user_menu_name 菜单,
                frg.request_group_name 请求组,
                fa2.application_name 请求组应用产品 
      FROM apps.fnd_application_vl fa,
                apps.fnd_responsibility_vl b,
                apps.fnd_menus_vl fmv,
                applsys.fnd_request_groups frg,
                apps.fnd_application_vl fa3,
                apps.fnd_application_vl fa2 
    WHERE b.responsibility_name IN (SELECT col
                                            FROM able_test)
            AND b.application_id = fa.application_id
            AND b.menu_id = fmv.menu_id(+)
            AND b.data_group_application_id = fa3.application_id(+)
            AND b.request_group_id = frg.request_group_id(+)
            AND frg.application_id = fa2.application_id(+)

Oracle EBS-SQL (SYS-8):职责定义明细.sql,布布扣,bubuko.com

Oracle EBS-SQL (SYS-8):职责定义明细.sql