SELECT hrorg.name , hrorg.organization_id , hrorg.date_from , hrorg.date_to , hrbus.name , hrorg.business_group_id from hr_organization_units hrorg , hr_organization_units hrbus WHERE hrorg.business_group_id = hrbus.organization_id
SELECT HRORG.NAME
, HRORG.ORGANIZATION_ID
, HRORG.DATE_FROM
, HRORG.DATE_TO
, HRBUS.NAME
, HRORG.BUSINESS_GROUP_ID
FROM HR_ORGANIZATION_UNITS HRORG
, HR_ORGANIZATION_UNITS HRBUS
WHERE HRORG.BUSINESS_GROUP_ID = HRBUS.ORGANIZATION_ID
|
|
|