[Home] [Help] [Dependency Information]
Object Name: | RCI_DR_INC |
---|---|
Object Type: | TABLE |
Owner: | AMW |
FND Design Data: | AMW.RCI_DR_INC |
Subobject Name: | |
Status: | VALID |
This table stores the audit records of each fact table, like when each table was last loaded etc.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FACT_NAME | VARCHAR2 | (30) | name of fact table | |
LAST_RUN_DATE | DATE | date when the fact table was last loaded | ||
CREATED_BY | NUMBER | WHO column | ||
CREATION_DATE | DATE | WHO column | ||
LAST_UPDATE_DATE | DATE | WHO column | ||
LAST_UPDATED_BY | NUMBER | WHO column | ||
LAST_UPDATE_LOGIN | NUMBER | WHO column | ||
PROGRAM_ID | NUMBER | Concurrent program ID used for loading data | ||
PROGRAM_LOGIN_ID | NUMBER | Concurrent program login ID used for loading data | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent program application ID used for loading data | ||
REQUEST_ID | NUMBER | Concurrent request ID used for loading data |
Cut, paste (and edit) the following text to query this object:
SELECT FACT_NAME
, LAST_RUN_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID
, REQUEST_ID
FROM AMW.RCI_DR_INC;
AMW.RCI_DR_INC does not reference any database object
AMW.RCI_DR_INC is referenced by following:
|
|
|