VIEW: APPS.PER_BUSINESS_GROUPS_PERF

Source

View Text - Preformatted

SELECT O.ORGANIZATION_ID , O.NAME , O.DATE_FROM , O.DATE_TO , O.INTERNAL_ADDRESS_LINE , O.LOCATION_ID , O.COMMENTS , O3.ORG_INFORMATION1 , O3.ORG_INFORMATION2 , O3.ORG_INFORMATION3 ,O3.ORG_INFORMATION16 , O3.ORG_INFORMATION4 , O3.ORG_INFORMATION5 , O3.ORG_INFORMATION6 , O3.ORG_INFORMATION7 , O3.ORG_INFORMATION8 , O3.ORG_INFORMATION9 , O3.ORG_INFORMATION10 , O4.ORG_INFORMATION2 , O3.ORG_INFORMATION15 , O3.ORG_INFORMATION14 FROM HR_ALL_ORGANIZATION_UNITS O , HR_ORGANIZATION_INFORMATION O3 , HR_ORGANIZATION_INFORMATION O4 WHERE O.ORGANIZATION_ID = O3.ORGANIZATION_ID AND O.ORGANIZATION_ID = O4.ORGANIZATION_ID AND O3.ORG_INFORMATION_CONTEXT = 'Business Group Information' AND O4.ORG_INFORMATION_CONTEXT = 'CLASS' AND O4.ORG_INFORMATION1 = 'HR_BG' AND O4.ORG_INFORMATION2 = 'Y'

View Text - HTML Formatted

SELECT O.ORGANIZATION_ID
, O.NAME
, O.DATE_FROM
, O.DATE_TO
, O.INTERNAL_ADDRESS_LINE
, O.LOCATION_ID
, O.COMMENTS
, O3.ORG_INFORMATION1
, O3.ORG_INFORMATION2
, O3.ORG_INFORMATION3
, O3.ORG_INFORMATION16
, O3.ORG_INFORMATION4
, O3.ORG_INFORMATION5
, O3.ORG_INFORMATION6
, O3.ORG_INFORMATION7
, O3.ORG_INFORMATION8
, O3.ORG_INFORMATION9
, O3.ORG_INFORMATION10
, O4.ORG_INFORMATION2
, O3.ORG_INFORMATION15
, O3.ORG_INFORMATION14
FROM HR_ALL_ORGANIZATION_UNITS O
, HR_ORGANIZATION_INFORMATION O3
, HR_ORGANIZATION_INFORMATION O4
WHERE O.ORGANIZATION_ID = O3.ORGANIZATION_ID
AND O.ORGANIZATION_ID = O4.ORGANIZATION_ID
AND O3.ORG_INFORMATION_CONTEXT = 'BUSINESS GROUP INFORMATION'
AND O4.ORG_INFORMATION_CONTEXT = 'CLASS'
AND O4.ORG_INFORMATION1 = 'HR_BG'
AND O4.ORG_INFORMATION2 = 'Y'