View: OKL_BPD_LATE_POLICIES_UV

Product:	OKL - Leasing and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_BPD_LATE_POLICIES_UV

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
, STAT.NAME LOCATION
, LPOB.TDF_ID TDF_ID
, LPOB.IDX_ID IDX_ID
, INDS.NAME IDX_NAME
, LPOB.LATE_POLICY_TYPE_CODE LATE_POLICY_TYPE_CODE
, LPOB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LPOB.LATE_CHRG_AMOUNT LATE_CHRG_AMOUNT
, LPOB.LATE_CHRG_RATE LATE_CHRG_RATE
, LPOB.LATE_INT_RATE LATE_INT_RATE
FROM OKL_LATE_POLICIES_B LPOB
, OKL_LATE_POLICIES_TL LPOT
, OKX_STATES_V STAT
, OKL_INDICES INDS
WHERE LPOB.ID = LPOT.ID AND LPOB.ISE_ID = STAT.ID1
AND LPOB.IDX_ID = INDS.ID(+)
AND LPOT.LANGUAGE = USERENV('LANG')

Columns