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

VIEW: APPS.OKL_STRM_ELEMENTS_V

Object Details
Object Name: OKL_STRM_ELEMENTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_STRM_ELEMENTS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


The due date and amount for a payment schedule are stored here. Reference to the stream header
is also stored here.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Auto-generated by Headstart Utilities
ID NUMBER
Yes Primary key column
SE_LINE_NUMBER NUMBER
Yes Sequence number of the stream element.
DATE_BILLED DATE

Date on which stream element is billed.
OBJECT_VERSION_NUMBER NUMBER (9) Yes Column used for locking records during updates
STM_ID NUMBER
Yes Foreign key to table OKL_STREAMS
AMOUNT NUMBER
Yes Amount
COMMENTS VARCHAR2 (1995)
User entered comments
ACCRUED_YN VARCHAR2 (3)
Whether the payment amount has been accrued.
STREAM_ELEMENT_DATE DATE
Yes The inclusive start date of the period of time between actions
PROGRAM_ID NUMBER (15)
Concurrent Manager column
REQUEST_ID NUMBER (15)
Concurrent Manager column
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Manager column
PROGRAM_UPDATE_DATE DATE

Concurrent Manager column
CREATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
SEL_ID NUMBER

Stream Element Identifier
SOURCE_ID NUMBER

Source Identifier
SOURCE_TABLE VARCHAR2 (30)
Source Table Name
BILL_ADJ_FLAG VARCHAR2 (3)
Billing Adjustment Flag
ACCRUAL_ADJ_FLAG VARCHAR2 (3)
Accrual Adjustment Flag
DATE_DISBURSED DATE

Date amount disbursed to vendor
Query Text

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


SELECT ROW_ID
,      ID
,      SE_LINE_NUMBER
,      DATE_BILLED
,      OBJECT_VERSION_NUMBER
,      STM_ID
,      AMOUNT
,      COMMENTS
,      ACCRUED_YN
,      STREAM_ELEMENT_DATE
,      PROGRAM_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SEL_ID
,      SOURCE_ID
,      SOURCE_TABLE
,      BILL_ADJ_FLAG
,      ACCRUAL_ADJ_FLAG
,      DATE_DISBURSED
FROM APPS.OKL_STRM_ELEMENTS_V;

Dependencies

[top of page]

APPS.OKL_STRM_ELEMENTS_V references the following:

SchemaAPPS
SynonymOKL_STRM_ELEMENTS
APPS.OKL_STRM_ELEMENTS_V is referenced by following:

SchemaAPPS
Package BodyOKL_AM_LEASE_LOAN_TRMNT_PVT - show dependent code
Package BodyOKL_AM_LEASE_TRMNT_PVT - show dependent code
Package BodyOKL_AM_TERMNT_QUOTE_PVT - show dependent code
Package BodyOKL_BILL_STATUS_PVT - show dependent code
ViewOKL_BPD_AP_DISB_DTL_LN_UV
Package BodyOKL_CONTRACT_BOOK_PVT - show dependent code
Package BodyOKL_CONTRACT_INFO - show dependent code
Package BodyOKL_CS_PRINCIPAL_PAYDOWN_PVT - show dependent code
ViewOKL_CS_TAX_SUMMARY_UV
Package BodyOKL_DAILY_INTEREST_CALC_PVT - show dependent code
Package BodyOKL_EVERGREEN_BILLING_PVT - show dependent code
PL/SQL PackageOKL_GENERATE_ACCRUALS_PVT - show dependent code
Package BodyOKL_GENERATE_ACCRUALS_PVT - show dependent code
ViewOKL_KLE_STRM_V
Package BodyOKL_LA_STREAM_PVT - show dependent code
Package BodyOKL_LTE_CHRG_PVT - show dependent code
Package BodyOKL_LTE_INT_PVT - show dependent code
Package BodyOKL_RELEASE_PVT - show dependent code
PL/SQL PackageOKL_SEL_PVT - show dependent code
Package BodyOKL_SEL_PVT - show dependent code
ViewOKL_TAX_LINES_UV
Package BodyOKL_UBB_PVT - show dependent code
Package BodyOKL_VARIABLE_INTEREST_PVT - show dependent code
Package BodyOKL_VARIABLE_INT_UTIL_PVT - show dependent code