Product: | PN - Property Manager |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PN_PHONES_V |
SELECT PHONE.ROWID ROW_ID
, PHONE.PHONE_ID PHONE_ID
, PHONE.CONTACT_ID CONTACT_ID
, PHONE.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PHONE.LAST_UPDATED_BY LAST_UPDATED_BY
, PHONE.CREATION_DATE CREATION_DATE
, PHONE.CREATED_BY CREATED_BY
, PHONE.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PHONE.STATUS STATUS
, PHONE.PHONE_TYPE PHONE_TYPE
, PHONE.AREA_CODE AREA_CODE
, PHONE.PHONE_NUMBER PHONE_NUMBER
, PHONE.EXTENSION EXTENSION
, PHONE.PRIMARY_FLAG PRIMARY_FLAG
, PHONE.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PHONE.ATTRIBUTE1 ATTRIBUTE1
, PHONE.ATTRIBUTE2 ATTRIBUTE2
, PHONE.ATTRIBUTE3 ATTRIBUTE3
, PHONE.ATTRIBUTE4 ATTRIBUTE4
, PHONE.ATTRIBUTE5 ATTRIBUTE5
, PHONE.ATTRIBUTE6 ATTRIBUTE6
, PHONE.ATTRIBUTE7 ATTRIBUTE7
, PHONE.ATTRIBUTE8 ATTRIBUTE8
, PHONE.ATTRIBUTE9 ATTRIBUTE9
, PHONE.ATTRIBUTE10 ATTRIBUTE10
, PHONE.ATTRIBUTE11 ATTRIBUTE11
, PHONE.ATTRIBUTE12 ATTRIBUTE12
, PHONE.ATTRIBUTE13 ATTRIBUTE13
, PHONE.ATTRIBUTE14 ATTRIBUTE14
, PHONE.ATTRIBUTE15 ATTRIBUTE15
, PLOOK.MEANING PHONE_TYPE_IS
, PHONE.ORG_ID ORG_ID
FROM FND_LOOKUPS PLOOK
, PN_PHONES PHONE
WHERE PLOOK.LOOKUP_TYPE = 'PN_PHONE_TYPE'
AND PLOOK.LOOKUP_CODE = PHONE.PHONE_TYPE