View: IGF_SL_ADDR_V

Product:	IGF - Financial Aid
Description:	Person's address details
Implementation/DBA Data:	APPS.IGF_SL_ADDR_V

View Text

SELECT PS.PARTY_ID PERSON_ID
, PSU.SITE_USE_TYPE SITE_USE_TYPE
, L.ADDRESS1 ADDR_LINE_1
, L.ADDRESS2 ADDR_LINE_2
, L.ADDRESS3 ADDR_LINE_3
, L.ADDRESS4 ADDR_LINE_4
, L.CITY CITY
, L.STATE STATE
, L.PROVINCE PROVINCE
, L.COUNTY COUNTY
, L.COUNTRY COUNTRY
, L.POSTAL_CODE POSTAL_CODE
, L.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM HZ_PARTY_SITES PS
, HZ_LOCATIONS L
, HZ_PARTY_SITE_USES PSU
WHERE PS.LOCATION_ID = L.LOCATION_ID
AND PS.PARTY_SITE_ID = PSU.PARTY_SITE_ID
AND PSU.STATUS = 'A'
AND PSU.SITE_USE_TYPE IN ('HOME'
, 'RESIDES_AT')
AND SYSDATE BETWEEN NVL(PS.START_DATE_ACTIVE
, SYSDATE)
AND NVL(PS.END_DATE_ACTIVE
, SYSDATE)

Columns