[Home] [Help] [Dependency Information]
Object Name: | EDW_PUSH_DETAIL_LOG |
---|---|
Object Type: | TABLE |
Owner: | BIS |
FND Design Data: | BIS.EDW_PUSH_DETAIL_LOG |
Subobject Name: | |
Status: | VALID |
Log table for collection
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_PUSH_DETAIL_LOG_IDX | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
INSTANCE_CODE
OBJECT_NAME |
EDW_PUSH_DETAIL_LOG_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PUSH_LOG_FK |
EDW_PUSH_DETAIL_LOG_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | WH_PUSH_START_DATE |
EDW_PUSH_DETAIL_LOG_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
INSTANCE_CODE
OBJECT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INSTANCE_CODE | VARCHAR2 | (80) | comment | |
PUSH_CONC_ID | NUMBER | comment | ||
PUSH_LOG_FK | NUMBER | comment | ||
PUSH_STATUS | VARCHAR2 | (40) | comment | |
PUSH_START_DATE | DATE | comment | ||
PUSH_END_DATE | DATE | comment | ||
WH_PUSH_START_DATE | DATE | comment | ||
WH_PUSH_END_DATE | DATE | comment | ||
NO_OF_PUSHED_RECORDS | NUMBER | comment | ||
PUSH_EXCEPTION_MESSAGE | VARCHAR2 | (4000) | comment | |
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_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
LAST_UPDATE_BY | NUMBER | comment | ||
PUSH_CONCURRENT_ID | NUMBER | comment | ||
OBJECT_NAME | VARCHAR2 | (400) | comment | |
OBJECT_TYPE | VARCHAR2 | (100) | comment | |
PERIOD_START | DATE | comment | ||
PERIOD_END | DATE | comment | ||
PUSH_LOG_PK | NUMBER | comment | ||
OBJECT_ID | NUMBER | (9) | comment |
Cut, paste (and edit) the following text to query this object:
SELECT INSTANCE_CODE
, PUSH_CONC_ID
, PUSH_LOG_FK
, PUSH_STATUS
, PUSH_START_DATE
, PUSH_END_DATE
, WH_PUSH_START_DATE
, WH_PUSH_END_DATE
, NO_OF_PUSHED_RECORDS
, PUSH_EXCEPTION_MESSAGE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_BY
, PUSH_CONCURRENT_ID
, OBJECT_NAME
, OBJECT_TYPE
, PERIOD_START
, PERIOD_END
, PUSH_LOG_PK
, OBJECT_ID
FROM BIS.EDW_PUSH_DETAIL_LOG;
BIS.EDW_PUSH_DETAIL_LOG does not reference any database object
BIS.EDW_PUSH_DETAIL_LOG is referenced by following:
|
|
|