VIEW: APPS.OKL_SIF_FEES_V

Source

View Text - Preformatted

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 ,sfeb.orig_contract_line_id orig_contract_line_id FROM OKL_SIF_FEES SFEB

View Text - HTML Formatted

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
, SFEB.ORIG_CONTRACT_LINE_ID ORIG_CONTRACT_LINE_ID
FROM OKL_SIF_FEES SFEB