VIEW: APPS.OKL_SIF_RETS_V

Source

View Text - Preformatted

SELECT SIRB.ROWID ROW_ID ,SIRB.ID ID ,SIRB.TRANSACTION_NUMBER TRANSACTION_NUMBER ,SIRB.SRT_CODE SRT_CODE ,SIRB.EFFECTIVE_PRE_TAX_YIELD EFFECTIVE_PRE_TAX_YIELD ,SIRB.YIELD_NAME YIELD_NAME ,SIRB.INDEX_NUMBER INDEX_NUMBER ,SIRB.EFFECTIVE_AFTER_TAX_YIELD EFFECTIVE_AFTER_TAX_YIELD ,SIRB.NOMINAL_PRE_TAX_YIELD NOMINAL_PRE_TAX_YIELD ,SIRB.NOMINAL_AFTER_TAX_YIELD NOMINAL_AFTER_TAX_YIELD ,SIRB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER ,SIRB.IMPLICIT_INTEREST_RATE IMPLICIT_INTEREST_RATE ,SIRB.DATE_PROCESSED DATE_PROCESSED ,SIRB.CREATED_BY CREATED_BY ,SIRB.LAST_UPDATED_BY LAST_UPDATED_BY ,SIRB.CREATION_DATE CREATION_DATE ,SIRB.LAST_UPDATE_DATE LAST_UPDATE_DATE ,SIRB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , SIRB.REQUEST_ID REQUEST_ID ,SIRB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID , SIRB.PROGRAM_ID PROGRAM_ID , SIRB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE ,SIRB.STREAM_INTERFACE_ATTRIBUTE01 STREAM_INTERFACE_ATTRIBUTE01 ,SIRB.STREAM_INTERFACE_ATTRIBUTE02 STREAM_INTERFACE_ATTRIBUTE02 ,SIRB.STREAM_INTERFACE_ATTRIBUTE03 STREAM_INTERFACE_ATTRIBUTE03 ,SIRB.STREAM_INTERFACE_ATTRIBUTE04 STREAM_INTERFACE_ATTRIBUTE04 ,SIRB.STREAM_INTERFACE_ATTRIBUTE05 STREAM_INTERFACE_ATTRIBUTE05 ,SIRB.STREAM_INTERFACE_ATTRIBUTE06 STREAM_INTERFACE_ATTRIBUTE06 ,SIRB.STREAM_INTERFACE_ATTRIBUTE07 STREAM_INTERFACE_ATTRIBUTE07 ,SIRB.STREAM_INTERFACE_ATTRIBUTE08 STREAM_INTERFACE_ATTRIBUTE08 ,SIRB.STREAM_INTERFACE_ATTRIBUTE09 STREAM_INTERFACE_ATTRIBUTE09 ,SIRB.STREAM_INTERFACE_ATTRIBUTE10 STREAM_INTERFACE_ATTRIBUTE10 ,SIRB.STREAM_INTERFACE_ATTRIBUTE11 STREAM_INTERFACE_ATTRIBUTE11 ,SIRB.STREAM_INTERFACE_ATTRIBUTE12 STREAM_INTERFACE_ATTRIBUTE12 ,SIRB.STREAM_INTERFACE_ATTRIBUTE13 STREAM_INTERFACE_ATTRIBUTE13 ,SIRB.STREAM_INTERFACE_ATTRIBUTE14 STREAM_INTERFACE_ATTRIBUTE14 ,SIRB.STREAM_INTERFACE_ATTRIBUTE15 STREAM_INTERFACE_ATTRIBUTE15 FROM OKL_SIF_RETS SIRB

View Text - HTML Formatted

SELECT SIRB.ROWID ROW_ID
, SIRB.ID ID
, SIRB.TRANSACTION_NUMBER TRANSACTION_NUMBER
, SIRB.SRT_CODE SRT_CODE
, SIRB.EFFECTIVE_PRE_TAX_YIELD EFFECTIVE_PRE_TAX_YIELD
, SIRB.YIELD_NAME YIELD_NAME
, SIRB.INDEX_NUMBER INDEX_NUMBER
, SIRB.EFFECTIVE_AFTER_TAX_YIELD EFFECTIVE_AFTER_TAX_YIELD
, SIRB.NOMINAL_PRE_TAX_YIELD NOMINAL_PRE_TAX_YIELD
, SIRB.NOMINAL_AFTER_TAX_YIELD NOMINAL_AFTER_TAX_YIELD
, SIRB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SIRB.IMPLICIT_INTEREST_RATE IMPLICIT_INTEREST_RATE
, SIRB.DATE_PROCESSED DATE_PROCESSED
, SIRB.CREATED_BY CREATED_BY
, SIRB.LAST_UPDATED_BY LAST_UPDATED_BY
, SIRB.CREATION_DATE CREATION_DATE
, SIRB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SIRB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SIRB.REQUEST_ID REQUEST_ID
, SIRB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, SIRB.PROGRAM_ID PROGRAM_ID
, SIRB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SIRB.STREAM_INTERFACE_ATTRIBUTE01 STREAM_INTERFACE_ATTRIBUTE01
, SIRB.STREAM_INTERFACE_ATTRIBUTE02 STREAM_INTERFACE_ATTRIBUTE02
, SIRB.STREAM_INTERFACE_ATTRIBUTE03 STREAM_INTERFACE_ATTRIBUTE03
, SIRB.STREAM_INTERFACE_ATTRIBUTE04 STREAM_INTERFACE_ATTRIBUTE04
, SIRB.STREAM_INTERFACE_ATTRIBUTE05 STREAM_INTERFACE_ATTRIBUTE05
, SIRB.STREAM_INTERFACE_ATTRIBUTE06 STREAM_INTERFACE_ATTRIBUTE06
, SIRB.STREAM_INTERFACE_ATTRIBUTE07 STREAM_INTERFACE_ATTRIBUTE07
, SIRB.STREAM_INTERFACE_ATTRIBUTE08 STREAM_INTERFACE_ATTRIBUTE08
, SIRB.STREAM_INTERFACE_ATTRIBUTE09 STREAM_INTERFACE_ATTRIBUTE09
, SIRB.STREAM_INTERFACE_ATTRIBUTE10 STREAM_INTERFACE_ATTRIBUTE10
, SIRB.STREAM_INTERFACE_ATTRIBUTE11 STREAM_INTERFACE_ATTRIBUTE11
, SIRB.STREAM_INTERFACE_ATTRIBUTE12 STREAM_INTERFACE_ATTRIBUTE12
, SIRB.STREAM_INTERFACE_ATTRIBUTE13 STREAM_INTERFACE_ATTRIBUTE13
, SIRB.STREAM_INTERFACE_ATTRIBUTE14 STREAM_INTERFACE_ATTRIBUTE14
, SIRB.STREAM_INTERFACE_ATTRIBUTE15 STREAM_INTERFACE_ATTRIBUTE15
FROM OKL_SIF_RETS SIRB