VIEW: APPS.HR_FEDREP_V

Source

View Text - Preformatted

SELECT location_id Entity_id, location_code||decode(location_code,null,'',', ')|| address_line_1||decode(address_line_1,null,'',', ')|| address_line_2||decode(address_line_2,null,'',', ')|| town_or_city||decode(town_or_city,null,'',', ')|| region_2||decode(region_2,null,'',', ')||country Node_name, location_id Location_id From hr_locations_all

View Text - HTML Formatted

SELECT LOCATION_ID ENTITY_ID
, LOCATION_CODE||DECODE(LOCATION_CODE
, NULL
, ''
, '
, ')|| ADDRESS_LINE_1||DECODE(ADDRESS_LINE_1
, NULL
, ''
, '
, ')|| ADDRESS_LINE_2||DECODE(ADDRESS_LINE_2
, NULL
, ''
, '
, ')|| TOWN_OR_CITY||DECODE(TOWN_OR_CITY
, NULL
, ''
, '
, ')|| REGION_2||DECODE(REGION_2
, NULL
, ''
, '
, ')||COUNTRY NODE_NAME
, LOCATION_ID LOCATION_ID
FROM HR_LOCATIONS_ALL