FND Design Data [Home] [Help]

View: OKL_STREAM_INTERFACES_V

Product: OKL - Lease and Finance Management
Description: Holds the contract header level details for external pricing.
Implementation/DBA Data: ViewAPPS.OKL_STREAM_INTERFACES_V
View Text

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

Columns

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