[Home] [Help]
View: BEN_REG_ORGANIZATIONS
View Text
SELECT O.BUSINESS_GROUP_ID
, O.ORGANIZATION_ID
, O.NAME
, O.DATE_FROM
, O.DATE_TO
FROM HR_ORGANIZATION_UNITS O
, HR_ORGANIZATION_INFORMATION O4
WHERE O.ORGANIZATION_ID = O4.ORGANIZATION_ID (+)
AND O.ORGANIZATION_ID = O4.ORGANIZATION_ID
AND O4.ORG_INFORMATION_CONTEXT (+)|| '' = 'CLASS'
AND O4.ORG_INFORMATION2(+) = 'Y'
AND O4.ORG_INFORMATION1 = 'REGBOD'
Columns
Name |
BUSINESS_GROUP_ID |
ORGANIZATION_ID |
NAME |
DATE_FROM |
DATE_TO |