View: PER_QUALIFICATIONS_V2

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PER_QUALIFICATIONS_V2

View Text

SELECT ESA.PERSON_ID
, ESA.ATTENDANCE_ID
, ESA.ESTABLISHMENT_ID
, NVL(ESA.ESTABLISHMENT
, EST.NAME) ESTABLISHMENT
, EST.LOCATION LOCATION
, ESA.ATTENDED_START_DATE
, ESA.ATTENDED_END_DATE
FROM PER_ESTABLISHMENTS EST
, PER_ESTABLISHMENT_ATTENDANCES ESA
WHERE ESA.ESTABLISHMENT_ID = EST.ESTABLISHMENT_ID (+)
AND ESA.ATTENDANCE_ID IS NOT NULL

Columns