View: CS_SR_PARTY_ADDRESS_V

Product:	CS - Service
Description:	This view details the address information of all parties. The address column is a concatenated form of the address from HZ_PARTIES.
Implementation/DBA Data:	APPS.CS_SR_PARTY_ADDRESS_V

View Text

SELECT ADDRESS1 || DECODE(ADDRESS2
, NULL
, NULL
, ';'||ADDRESS2) || DECODE(ADDRESS3
, NULL
, NULL
, ';'||ADDRESS3) || DECODE(ADDRESS4
, NULL
, NULL
, ';'||ADDRESS4) ADDRESS
, CITY
, STATE
, PROVINCE
, POSTAL_CODE
, PARTY_ID
, PARTY_TYPE
, STATUS
, PARTY_NAME
, PARTY_NUMBER
, EMAIL_ADDRESS
, PERSON_LAST_NAME
, PERSON_FIRST_NAME
, PERSON_PRE_NAME_ADJUNCT
, COUNTRY
, KNOWN_AS
FROM HZ_PARTIES

Columns