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

TABLE: ENI.EDW_ITEM_ITEM_LSTG

Object Details
Object Name: EDW_ITEM_ITEM_LSTG
Object Type: TABLE
Owner: ENI
Subobject Name:
Status: VALID


This is the interface table for Item level table. Data from multiple transactional systems is staged here for verification and cleansing, before loading it into the dimension level table.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 30
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EDW_ITEM_ITEM_LSTG_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnITEM_NUMBER_PK
EDW_ITEM_ITEM_LSTG_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnCOLLECTION_STATUS
Columns
Name Datatype Length Mandatory Comments
CATSET1_CATEGORY_FK_KEY NUMBER

System generated foreign key to the first category level in the first item category hierarchy
CATSET2_CATEGORY_FK_KEY NUMBER

System generated foreign key to the first category level in the second item category hierarchy
CATSET3_CATEGORY_FK_KEY NUMBER

System generated foreign key to the first category level in the second item category hierarchy
PRODUCT_GROUP_FK_KEY NUMBER

System generated foreign key to the product group level
REQUEST_ID NUMBER

Standard Who column
COLLECTION_STATUS VARCHAR2 (30)
Collection status code for the record
CATSET1_CATEGORY_FK VARCHAR2 (240)
Foreign key to the first category level in the first item category hierarchy
DESCRIPTION VARCHAR2 (240)
Item Description
CATSET2_CATEGORY_FK VARCHAR2 (240)
Foreign key to the first category level in the second item category hierarchy
ERROR_CODE VARCHAR2 (2000)
Error code
INSTANCE VARCHAR2 (40)
Instance from which the record was collected
CATSET3_CATEGORY_FK VARCHAR2 (240)
Foreign key to the first category level in the third item category hierarchy
ITEM_NAME VARCHAR2 (240)
Item name
ITEM_NUMBER_DP VARCHAR2 (240)
Not currently used
ITEM_NUMBER_PK VARCHAR2 (1000)
Unique identifier
NAME VARCHAR2 (320)
Name
ONE_TIME_FLAG VARCHAR2 (10)
One time flag
OPERATION_CODE VARCHAR2 (30)
Operation code
PRODUCT_GROUP_FK VARCHAR2 (240)
Foreign key to the product group level
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
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
Query Text

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


SELECT CATSET1_CATEGORY_FK_KEY
,      CATSET2_CATEGORY_FK_KEY
,      CATSET3_CATEGORY_FK_KEY
,      PRODUCT_GROUP_FK_KEY
,      REQUEST_ID
,      COLLECTION_STATUS
,      CATSET1_CATEGORY_FK
,      DESCRIPTION
,      CATSET2_CATEGORY_FK
,      ERROR_CODE
,      INSTANCE
,      CATSET3_CATEGORY_FK
,      ITEM_NAME
,      ITEM_NUMBER_DP
,      ITEM_NUMBER_PK
,      NAME
,      ONE_TIME_FLAG
,      OPERATION_CODE
,      PRODUCT_GROUP_FK
,      ROW_ID
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      CATEGORY_ID
,      CATEGORY_SET_ID
,      ITEM_TYPE
FROM ENI.EDW_ITEM_ITEM_LSTG;

Dependencies

[top of page]

ENI.EDW_ITEM_ITEM_LSTG does not reference any database object

ENI.EDW_ITEM_ITEM_LSTG is referenced by following:

SchemaAPPS
SynonymEDW_ITEM_ITEM_LSTG