View: IGS_PE_HZ_CONT_PREF_V

Product:	IGS - Student System
Description:	This will be used to view Contact Preference information
Implementation/DBA Data:	APPS.IGS_PE_HZ_CONT_PREF_V

View Text

SELECT HZPREF.ROWID ROW_ID
, HZPREF.CONTACT_PREFERENCE_ID
, HZPREF.CONTACT_LEVEL_TABLE
, HZPREF.CONTACT_LEVEL_TABLE_ID PERSON_ID
, HZPREF.CONTACT_TYPE
, LK.MEANING CONTACT_TYPE_M
, HP.PARTY_NUMBER PERSON_NUMBER
, HZPREF.PREFERENCE_CODE
, LK1.MEANING PREFERENCE_MEANING
, HZPREF.PREFERENCE_START_DATE START_DATE
, HZPREF.PREFERENCE_END_DATE END_DATE
, HZPREF.REQUESTED_BY
, HZPREF.REASON_CODE
, LK3.MEANING REASON_CODE_M
, HZPREF.CREATED_BY
, HZPREF.CREATION_DATE
, HZPREF.LAST_UPDATE_LOGIN
, HZPREF.LAST_UPDATE_DATE
, HZPREF.LAST_UPDATED_BY
, HZPREF.OBJECT_VERSION_NUMBER
, HZPREF.STATUS
, HZPREF.CREATED_BY_MODULE
, HZPREF.APPLICATION_ID
FROM HZ_CONTACT_PREFERENCES HZPREF
, HZ_PARTIES HP
, FND_LOOKUP_VALUES LK
, FND_LOOKUP_VALUES LK1
, FND_LOOKUP_VALUES LK3
WHERE HP.PARTY_ID=HZPREF.CONTACT_LEVEL_TABLE_ID
AND HZPREF.CONTACT_LEVEL_TABLE = 'HZ_PARTIES'
AND LK.LOOKUP_CODE ='VISIT'
AND LK.LOOKUP_TYPE='CONTACT_TYPE'
AND HZPREF.CONTACT_TYPE=LK.LOOKUP_CODE
AND LK.VIEW_APPLICATION_ID = 222
AND LK.SECURITY_GROUP_ID = 0
AND LK.LANGUAGE = USERENV('LANG')
AND HZPREF.PREFERENCE_CODE = LK1.LOOKUP_CODE
AND LK1.LOOKUP_TYPE ='PREFERENCE_CODE'
AND LK1.VIEW_APPLICATION_ID = 222
AND LK1.SECURITY_GROUP_ID = 0
AND LK1.LANGUAGE = USERENV('LANG')
AND HZPREF.REASON_CODE = LK3.LOOKUP_CODE (+)
AND LK3.LOOKUP_TYPE (+)='REASON_CODE'
AND LK3.VIEW_APPLICATION_ID (+)= 222
AND LK3.SECURITY_GROUP_ID (+)= 0
AND LK3.LANGUAGE(+) = USERENV('LANG')

Columns