VIEW: APPS.CSC_CONTACT_RESTRICTIONS_V

Source

View Text - Preformatted

SELECT hcp.rowid ROW_ID , hcp.contact_preference_id CONTACT_RESTRICTION_ID, hcp.contact_type CONTACT_TYPE , lkup1.meaning CONTACT_TYPE_MEANING , hcp.preference_start_date RESTRICT_START_DATE , hcp.preference_end_date RESTRICT_END_DATE , hcp.reason_code RESTRICT_REASON , lkup2.meaning RESTRICTION_MEANING , hcp.last_update_date LAST_UPDATE_DATE , hcp.last_updated_by LAST_UPDATED_BY , hcp.creation_date CREATION_DATE , hcp.created_by CREATED_BY , hcp.last_update_login LAST_UPDATE_LOGIN , hcp.contact_level_table SUBJECT_TABLE , hcp.contact_level_table_id SUBJECT_ID , hcp.object_version_number OBJECT_VERSION_NUMBER , hcp.created_by_module CREATED_BY_MODULE , hcp.application_id 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 ROW_ID
, HCP.CONTACT_PREFERENCE_ID CONTACT_RESTRICTION_ID
, HCP.CONTACT_TYPE CONTACT_TYPE
, LKUP1.MEANING CONTACT_TYPE_MEANING
, HCP.PREFERENCE_START_DATE RESTRICT_START_DATE
, HCP.PREFERENCE_END_DATE RESTRICT_END_DATE
, HCP.REASON_CODE RESTRICT_REASON
, LKUP2.MEANING RESTRICTION_MEANING
, HCP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, HCP.LAST_UPDATED_BY LAST_UPDATED_BY
, HCP.CREATION_DATE CREATION_DATE
, HCP.CREATED_BY CREATED_BY
, HCP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, HCP.CONTACT_LEVEL_TABLE SUBJECT_TABLE
, HCP.CONTACT_LEVEL_TABLE_ID SUBJECT_ID
, HCP.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, HCP.CREATED_BY_MODULE CREATED_BY_MODULE
, HCP.APPLICATION_ID 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'