VIEW: APPS.PER_BUSINESS_GROUP_NAME

Source

View Text - Preformatted

SELECT O.ORGANIZATION_ID , OTL.NAME FROM HR_ALL_ORGANIZATION_UNITS O , HR_ALL_ORGANIZATION_UNITS_TL OTL , HR_ORGANIZATION_INFORMATION O2 , HR_ORGANIZATION_INFORMATION O3 , HR_ORGANIZATION_INFORMATION O4 WHERE O.ORGANIZATION_ID = OTL.ORGANIZATION_ID AND O.ORGANIZATION_ID = O2.ORGANIZATION_ID (+) AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID AND O.ORGANIZATION_ID = O4.ORGANIZATION_ID AND O3.ORG_INFORMATION_CONTEXT = 'Business Group Information' AND O2.ORG_INFORMATION_CONTEXT (+) = 'Work Day Information' AND O4.ORG_INFORMATION_CONTEXT = 'CLASS' AND O4.ORG_INFORMATION1 = 'HR_BG' AND O4.ORG_INFORMATION2 = 'Y' AND OTL.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT O.ORGANIZATION_ID
, OTL.NAME
FROM HR_ALL_ORGANIZATION_UNITS O
, HR_ALL_ORGANIZATION_UNITS_TL OTL
, HR_ORGANIZATION_INFORMATION O2
, HR_ORGANIZATION_INFORMATION O3
, HR_ORGANIZATION_INFORMATION O4
WHERE O.ORGANIZATION_ID = OTL.ORGANIZATION_ID
AND O.ORGANIZATION_ID = O2.ORGANIZATION_ID (+)
AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID
AND O.ORGANIZATION_ID = O4.ORGANIZATION_ID
AND O3.ORG_INFORMATION_CONTEXT = 'BUSINESS GROUP INFORMATION'
AND O2.ORG_INFORMATION_CONTEXT (+) = 'WORK DAY INFORMATION'
AND O4.ORG_INFORMATION_CONTEXT = 'CLASS'
AND O4.ORG_INFORMATION1 = 'HR_BG'
AND O4.ORG_INFORMATION2 = 'Y'
AND OTL.LANGUAGE = USERENV('LANG')