View: CSI_HZPTY_ADDRESSES_V

Product:	CSI - Install Base
Description:	Customer Party Addresses view for the record groups.
Implementation/DBA Data:	APPS.CSI_HZPTY_ADDRESSES_V

View Text

SELECT HPS.PARTY_SITE_ID LOCATION
, HL.DESCRIPTION DESCRIPTION
, HZP.PARTY_NAME PARTY_NAME
, 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.START_DATE_ACTIVE START_DATE_ACTIVE
, HPS.END_DATE_ACTIVE END_DATE_ACTIVE
, HPS.STATUS STATUS
, HPS.IDENTIFYING_ADDRESS_FLAG IDENTIFYING_ADDRESS_FLAG
, HZP.PARTY_ID PARTY_ID
, HPS.PARTY_SITE_NUMBER PARTY_SITE_NUMBER
, HZP.PARTY_NUMBER PARTY_NUMBER
FROM HZ_PARTIES HZP
, HZ_PARTY_SITES HPS
, HZ_LOCATIONS HL
WHERE HZP.PARTY_ID = HPS.PARTY_ID AND HPS.LOCATION_ID = HL.LOCATION_ID

Columns