SELECT org.organization_id , org.name , null , loc.telephone_number_1 , loc.telephone_number_2 , loc.ece_tp_location_code FROM hr_locations_all loc, hr_all_organization_units_vl org WHERE org.location_id = loc.location_id
SELECT ORG.ORGANIZATION_ID
, ORG.NAME
, NULL
, LOC.TELEPHONE_NUMBER_1
, LOC.TELEPHONE_NUMBER_2
, LOC.ECE_TP_LOCATION_CODE
FROM HR_LOCATIONS_ALL LOC
, HR_ALL_ORGANIZATION_UNITS_VL ORG
WHERE ORG.LOCATION_ID = LOC.LOCATION_ID
|
|
|