职责对应的组织

SELECT *
FROM bis_operating_units_v bouv,
fnd_responsibility_vl frv,
hr_all_organization_units hou
where bouv.id = hou.organization_id
and bouv.responsibility_id = frv.RESPONSIBILITY_ID

原文地址:https://www.cnblogs.com/huanghongbo/p/5750445.html