How to check which responsiblity we are using


DECLARE
p_userid NUMBER;
p_respid NUMBER;
p_applid NUMBER;

x_resp_name VARCHAR2(50);

BEGIN

SELECT user_id
INTO p_userid FROM fnd_user
WHERE user_name ='MFG';

SELECT responsibility_id
INTO p_respid FROM fnd_responsibility_tl
WHERE responsibility_name = 'Purchasing, Vision Operations (USA)';

p_applid := 201; -- Puchasing Module

fnd_global.apps_initialize(p_userid, p_respid, p_applid);

SELECT fnd_profile.value('RESP_NAME') INTO x_resp_name FROM dual;

Dbms_Output.put_line(x_resp_name);

END;

Similarly

SELECT fnd_profile.value('PROFILEOPTION')
,fnd_profile.value('MFG_ORGANIZATION_ID')
,fnd_profile.value('ORG_ID')
,fnd_profile.value('LOGIN_ID')
,fnd_profile.value('USER_ID')
,fnd_profile.value('USERNAME')
,fnd_profile.value('CONCURRENT_REQUEST_ID')
,fnd_profile.value('GL_SET_OF_BKS_ID')
,fnd_profile.value('SO_ORGANIZATION_ID')
,fnd_profile.value('APPL_SHRT_NAME')
,fnd_profile.value('RESP_NAME')
,fnd_profile.value('RESP_ID')
FROM DUAL;


评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值