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
原文：http://www.cnblogs.com/huanghongbo/p/5750445.html