Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AST_CONTACT_RESTRICTIONS_V |
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'