eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: OKL.OKL_STRM_ELEMENTS_H

Object Details

Object Name:	OKL_STRM_ELEMENTS_H
Object Type:	TABLE
Owner:	OKL
FND Design Data:	OKL.OKL_STRM_ELEMENTS_H
Subobject Name:
Status:	VALID

Holds the stream elemnts history details

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKL_SELH_SEL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID MAJOR_VERSION
OKL_SELH_SEL_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	STM_ID SE_LINE_NUMBER MAJOR_VERSION

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Primary key column
MAJOR_VERSION	NUMBER		Yes	Major Version
SE_LINE_NUMBER	NUMBER		Yes	Sequence number of the stream element.
DATE_BILLED	DATE			Date on which stream element is billed.
STM_ID	NUMBER		Yes	Foreign key to table OKL_STREAMS
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Column used for locking records during updates
STREAM_ELEMENT_DATE	DATE		Yes	The inclusive start date of the period of time between actions
AMOUNT	NUMBER	(14)	Yes	Amount
COMMENTS	VARCHAR2	(1995)		User entered comments
ACCRUED_YN	VARCHAR2	(3)		Whether the payment amount has been accrued.
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

Query Text

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


SELECT ID
,      MAJOR_VERSION
,      SE_LINE_NUMBER
,      DATE_BILLED
,      STM_ID
,      OBJECT_VERSION_NUMBER
,      STREAM_ELEMENT_DATE
,      AMOUNT
,      COMMENTS
,      ACCRUED_YN
,      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
FROM OKL.OKL_STRM_ELEMENTS_H;

Dependencies

[top of page]

OKL.OKL_STRM_ELEMENTS_H does not reference any database object

OKL.OKL_STRM_ELEMENTS_H is referenced by following:

APPS: OKL_STRM_ELEMENTS_H