View: HRFV_SCHOOLS_AND_COLLEGES

Product:	PER - Human Resources
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.HRFV_SCHOOLS_AND_COLLEGES

View Text

SELECT PE.NAME SCHOOL_OR_COLLEGE_NAME
, PE.LOCATION SCHOOL_OR_COLLEGE_LOCATION
, '_DF:PER:PER_ESTABLISHMENTS:PE'
, PE.ESTABLISHMENT_ID SCHOOL_OR_COLLEGE_ID
FROM PER_ESTABLISHMENTS PE WITH READ ONLY

Columns