Product: | CSC - Customer Care |
---|---|
Description: | View of HZ_LOCATIONS. This view is used to get party locations details |
Implementation/DBA Data: | APPS.CSC_HZ_PARTY_LOCATIONS_V |
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
, LOC.ADDRESS1||DECODE(LOC.ADDRESS2
, NULL
, NULL
, ';'||LOC.ADDRESS2|| DECODE(LOC.ADDRESS3
, NULL
, NULL
, ';'||LOC.ADDRESS3|| DECODE(LOC.ADDRESS4
, NULL
, NULL
, ';'||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.LAST_UPDATE_DATE
, 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.LAST_UPDATE_DATE
, USE.LAST_UPDATE_DATE
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(+)