SELECT organization_id , business_group_id , name , date_from , date_to , internal_address_line , location_id , location_code , code , type , enabled FROM hr_fr_pension_providers_v UNION SELECT organization_id , business_group_id , name , date_from , date_to , internal_address_line , location_id , location_code , null , null , enabled FROM hr_fr_pension_groups_v
SELECT ORGANIZATION_ID
, BUSINESS_GROUP_ID
, NAME
, DATE_FROM
, DATE_TO
, INTERNAL_ADDRESS_LINE
, LOCATION_ID
, LOCATION_CODE
, CODE
, TYPE
, ENABLED
FROM HR_FR_PENSION_PROVIDERS_V UNION SELECT ORGANIZATION_ID
, BUSINESS_GROUP_ID
, NAME
, DATE_FROM
, DATE_TO
, INTERNAL_ADDRESS_LINE
, LOCATION_ID
, LOCATION_CODE
, NULL
, NULL
, ENABLED
FROM HR_FR_PENSION_GROUPS_V
|
|
|