Product: | AS - Sales Foundation |
---|---|
Description: | This view stores address information for organization, individual consumer or business contact, but without address_type column. |
Implementation/DBA Data: | APPS.AS_PARTY_ADDRESSES_V |
SELECT PARTY_SITE.ROWID
, PARTY_SITE.PARTY_ID
, PARTY_SITE.PARTY_SITE_ID
, PARTY_SITE.PARTY_ID
, PARTY_SITE.PARTY_SITE_ID
, PARTY_SITE.PARTY_SITE_NUMBER
, LOC.LOCATION_ID
, 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
, 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
, LOC.VALIDATED_FLAG
FROM HZ_PARTY_SITES PARTY_SITE
, HZ_LOCATIONS LOC
WHERE LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
AND PARTY_SITE.STATUS='A'