View: CS_SYSTEM_BILLTO_LOC_RG_V

Product:	CS - Service
Description:
Implementation/DBA Data:	APPS.CS_SYSTEM_BILLTO_LOC_RG_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
, 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
, HPS.PARTY_SITE_ID LOCATION
FROM HZ_CUST_ACCT_SITES_ALL HCAS
, HZ_PARTY_SITES HPS
, HZ_LOCATIONS HL
, HZ_PARTIES HP
WHERE HP.PARTY_ID = HPS.PARTY_ID
AND HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID
AND HPS.LOCATION_ID = HL.LOCATION_ID

Columns