View: OKL_INS_CLAIMS_V

Product:	OKL - Lease and Finance Management
Description:	Lease and optional insurance claims
Implementation/DBA Data:	APPS.OKL_INS_CLAIMS_V

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
, 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.HOLD_DATE HOLD_DATE
, 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
FROM OKL_INS_CLAIMS_B CLMB
, OKL_INS_CLAIMS_TL CLMT
WHERE CLMB.ID = CLMT.ID
AND CLMT.LANGUAGE = USERENV('LANG')

Columns