Product: | CSD - Depot Repair |
---|---|
Description: | |
Implementation/DBA Data: | APPS.CSD_PARTY_SITES_V |
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(+)