View: OKL_DISB_RULES_V

Product:	OKL - Lease and Finance Management
Description:	Disbursement Rules view for consolidation of disbursement transactions
Implementation/DBA Data:	APPS.OKL_DISB_RULES_V

View Text

SELECT DRAB.ROWID ROW_ID
, DRAB.DISB_RULE_ID
, DRAB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, DRAT.SFWT_FLAG SFWT_FLAG
, DRAB.RULE_NAME
, DRAB.ORG_ID
, DRAB.START_DATE
, DRAB.END_DATE
, DRAB.FEE_OPTION
, DRAB.FEE_BASIS
, DRAB.FEE_AMOUNT
, DRAB.FEE_PERCENT
, DRAB.CONSOLIDATE_BY_DUE_DATE
, DRAB.FREQUENCY
, DRAB.DAY_OF_MONTH
, DRAB.SCHEDULED_MONTH
, DRAB.CONSOLIDATE_STRM_TYPE
, DRAT.DESCRIPTION
, DRAB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, DRAB.ATTRIBUTE1 ATTRIBUTE1
, DRAB.ATTRIBUTE2 ATTRIBUTE2
, DRAB.ATTRIBUTE3 ATTRIBUTE3
, DRAB.ATTRIBUTE4 ATTRIBUTE4
, DRAB.ATTRIBUTE5 ATTRIBUTE5
, DRAB.ATTRIBUTE6 ATTRIBUTE6
, DRAB.ATTRIBUTE7 ATTRIBUTE7
, DRAB.ATTRIBUTE8 ATTRIBUTE8
, DRAB.ATTRIBUTE9 ATTRIBUTE9
, DRAB.ATTRIBUTE10 ATTRIBUTE10
, DRAB.ATTRIBUTE11 ATTRIBUTE11
, DRAB.ATTRIBUTE12 ATTRIBUTE12
, DRAB.ATTRIBUTE13 ATTRIBUTE13
, DRAB.ATTRIBUTE14 ATTRIBUTE14
, DRAB.ATTRIBUTE15 ATTRIBUTE15
, DRAB.CREATED_BY CREATED_BY
, DRAB.CREATION_DATE CREATION_DATE
, DRAB.LAST_UPDATED_BY LAST_UPDATED_BY
, DRAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, DRAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_DISB_RULES_ALL_B DRAB
, OKL_DISB_RULES_TL DRAT
WHERE DRAB.DISB_RULE_ID = DRAT.DISB_RULE_ID
AND DRAT.LANGUAGE = USERENV('LANG')

Columns