VIEW: APPS.CSC_HZ_PARTY_SITES_V

Source

View Text - Preformatted

SELECT SITE.ROWID , SITE.PARTY_ID , PARTY.PARTY_NUMBER , PARTY.PARTY_NAME , PARTY.PARTY_TYPE , LOC.LOCATION_ID , SITE.PARTY_SITE_ID , SITE.STATUS , SITE.PARTY_SITE_NAME , SITE.ADDRESSEE , LOC.LANGUAGE , rtrim(LOC.ADDRESS1|| ';' || LOC.ADDRESS2 || ';' || LOC.ADDRESS3 || ';' || LOC.ADDRESS4, ';') ADDRESS , LOC.ADDRESS1 || ' ' || LOC.ADDRESS2 || ' ' || LOC.ADDRESS3 || ' ' || LOC.ADDRESS4 || ' ' || LOC.CITY || ' ' || LOC.STATE || ' ' || LOC.POSTAL_CODE || ' ' || LOC.PROVINCE || ' ' || LOC.COUNTRY FULL_ADDRESS , LOC.ADDRESS1 , LOC.ADDRESS2 , LOC.ADDRESS3 , LOC.ADDRESS4 , LOC.STREET , LOC.HOUSE_NUMBER , LOC.APARTMENT_NUMBER , LOC.BUILDING , LOC.POSITION , LOC.CITY , LOC.STATE , LOC.PROVINCE , LOC.POSTAL_CODE , LOC.PO_BOX_NUMBER , LOC.COUNTY , LOC.COUNTRY , SITE.IDENTIFYING_ADDRESS_FLAG , LOC.OBJECT_VERSION_NUMBER , LOC.ATTRIBUTE_CATEGORY , LOC.ATTRIBUTE1 , LOC.ATTRIBUTE2 , LOC.ATTRIBUTE3 , LOC.ATTRIBUTE4 , LOC.ATTRIBUTE5 , LOC.ATTRIBUTE6 , LOC.ATTRIBUTE7 , LOC.ATTRIBUTE8 , LOC.ATTRIBUTE9 , LOC.ATTRIBUTE10 , LOC.ATTRIBUTE11 , LOC.ATTRIBUTE12 , LOC.ATTRIBUTE13 , LOC.ATTRIBUTE14 , LOC.ATTRIBUTE15 , LOC.ATTRIBUTE16 , LOC.ATTRIBUTE17 , LOC.ATTRIBUTE18 , LOC.ATTRIBUTE19 , LOC.ATTRIBUTE20 , LOC.ADDRESS_KEY , LOC.APARTMENT_FLAG , LOC.STREET_SUFFIX , LOC.SECONDARY_SUFFIX_ELEMENT , LOC.RURAL_ROUTE_TYPE , LOC.RURAL_ROUTE_NUMBER , LOC.STREET_NUMBER , LOC.FLOOR , LOC.SUITE , LOC.ROOM , LOC.POSTAL_PLUS4_CODE , LOC.TIME_ZONE , LOC.POST_OFFICE , LOC.DELIVERY_POINT_CODE , LOC.LOCATION_DIRECTIONS , LOC.ADDRESS_ERROR_CODE , LOC.CLLI_CODE , LOC.DODAAC , LOC.TRAILING_DIRECTORY_CODE , LOC.LIFE_CYCLE_STATUS , LOC.SHORT_DESCRIPTION , LOC.DESCRIPTION , LOC.SALES_TAX_GEOCODE , LOC.SALES_TAX_INSIDE_CITY_LIMITS , SITE.OBJECT_VERSION_NUMBER ,LOC.TIMEZONE_ID ,LOC.ADDRESS_LINES_PHONETIC ,nvl(TER.ADDRESS_STYLE,'AS_DEFAULT') ADDRESS_STYLE ,SITE.PARTY_SITE_NUMBER SITE_NUMBER FROM HZ_PARTY_SITES SITE, HZ_LOCATIONS LOC, HZ_PARTIES PARTY, FND_TERRITORIES TER WHERE SITE.LOCATION_ID = LOC.LOCATION_ID AND SITE.PARTY_ID = PARTY.PARTY_ID AND TER.TERRITORY_CODE = LOC.COUNTRY AND NVL(SITE.CREATED_BY_MODULE,'XXX') <> 'SR_ONETIME'

