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

TABLE: BIS.EDW_LOAD_PROGRESS_LOG

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


Detail log table for load progress. EDW_LOAD_PROGRESS_LOG is a child table of EDW_COLLECTION_DETAIL_LOG.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EDW_LOAD_PROGRESS_LOG_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOAD_FK
EDW_LOAD_PROGRESS_LOG_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_ID
Columns
Name Datatype Length Mandatory Comments
LOAD_FK NUMBER

comment
OBJECT_NAME VARCHAR2 (400)
comment
SEQ_ID VARCHAR2 (40)
comment
OBJ_ID NUMBER

comment
LOAD_PROGRESS VARCHAR2 (800)
comment
START_DATE DATE

comment
END_DATE DATE

comment
CATEGORY VARCHAR2 (40)
comment
OPERATION VARCHAR2 (40)
comment
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_BY NUMBER

comment
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_ID NUMBER (9)
comment
Query Text

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


SELECT LOAD_FK
,      OBJECT_NAME
,      SEQ_ID
,      OBJ_ID
,      LOAD_PROGRESS
,      START_DATE
,      END_DATE
,      CATEGORY
,      OPERATION
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_ID
FROM BIS.EDW_LOAD_PROGRESS_LOG;

Dependencies

[top of page]

BIS.EDW_LOAD_PROGRESS_LOG does not reference any database object

BIS.EDW_LOAD_PROGRESS_LOG is referenced by following:

SchemaAPPS
SynonymEDW_LOAD_PROGRESS_LOG