【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;
复制代码

 

posted @   Iven_lin  阅读(49)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· [翻译] 为什么 Tracebit 用 C# 开发
· 腾讯ima接入deepseek-r1,借用别人脑子用用成真了~
· Deepseek官网太卡,教你白嫖阿里云的Deepseek-R1满血版
· DeepSeek崛起:程序员“饭碗”被抢,还是职业进化新起点?
· RFID实践——.NET IoT程序读取高频RFID卡/标签
点击右上角即可分享
微信分享提示