Product: | AS - Sales Foundation |
---|---|
Description: | This view stores telephone and fax information for parties/sites |
Implementation/DBA Data: | APPS.AS_PARTY_PHONES_V |
SELECT PHON.ROWID
, PHON.CONTACT_POINT_ID
, PHON.CONTACT_POINT_ID
, PHON.LAST_UPDATE_DATE
, PHON.LAST_UPDATED_BY
, PHON.CREATION_DATE
, PHON.CREATED_BY
, PHON.PHONE_NUMBER
, PHON.STATUS
, PHON.PHONE_LINE_TYPE
, LOOK.MEANING
, PHON.LAST_UPDATE_LOGIN
, PHON.REQUEST_ID
, PHON.PROGRAM_APPLICATION_ID
, PHON.PROGRAM_ID
, PHON.PROGRAM_UPDATE_DATE
, PHON.OWNER_TABLE_NAME
, PHON.OWNER_TABLE_ID
, PHON.PHONE_AREA_CODE
, PHON.PHONE_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 HZ_CONTACT_POINTS PHON
, AR_LOOKUPS LOOK
WHERE PHON.PHONE_LINE_TYPE = LOOK.LOOKUP_CODE(+)
AND LOOK.LOOKUP_TYPE(+) = 'PHONE_LINE_TYPE'
AND PHON.CONTACT_POINT_TYPE = 'PHONE'
AND PHON.STATUS IN ('A'
, 'I')