View: IGS_AD_VISA_TYPE_V

Product:	IGS - Student System
Description:
Implementation/DBA Data:	APPS.IGS_AD_VISA_TYPE_V

View Text

SELECT DESCRIPTION
, VISA_TYPE
FROM IGS_AD_VISA_TYPE
WHERE FND_PROFILE.VALUE('IGS_EN_VISA_TYPE')='O' UNION SELECT MEANING DESCRIPTION
, LOOKUP_CODE VISA_TYPE
FROM FND_COMMON_LOOKUPS
WHERE LOOKUP_TYPE='PER_US_VISA_TYPES'
AND FND_PROFILE.VALUE('IGS_EN_VISA_TYPE')='H'

Columns