Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: OKL.OKL_STREAM_INTERFACES#

Object Details
Object Name: OKL_STREAM_INTERFACES#
Object Type: VIEW
Owner: OKL
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes
OBJECT_VERSION_NUMBER NUMBER (9) Yes
FASB_ACCT_TREATMENT_METHOD VARCHAR2 (30) Yes
IRS_TAX_TREATMENT_METHOD VARCHAR2 (30) Yes
SIF_MODE VARCHAR2 (30)
DATE_DELIVERY DATE
Yes
TOTAL_FUNDING NUMBER (14)
SECURITY_DEPOSIT_AMOUNT NUMBER (14)
SIS_CODE VARCHAR2 (30) Yes
KHR_ID NUMBER
Yes
PRICING_TEMPLATE_NAME VARCHAR2 (150) Yes
DATE_PROCESSED DATE
Yes
DATE_SEC_DEPOSIT_COLLECTED DATE

DATE_PAYMENTS_COMMENCEMENT DATE
Yes
TRANSACTION_NUMBER NUMBER
Yes
COUNTRY VARCHAR2 (150) Yes
IMPLICIT_INTEREST_RATE NUMBER (18)
ADJUST VARCHAR2 (80)
ADJUSTMENT_METHOD VARCHAR2 (80)
ORP_CODE VARCHAR2 (30) Yes
LENDING_RATE NUMBER (18)
RVI_YN VARCHAR2 (10)
RVI_RATE NUMBER (18)
REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

JTOT_OBJECT1_CODE VARCHAR2 (30)
OBJECT1_ID1 VARCHAR2 (40)
OBJECT1_ID2 VARCHAR2 (400)
TERM NUMBER

STRUCTURE VARCHAR2 (200)
DEAL_TYPE VARCHAR2 (200)
LOG_FILE VARCHAR2 (200)
FIRST_PAYMENT VARCHAR2 (200)
LAST_PAYMENT VARCHAR2 (200)
STREAM_INTERFACE_ATTRIBUTE01 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE02 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE03 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE04 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE05 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE06 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE07 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE08 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE09 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE10 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE11 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE12 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE13 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE14 VARCHAR2 (450)
STREAM_INTERFACE_ATTRIBUTE15 VARCHAR2 (450)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
PURPOSE_CODE VARCHAR2 (30)
SIF_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ID
,      OBJECT_VERSION_NUMBER
,      FASB_ACCT_TREATMENT_METHOD
,      IRS_TAX_TREATMENT_METHOD
,      SIF_MODE
,      DATE_DELIVERY
,      TOTAL_FUNDING
,      SECURITY_DEPOSIT_AMOUNT
,      SIS_CODE
,      KHR_ID
,      PRICING_TEMPLATE_NAME
,      DATE_PROCESSED
,      DATE_SEC_DEPOSIT_COLLECTED
,      DATE_PAYMENTS_COMMENCEMENT
,      TRANSACTION_NUMBER
,      COUNTRY
,      IMPLICIT_INTEREST_RATE
,      ADJUST
,      ADJUSTMENT_METHOD
,      ORP_CODE
,      LENDING_RATE
,      RVI_YN
,      RVI_RATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      JTOT_OBJECT1_CODE
,      OBJECT1_ID1
,      OBJECT1_ID2
,      TERM
,      STRUCTURE
,      DEAL_TYPE
,      LOG_FILE
,      FIRST_PAYMENT
,      LAST_PAYMENT
,      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
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PURPOSE_CODE
,      SIF_ID
FROM OKL.OKL_STREAM_INTERFACES#;

Dependencies

[top of page]

OKL.OKL_STREAM_INTERFACES# references the following:

SchemaOKL
TableOKL_STREAM_INTERFACES
OKL.OKL_STREAM_INTERFACES# is referenced by following:

SchemaAPPS
SynonymOKL_STREAM_INTERFACES