VIEW: APPS.AST_CONTACT_RESTRICTIONS_V

Source

View Text - Preformatted

SELECT HCP.rowid, HCP.CONTACT_PREFERENCE_ID, HCP.CONTACT_TYPE, lkup1.meaning, HCP.PREFERENCE_START_DATE, HCP.PREFERENCE_END_DATE, HCP.REASON_CODE, lkup2.meaning, HCP.LAST_UPDATE_DATE, HCP.LAST_UPDATED_BY, HCP.CREATION_DATE, HCP.CREATED_BY, HCP.LAST_UPDATE_LOGIN, HCP.CONTACT_LEVEL_TABLE, HCP.CONTACT_LEVEL_TABLE_ID, HCP.OBJECT_VERSION_NUMBER, HCP.CREATED_BY_MODULE, HCP.APPLICATION_ID FROM HZ_CONTACT_PREFERENCES hcp, AR_LOOKUPS lkup1, AR_LOOKUPS lkup2 WHERE hcp.PREFERENCE_CODE = 'DO_NOT' AND hcp. CONTACT_LEVEL_TABLE <> 'HZ_CONTACT_POINTS' AND hcp.contact_type = lkup1.lookup_code(+) AND lkup1.lookup_type(+) = 'CONTACT_TYPE' AND hcp.reason_code = lkup2.lookup_code(+) AND lkup2.lookup_type(+) = 'REASON_CODE'

View Text - HTML Formatted

SELECT HCP.ROWID
, HCP.CONTACT_PREFERENCE_ID
, HCP.CONTACT_TYPE
, LKUP1.MEANING
, HCP.PREFERENCE_START_DATE
, HCP.PREFERENCE_END_DATE
, HCP.REASON_CODE
, LKUP2.MEANING
, HCP.LAST_UPDATE_DATE
, HCP.LAST_UPDATED_BY
, HCP.CREATION_DATE
, HCP.CREATED_BY
, HCP.LAST_UPDATE_LOGIN
, HCP.CONTACT_LEVEL_TABLE
, HCP.CONTACT_LEVEL_TABLE_ID
, HCP.OBJECT_VERSION_NUMBER
, HCP.CREATED_BY_MODULE
, HCP.APPLICATION_ID
FROM HZ_CONTACT_PREFERENCES HCP
, AR_LOOKUPS LKUP1
, AR_LOOKUPS LKUP2
WHERE HCP.PREFERENCE_CODE = 'DO_NOT'
AND HCP. CONTACT_LEVEL_TABLE <> 'HZ_CONTACT_POINTS'
AND HCP.CONTACT_TYPE = LKUP1.LOOKUP_CODE(+)
AND LKUP1.LOOKUP_TYPE(+) = 'CONTACT_TYPE'
AND HCP.REASON_CODE = LKUP2.LOOKUP_CODE(+)
AND LKUP2.LOOKUP_TYPE(+) = 'REASON_CODE'