正德厚生,臻于至善

profile

select o.USER_PROFILE_OPTION_NAME,o.PROFILE_OPTION_NAME,v.profile_option_value,v.level_id from fnd_profile_option_values v,fnd_profile_options_vl o where v.profile_option_id=o.profile_option_id and o.PROFILE_OPTION_NAME='CUX_0_FND_OBJECT_PUT_PATH' order by v.last_update_date desc;

select v.profile_option_value from fnd_profile_option_values v
 where v.level_id = 10001
 and v.profile_option_id =
       (select profile_option_id
          from fnd_profile_options o
         where o.profile_option_name = 'CUX_0_FND_OBJECT_PUT_PATH');

update fnd_profile_option_values v
   set v.profile_option_value = '/fmsnfs/deployment'
 where v.level_id = 10001
 and v.profile_option_id =
       (select profile_option_id
          from fnd_profile_options o
         where o.profile_option_name = 'CUX_0_FND_OBJECT_PUT_PATH');

select v.profile_option_value from fnd_profile_option_values v
 where v.level_id = 10001
 and v.profile_option_id =
       (select profile_option_id
          from fnd_profile_options o
         where o.profile_option_name = 'CUX_0_FND_OBJECT_PUT_PATH');

commit;
赞(0) 打赏
未经允许不得转载:徐万新之路 » profile

评论 抢沙发

联系我们

觉得文章有用就打赏一下文章作者

支付宝扫一扫

微信扫一扫

登录

找回密码

注册