VIEW: APPS.OKL_ST_MAP_PERIODIC_FEES_V

Source

View Text - Preformatted

SELECT TRANSACTION_NUMBER, SFE_TYPE, SFEB.SIF_ID SIF_ID, KLE_ID, SIL_ID, SFEB.STRUCTURE STRUCTURE, SFEB.CASH_EFFECT_YN, SFEB.TAX_EFFECT_YN , SFEB.DAYS_IN_PERIOD DAYS_IN_PERIOD, DATE_START, SFEB.QUERY_LEVEL_YN QUERY_LEVEL_YN, LEVEL_TYPE, FEE_INDEX_NUMBER, DESCRIPTION, LEVEL_INDEX_NUMBER, NUMBER_OF_PERIODS, PERIOD, ADVANCE_OR_ARREARS, AMOUNT, LOCK_LEVEL_STEP, RATE, SFEB.STREAM_INTERFACE_ATTRIBUTE01, SFEB.STREAM_INTERFACE_ATTRIBUTE02 , SFEB.STREAM_INTERFACE_ATTRIBUTE03 , SFEB.STREAM_INTERFACE_ATTRIBUTE04 , SFEB.STREAM_INTERFACE_ATTRIBUTE05 , SFEB.STREAM_INTERFACE_ATTRIBUTE06 , SFEB.STREAM_INTERFACE_ATTRIBUTE07 , SFEB.STREAM_INTERFACE_ATTRIBUTE08 , SFEB.STREAM_INTERFACE_ATTRIBUTE09 , SFEB.STREAM_INTERFACE_ATTRIBUTE10 , SFEB.STREAM_INTERFACE_ATTRIBUTE11 , SFEB.STREAM_INTERFACE_ATTRIBUTE12 , SFEB.STREAM_INTERFACE_ATTRIBUTE13 , SFEB.STREAM_INTERFACE_ATTRIBUTE14 , SFEB.STREAM_INTERFACE_ATTRIBUTE15 , SFEB.STREAM_INTERFACE_ATTRIBUTE16 , SFEB.STREAM_INTERFACE_ATTRIBUTE17 , SFEB.STREAM_INTERFACE_ATTRIBUTE18 , SFEB.STREAM_INTERFACE_ATTRIBUTE19 , SFEB.STREAM_INTERFACE_ATTRIBUTE20 , SFEB.DATE_PAID DATE_PAID FROM OKL_SIF_FEES SFEB,OKL_STREAM_INTERFACES SIFB WHERE SFEB.SIF_ID = SIFB.ID ORDER BY FEE_INDEX_NUMBER, LEVEL_INDEX_NUMBER

View Text - HTML Formatted

SELECT TRANSACTION_NUMBER
, SFE_TYPE
, SFEB.SIF_ID SIF_ID
, KLE_ID
, SIL_ID
, SFEB.STRUCTURE STRUCTURE
, SFEB.CASH_EFFECT_YN
, SFEB.TAX_EFFECT_YN
, SFEB.DAYS_IN_PERIOD DAYS_IN_PERIOD
, DATE_START
, SFEB.QUERY_LEVEL_YN QUERY_LEVEL_YN
, LEVEL_TYPE
, FEE_INDEX_NUMBER
, DESCRIPTION
, LEVEL_INDEX_NUMBER
, NUMBER_OF_PERIODS
, PERIOD
, ADVANCE_OR_ARREARS
, AMOUNT
, LOCK_LEVEL_STEP
, RATE
, SFEB.STREAM_INTERFACE_ATTRIBUTE01
, SFEB.STREAM_INTERFACE_ATTRIBUTE02
, SFEB.STREAM_INTERFACE_ATTRIBUTE03
, SFEB.STREAM_INTERFACE_ATTRIBUTE04
, SFEB.STREAM_INTERFACE_ATTRIBUTE05
, SFEB.STREAM_INTERFACE_ATTRIBUTE06
, SFEB.STREAM_INTERFACE_ATTRIBUTE07
, SFEB.STREAM_INTERFACE_ATTRIBUTE08
, SFEB.STREAM_INTERFACE_ATTRIBUTE09
, SFEB.STREAM_INTERFACE_ATTRIBUTE10
, SFEB.STREAM_INTERFACE_ATTRIBUTE11
, SFEB.STREAM_INTERFACE_ATTRIBUTE12
, SFEB.STREAM_INTERFACE_ATTRIBUTE13
, SFEB.STREAM_INTERFACE_ATTRIBUTE14
, SFEB.STREAM_INTERFACE_ATTRIBUTE15
, SFEB.STREAM_INTERFACE_ATTRIBUTE16
, SFEB.STREAM_INTERFACE_ATTRIBUTE17
, SFEB.STREAM_INTERFACE_ATTRIBUTE18
, SFEB.STREAM_INTERFACE_ATTRIBUTE19
, SFEB.STREAM_INTERFACE_ATTRIBUTE20
, SFEB.DATE_PAID DATE_PAID
FROM OKL_SIF_FEES SFEB
, OKL_STREAM_INTERFACES SIFB
WHERE SFEB.SIF_ID = SIFB.ID ORDER BY FEE_INDEX_NUMBER
, LEVEL_INDEX_NUMBER