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