[Home] [Help] [Dependency Information]
Object Name: | EDW_POA_SPIM_SPLRITEM_LSTG |
---|---|
Object Type: | TABLE |
Owner: | POA |
FND Design Data: | POA.EDW_POA_SPIM_SPLRITEM_LSTG |
Subobject Name: | |
Status: | VALID |
This is the interface table for the Supplier Item 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_SUMMARY |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_POA_SPIM_SPLRITEM_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | SUPPLIER_ITEM_PK |
EDW_POA_SPIM_SPLRITEM_LSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | COLLECTION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUPPLIER_ITEM_PK | VARCHAR2 | (480) | Unique identifier | |
ROW_ID | VARCHAR2 | (20) | Row identifier | |
ALL_FK | VARCHAR2 | (40) | Foreign key to top level of Supplier Item dimension | |
ALL_FK_KEY | NUMBER | System generated foreign key to top level of Supplier Item dimension | ||
SUPPLIER_SITE_ITEM_DP | VARCHAR2 | (480) | Unique supplier site item name | |
SUPPLIER_ITEM_DP | VARCHAR2 | (480) | Unique supplier item name | |
NAME | VARCHAR2 | (40) | Supplier item name | |
SUPPLIER_SITE_CODE | VARCHAR2 | (120) | Unique code assigned to supplier site by the source database application | |
SUPPLIER_NAME | VARCHAR2 | (480) | Supplier name | |
INSTANCE | VARCHAR2 | (40) | Source database instance for supplier item | |
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 | |
LAST_UPDATE_DATE | DATE | Standard Who Column | ||
CREATION_DATE | DATE | Standard Who Column | ||
REQUEST_ID | NUMBER | Identifier used by collection program | ||
OPERATION_CODE | VARCHAR2 | (30) | Code used by the loader program to determine whether to insert/update/delete this record | |
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
COLLECTION_STATUS | VARCHAR2 | (30) | Loading status code for the record (It refers to the status after the Load Engine attempts to move the record from the staging table to the level table. It does not refer to the movement of the data from the source to the staging table) |
Cut, paste (and edit) the following text to query this object:
SELECT SUPPLIER_ITEM_PK
, ROW_ID
, ALL_FK
, ALL_FK_KEY
, SUPPLIER_SITE_ITEM_DP
, SUPPLIER_ITEM_DP
, NAME
, SUPPLIER_SITE_CODE
, SUPPLIER_NAME
, INSTANCE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, LAST_UPDATE_DATE
, CREATION_DATE
, REQUEST_ID
, OPERATION_CODE
, ERROR_CODE
, COLLECTION_STATUS
FROM POA.EDW_POA_SPIM_SPLRITEM_LSTG;
POA.EDW_POA_SPIM_SPLRITEM_LSTG does not reference any database object
POA.EDW_POA_SPIM_SPLRITEM_LSTG is referenced by following:
|
|
|