FND Design Data [Home] [Help]

View: OKL_SIF_FEES_V

Product: OKL - Lease and Finance Management
Description: Holds the fee and payment details required for external pricing.
Implementation/DBA Data: ViewAPPS.OKL_SIF_FEES_V
View Text

SELECT SFEB.ROWID ROW_ID
, SFEB.ID ID
, SFEB.SFE_TYPE SFE_TYPE
, SFEB.DATE_START DATE_START
, SFEB.DATE_PAID DATE_PAID
, SFEB.AMOUNT AMOUNT
, SFEB.IDC_ACCOUNTING_FLAG IDC_ACCOUNTING_FLAG
, SFEB.INCOME_OR_EXPENSE INCOME_OR_EXPENSE
, SFEB.DESCRIPTION DESCRIPTION
, SFEB.FEE_INDEX_NUMBER FEE_INDEX_NUMBER
, SFEB.LEVEL_INDEX_NUMBER LEVEL_INDEX_NUMBER
, SFEB.ADVANCE_OR_ARREARS ADVANCE_OR_ARREARS
, SFEB.LEVEL_TYPE LEVEL_TYPE
, SFEB.LOCK_LEVEL_STEP LOCK_LEVEL_STEP
, SFEB.PERIOD PERIOD
, SFEB.NUMBER_OF_PERIODS NUMBER_OF_PERIODS
, SFEB.LEVEL_LINE_NUMBER LEVEL_LINE_NUMBER
, SFEB.SIF_ID SIF_ID
, SFEB.KLE_ID KLE_ID
, SFEB.SIL_ID SIL_ID
, SFEB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SFEB.RATE RATE
, SFEB.STRUCTURE STRUCTURE
, SFEB.DAYS_IN_PERIOD DAYS_IN_PERIOD
, SFEB.QUERY_LEVEL_YN QUERY_LEVEL_YN
, SFEB.CASH_EFFECT_YN CASH_EFFECT_YN
, SFEB.TAX_EFFECT_YN TAX_EFFECT_YN
, SFEB.STREAM_INTERFACE_ATTRIBUTE01 STREAM_INTERFACE_ATTRIBUTE01
, SFEB.STREAM_INTERFACE_ATTRIBUTE02 STREAM_INTERFACE_ATTRIBUTE02
, SFEB.STREAM_INTERFACE_ATTRIBUTE03 STREAM_INTERFACE_ATTRIBUTE03
, SFEB.STREAM_INTERFACE_ATTRIBUTE04 STREAM_INTERFACE_ATTRIBUTE04
, SFEB.STREAM_INTERFACE_ATTRIBUTE05 STREAM_INTERFACE_ATTRIBUTE05
, SFEB.STREAM_INTERFACE_ATTRIBUTE06 STREAM_INTERFACE_ATTRIBUTE06
, SFEB.STREAM_INTERFACE_ATTRIBUTE07 STREAM_INTERFACE_ATTRIBUTE07
, SFEB.STREAM_INTERFACE_ATTRIBUTE08 STREAM_INTERFACE_ATTRIBUTE08
, SFEB.STREAM_INTERFACE_ATTRIBUTE09 STREAM_INTERFACE_ATTRIBUTE09
, SFEB.STREAM_INTERFACE_ATTRIBUTE10 STREAM_INTERFACE_ATTRIBUTE10
, SFEB.STREAM_INTERFACE_ATTRIBUTE11 STREAM_INTERFACE_ATTRIBUTE11
, SFEB.STREAM_INTERFACE_ATTRIBUTE12 STREAM_INTERFACE_ATTRIBUTE12
, SFEB.STREAM_INTERFACE_ATTRIBUTE13 STREAM_INTERFACE_ATTRIBUTE13
, SFEB.STREAM_INTERFACE_ATTRIBUTE14 STREAM_INTERFACE_ATTRIBUTE14
, SFEB.STREAM_INTERFACE_ATTRIBUTE15 STREAM_INTERFACE_ATTRIBUTE15
, SFEB.STREAM_INTERFACE_ATTRIBUTE16 STREAM_INTERFACE_ATTRIBUTE16
, SFEB.STREAM_INTERFACE_ATTRIBUTE17 STREAM_INTERFACE_ATTRIBUTE17
, SFEB.STREAM_INTERFACE_ATTRIBUTE18 STREAM_INTERFACE_ATTRIBUTE18
, SFEB.STREAM_INTERFACE_ATTRIBUTE19 STREAM_INTERFACE_ATTRIBUTE19
, SFEB.STREAM_INTERFACE_ATTRIBUTE20 STREAM_INTERFACE_ATTRIBUTE20
, SFEB.CREATED_BY CREATED_BY
, SFEB.LAST_UPDATED_BY LAST_UPDATED_BY
, SFEB.CREATION_DATE CREATION_DATE
, SFEB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SFEB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SFEB.DAYS_IN_MONTH
, SFEB.DAYS_IN_YEAR
, SFEB.BALANCE_TYPE_CODE
, SFEB.DOWN_PAYMENT_AMOUNT
FROM OKL_SIF_FEES SFEB

Columns

Name
ROW_ID
ID
SFE_TYPE
DATE_START
DATE_PAID
AMOUNT
IDC_ACCOUNTING_FLAG
INCOME_OR_EXPENSE
DESCRIPTION
FEE_INDEX_NUMBER
LEVEL_INDEX_NUMBER
ADVANCE_OR_ARREARS
LEVEL_TYPE
LOCK_LEVEL_STEP
PERIOD
NUMBER_OF_PERIODS
LEVEL_LINE_NUMBER
SIF_ID
KLE_ID
SIL_ID
OBJECT_VERSION_NUMBER
RATE
STRUCTURE
DAYS_IN_PERIOD
QUERY_LEVEL_YN
CASH_EFFECT_YN
TAX_EFFECT_YN
STREAM_INTERFACE_ATTRIBUTE01
STREAM_INTERFACE_ATTRIBUTE02
STREAM_INTERFACE_ATTRIBUTE03
STREAM_INTERFACE_ATTRIBUTE04
STREAM_INTERFACE_ATTRIBUTE05
STREAM_INTERFACE_ATTRIBUTE06
STREAM_INTERFACE_ATTRIBUTE07
STREAM_INTERFACE_ATTRIBUTE08
STREAM_INTERFACE_ATTRIBUTE09
STREAM_INTERFACE_ATTRIBUTE10
STREAM_INTERFACE_ATTRIBUTE11
STREAM_INTERFACE_ATTRIBUTE12
STREAM_INTERFACE_ATTRIBUTE13
STREAM_INTERFACE_ATTRIBUTE14
STREAM_INTERFACE_ATTRIBUTE15
STREAM_INTERFACE_ATTRIBUTE16
STREAM_INTERFACE_ATTRIBUTE17
STREAM_INTERFACE_ATTRIBUTE18
STREAM_INTERFACE_ATTRIBUTE19
STREAM_INTERFACE_ATTRIBUTE20
CREATED_BY
LAST_UPDATED_BY
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
DAYS_IN_MONTH
DAYS_IN_YEAR
BALANCE_TYPE_CODE
DOWN_PAYMENT_AMOUNT