View: CSI_HZCA_SITE_USES_V

Product:	CSI - Install Base
Description:	Customer Account Site uses view for record groups.
Implementation/DBA Data:	APPS.CSI_HZCA_SITE_USES_V

View Text

SELECT HL.CITY PARTY_CITY
, HL.ADDRESS1 || ' ' || HL.ADDRESS2 || ' ' || HL.ADDRESS3 || ' ' || HL.ADDRESS4 || ' ' || HL.CITY || ' ' || HL.STATE || ' ' || HL.POSTAL_CODE || ' ' || HL.COUNTRY PARTY_ADDRESS
, HP.PARTY_NAME PARTY_NAME
, HCAS.CUST_ACCT_SITE_ID CUST_ACCT_SITE_ID
, HCSU.SITE_USE_ID SITE_USE_ID
, HCSU.SITE_USE_CODE SITE_USE_CODE
, HCSU.STATUS STATUS
, HL.ADDRESS1 PARTY_ADDRESS1
, HL.ADDRESS2 PARTY_ADDRESS2
, SUBSTR( HL.CITY || DECODE( HL.CITY
, ''
, ''
, DECODE( HL.STATE || HL.COUNTRY || HL.POSTAL_CODE
, ''
, ''
, '
, ')) || HL.STATE ||' ' || HL.POSTAL_CODE || ' ' || HL.COUNTRY
, 1
, 220) PARTY_ADDRESS3
, HCAS.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, HP.PARTY_ID PARTY_ID
, HPS.PARTY_SITE_NAME PARTY_SITE_NAME
, HL.ADDRESS1 ADDRESS1
, HL.ADDRESS2 ADDRESS2
, HL.ADDRESS3 ADDRESS3
, HL.ADDRESS4 ADDRESS4
, HL.CITY CITY
, HL.STATE STATE
, HL.POSTAL_CODE ZIP
, HL.COUNTRY COUNTRY
, HPS.PARTY_SITE_NUMBER PARTY_SITE_NUMBER
, HP.PARTY_NUMBER PARTY_NUMBER
, HPS.STATUS PARTY_SITE_STATUS FROM HZ_CUST_ACCT_SITES_ALL HCAS
, HZ_PARTY_SITES HPS
, HZ_LOCATIONS HL
, HZ_PARTIES HP
, HZ_CUST_SITE_USES_ALL HCSU
WHERE HP.PARTY_ID = HPS.PARTY_ID AND HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID AND HPS.LOCATION_ID = HL.LOCATION_ID AND HCAS.CUST_ACCT_SITE_ID = HCSU.CUST_ACCT_SITE_ID

Columns