View: IGS_AS_ALIAS_TYPES_V

Product:	IGS - Student System
Description:	Contains Alias Types (i.e., "former names") that are to be shown on the transcript.
Implementation/DBA Data:	APPS.IGS_AS_ALIAS_TYPES_V

View Text

SELECT AAT.ROWID
, AAT.ORDER_OF_DISPLAY
, AAT.ALIAS_TYPE
, PAT.MEANING DESCRIPTION
, AAT.CREATED_BY
, AAT.CREATION_DATE
, AAT.LAST_UPDATED_BY
, AAT.LAST_UPDATE_DATE
, AAT.LAST_UPDATE_LOGIN
FROM IGS_AS_ALIAS_TYPES AAT
, IGS_LOOKUP_VALUES PAT
WHERE AAT.ALIAS_TYPE = PAT.LOOKUP_CODE
AND PAT.LOOKUP_TYPE = 'PE_ALIAS_TYPE'

Columns