VIEW: APPS.CS_SR_PARTY_ADDRESS_V

Source

View Text - Preformatted

SELECT address1 || decode(address2,null,null,';'||address2) || decode(address3,null,null,';'||address3) || decode(address4,null,null,';'||address4) address, city, state, province, county, 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

View Text - HTML Formatted

SELECT ADDRESS1 || DECODE(ADDRESS2
, NULL
, NULL
, ';'||ADDRESS2) || DECODE(ADDRESS3
, NULL
, NULL
, ';'||ADDRESS3) || DECODE(ADDRESS4
, NULL
, NULL
, ';'||ADDRESS4) ADDRESS
, CITY
, STATE
, PROVINCE
, COUNTY
, 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