[Home] [Help] [Dependency Information]
Object Name: | EDW_ITEM_ITEMREV_LSTG |
---|---|
Object Type: | TABLE |
Owner: | ENI |
Subobject Name: | |
Status: | VALID |
This is the interface table for the Item Revision level table. Data from multiple transactional systems is staged here for verification and cleansing, before loading it into the dimension level table.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 30 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_ITEM_ITEMREV_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | ITEM_REVISION_PK |
EDW_ITEM_ITEMREV_LSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | COLLECTION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_ORG_FK_KEY | NUMBER | System generated foreign key to the organization item level | ||
REQUEST_ID | NUMBER | Standard Who column | ||
COLLECTION_STATUS | VARCHAR2 | (30) | Collection status code for the record | |
ERROR_CODE | VARCHAR2 | (2000) | Error code | |
INSTANCE | VARCHAR2 | (40) | Instance from which the record was collected | |
ITEM_ORG_FK | VARCHAR2 | (320) | Foreign key to the organization item level | |
ITEM_REVISION | VARCHAR2 | (240) | Item revision | |
ITEM_REVISION_DP | VARCHAR2 | (240) | Not currently used | |
ITEM_REVISION_PK | VARCHAR2 | (320) | Unique identifier | |
LEVEL_NAME | VARCHAR2 | (25) | Level name | |
NAME | VARCHAR2 | (320) | Item name | |
OPERATION_CODE | VARCHAR2 | (30) | Operation code | |
ROW_ID | ROWID | (10) | Row ID | |
USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
CREATION_DATE | DATE | Standard Who column | ||
EFFECTIVE_DATE | DATE | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Standard Who column | ||
INVENTORY_ITEM_ID | NUMBER | Inventory Item Surrogate Key | ||
ORGANIZATION_ID | NUMBER | Organization Surrogate Key | ||
CATEGORY_ID | NUMBER | Category Surrogate Key | ||
CATEGORY_SET_ID | NUMBER | Category Set Surrogate Key | ||
ITEM_TYPE | VARCHAR2 | (30) | Item Type |
Cut, paste (and edit) the following text to query this object:
SELECT ITEM_ORG_FK_KEY
, REQUEST_ID
, COLLECTION_STATUS
, ERROR_CODE
, INSTANCE
, ITEM_ORG_FK
, ITEM_REVISION
, ITEM_REVISION_DP
, ITEM_REVISION_PK
, LEVEL_NAME
, NAME
, OPERATION_CODE
, ROW_ID
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, CREATION_DATE
, EFFECTIVE_DATE
, LAST_UPDATE_DATE
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, CATEGORY_ID
, CATEGORY_SET_ID
, ITEM_TYPE
FROM ENI.EDW_ITEM_ITEMREV_LSTG;
ENI.EDW_ITEM_ITEMREV_LSTG does not reference any database object
ENI.EDW_ITEM_ITEMREV_LSTG is referenced by following:
|
|
|