VIEW: APPS.CSC_HZ_CONTACT_PREFERENCES_V

Source

View Text - Preformatted

SELECT hc.CONTACT_PREFERENCE_ID ,hc.CONTACT_LEVEL_TABLE ,hc.CONTACT_LEVEL_TABLE_ID ,hc.CONTACT_TYPE ,hc.PREFERENCE_CODE ,ar1.MEANING PREFERENCE_CODE_MEANING ,hc.PREFERENCE_TOPIC_TYPE ,hc.PREFERENCE_TOPIC_TYPE_ID ,hc.PREFERENCE_TOPIC_TYPE_CODE ,fnd.MEANING PREF_TOPIC_TYPE_CODE_MEANING ,hc.PREFERENCE_START_DATE ,hc.PREFERENCE_END_DATE ,hc.PREFERENCE_START_TIME_HR ,hc.PREFERENCE_END_TIME_HR ,hc.PREFERENCE_START_TIME_MI ,hc.PREFERENCE_END_TIME_MI ,hc.REASON_CODE ,ar2.MEANING REASON_CODE_MEANING ,hc.CREATED_BY ,hc.CREATION_DATE ,hc.LAST_UPDATE_LOGIN ,hc.LAST_UPDATE_DATE ,hc.LAST_UPDATED_BY ,hc.OBJECT_VERSION_NUMBER ,hc.STATUS ,hc.CREATED_BY_MODULE ,hc.APPLICATION_ID from hz_contact_preferences hc, ar_lookups ar1, ar_lookups ar2, fnd_lookup_values fnd WHERE ar1.lookup_type = 'PREFERENCE_CODE' AND ar1.lookup_code = hc.PREFERENCE_CODE AND ar2.lookup_type(+) = 'REASON_CODE' AND ar2.lookup_code(+) = hc.REASON_CODE AND fnd.lookup_type (+) = 'CONTACT_USAGE' AND fnd.lookup_code(+) = hc.PREFERENCE_TOPIC_TYPE_CODE AND fnd.language(+) = userenv('LANG')

View Text - HTML Formatted

SELECT HC.CONTACT_PREFERENCE_ID
, HC.CONTACT_LEVEL_TABLE
, HC.CONTACT_LEVEL_TABLE_ID
, HC.CONTACT_TYPE
, HC.PREFERENCE_CODE
, AR1.MEANING PREFERENCE_CODE_MEANING
, HC.PREFERENCE_TOPIC_TYPE
, HC.PREFERENCE_TOPIC_TYPE_ID
, HC.PREFERENCE_TOPIC_TYPE_CODE
, FND.MEANING PREF_TOPIC_TYPE_CODE_MEANING
, HC.PREFERENCE_START_DATE
, HC.PREFERENCE_END_DATE
, HC.PREFERENCE_START_TIME_HR
, HC.PREFERENCE_END_TIME_HR
, HC.PREFERENCE_START_TIME_MI
, HC.PREFERENCE_END_TIME_MI
, HC.REASON_CODE
, AR2.MEANING REASON_CODE_MEANING
, HC.CREATED_BY
, HC.CREATION_DATE
, HC.LAST_UPDATE_LOGIN
, HC.LAST_UPDATE_DATE
, HC.LAST_UPDATED_BY
, HC.OBJECT_VERSION_NUMBER
, HC.STATUS
, HC.CREATED_BY_MODULE
, HC.APPLICATION_ID
FROM HZ_CONTACT_PREFERENCES HC
, AR_LOOKUPS AR1
, AR_LOOKUPS AR2
, FND_LOOKUP_VALUES FND
WHERE AR1.LOOKUP_TYPE = 'PREFERENCE_CODE'
AND AR1.LOOKUP_CODE = HC.PREFERENCE_CODE
AND AR2.LOOKUP_TYPE(+) = 'REASON_CODE'
AND AR2.LOOKUP_CODE(+) = HC.REASON_CODE
AND FND.LOOKUP_TYPE (+) = 'CONTACT_USAGE'
AND FND.LOOKUP_CODE(+) = HC.PREFERENCE_TOPIC_TYPE_CODE
AND FND.LANGUAGE(+) = USERENV('LANG')