[Home] [Help]
View: PA_ORGANIZATIONS_V
View Text
SELECT ORG.ORGANIZATION_ID
, ORG.NAME
, ORG.BUSINESS_GROUP_ID
, ORG.DATE_FROM
, ORG.DATE_TO
, ORG.TYPE
, NULL
FROM HR_ORGANIZATION_UNITS ORG
Columns
Name |
ORGANIZATION_ID |
NAME |
BUSINESS_GROUP_ID |
DATE_FROM |
DATE_TO |
TYPE |
WITHIN_CURRENT_OPERATING_UNIT |