VIEW: APPS.OKL_CS_CUST_INS_POLICY_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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