Oracle EBS-SQL (SYS-4):sys_职责查询.sql

select

   t.RESPONSIBILITY_NAME

from apps.FND_RESPONSIBILITY_VL t

    where t.RESPONSIBILITY_NAME like '%MRP%' or            

              t.RESPONSIBILITY_NAME like '%WIP%' or

              t.RESPONSIBILITY_NAME like '%BOM%' or

              t.RESPONSIBILITY_NAME like '%QA%'    or

              t.RESPONSIBILITY_NAME like '%MFG%'