DBA Data[Home] [Help]

VIEW: APPS.HRFV_SCHOOLS_AND_COLLEGES

Source

View Text - Preformatted

SELECT pe.name school_or_college_name ,pe.location school_or_college_location ,'_DF:PER:PER_ESTABLISHMENTS:pe' ,'_DF:PER:Establishment Developer DF:pe' ,pe.establishment_id school_or_college_id FROM per_establishments pe WITH READ ONLY
View Text - HTML Formatted

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