【OracleEBS】 根据组织id得到帐套id和公司名称

 

 

declare
  l_org_information3 varchar2(150); --帐套id
  l_company_desc     varchar2(150); --公司中文描述
begin
  select o3.org_information3, o3.attribute3
    into l_org_information3, l_company_desc
    from hr_all_organization_units    o,
         hr_all_organization_units_tl otl,
         hr_organization_information  o2,
         hr_organization_information  o3
   where o.organization_id = o2.organization_id
     and o.organization_id = o3.organization_id
     and o2.org_information_context || '' = 'CLASS'
     and o3.org_information_context = 'Operating Unit Information'
     and o2.org_information1 = 'OPERATING_UNIT'
     and o2.org_information2 = 'Y'
     and o.organization_id = otl.organization_id
     and otl.language = userenv('LANG')
     and o.organization_id = 101;

  dbms_output.put_line(l_org_information3 || '--' || l_company_desc);
end;