VIEW: APPS.PV_PARTNER_LOV_V

Source

View Text - Preformatted

SELECT PARTY.party_name ,PARTY.party_number ,PARTY.party_id ,LOC.location_id ,SITE.party_site_id ,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 ,USE.site_use_type ,SITE.identifying_address_flag ,SITE.status ,PARTY.party_type FROM hz_party_sites SITE ,hz_party_site_uses USE ,hz_locations LOC ,hz_parties PARTY WHERE SITE.location_id = LOC.location_id(+) AND SITE.party_site_id = USE.party_site_id(+) AND PARTY.party_id = SITE.party_id(+) AND PARTY.PARTY_TYPE='ORGANIZATION'

View Text - HTML Formatted

SELECT PARTY.PARTY_NAME
, PARTY.PARTY_NUMBER
, PARTY.PARTY_ID
, LOC.LOCATION_ID
, SITE.PARTY_SITE_ID
, 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
, USE.SITE_USE_TYPE
, SITE.IDENTIFYING_ADDRESS_FLAG
, SITE.STATUS
, PARTY.PARTY_TYPE
FROM HZ_PARTY_SITES SITE
, HZ_PARTY_SITE_USES USE
, HZ_LOCATIONS LOC
, HZ_PARTIES PARTY
WHERE SITE.LOCATION_ID = LOC.LOCATION_ID(+)
AND SITE.PARTY_SITE_ID = USE.PARTY_SITE_ID(+)
AND PARTY.PARTY_ID = SITE.PARTY_ID(+)
AND PARTY.PARTY_TYPE='ORGANIZATION'