VIEW: APPS.JTF_PARTY_ADDRESSES_V

Source

View Text - Preformatted

SELECT PARTY_SITE.ROWID , PARTY.PARTY_ID , PARTY_SITE.PARTY_SITE_ID , PARTY.PARTY_ID , PARTY_SITE.PARTY_SITE_ID , PARTY.PARTY_NUMBER , PARTY_SITE.PARTY_SITE_NUMBER , LOC.LOCATION_ID , PARTY.PARTY_TYPE , PARTY_SITE.LAST_UPDATE_DATE , PARTY_SITE.LAST_UPDATED_BY , PARTY_SITE.LAST_UPDATE_LOGIN , PARTY_SITE.CREATION_DATE , PARTY_SITE.CREATED_BY , PARTY_SITE.IDENTIFYING_ADDRESS_FLAG , LOC.ADDRESS_KEY , LOC.ADDRESS_STYLE , USE.SITE_USE_TYPE , PARTY_SITE.LANGUAGE , PARTY_SITE.ORIG_SYSTEM_REFERENCE , LOC.ADDRESS1 , LOC.ADDRESS2 , LOC.ADDRESS3 , LOC.ADDRESS4 , LOC.ADDRESS_LINES_PHONETIC , PARTY_SITE.MAILSTOP , LOC.CITY , LOC.POSTAL_CODE , LOC.STATE , LOC.PROVINCE , LOC.COUNTY , LOC.COUNTRY , PARTY_SITE.STATUS , PARTY_SITE.REQUEST_ID , PARTY_SITE.PROGRAM_UPDATE_DATE , PARTY_SITE.PROGRAM_APPLICATION_ID , PARTY_SITE.PROGRAM_ID , PARTY_SITE.ATTRIBUTE_CATEGORY , PARTY_SITE.ATTRIBUTE1 , PARTY_SITE.ATTRIBUTE2 , PARTY_SITE.ATTRIBUTE3 , PARTY_SITE.ATTRIBUTE4 , PARTY_SITE.ATTRIBUTE5 , PARTY_SITE.ATTRIBUTE6 , PARTY_SITE.ATTRIBUTE7 , PARTY_SITE.ATTRIBUTE8 , PARTY_SITE.ATTRIBUTE9 , PARTY_SITE.ATTRIBUTE10 , PARTY_SITE.ATTRIBUTE11 , PARTY_SITE.ATTRIBUTE12 , PARTY_SITE.ATTRIBUTE13 , PARTY_SITE.ATTRIBUTE14 , PARTY_SITE.ATTRIBUTE15 , PARTY_SITE.GLOBAL_ATTRIBUTE_CATEGORY , PARTY_SITE.GLOBAL_ATTRIBUTE1 , PARTY_SITE.GLOBAL_ATTRIBUTE2 , PARTY_SITE.GLOBAL_ATTRIBUTE3 , PARTY_SITE.GLOBAL_ATTRIBUTE4 , PARTY_SITE.GLOBAL_ATTRIBUTE5 , PARTY_SITE.GLOBAL_ATTRIBUTE6 , PARTY_SITE.GLOBAL_ATTRIBUTE7 , PARTY_SITE.GLOBAL_ATTRIBUTE8 , PARTY_SITE.GLOBAL_ATTRIBUTE9 , PARTY_SITE.GLOBAL_ATTRIBUTE10 , PARTY_SITE.GLOBAL_ATTRIBUTE11 , PARTY_SITE.GLOBAL_ATTRIBUTE12 , PARTY_SITE.GLOBAL_ATTRIBUTE13 , PARTY_SITE.GLOBAL_ATTRIBUTE14 , PARTY_SITE.GLOBAL_ATTRIBUTE15 , PARTY_SITE.GLOBAL_ATTRIBUTE16 , PARTY_SITE.GLOBAL_ATTRIBUTE17 , PARTY_SITE.GLOBAL_ATTRIBUTE18 , PARTY_SITE.GLOBAL_ATTRIBUTE19 , PARTY_SITE.GLOBAL_ATTRIBUTE20 FROM HZ_PARTIES PARTY,HZ_PARTY_SITES PARTY_SITE,HZ_LOCATIONS LOC,HZ_PARTY_SITE_USES USE WHERE PARTY.PARTY_ID = PARTY_SITE.PARTY_ID AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID AND PARTY_SITE.PARTY_SITE_ID = USE.PARTY_SITE_ID

