VIEW: OKL.OKL_STREAM_INTERFACES#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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