View: OKL_LATE_POLICIES_V

Product:	OKL - Lease and Finance Management
Description:	Policy for charging on overdue receivables
Implementation/DBA Data:	APPS.OKL_LATE_POLICIES_V

View Text

SELECT LPOB.ROWID ROW_ID
, LPOB.ID ID
, LPOB.ORG_ID ORG_ID
, LPOT.NAME NAME
, LPOT.DESCRIPTION DESCRIPTION
, LPOB.ISE_ID ISE_ID
, LPOB.TDF_ID TDF_ID
, LPOB.IDX_ID IDX_ID
, LPOB.LATE_POLICY_TYPE_CODE LATE_POLICY_TYPE_CODE
, LPOB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LPOB.LATE_CHRG_ALLOWED_YN LATE_CHRG_ALLOWED_YN
, LPOB.LATE_CHRG_FIXED_YN LATE_CHRG_FIXED_YN
, LPOB.LATE_CHRG_AMOUNT LATE_CHRG_AMOUNT
, LPOB.LATE_CHRG_RATE LATE_CHRG_RATE
, LPOB.LATE_CHRG_GRACE_PERIOD LATE_CHRG_GRACE_PERIOD
, LPOB.LATE_CHRG_MINIMUM_BALANCE LATE_CHRG_MINIMUM_BALANCE
, LPOB.MINIMUM_LATE_CHARGE MINIMUM_LATE_CHARGE
, LPOB.MAXIMUM_LATE_CHARGE MAXIMUM_LATE_CHARGE
, LPOB.LATE_INT_ALLOWED_YN LATE_INT_ALLOWED_YN
, LPOB.LATE_INT_FIXED_YN LATE_INT_FIXED_YN
, LPOB.LATE_INT_RATE LATE_INT_RATE
, LPOB.ADDER_RATE ADDER_RATE
, LPOB.LATE_INT_GRACE_PERIOD LATE_INT_GRACE_PERIOD
, LPOB.LATE_INT_MINIMUM_BALANCE LATE_INT_MINIMUM_BALANCE
, LPOB.MINIMUM_LATE_INTEREST MINIMUM_LATE_INTEREST
, LPOB.MAXIMUM_LATE_INTEREST MAXIMUM_LATE_INTEREST
, LPOB.EFFECTIVE_DATE_FROM EFFECTIVE_DATE_FROM
, LPOB.EFFECTIVE_DATE_TO EFFECTIVE_DATE_TO
, LPOB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, LPOB.ATTRIBUTE1 ATTRIBUTE1
, LPOB.ATTRIBUTE2 ATTRIBUTE2
, LPOB.ATTRIBUTE3 ATTRIBUTE3
, LPOB.ATTRIBUTE4 ATTRIBUTE4
, LPOB.ATTRIBUTE5 ATTRIBUTE5
, LPOB.ATTRIBUTE6 ATTRIBUTE6
, LPOB.ATTRIBUTE7 ATTRIBUTE7
, LPOB.ATTRIBUTE8 ATTRIBUTE8
, LPOB.ATTRIBUTE9 ATTRIBUTE9
, LPOB.ATTRIBUTE10 ATTRIBUTE10
, LPOB.ATTRIBUTE11 ATTRIBUTE11
, LPOB.ATTRIBUTE12 ATTRIBUTE12
, LPOB.ATTRIBUTE13 ATTRIBUTE13
, LPOB.ATTRIBUTE14 ATTRIBUTE14
, LPOB.ATTRIBUTE15 ATTRIBUTE15
, LPOB.CREATED_BY CREATED_BY
, LPOB.CREATION_DATE CREATION_DATE
, LPOB.LAST_UPDATED_BY LAST_UPDATED_BY
, LPOB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LPOB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LPOB.DAYS_IN_YEAR DAYS_IN_YEAR
FROM OKL_LATE_POLICIES_B LPOB
, OKL_LATE_POLICIES_TL LPOT
WHERE LPOB.ID = LPOT.ID
AND LPOT.LANGUAGE = USERENV('LANG')

Columns