VIEW: APPS.HR_LEGAL_ENTITIES

Source

View Text - Preformatted

SELECT O.BUSINESS_GROUP_ID , O.ORGANIZATION_ID , OTL.NAME , O.DATE_FROM , O.DATE_TO 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 O2.ORG_INFORMATION_CONTEXT = 'CLASS' AND O2.ORG_INFORMATION2 = 'Y' AND O2.ORG_INFORMATION1 IN ('HR_LEGAL', 'PAR_ENT', 'FR_SOCIETE', 'HR_LEGAL_EMPLOYER') AND OTL.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT O.BUSINESS_GROUP_ID
, O.ORGANIZATION_ID
, OTL.NAME
, O.DATE_FROM
, O.DATE_TO
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 O2.ORG_INFORMATION_CONTEXT = 'CLASS'
AND O2.ORG_INFORMATION2 = 'Y'
AND O2.ORG_INFORMATION1 IN ('HR_LEGAL'
, 'PAR_ENT'
, 'FR_SOCIETE'
, 'HR_LEGAL_EMPLOYER')
AND OTL.LANGUAGE = USERENV('LANG')