View Text - HTML Formatted

SELECT SITE.ROWID
, SITE.PARTY_ID
, PARTY.PARTY_NUMBER
, PARTY.PARTY_NAME
, PARTY.PARTY_TYPE
, LOC.LOCATION_ID
, SITE.PARTY_SITE_ID
, SITE.STATUS
, SITE.PARTY_SITE_NAME
, SITE.ADDRESSEE
, LOC.LANGUAGE
, RTRIM(LOC.ADDRESS1|| ';' || LOC.ADDRESS2 || ';' || LOC.ADDRESS3 || ';' || LOC.ADDRESS4
, ';') ADDRESS
, LOC.ADDRESS1 || ' ' || LOC.ADDRESS2 || ' ' || LOC.ADDRESS3 || ' ' || LOC.ADDRESS4 || ' ' || LOC.CITY || ' ' || LOC.STATE || ' ' || LOC.POSTAL_CODE || ' ' || LOC.PROVINCE || ' ' || LOC.COUNTRY FULL_ADDRESS
, LOC.ADDRESS1
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.ADDRESS4
, LOC.STREET
, LOC.HOUSE_NUMBER
, LOC.APARTMENT_NUMBER
, LOC.BUILDING
, LOC.POSITION
, LOC.CITY
, LOC.STATE
, LOC.PROVINCE
, LOC.POSTAL_CODE
, LOC.PO_BOX_NUMBER
, LOC.COUNTY
, LOC.COUNTRY
, SITE.IDENTIFYING_ADDRESS_FLAG
, LOC.OBJECT_VERSION_NUMBER
, LOC.ATTRIBUTE_CATEGORY
, LOC.ATTRIBUTE1
, LOC.ATTRIBUTE2
, LOC.ATTRIBUTE3
, LOC.ATTRIBUTE4
, LOC.ATTRIBUTE5
, LOC.ATTRIBUTE6
, LOC.ATTRIBUTE7
, LOC.ATTRIBUTE8
, LOC.ATTRIBUTE9
, LOC.ATTRIBUTE10
, LOC.ATTRIBUTE11
, LOC.ATTRIBUTE12
, LOC.ATTRIBUTE13
, LOC.ATTRIBUTE14
, LOC.ATTRIBUTE15
, LOC.ATTRIBUTE16
, LOC.ATTRIBUTE17
, LOC.ATTRIBUTE18
, LOC.ATTRIBUTE19
, LOC.ATTRIBUTE20
, LOC.ADDRESS_KEY
, LOC.APARTMENT_FLAG
, LOC.STREET_SUFFIX
, LOC.SECONDARY_SUFFIX_ELEMENT
, LOC.RURAL_ROUTE_TYPE
, LOC.RURAL_ROUTE_NUMBER
, LOC.STREET_NUMBER
, LOC.FLOOR
, LOC.SUITE
, LOC.ROOM
, LOC.POSTAL_PLUS4_CODE
, LOC.TIME_ZONE
, LOC.POST_OFFICE
, LOC.DELIVERY_POINT_CODE
, LOC.LOCATION_DIRECTIONS
, LOC.ADDRESS_ERROR_CODE
, LOC.CLLI_CODE
, LOC.DODAAC
, LOC.TRAILING_DIRECTORY_CODE
, LOC.LIFE_CYCLE_STATUS
, LOC.SHORT_DESCRIPTION
, LOC.DESCRIPTION
, LOC.SALES_TAX_GEOCODE
, LOC.SALES_TAX_INSIDE_CITY_LIMITS
, SITE.OBJECT_VERSION_NUMBER
, LOC.TIMEZONE_ID
, LOC.ADDRESS_LINES_PHONETIC
, NVL(TER.ADDRESS_STYLE
, 'AS_DEFAULT') ADDRESS_STYLE
, SITE.PARTY_SITE_NUMBER SITE_NUMBER
FROM HZ_PARTY_SITES SITE
, HZ_LOCATIONS LOC
, HZ_PARTIES PARTY
, FND_TERRITORIES TER
WHERE SITE.LOCATION_ID = LOC.LOCATION_ID
AND SITE.PARTY_ID = PARTY.PARTY_ID
AND TER.TERRITORY_CODE = LOC.COUNTRY
AND NVL(SITE.CREATED_BY_MODULE
, 'XXX') <> 'SR_ONETIME'