View: PER_BUSINESS_GROUPS

Product:	PER - Human Resources
Description:	View based on HR_ORGANIZATION_UNITS and HR_ORGANIZATION that returns specific information for a Business Group.
Implementation/DBA Data:	APPS.PER_BUSINESS_GROUPS

View Text

SELECT O.ORGANIZATION_ID
, O.ORGANIZATION_ID
, OTL.NAME
, O.DATE_FROM
, O.DATE_TO
, O.INTERNAL_ADDRESS_LINE
, O.LOCATION_ID
, O.COMMENTS
, O2.ORG_INFORMATION1
, O2.ORG_INFORMATION2
, O2.ORG_INFORMATION3
, O2.ORG_INFORMATION4
, O3.ORG_INFORMATION1
, O3.ORG_INFORMATION2
, O3.ORG_INFORMATION3
, O3.ORG_INFORMATION4
, O3.ORG_INFORMATION5
, O3.ORG_INFORMATION6
, O3.ORG_INFORMATION7
, O3.ORG_INFORMATION8
, O3.ORG_INFORMATION9
, O3.ORG_INFORMATION10
, O3.ORG_INFORMATION14
, O4.ORG_INFORMATION2
, O3.ORG_INFORMATION15
, O3.ORG_INFORMATION16
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')

Columns