Product: | OKL - Lease and Finance Management |
---|---|
Description: | Holds the header details for the data returned by the external pricing engine. |
Implementation/DBA Data: | APPS.OKL_SIF_RETS_V |
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