VIEW: APPS.IGS_PE_HZ_CONT_PREF_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')