View: OKL_INS_PARTYSITES_V

Product:	OKL - Lease and Finance Management
Description:	This view stores insurance party site information
Implementation/DBA Data:	APPS.OKL_INS_PARTYSITES_V

View Text

SELECT HPS.PARTY_ID
, HLN.ADDRESS1
, HLN.ADDRESS2
, HLN.ADDRESS3
, HLN.ADDRESS4
, HLN.CITY
, HLN.POSTAL_CODE
, HLN.STATE
, HLN.COUNTRY
, HLN.PROVINCE
, HLN.COUNTY
, HLN.ADDRESS1 ||'
, ' ||HLN.ADDRESS2||'
, '||HLN.ADDRESS3||'
, '||HLN.ADDRESS4||'
, '||HLN.CITY||'
, '||HLN.POSTAL_CODE||'
, '||HLN.STATE||'
, '||HLN.COUNTRY||'
, '||HLN.PROVINCE||'
, '||HLN.COUNTY ADDRESS
, HPS.PARTY_SITE_ID
, PRT.CATEGORY_CODE
FROM HZ_PARTIES PRT
, HZ_PARTY_SITES HPS
, HZ_LOCATIONS HLN
WHERE (PRT.CATEGORY_CODE = 'INSURER' OR PRT.CATEGORY_CODE = 'INSURANCE_AGENT')
AND PRT.PARTY_ID = HPS.PARTY_ID
AND HPS.STATUS ='A'
AND PRT.STATUS ='A'
AND HLN.LOCATION_ID = HPS.LOCATION_ID

Columns