通过ORG ID 取SOB ID(转)

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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10359218/viewspace-749050/，如需转载，请注明出处，否则将追究法律责任。