View: ASF_PARTY_SITES_LOV_V

View Text

SELECT NULL
, NULL
, SITE.PARTY_SITE_ID
, SITE.PARTY_ID
, SITE.STATUS
, USE.PRIMARY_PER_TYPE
, USE.SITE_USE_TYPE
, LOC.ADDRESS1
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.ADDRESS4
, LOC.CITY
, LOC.STATE
, LOC.COUNTRY
, LOC.COUNTY
, LOC.POSTAL_CODE
, LOC.PROVINCE
, ASF_CUST_ACCOUNTS_PUB.IS_VALID_LOCATION_SEGMENTS(LOC.COUNTRY
, LOC.CITY
, LOC.STATE
, LOC.COUNTY
, LOC.PROVINCE
, LOC.POSTAL_CODE)
FROM HZ_LOCATIONS LOC
, HZ_PARTY_SITES SITE
, HZ_PARTY_SITE_USES USE
WHERE USE.PARTY_SITE_ID (+)= SITE.PARTY_SITE_ID
AND LOC.LOCATION_ID = SITE.LOCATION_ID
AND SITE.STATUS IN ('A'
, 'I')
AND DECODE(USE.STATUS(+)
, 'A'
, 1
, 'I'
, 1
, NULL
, 1
, -99) = 1

Columns