View: HZ_PARTY_SITES_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.HZ_PARTY_SITES_V

View Text

SELECT A.PARTY_ID
, A.PARTY_SITE_ID
, A.LOCATION_ID
, A.LAST_UPDATE_DATE
, A.PARTY_SITE_NUMBER
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.REQUEST_ID
, A.PROGRAM_APPLICATION_ID
, A.PROGRAM_ID
, A.PROGRAM_UPDATE_DATE
, A.WH_UPDATE_DATE
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE5
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.ATTRIBUTE16
, A.ATTRIBUTE17
, A.ATTRIBUTE18
, A.ATTRIBUTE19
, A.ATTRIBUTE20
, A.GLOBAL_ATTRIBUTE_CATEGORY
, A.GLOBAL_ATTRIBUTE1
, A.GLOBAL_ATTRIBUTE2
, A.GLOBAL_ATTRIBUTE3
, A.GLOBAL_ATTRIBUTE4
, A.GLOBAL_ATTRIBUTE5
, A.GLOBAL_ATTRIBUTE6
, A.GLOBAL_ATTRIBUTE7
, A.GLOBAL_ATTRIBUTE8
, A.GLOBAL_ATTRIBUTE9
, A.GLOBAL_ATTRIBUTE10
, A.GLOBAL_ATTRIBUTE11
, A.GLOBAL_ATTRIBUTE12
, A.GLOBAL_ATTRIBUTE13
, A.GLOBAL_ATTRIBUTE14
, A.GLOBAL_ATTRIBUTE15
, A.GLOBAL_ATTRIBUTE16
, A.GLOBAL_ATTRIBUTE17
, A.GLOBAL_ATTRIBUTE18
, A.GLOBAL_ATTRIBUTE19
, A.GLOBAL_ATTRIBUTE20
, A.ORIG_SYSTEM_REFERENCE
, A.START_DATE_ACTIVE
, A.END_DATE_ACTIVE
, A.REGION
, A.MAILSTOP
, A.CUSTOMER_KEY_OSM
, A.PHONE_KEY_OSM
, A.CONTACT_KEY_OSM
, A.IDENTIFYING_ADDRESS_FLAG
, A.LANGUAGE
, A.STATUS
, A.PARTY_SITE_NAME
, B.SITE_USE_TYPE
, B.PRIMARY_PER_TYPE
, B.COMMENTS
, B.PARTY_SITE_USE_ID
, C.COUNTRY
, C.ADDRESS1
, C.ADDRESS2
, C.ADDRESS3
, C.ADDRESS4
, C.CITY
, C.POSTAL_CODE
, C.STATE
, C.PROVINCE
, C.COUNTY
, C.ADDRESS_KEY
, C.ADDRESS_STYLE
, C.VALIDATED_FLAG
, C.ADDRESS_LINES_PHONETIC
, C.APARTMENT_FLAG
, C.PO_BOX_NUMBER
, C.HOUSE_NUMBER
, C.STREET_SUFFIX
, C.APARTMENT_NUMBER
, C.SECONDARY_SUFFIX_ELEMENT
, C.STREET
, C.RURAL_ROUTE_TYPE
, C.RURAL_ROUTE_NUMBER
, C.STREET_NUMBER
, C.BUILDING
, C.FLOOR
, C.SUITE
, C.ROOM
, C.POSTAL_PLUS4_CODE
, C.TIME_ZONE
, C.OVERSEAS_ADDRESS_FLAG
, C.POST_OFFICE
, C.POSITION
, C.DELIVERY_POINT_CODE
, C.LOCATION_DIRECTIONS
, C.ADDRESS_EFFECTIVE_DATE
, C.ADDRESS_EXPIRATION_DATE
, C.ADDRESS_ERROR_CODE
, C.CLLI_CODE
, C.DODAAC
, C.TRAILING_DIRECTORY_CODE
, C.LIFE_CYCLE_STATUS
, C.SHORT_DESCRIPTION
, C.DESCRIPTION
, C.CONTENT_SOURCE_TYPE
, C.LOC_HIERARCHY_ID
, C.SALES_TAX_GEOCODE
, C.SALES_TAX_INSIDE_CITY_LIMITS
, C.FA_LOCATION_ID
FROM HZ_PARTY_SITES A
, HZ_PARTY_SITE_USES B
, HZ_LOCATIONS C
WHERE A.LOCATION_ID = C.LOCATION_ID
AND A.PARTY_SITE_ID = B.PARTY_SITE_ID(+)

Columns