ebs系统根据ou_id查找resp_id的sql
时间: 2023-08-06 19:09:10 浏览: 62
好的,以下是根据OU_ID查找RESP_ID的SQL:
```
SELECT DISTINCT furg.resp_id
FROM fnd_user_resp_groups_direct furg
WHERE furg.user_id IN (
SELECT fu.user_id
FROM fnd_user fu
WHERE fu.security_enabled_flag = 'Y'
AND fu.user_name = :p_user_name
)
AND furg.resp_id IN (
SELECT fra.resp_id
FROM fnd_responsibility_access fra
WHERE fra.responsibility_id IN (
SELECT frr.responsibility_id
FROM fnd_responsibility_vl frr
WHERE frr.application_id = :p_application_id
AND frr.responsibility_key = :p_responsibility_key
)
)
AND furg.org_id = :p_org_id;
```
该SQL会从EBS系统的FND_USER_RESP_GROUPS_DIRECT表中查询与用户、OU和RESP相关的记录,然后返回RESP_ID。需要注意的是,需要将:p_user_name、:p_application_id、:p_responsibility_key和:p_org_id替换为实际的参数值,才能正常执行该SQL。