Product: | AS - Sales Foundation |
---|---|
Description: | Phones view |
Implementation/DBA Data: | Not implemented in this database |
SELECT PHON.ROWID
, PHON.PHONE_ID
, PHON.LAST_UPDATE_DATE
, PHON.LAST_UPDATED_BY
, PHON.CREATION_DATE
, PHON.CREATED_BY
, PHON.PHONE_NUMBER
, PHON.STATUS
, PHON.PHONE_TYPE
, LOOK.MEANING
, PHON.LAST_UPDATE_LOGIN
, PHON.REQUEST_ID
, PHON.PROGRAM_APPLICATION_ID
, PHON.PROGRAM_ID
, PHON.PROGRAM_UPDATE_DATE
, PHON.CUSTOMER_ID
, PHON.ADDRESS_ID
, PHON.CONTACT_ID
, PHON.AREA_CODE
, PHON.EXTENSION
, PHON.PRIMARY_FLAG
, 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 AR_LOOKUPS LOOK
, RA_PHONES PHON
WHERE PHON.PHONE_TYPE = LOOK.LOOKUP_CODE(+)
AND LOOK.LOOKUP_TYPE(+) = 'COMMUNICATION_TYPE'