VIEW: APPS.CS_SR_INCIDENT_ADDRESS_V

Source

View Text - Preformatted

SELECT l.address1||decode(l.address2,null,null,';'||l.address2) ||decode(l.address3,null,null,';'||l.address3)||decode(l.address4,null,null,';'||l.address4) address, l.city, l.state, l.country, l.province, l.postal_code, l.county, decode(s.party_site_id, null, l.location_id, s.party_site_id) location_id, decode(s.party_site_id, null, 'HZ_LOCATION', 'HZ_PARTY_SITE') location_type_code, p.party_id, p.party_name, p.party_type from hz_locations l, hz_party_sites s, hz_parties p WHERE s.status(+) = 'A' and s.location_id(+) = l.location_id and p.status(+) = 'A' and p.party_id(+) = s.party_id

View Text - HTML Formatted

SELECT L.ADDRESS1||DECODE(L.ADDRESS2
, NULL
, NULL
, ';'||L.ADDRESS2) ||DECODE(L.ADDRESS3
, NULL
, NULL
, ';'||L.ADDRESS3)||DECODE(L.ADDRESS4
, NULL
, NULL
, ';'||L.ADDRESS4) ADDRESS
, L.CITY
, L.STATE
, L.COUNTRY
, L.PROVINCE
, L.POSTAL_CODE
, L.COUNTY
, DECODE(S.PARTY_SITE_ID
, NULL
, L.LOCATION_ID
, S.PARTY_SITE_ID) LOCATION_ID
, DECODE(S.PARTY_SITE_ID
, NULL
, 'HZ_LOCATION'
, 'HZ_PARTY_SITE') LOCATION_TYPE_CODE
, P.PARTY_ID
, P.PARTY_NAME
, P.PARTY_TYPE
FROM HZ_LOCATIONS L
, HZ_PARTY_SITES S
, HZ_PARTIES P
WHERE S.STATUS(+) = 'A'
AND S.LOCATION_ID(+) = L.LOCATION_ID
AND P.STATUS(+) = 'A'
AND P.PARTY_ID(+) = S.PARTY_ID