VIEW: APPS.OKL_STREAM_INTERFACES_V

Source

View Text - Preformatted

SELECT SIFB.ROWID ROW_ID ,SIFB.ID ID ,SIFB.FASB_ACCT_TREATMENT_METHOD FASB_ACCT_TREATMENT_METHOD ,SIFB.DATE_PAYMENTS_COMMENCEMENT DATE_PAYMENTS_COMMENCEMENT ,SIFB.COUNTRY COUNTRY ,SIFB.SECURITY_DEPOSIT_AMOUNT SECURITY_DEPOSIT_AMOUNT ,SIFB.DATE_DELIVERY DATE_DELIVERY ,SIFB.IRS_TAX_TREATMENT_METHOD IRS_TAX_TREATMENT_METHOD ,SIFB.SIF_MODE SIF_MODE ,SIFB.PRICING_TEMPLATE_NAME PRICING_TEMPLATE_NAME ,SIFB.DATE_SEC_DEPOSIT_COLLECTED DATE_SEC_DEPOSIT_COLLECTED ,SIFB.TRANSACTION_NUMBER TRANSACTION_NUMBER ,SIFB.TOTAL_FUNDING TOTAL_FUNDING ,SIFB.SIS_CODE SIS_CODE ,SIFB.KHR_ID KHR_ID ,SIFB.ADJUST ADJUST ,SIFB.IMPLICIT_INTEREST_RATE IMPLICIT_INTEREST_RATE ,SIFB.ADJUSTMENT_METHOD ADJUSTMENT_METHOD ,SIFB.DATE_PROCESSED DATE_PROCESSED ,SIFB.ORP_CODE ORP_CODE , SIFB.REQUEST_ID REQUEST_ID ,SIFB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID , SIFB.PROGRAM_ID PROGRAM_ID , SIFB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE ,SIFB.TERM TERM ,SIFB.JTOT_OBJECT1_CODE ,SIFB.OBJECT1_ID1 OBJECT1_ID1 ,SIFB.OBJECT1_ID2 OBJECT1_ID2 ,SIFB.STRUCTURE STRUCTURE ,SIFB.LOG_FILE LOG_FILE ,SIFB.DEAL_TYPE DEAL_TYPE ,SIFB.STREAM_INTERFACE_ATTRIBUTE01 STREAM_INTERFACE_ATTRIBUTE01 ,SIFB.STREAM_INTERFACE_ATTRIBUTE02 STREAM_INTERFACE_ATTRIBUTE02 ,SIFB.STREAM_INTERFACE_ATTRIBUTE03 STREAM_INTERFACE_ATTRIBUTE03 ,SIFB.STREAM_INTERFACE_ATTRIBUTE04 STREAM_INTERFACE_ATTRIBUTE04 ,SIFB.STREAM_INTERFACE_ATTRIBUTE05 STREAM_INTERFACE_ATTRIBUTE05 ,SIFB.STREAM_INTERFACE_ATTRIBUTE06 STREAM_INTERFACE_ATTRIBUTE06 ,SIFB.STREAM_INTERFACE_ATTRIBUTE07 STREAM_INTERFACE_ATTRIBUTE07 ,SIFB.STREAM_INTERFACE_ATTRIBUTE08 STREAM_INTERFACE_ATTRIBUTE08 ,SIFB.STREAM_INTERFACE_ATTRIBUTE09 STREAM_INTERFACE_ATTRIBUTE09 ,SIFB.STREAM_INTERFACE_ATTRIBUTE10 STREAM_INTERFACE_ATTRIBUTE10 ,SIFB.STREAM_INTERFACE_ATTRIBUTE11 STREAM_INTERFACE_ATTRIBUTE11 ,SIFB.STREAM_INTERFACE_ATTRIBUTE12 STREAM_INTERFACE_ATTRIBUTE12 ,SIFB.STREAM_INTERFACE_ATTRIBUTE13 STREAM_INTERFACE_ATTRIBUTE13 ,SIFB.STREAM_INTERFACE_ATTRIBUTE14 STREAM_INTERFACE_ATTRIBUTE14 ,SIFB.STREAM_INTERFACE_ATTRIBUTE15 STREAM_INTERFACE_ATTRIBUTE15 ,SIFB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER ,SIFB.CREATED_BY CREATED_BY ,SIFB.LAST_UPDATED_BY LAST_UPDATED_BY ,SIFB.CREATION_DATE CREATION_DATE ,SIFB.LAST_UPDATE_DATE LAST_UPDATE_DATE ,SIFB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN ,SIFB.FIRST_PAYMENT FIRST_PAYMENT ,SIFB.LAST_PAYMENT LAST_PAYMENT ,SIFB.LENDING_RATE LENDING_RATE ,SIFB.RVI_YN RVI_YN ,SIFB.RVI_RATE RVI_RATE ,SIFB.PURPOSE_CODE PURPOSE_CODE ,SIFB.SIF_ID SIF_ID FROM OKL_STREAM_INTERFACES SIFB

