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

TABLE: BIS.EDW_TEMP_COLLECTION_LOG

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


EDW_TEMP_COLLECTION_LOG


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
OBJECT_NAME VARCHAR2 (400)
comment
OBJECT_TYPE VARCHAR2 (400)
comment
CONCURRENT_ID NUMBER

comment
INSTANCE VARCHAR2 (400)
comment
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
ROWS_READY NUMBER

comment
ROWS_PROCESSED NUMBER

comment
ROWS_COLLECTED NUMBER

comment
ROWS_DANGLING NUMBER

comment
ROWS_DUPLICATE NUMBER

comment
ROWS_ERROR NUMBER

comment
STATUS VARCHAR2 (400)
comment
START_DATE DATE

comment
END_DATE DATE

comment
NUMBER_INSERT NUMBER

comment
NUMBER_UPDATE NUMBER

comment
NUMBER_DELETE NUMBER

comment
NUMBER_READY NUMBER

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.
LAST_UPDATE_BY NUMBER

comment
CREATED_BY NUMBER

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

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

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


SELECT OBJECT_NAME
,      OBJECT_TYPE
,      CONCURRENT_ID
,      INSTANCE
,      REQUEST_ID
,      ROWS_READY
,      ROWS_PROCESSED
,      ROWS_COLLECTED
,      ROWS_DANGLING
,      ROWS_DUPLICATE
,      ROWS_ERROR
,      STATUS
,      START_DATE
,      END_DATE
,      NUMBER_INSERT
,      NUMBER_UPDATE
,      NUMBER_DELETE
,      NUMBER_READY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      LAST_UPDATE_BY
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM BIS.EDW_TEMP_COLLECTION_LOG;

Dependencies

[top of page]

BIS.EDW_TEMP_COLLECTION_LOG does not reference any database object

BIS.EDW_TEMP_COLLECTION_LOG is referenced by following:

SchemaAPPS
SynonymEDW_TEMP_COLLECTION_LOG