View: HR_FEDREP_V

Product:	PER - Human Resources
Description:	View for VETS/EEO on Generic Hierarchy
Implementation/DBA Data:	APPS.HR_FEDREP_V

View Text

SELECT TO_CHAR(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

Columns