VIEW: APPS.CS_SR_SYSTEMS_V

Source

View Text - Preformatted

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 AND TRUNC(SYSDATE) BETWEEN NVL ( TRUNC(csv.start_date_active) , TRUNC(SYSDATE) ) AND NVL ( TRUNC(csv.end_date_active) , TRUNC(SYSDATE) )

View Text - HTML Formatted

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
AND TRUNC(SYSDATE) BETWEEN NVL ( TRUNC(CSV.START_DATE_ACTIVE)
, TRUNC(SYSDATE) )
AND NVL ( TRUNC(CSV.END_DATE_ACTIVE)
, TRUNC(SYSDATE) )