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

TABLE: OKL.OKL_QUOTE_STREAMS

Object Details
Object Name: OKL_QUOTE_STREAMS
Object Type: TABLE
Owner: OKL
Subobject Name:
Status: VALID


Table for storing quote streams


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKL_QUOTE_STREAMS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnQUOTE_STREAM_ID
Columns
Name Datatype Length Mandatory Comments
QUOTE_STREAM_ID NUMBER
Yes Identifier for the Quote Stream Header
OBJECT_VERSION_NUMBER NUMBER
Yes Column used for locking records during updates
QUOTE_TYPE VARCHAR2 (30) Yes Type of the Quote, for which Streams are generated. Eg. Lease Quote
QUOTE_ID NUMBER
Yes Identifier for the Quote
OTY_CODE VARCHAR2 (30) Yes Object Type Code for which the Streams are generated against.
SOURCE_ID NUMBER
Yes Source Identifier of the Object
SOURCE_TABLE VARCHAR2 (30) Yes Source Object Type.
STY_ID NUMBER
Yes Identifier of the Stream Type
SAY_CODE VARCHAR2 (30) Yes Status of the Stream. Current/Work/History
CREATED_BY NUMBER
Yes Created By
CREATION_DATE DATE
Yes Creation Date
LAST_UPDATED_BY NUMBER
Yes Last Updated By
LAST_UPDATE_DATE DATE
Yes Last Update Date
LAST_UPDATE_LOGIN NUMBER

Last Update Login
LINK_ASSET_ID NUMBER

Identifier of the Linked Asset. Used by Serviced Assets
Query Text

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


SELECT QUOTE_STREAM_ID
,      OBJECT_VERSION_NUMBER
,      QUOTE_TYPE
,      QUOTE_ID
,      OTY_CODE
,      SOURCE_ID
,      SOURCE_TABLE
,      STY_ID
,      SAY_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LINK_ASSET_ID
FROM OKL.OKL_QUOTE_STREAMS;

Dependencies

[top of page]

OKL.OKL_QUOTE_STREAMS does not reference any database object

OKL.OKL_QUOTE_STREAMS is referenced by following:

SchemaOKL
ViewOKL_QUOTE_STREAMS#