View: OKL_CS_CUST_INS_POLICY_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_CS_CUST_INS_POLICY_UV

View Text

SELECT DISTINCT CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, CHR.START_DATE START_DATE
, CHR.END_DATE END_DATE
, STAT.MEANING STATUS
, CHR.DESCRIPTION DESCRIPTION
, P.PARTY_ID PARTY_ID
, INB.POLICY_NUMBER POLICY_NUMBER
, FLPT.MEANING POLICY_TYPE
, CHR.ID CONTRACT_ID
, CHR.ORG_ID ORG_ID
, OU.NAME OPERATING_UNIT
FROM OKL_INS_POLICIES_ALL_B INB
, OKC_K_HEADERS_V CHR
, FND_LOOKUPS FLPT
, OKC_STATUSES_V STAT
, OKC_K_PARTY_ROLES_B CPR
, HZ_PARTIES P
, HR_OPERATING_UNITS OU
WHERE CHR.SCS_CODE = 'LEASE'
AND INB.KHR_ID = CHR.ID
AND CPR.CHR_ID = CHR.ID
AND INB.KHR_ID = CPR.CHR_ID
AND CPR.OBJECT1_ID1 = P.PARTY_ID
AND CPR.JTOT_OBJECT1_CODE = 'OKX_PARTY'
AND CHR.STS_CODE = STAT.CODE
AND INB.IPY_TYPE = FLPT.LOOKUP_CODE
AND FLPT.LOOKUP_TYPE = 'OKL_INSURANCE_TYPE'
AND STAT.CODE != 'ABANDONED'
AND OU.ORGANIZATION_ID = CHR.ORG_ID

Columns