eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: CSC_HZ_PARTY_LOCATIONS_V

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

View Text

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(+)

Columns

Name
ROW_ID
PARTY_ID
PARTY_NUMBER
PARTY_NAME
PARTY_TYPE
LOCATION_ID
PARTY_SITE_ID
PARTY_SITE_USE_ID
STATUS
TYPE
LANGUAGE
ADDRESS
FULL_ADDRESS
ADDRESS1
ADDRESS2
ADDRESS3
ADDRESS4
STREET
HOUSE_NUMBER
APARTMENT_NUMBER
BUILDING
POSITION
CITY
STATE
PROVINCE
POSTAL_CODE
PO_BOX_NUMBER
COUNTY
COUNTRY
PRIMARY_FLAG
LAST_UPDATE_DATE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
ADDRESS_KEY
APARTMENT_FLAG
STREET_SUFFIX
SECONDARY_SUFFIX_ELEMENT
RURAL_ROUTE_TYPE
RURAL_ROUTE_NUMBER
STREET_NUMBER
FLOOR
SUITE
ROOM
POSTAL_PLUS4_CODE
TIME_ZONE
POST_OFFICE
DELIVERY_POINT_CODE
LOCATION_DIRECTIONS
ADDRESS_ERROR_CODE
CLLI_CODE
DODAAC
TRAILING_DIRECTORY_CODE
LIFE_CYCLE_STATUS
SHORT_DESCRIPTION
DESCRIPTION
SALES_TAX_GEOCODE
SALES_TAX_INSIDE_CITY_LIMITS
SITE_LAST_UPDATE_DATE
USE_LAST_UPDATE_DATE