VIEW: APPS.CSC_HZ_PARTY_LOCATIONS_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 , USE.PARTY_SITE_USE_ID , SITE.STATUS , USE.SITE_USE_TYPE , 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 , USE.OBJECT_VERSION_NUMBER FROM HZ_PARTY_SITES SITE, HZ_LOCATIONS LOC, HZ_PARTY_SITE_USES USE, HZ_PARTIES PARTY WHERE SITE.LOCATION_ID = LOC.LOCATION_ID AND SITE.PARTY_ID = PARTY.PARTY_ID AND SITE.PARTY_SITE_ID = USE.PARTY_SITE_ID(+) 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
, USE.PARTY_SITE_USE_ID
, SITE.STATUS
, USE.SITE_USE_TYPE
, 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
, USE.OBJECT_VERSION_NUMBER
FROM HZ_PARTY_SITES SITE
, HZ_LOCATIONS LOC
, HZ_PARTY_SITE_USES USE
, HZ_PARTIES PARTY
WHERE SITE.LOCATION_ID = LOC.LOCATION_ID
AND SITE.PARTY_ID = PARTY.PARTY_ID
AND SITE.PARTY_SITE_ID = USE.PARTY_SITE_ID(+)
AND NVL(SITE.CREATED_BY_MODULE
, 'XXX') <> 'SR_ONETIME'