View: ASF_ADDRESSES_V

View Text

SELECT SITE.PARTY_ID
, LOC.LOCATION_ID
, SITE.PARTY_SITE_ID
, SITE_USE.PARTY_SITE_USE_ID
, LOC.ADDRESS1
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.ADDRESS4
, LOC.CITY
, LOC.STATE
, LOC.PROVINCE
, LOC.POSTAL_CODE
, LOC.COUNTY
, LOC.COUNTRY
, SITE.START_DATE_ACTIVE
, SITE.END_DATE_ACTIVE
, SITE_USE.SITE_USE_TYPE
, SITE.IDENTIFYING_ADDRESS_FLAG
, SITE.STATUS
, PARTY.PARTY_TYPE
, PARTY.PARTY_NAME
, PARTY.PERSON_FIRST_NAME
, PARTY.PERSON_LAST_NAME
, LOC.LAST_UPDATE_DATE
, SITE.LAST_UPDATE_DATE
, SITE_USE.LAST_UPDATE_DATE
FROM HZ_PARTY_SITES SITE
, HZ_PARTY_SITE_USES SITE_USE
, HZ_LOCATIONS LOC
, HZ_PARTIES PARTY
WHERE SITE.PARTY_ID = PARTY.PARTY_ID
AND PARTY.STATUS IN ('A'
, 'I')
AND SITE.LOCATION_ID(+) = LOC.LOCATION_ID
AND DECODE(SITE.STATUS(+)
, 'A'
, 1
, 'I'
, 1
, NULL
, 1
, -99) = 1
AND SITE.PARTY_SITE_ID = SITE_USE.PARTY_SITE_ID(+)
AND DECODE(SITE_USE.STATUS(+)
, 'A'
, 1
, 'I'
, 1
, NULL
, 1
, -99) = 1 ORDER BY LOC.LOCATION_ID

Columns