Product: | ICX - Oracle iProcurement |
---|---|
Description: | Obsolete |
Implementation/DBA Data: | Not implemented in this database |
SELECT /* $HEADER: ICXARV.SQL 10.4 96/04/15 21:49:07 RHADDAD SHIP $ */ /* PURPOSE: THE VIEW AR_PHONES_V IS FOR USE AS A BASE TABLE */ /* FOR ORACLE FORMS 4 PROGRAMS */ 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.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 RA_PHONES PHON
, AR_LOOKUPS LOOK
WHERE PHON.PHONE_TYPE = LOOK.LOOKUP_CODE
AND LOOK.LOOKUP_TYPE = 'COMMUNICATION_TYPE'