[Home] [Help]
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
Name |
ADDRESS |
CITY |
STATE |
COUNTRY |
PROVINCE |
POSTAL_CODE |
COUNTY |
LOCATION_ID |
LOCATION_TYPE_CODE |
PARTY_ID |
PARTY_NAME |
PARTY_TYPE |