View: OKL_INS_CLAIMS_UV

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

View Text

SELECT CLMB.ROWID ROW_ID
, CLMB.ID ID
, CLMB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CLMT.SFWT_FLAG SFWT_FLAG
, CLMB.IPY_ID IPY_ID
, CLMB.LTP_CODE LTP_CODE
, CLMB.CSU_CODE CSU_CODE
, FLPS.MEANING STATUS
, CLMB.CLAIM_NUMBER CLAIM_NUMBER
, CLMB.CLAIM_DATE CLAIM_DATE
, CLMB.LOSS_DATE LOSS_DATE
, CLMT.DESCRIPTION DESCRIPTION
, CLMB.POLICE_CONTACT POLICE_CONTACT
, CLMT.POLICE_REPORT POLICE_REPORT
, CLMB.AMOUNT AMOUNT
, CLMB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CLMB.ATTRIBUTE1 ATTRIBUTE1
, CLMB.ATTRIBUTE2 ATTRIBUTE2
, CLMB.ATTRIBUTE3 ATTRIBUTE3
, CLMB.ATTRIBUTE4 ATTRIBUTE4
, CLMB.ATTRIBUTE5 ATTRIBUTE5
, CLMB.ATTRIBUTE6 ATTRIBUTE6
, CLMB.ATTRIBUTE7 ATTRIBUTE7
, CLMB.ATTRIBUTE8 ATTRIBUTE8
, CLMB.ATTRIBUTE9 ATTRIBUTE9
, CLMB.ATTRIBUTE10 ATTRIBUTE10
, CLMB.ATTRIBUTE11 ATTRIBUTE11
, CLMB.ATTRIBUTE12 ATTRIBUTE12
, CLMB.ATTRIBUTE13 ATTRIBUTE13
, CLMB.ATTRIBUTE14 ATTRIBUTE14
, CLMB.ATTRIBUTE15 ATTRIBUTE15
, CLMB.ORG_ID ORG_ID
, CLMB.REQUEST_ID REQUEST_ID
, CLMB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, CLMB.PROGRAM_ID PROGRAM_ID
, CLMB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CLMB.CREATED_BY CREATED_BY
, CLMB.CREATION_DATE CREATION_DATE
, CLMB.LAST_UPDATED_BY LAST_UPDATED_BY
, CLMB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CLMB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, IPYB.POLICY_NUMBER POLICY_NUMBER
, IPYB.IPY_TYPE IPY_TYPE
, FLPT.MEANING POLICY_TYPE
FROM OKL_INS_CLAIMS_ALL_B CLMB
, OKL_INS_CLAIMS_TL CLMT
, FND_LOOKUPS FLPS
, FND_LOOKUPS FLPT
, OKL_INS_POLICIES_B IPYB
WHERE CLMB.ID = CLMT.ID
AND CLMT.LANGUAGE = USERENV('LANG')
AND CSU_CODE = FLPS.LOOKUP_CODE
AND FLPS.LOOKUP_TYPE = 'OKL_CLAIM_STATUS'
AND CLMB.IPY_ID = IPYB.ID
AND IPYB.IPY_TYPE = FLPT.LOOKUP_CODE
AND FLPT.LOOKUP_TYPE = 'OKL_INSURANCE_TYPE'

Columns