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

TABLE: BIS.BIS_RS_PROG_RUN_HISTORY

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

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BIS_RS_PROG_RUN_HISTORY_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
BIS_RS_PROG_RUN_HISTORY_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROGRAM_ID
ColumnPROG_APP_ID
Columns
Name Datatype Length Mandatory Comments
SET_REQUEST_ID NUMBER
Yes The request id for the request set
STAGE_REQUEST_ID NUMBER

The request id for the stage
REQUEST_ID NUMBER
Yes Concurrent request id for the program
PROGRAM_ID NUMBER
Yes Concurrent program id
PROG_APP_ID NUMBER
Yes Concurrent program application id
STATUS_CODE VARCHAR2 (1)
Concurrent request status
PHASE_CODE VARCHAR2 (1)
The request phase code
START_DATE DATE
Yes The request start date
COMPLETION_DATE DATE

The request completion date
COMPLETION_TEXT VARCHAR2 (240)
The request Completion text.
CREATION_DATE DATE
Yes Row Creation Date (Who Column)
CREATED_BY NUMBER
Yes Row created by (Who Column)
LAST_UPDATED_BY NUMBER
Yes row Last updated by (Who Column)
LAST_UPDATE_DATE DATE
Yes Row Last Update date (Who Column)
Query Text

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


SELECT SET_REQUEST_ID
,      STAGE_REQUEST_ID
,      REQUEST_ID
,      PROGRAM_ID
,      PROG_APP_ID
,      STATUS_CODE
,      PHASE_CODE
,      START_DATE
,      COMPLETION_DATE
,      COMPLETION_TEXT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM BIS.BIS_RS_PROG_RUN_HISTORY;

Dependencies

[top of page]

BIS.BIS_RS_PROG_RUN_HISTORY does not reference any database object

BIS.BIS_RS_PROG_RUN_HISTORY is referenced by following:

SchemaBIS
ViewBIS_RS_PROG_RUN_HISTORY#