View: CS_SR_SYSTEMS_V

Product:	CS - Service
Description:	This view brings data related to systems and corresponding customer details.
Implementation/DBA Data:	APPS.CS_SR_SYSTEMS_V

View Text

SELECT CSV.SYSTEM_ID
, CSV.NAME
, CSV.DESCRIPTION
, P.PARTY_NAME
, P.PARTY_NUMBER
, P.EMAIL_ADDRESS
, P.ADDRESS1 || DECODE(P.ADDRESS2
, NULL
, NULL
, ';'||P.ADDRESS2) || DECODE(P.ADDRESS3
, NULL
, NULL
, ';'||P.ADDRESS3) || DECODE(P.ADDRESS4
, NULL
, NULL
, ';'||P.ADDRESS4) ADDRESS
, P.CITY
, P.STATE
, P.COUNTRY
, P.PROVINCE
, P.POSTAL_CODE
, P.PARTY_ID
, DECODE(P.PARTY_TYPE
, 'PERSON'
, 'PERSON'
, 'ORGANIZATION') CALLER_TYPE
, P.KNOWN_AS
FROM CSI_SYSTEMS_VL CSV
, HZ_PARTIES P
, HZ_CUST_ACCOUNTS CA
WHERE CSV.CUSTOMER_ID = CA.CUST_ACCOUNT_ID
AND CA.PARTY_ID = P.PARTY_ID

Columns