根据组织id得到帐套id和公司名称代码,OracleEBS代码库,德仔网

代码语言

代码分类

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

作者:Dezai.CN / 发布于2013/1/5/ 828

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   = &p_org_id;--OU id
   END;

试试其它关键字

　组织id得　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)