Product: | ASF - Sales Online |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT CNT.ROWID
, CNT.CONTACT_POINT_ID
, CNT.CONTACT_POINT_TYPE
, CNT.STATUS
, CODE_STATUS.MEANING
, CNT.OWNER_TABLE_NAME
, CNT.OWNER_TABLE_ID
, CNT.LAST_UPDATE_DATE /*
, TO_CHAR(CNT.LAST_UPDATE_DATE
, 'YYYY-MM-DD HH:MI:SS')||'.0' */
, CNT.LAST_UPDATED_BY
, CNT.CREATION_DATE
, CNT.CREATED_BY
, CNT.EMAIL_FORMAT
, CNT.EMAIL_ADDRESS
, CNT.PHONE_LINE_TYPE
, COMMUNICATION_TYPE.MEANING
, CNT.PHONE_COUNTRY_CODE
, CNT.PHONE_AREA_CODE
, CNT.PHONE_NUMBER
, CNT.PHONE_EXTENSION
, CNT.PRIMARY_FLAG
, CNT.DO_NOT_USE_FLAG
, CNT.PHONE_PREFERRED_ORDER
, CNT.LAST_UPDATE_LOGIN
, CNT.REQUEST_ID
, CNT.PROGRAM_APPLICATION_ID
, CNT.PROGRAM_ID
, CNT.PROGRAM_UPDATE_DATE
, CNT.ORIG_SYSTEM_REFERENCE
, CNT.ATTRIBUTE_CATEGORY
, CNT.ATTRIBUTE1
, CNT.ATTRIBUTE2
, CNT.ATTRIBUTE3
, CNT.ATTRIBUTE4
, CNT.ATTRIBUTE5
, CNT.ATTRIBUTE6
, CNT.ATTRIBUTE7
, CNT.ATTRIBUTE8
, CNT.ATTRIBUTE9
, CNT.ATTRIBUTE10
, CNT.ATTRIBUTE11
, CNT.ATTRIBUTE12
, CNT.ATTRIBUTE13
, CNT.ATTRIBUTE14
, CNT.ATTRIBUTE15
FROM HZ_CONTACT_POINTS CNT
, AR_LOOKUPS COMMUNICATION_TYPE
, AR_LOOKUPS CODE_STATUS
WHERE CNT.CONTACT_POINT_TYPE IN ( 'PHONE'
, 'FAX'
, 'EMAIL')
AND CNT.PHONE_LINE_TYPE = COMMUNICATION_TYPE.LOOKUP_CODE(+)
AND COMMUNICATION_TYPE.LOOKUP_TYPE(+) = 'COMMUNICATION_TYPE'
AND CNT.STATUS = CODE_STATUS.LOOKUP_CODE(+)
AND CODE_STATUS.LOOKUP_TYPE(+) = 'CODE_STATUS'
AND CNT.STATUS IN ('A'
, 'I')