View: CS_SR_INCIDENT_ADDRESS_V

Product:	CS - Service
Description:	This view has the address of the contacts for a service request.
Implementation/DBA Data:	APPS.CS_SR_INCIDENT_ADDRESS_V

View Text

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

Columns