View Text - HTML Formatted

SELECT PARTY_SITE.ROWID
, PARTY.PARTY_ID
, PARTY_SITE.PARTY_SITE_ID
, PARTY.PARTY_ID
, PARTY_SITE.PARTY_SITE_ID
, PARTY.PARTY_NUMBER
, PARTY_SITE.PARTY_SITE_NUMBER
, LOC.LOCATION_ID
, PARTY.PARTY_TYPE
, PARTY_SITE.LAST_UPDATE_DATE
, PARTY_SITE.LAST_UPDATED_BY
, PARTY_SITE.LAST_UPDATE_LOGIN
, PARTY_SITE.CREATION_DATE
, PARTY_SITE.CREATED_BY
, PARTY_SITE.IDENTIFYING_ADDRESS_FLAG
, LOC.ADDRESS_KEY
, LOC.ADDRESS_STYLE
, USE.SITE_USE_TYPE
, PARTY_SITE.LANGUAGE
, PARTY_SITE.ORIG_SYSTEM_REFERENCE
, LOC.ADDRESS1
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.ADDRESS4
, LOC.ADDRESS_LINES_PHONETIC
, PARTY_SITE.MAILSTOP
, LOC.CITY
, LOC.POSTAL_CODE
, LOC.STATE
, LOC.PROVINCE
, LOC.COUNTY
, LOC.COUNTRY
, PARTY_SITE.STATUS
, PARTY_SITE.REQUEST_ID
, PARTY_SITE.PROGRAM_UPDATE_DATE
, PARTY_SITE.PROGRAM_APPLICATION_ID
, PARTY_SITE.PROGRAM_ID
, PARTY_SITE.ATTRIBUTE_CATEGORY
, PARTY_SITE.ATTRIBUTE1
, PARTY_SITE.ATTRIBUTE2
, PARTY_SITE.ATTRIBUTE3
, PARTY_SITE.ATTRIBUTE4
, PARTY_SITE.ATTRIBUTE5
, PARTY_SITE.ATTRIBUTE6
, PARTY_SITE.ATTRIBUTE7
, PARTY_SITE.ATTRIBUTE8
, PARTY_SITE.ATTRIBUTE9
, PARTY_SITE.ATTRIBUTE10
, PARTY_SITE.ATTRIBUTE11
, PARTY_SITE.ATTRIBUTE12
, PARTY_SITE.ATTRIBUTE13
, PARTY_SITE.ATTRIBUTE14
, PARTY_SITE.ATTRIBUTE15
, PARTY_SITE.GLOBAL_ATTRIBUTE_CATEGORY
, PARTY_SITE.GLOBAL_ATTRIBUTE1
, PARTY_SITE.GLOBAL_ATTRIBUTE2
, PARTY_SITE.GLOBAL_ATTRIBUTE3
, PARTY_SITE.GLOBAL_ATTRIBUTE4
, PARTY_SITE.GLOBAL_ATTRIBUTE5
, PARTY_SITE.GLOBAL_ATTRIBUTE6
, PARTY_SITE.GLOBAL_ATTRIBUTE7
, PARTY_SITE.GLOBAL_ATTRIBUTE8
, PARTY_SITE.GLOBAL_ATTRIBUTE9
, PARTY_SITE.GLOBAL_ATTRIBUTE10
, PARTY_SITE.GLOBAL_ATTRIBUTE11
, PARTY_SITE.GLOBAL_ATTRIBUTE12
, PARTY_SITE.GLOBAL_ATTRIBUTE13
, PARTY_SITE.GLOBAL_ATTRIBUTE14
, PARTY_SITE.GLOBAL_ATTRIBUTE15
, PARTY_SITE.GLOBAL_ATTRIBUTE16
, PARTY_SITE.GLOBAL_ATTRIBUTE17
, PARTY_SITE.GLOBAL_ATTRIBUTE18
, PARTY_SITE.GLOBAL_ATTRIBUTE19
, PARTY_SITE.GLOBAL_ATTRIBUTE20
FROM HZ_PARTIES PARTY
, HZ_PARTY_SITES PARTY_SITE
, HZ_LOCATIONS LOC
, HZ_PARTY_SITE_USES USE
WHERE PARTY.PARTY_ID = PARTY_SITE.PARTY_ID
AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
AND PARTY_SITE.PARTY_SITE_ID = USE.PARTY_SITE_ID