VIEW: APPS.IGF_SL_ADDR_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)