VIEW: APPS.CSD_PARTY_SITES_V

Source

View Text - Preformatted

SELECT A.ROWID ROW_ID , 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.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.ORIG_SYSTEM_REFERENCE , A.MAILSTOP , A.IDENTIFYING_ADDRESS_FLAG , A.PARTY_SITE_NAME , A.STATUS SITE_STATUS , B.STATUS SITE_USE_STATUS , 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.POSTAL_PLUS4_CODE , C.POSITION , C.DELIVERY_POINT_CODE , C.LOCATION_DIRECTIONS , C.ADDRESS_EFFECTIVE_DATE , C.ADDRESS_EXPIRATION_DATE , C.CLLI_CODE , 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.ROWID ROW_ID
, 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.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.ORIG_SYSTEM_REFERENCE
, A.MAILSTOP
, A.IDENTIFYING_ADDRESS_FLAG
, A.PARTY_SITE_NAME
, A.STATUS SITE_STATUS
, B.STATUS SITE_USE_STATUS
, 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.POSTAL_PLUS4_CODE
, C.POSITION
, C.DELIVERY_POINT_CODE
, C.LOCATION_DIRECTIONS
, C.ADDRESS_EFFECTIVE_DATE
, C.ADDRESS_EXPIRATION_DATE
, C.CLLI_CODE
, 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(+)