VIEW: APPS.JTF_PARTY_PHONES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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