Responsibility Disable

原创

QUANWEIRU 2021-07-21 14:03:10 博主文章分类：Oracle EBS ©著作权

©著作权归作者所有：来自51CTO博客作者QUANWEIRU的原创作品，请联系作者获取转载授权，否则将追究法律责任

update fnd_responsibility b set end_date = sysdate where
        -- select * from   fnd_responsibility b where 
         b.responsibility_id  in ( 
            select  responsibility_id from fnd_responsibility_tl t 
            where 1 =1 
          --  and t.LANGUAGE = USERENV ('LANG')
            and  ( t.responsibility_name like '%32%WIP%' or t.responsibility_name like '%32%OSFM%' ) 
            --and  ( t.responsibility_name  <> '32A XGKA OSFM User - Read Only' and  t.responsibility_name  <> '32A XGKA WIP User - Read Only' )
        ) 
         and b.application_id in (
            select  application_id from fnd_responsibility_tl t 
            where 1 =1 
            --and t.LANGUAGE = USERENV ('LANG')
            and  ( t.responsibility_name like '%32%WIP%' or t.responsibility_name like '%32%OSFM%' ) 
            --and  ( t.responsibility_name  <> '32A XGKA OSFM User - Read Only' and  t.responsibility_name  <> '32A XGKA WIP User - Read Only' )
        );