select * from fnd_company_levels_t a START WITH a.company_id = '19' CONNECT BY prior a.company_id=a.higher_company_id;
得到ID为19的所有的下级机构
select * from fnd_company_levels_t a START WITH a.company_id = '19' CONNECT BY prior a.higher_company_id=a.company_id;
得到下级为19的所有上级的机构