View: IGS_PE_PID_TYPE_V

Product:	IGS - Student System
Description:	IGS_PE_PID_TYPE_V describes the person identifier types in the system
Implementation/DBA Data:	APPS.IGS_PE_PID_TYPE_V

View Text

SELECT PIT.ROWID ROW_ID
, PIT.PERSON_ID_TYPE
, API.API_PERSON_ID
, API.PE_PERSON_ID
, PIT.CREATED_BY
, PIT.CREATION_DATE
, PIT.LAST_UPDATED_BY
, PIT.LAST_UPDATE_DATE
, PIT.LAST_UPDATE_LOGIN
FROM IGS_PE_PERSON_ID_TYP PIT
, IGS_PE_ALT_PERS_ID API
WHERE API.PERSON_ID_TYPE = PIT.PERSON_ID_TYPE
AND PIT.PREFERRED_IND = 'Y'

Columns