VIEW: APPS.CSI_HZCA_SITE_USES_V

Source

View Text - Preformatted

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.ORG_ID SITE_ORG_ID, 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

View Text - HTML Formatted

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.ORG_ID SITE_ORG_ID
, 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