VIEW: APPS.HZ_PARTY_SITES_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)