VIEW: APPS.AS_PARTY_PHONES_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')