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

TABLE: BIS.BIS_RS_RUN_HISTORY

Object Details
Object Name: BIS_RS_RUN_HISTORY
Object Type: TABLE
Owner: BIS
FND Design Data: TableBIS.BIS_RS_RUN_HISTORY
Subobject Name:
Status: VALID


Stores the history of request set run.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BIS_RS_RUN_HISTORY_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
BIS_RS_RUN_HISTORY_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_SET_ID
ColumnSET_APP_ID
Columns
Name Datatype Length Mandatory Comments
REQUEST_SET_NAME VARCHAR2 (30)
Request Set Name
REQUEST_SET_ID NUMBER
Yes Request Set Id
SET_APP_ID NUMBER
Yes Request set application identifier
REQUEST_SET_TYPE VARCHAR2 (30) Yes Request set Type
REQUEST_ID NUMBER
Yes Concurrent request identifier for the request set
START_DATE DATE
Yes The request start date
COMPLETION_DATE DATE

The request end date
STATUS_CODE VARCHAR2 (1)
The request status
PHASE_CODE VARCHAR2 (1)
The request phase code
COMPLETION_TEXT VARCHAR2 (240)
The request Completion text.
CREATION_DATE DATE
Yes Creation Date of the row
CREATED_BY NUMBER
Yes Row created by (Who Column)
LAST_UPDATE_DATE DATE
Yes Row Last Updated by (Who Column)
LAST_UPDATED_BY NUMBER
Yes row Last updated by (Who Column)
Query Text

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


SELECT REQUEST_SET_NAME
,      REQUEST_SET_ID
,      SET_APP_ID
,      REQUEST_SET_TYPE
,      REQUEST_ID
,      START_DATE
,      COMPLETION_DATE
,      STATUS_CODE
,      PHASE_CODE
,      COMPLETION_TEXT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM BIS.BIS_RS_RUN_HISTORY;

Dependencies

[top of page]

BIS.BIS_RS_RUN_HISTORY does not reference any database object

BIS.BIS_RS_RUN_HISTORY is referenced by following:

SchemaAPPS
SynonymBIS_RS_RUN_HISTORY