View: HR_LEGAL_ENTITIES

Product:	PER - Human Resources
Description:	Used in US localizations to reflect the common organization structure Legal Entity/Company/Tax Unit.
Implementation/DBA Data:	APPS.HR_LEGAL_ENTITIES

View Text

SELECT O.BUSINESS_GROUP_ID
, O.ORGANIZATION_ID
, OTL.NAME
, O.DATE_FROM
, O.DATE_TO
, O3.ORG_INFORMATION1
, O3.ORG_INFORMATION2
FROM HR_ORG_UNITS_NO_JOIN 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 (+) || '' = 'LEGAL ENTITY ACCOUNTING'
AND O2.ORG_INFORMATION1 = 'HR_LEGAL'
AND O2.ORG_INFORMATION2 = 'Y'
AND O.ORGANIZATION_ID = OTL.ORGANIZATION_ID
AND OTL.LANGUAGE = USERENV('LANG')

Columns