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
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博客 ” ，链接：https://blog.itpub.net/24627116/viewspace-757673/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
库存管理INV_6个表
请登录后发表评论
登录
全部评论