View Text - HTML Formatted

SELECT SIFB.ROWID ROW_ID
, SIFB.ID ID
, SIFB.FASB_ACCT_TREATMENT_METHOD FASB_ACCT_TREATMENT_METHOD
, SIFB.DATE_PAYMENTS_COMMENCEMENT DATE_PAYMENTS_COMMENCEMENT
, SIFB.COUNTRY COUNTRY
, SIFB.SECURITY_DEPOSIT_AMOUNT SECURITY_DEPOSIT_AMOUNT
, SIFB.DATE_DELIVERY DATE_DELIVERY
, SIFB.IRS_TAX_TREATMENT_METHOD IRS_TAX_TREATMENT_METHOD
, SIFB.SIF_MODE SIF_MODE
, SIFB.PRICING_TEMPLATE_NAME PRICING_TEMPLATE_NAME
, SIFB.DATE_SEC_DEPOSIT_COLLECTED DATE_SEC_DEPOSIT_COLLECTED
, SIFB.TRANSACTION_NUMBER TRANSACTION_NUMBER
, SIFB.TOTAL_FUNDING TOTAL_FUNDING
, SIFB.SIS_CODE SIS_CODE
, SIFB.KHR_ID KHR_ID
, SIFB.ADJUST ADJUST
, SIFB.IMPLICIT_INTEREST_RATE IMPLICIT_INTEREST_RATE
, SIFB.ADJUSTMENT_METHOD ADJUSTMENT_METHOD
, SIFB.DATE_PROCESSED DATE_PROCESSED
, SIFB.ORP_CODE ORP_CODE
, SIFB.REQUEST_ID REQUEST_ID
, SIFB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, SIFB.PROGRAM_ID PROGRAM_ID
, SIFB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SIFB.TERM TERM
, SIFB.JTOT_OBJECT1_CODE
, SIFB.OBJECT1_ID1 OBJECT1_ID1
, SIFB.OBJECT1_ID2 OBJECT1_ID2
, SIFB.STRUCTURE STRUCTURE
, SIFB.LOG_FILE LOG_FILE
, SIFB.DEAL_TYPE DEAL_TYPE
, SIFB.STREAM_INTERFACE_ATTRIBUTE01 STREAM_INTERFACE_ATTRIBUTE01
, SIFB.STREAM_INTERFACE_ATTRIBUTE02 STREAM_INTERFACE_ATTRIBUTE02
, SIFB.STREAM_INTERFACE_ATTRIBUTE03 STREAM_INTERFACE_ATTRIBUTE03
, SIFB.STREAM_INTERFACE_ATTRIBUTE04 STREAM_INTERFACE_ATTRIBUTE04
, SIFB.STREAM_INTERFACE_ATTRIBUTE05 STREAM_INTERFACE_ATTRIBUTE05
, SIFB.STREAM_INTERFACE_ATTRIBUTE06 STREAM_INTERFACE_ATTRIBUTE06
, SIFB.STREAM_INTERFACE_ATTRIBUTE07 STREAM_INTERFACE_ATTRIBUTE07
, SIFB.STREAM_INTERFACE_ATTRIBUTE08 STREAM_INTERFACE_ATTRIBUTE08
, SIFB.STREAM_INTERFACE_ATTRIBUTE09 STREAM_INTERFACE_ATTRIBUTE09
, SIFB.STREAM_INTERFACE_ATTRIBUTE10 STREAM_INTERFACE_ATTRIBUTE10
, SIFB.STREAM_INTERFACE_ATTRIBUTE11 STREAM_INTERFACE_ATTRIBUTE11
, SIFB.STREAM_INTERFACE_ATTRIBUTE12 STREAM_INTERFACE_ATTRIBUTE12
, SIFB.STREAM_INTERFACE_ATTRIBUTE13 STREAM_INTERFACE_ATTRIBUTE13
, SIFB.STREAM_INTERFACE_ATTRIBUTE14 STREAM_INTERFACE_ATTRIBUTE14
, SIFB.STREAM_INTERFACE_ATTRIBUTE15 STREAM_INTERFACE_ATTRIBUTE15
, SIFB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SIFB.CREATED_BY CREATED_BY
, SIFB.LAST_UPDATED_BY LAST_UPDATED_BY
, SIFB.CREATION_DATE CREATION_DATE
, SIFB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SIFB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SIFB.FIRST_PAYMENT FIRST_PAYMENT
, SIFB.LAST_PAYMENT LAST_PAYMENT
, SIFB.LENDING_RATE LENDING_RATE
, SIFB.RVI_YN RVI_YN
, SIFB.RVI_RATE RVI_RATE
, SIFB.PURPOSE_CODE PURPOSE_CODE
, SIFB.SIF_ID SIF_ID
FROM OKL_STREAM_INTERFACES SIFB