VIEW: APPS.OKL_ST_MAP_LOAN_LINES_V

Source

View Text - Preformatted

SELECT SILB.ID ID, SILB.SIF_ID SIF_ID, SILB.KLE_ID KLE_ID, SILB.INDEX_NUMBER INDEX_NUMBER, SILB.DESCRIPTION DESCRIPTION, SILB.DATE_LENDING DATE_LENDING, SILB.DATE_START DATE_START, SFEB.STRUCTURE STRUCTURE, SILB.STREAM_INTERFACE_ATTRIBUTE01 STREAM_INTERFACE_ATTRIBUTE01, SILB.STREAM_INTERFACE_ATTRIBUTE02 STREAM_INTERFACE_ATTRIBUTE02, SILB.STREAM_INTERFACE_ATTRIBUTE03 STREAM_INTERFACE_ATTRIBUTE03, SILB.STREAM_INTERFACE_ATTRIBUTE04 STREAM_INTERFACE_ATTRIBUTE04, SILB.STREAM_INTERFACE_ATTRIBUTE05 STREAM_INTERFACE_ATTRIBUTE05, SILB.STREAM_INTERFACE_ATTRIBUTE06 STREAM_INTERFACE_ATTRIBUTE06, SILB.STREAM_INTERFACE_ATTRIBUTE07 STREAM_INTERFACE_ATTRIBUTE07, SILB.STREAM_INTERFACE_ATTRIBUTE08 STREAM_INTERFACE_ATTRIBUTE08, SILB.STREAM_INTERFACE_ATTRIBUTE09 STREAM_INTERFACE_ATTRIBUTE09, SILB.STREAM_INTERFACE_ATTRIBUTE10 STREAM_INTERFACE_ATTRIBUTE10, SILB.STREAM_INTERFACE_ATTRIBUTE11 STREAM_INTERFACE_ATTRIBUTE11, SILB.STREAM_INTERFACE_ATTRIBUTE12 STREAM_INTERFACE_ATTRIBUTE12, SILB.STREAM_INTERFACE_ATTRIBUTE13 STREAM_INTERFACE_ATTRIBUTE13, SILB.STREAM_INTERFACE_ATTRIBUTE14 STREAM_INTERFACE_ATTRIBUTE14, SILB.STREAM_INTERFACE_ATTRIBUTE15 STREAM_INTERFACE_ATTRIBUTE15, SIFB.TRANSACTION_NUMBER TRANSACTION_NUMBER , SFEB.DAYS_IN_MONTH, SFEB.DAYS_IN_YEAR, SILB.DOWN_PAYMENT_AMOUNT, SILB.CAPITALIZE_DOWN_PAYMENT_YN, silb.orig_contract_line_id FROM OKL_SIF_LINES SILB,OKL_STREAM_INTERFACES SIFB,OKL_SIF_FEES SFEB WHERE SILB.SIL_TYPE = 'SGN' AND SILB.SIF_ID = SIFB.ID AND SILB.ID = SFEB.SIL_ID AND SFEB.SFE_TYPE = 'SFN' AND SFEB.LEVEL_INDEX_NUMBER = 0 ORDER BY SILB.INDEX_NUMBER

View Text - HTML Formatted

SELECT SILB.ID ID
, SILB.SIF_ID SIF_ID
, SILB.KLE_ID KLE_ID
, SILB.INDEX_NUMBER INDEX_NUMBER
, SILB.DESCRIPTION DESCRIPTION
, SILB.DATE_LENDING DATE_LENDING
, SILB.DATE_START DATE_START
, SFEB.STRUCTURE STRUCTURE
, SILB.STREAM_INTERFACE_ATTRIBUTE01 STREAM_INTERFACE_ATTRIBUTE01
, SILB.STREAM_INTERFACE_ATTRIBUTE02 STREAM_INTERFACE_ATTRIBUTE02
, SILB.STREAM_INTERFACE_ATTRIBUTE03 STREAM_INTERFACE_ATTRIBUTE03
, SILB.STREAM_INTERFACE_ATTRIBUTE04 STREAM_INTERFACE_ATTRIBUTE04
, SILB.STREAM_INTERFACE_ATTRIBUTE05 STREAM_INTERFACE_ATTRIBUTE05
, SILB.STREAM_INTERFACE_ATTRIBUTE06 STREAM_INTERFACE_ATTRIBUTE06
, SILB.STREAM_INTERFACE_ATTRIBUTE07 STREAM_INTERFACE_ATTRIBUTE07
, SILB.STREAM_INTERFACE_ATTRIBUTE08 STREAM_INTERFACE_ATTRIBUTE08
, SILB.STREAM_INTERFACE_ATTRIBUTE09 STREAM_INTERFACE_ATTRIBUTE09
, SILB.STREAM_INTERFACE_ATTRIBUTE10 STREAM_INTERFACE_ATTRIBUTE10
, SILB.STREAM_INTERFACE_ATTRIBUTE11 STREAM_INTERFACE_ATTRIBUTE11
, SILB.STREAM_INTERFACE_ATTRIBUTE12 STREAM_INTERFACE_ATTRIBUTE12
, SILB.STREAM_INTERFACE_ATTRIBUTE13 STREAM_INTERFACE_ATTRIBUTE13
, SILB.STREAM_INTERFACE_ATTRIBUTE14 STREAM_INTERFACE_ATTRIBUTE14
, SILB.STREAM_INTERFACE_ATTRIBUTE15 STREAM_INTERFACE_ATTRIBUTE15
, SIFB.TRANSACTION_NUMBER TRANSACTION_NUMBER
, SFEB.DAYS_IN_MONTH
, SFEB.DAYS_IN_YEAR
, SILB.DOWN_PAYMENT_AMOUNT
, SILB.CAPITALIZE_DOWN_PAYMENT_YN
, SILB.ORIG_CONTRACT_LINE_ID
FROM OKL_SIF_LINES SILB
, OKL_STREAM_INTERFACES SIFB
, OKL_SIF_FEES SFEB
WHERE SILB.SIL_TYPE = 'SGN'
AND SILB.SIF_ID = SIFB.ID
AND SILB.ID = SFEB.SIL_ID
AND SFEB.SFE_TYPE = 'SFN'
AND SFEB.LEVEL_INDEX_NUMBER = 0 ORDER BY SILB.INDEX_NUMBER