[Home] [Help] [Dependency Information]
Object Name: | EDW_ITEM_PROD_CATG_LSTG |
---|---|
Object Type: | TABLE |
Owner: | ENI |
Subobject Name: | |
Status: | VALID |
This is the interface table for the Product Category 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_PROD_CATG_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | PRODUCT_CATEG_PK |
EDW_ITEM_PROD_CATG_LSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | COLLECTION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRIMARY_CODE_ID | NUMBER | System generated unique identifier of the Product Category (Primary Interest Code) record in the source database | ||
PRODUCT_LINE_FK_KEY | NUMBER | System generated foreign key to the Product Line level | ||
REQUEST_ID | NUMBER | Identifier used by collection program | ||
COLLECTION_STATUS | VARCHAR2 | (40) | Collection status code for the record | |
DESCRIPTION | VARCHAR2 | (240) | Description of the Product Category (Primary Interest Code) | |
ENABLED_FLAG | VARCHAR2 | (20) | Enabled flag | |
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
INSTANCE_CODE | VARCHAR2 | (40) | Instance from which the record was collected | |
NAME | VARCHAR2 | (320) | Product category name | |
OPERATION_CODE | VARCHAR2 | (40) | Code used by collection program to determine whether to insert/update/delete this record | |
PRODUCT_CATEG_DP | VARCHAR2 | (240) | Not currently used | |
PRODUCT_CATEG_PK | VARCHAR2 | (240) | Unique identifier | |
PRODUCT_LINE_FK | VARCHAR2 | (240) | Foreign key to the product line 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 | ||
DELETION_DATE | DATE | Record deletion date | ||
LAST_UPDATE_DATE | DATE | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT PRIMARY_CODE_ID
, PRODUCT_LINE_FK_KEY
, REQUEST_ID
, COLLECTION_STATUS
, DESCRIPTION
, ENABLED_FLAG
, ERROR_CODE
, INSTANCE_CODE
, NAME
, OPERATION_CODE
, PRODUCT_CATEG_DP
, PRODUCT_CATEG_PK
, PRODUCT_LINE_FK
, ROW_ID
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, CREATION_DATE
, DELETION_DATE
, LAST_UPDATE_DATE
FROM ENI.EDW_ITEM_PROD_CATG_LSTG;
ENI.EDW_ITEM_PROD_CATG_LSTG does not reference any database object
ENI.EDW_ITEM_PROD_CATG_LSTG is referenced by following:
|
|
|