Product: | JTF - CRM Foundation |
---|---|
Description: | JTF_PARTY_PHONES_V retrieves all Phone and Fax numbers for a party. |
Implementation/DBA Data: | APPS.JTF_PARTY_PHONES_V |
SELECT CONT_POINT.ROWID
, CONT_POINT.CONTACT_POINT_ID
, ORG_CONT.ORG_CONTACT_ID
, PARTY.PARTY_ID
, PARTY_SITE.PARTY_SITE_ID
, CONT_POINT.CONTACT_POINT_ID
, ORG_CONT.ORG_CONTACT_ID
, PARTY.PARTY_ID
, PARTY_SITE.PARTY_SITE_ID
, CONT_POINT.LAST_UPDATE_DATE
, CONT_POINT.LAST_UPDATED_BY
, CONT_POINT.CREATION_DATE
, CONT_POINT.CREATED_BY
, CONT_POINT.PHONE_NUMBER
, CONT_POINT.STATUS
, CONT_POINT.TELEPHONE_TYPE
, CONT_POINT.PHONE_LINE_TYPE
, CONT_POINT.LAST_UPDATE_LOGIN
, CONT_POINT.PHONE_AREA_CODE
, CONT_POINT.PHONE_EXTENSION
, CONT_POINT.PRIMARY_FLAG
, CONT_POINT.ORIG_SYSTEM_REFERENCE
, CONT_POINT.REQUEST_ID
, CONT_POINT.PROGRAM_APPLICATION_ID
, CONT_POINT.PROGRAM_ID
, CONT_POINT.PROGRAM_UPDATE_DATE
, CONT_POINT.ATTRIBUTE_CATEGORY
, CONT_POINT.ATTRIBUTE1
, CONT_POINT.ATTRIBUTE2
, CONT_POINT.ATTRIBUTE3
, CONT_POINT.ATTRIBUTE4
, CONT_POINT.ATTRIBUTE5
, CONT_POINT.ATTRIBUTE6
, CONT_POINT.ATTRIBUTE7
, CONT_POINT.ATTRIBUTE8
, CONT_POINT.ATTRIBUTE9
, CONT_POINT.ATTRIBUTE10
, CONT_POINT.ATTRIBUTE11
, CONT_POINT.ATTRIBUTE12
, CONT_POINT.ATTRIBUTE13
, CONT_POINT.ATTRIBUTE14
, CONT_POINT.ATTRIBUTE15
FROM HZ_PARTIES PARTY
, HZ_PARTY_SITES PARTY_SITE
, HZ_ORG_CONTACTS ORG_CONT
, HZ_CONTACT_POINTS CONT_POINT
WHERE PARTY.PARTY_ID = PARTY_SITE.PARTY_ID
AND PARTY_SITE.PARTY_SITE_ID = ORG_CONT.PARTY_SITE_ID(+)
AND CONT_POINT.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND CONT_POINT.OWNER_TABLE_ID(+) = PARTY.PARTY_ID
AND CONT_POINT.CONTACT_POINT_TYPE IN ( 'PHONE'
, 'FAX')