VIEW: APPS.CE_HR_BUS_GRPS_V

Source

View Text - Preformatted

SELECT O.BUSINESS_GROUP_ID , O.ORGANIZATION_ID , O.NAME , O3.ORG_INFORMATION10 , O.DATE_FROM , O.DATE_TO FROM HR_ORGANIZATION_UNITS O, HR_ORGANIZATION_INFORMATION O2, HR_ORGANIZATION_INFORMATION O3 WHERE O.ORGANIZATION_ID = O2.ORGANIZATION_ID AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID AND O3.ORG_INFORMATION_CONTEXT(+) || '' = 'Business Group Information' AND O2.ORG_INFORMATION_CONTEXT = 'CLASS' AND O2.ORG_INFORMATION1 = 'HR_BG' AND O2.ORG_INFORMATION2 = 'Y'

View Text - HTML Formatted

SELECT O.BUSINESS_GROUP_ID
, O.ORGANIZATION_ID
, O.NAME
, O3.ORG_INFORMATION10
, O.DATE_FROM
, O.DATE_TO
FROM HR_ORGANIZATION_UNITS O
, HR_ORGANIZATION_INFORMATION O2
, HR_ORGANIZATION_INFORMATION O3
WHERE O.ORGANIZATION_ID = O2.ORGANIZATION_ID
AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID
AND O3.ORG_INFORMATION_CONTEXT(+) || '' = 'BUSINESS GROUP INFORMATION'
AND O2.ORG_INFORMATION_CONTEXT = 'CLASS'
AND O2.ORG_INFORMATION1 = 'HR_BG'
AND O2.ORG_INFORMATION2 = 'Y'