[Home] [Help] [Dependency Information]
Object Name: | EDW_POA_SPLRITEM_M |
---|---|
Object Type: | TABLE |
Owner: | POA |
FND Design Data: | POA.EDW_POA_SPLRITEM_M |
Subobject Name: | |
Status: | VALID |
This is the denormalized star table for the Supplier Item dimension. It contains records for the lowest level of the Supplier Item dimension and their parentage up to the top level, across all hierarchies.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 30 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_POA_SPLRITEM_M_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
SITM_SUPPLIER_ITEM_PK
SITM_SUPPLIER_ITEM_PK_KEY |
EDW_POA_SPLRITEM_M_U2 | NORMAL | UNIQUE | APPS_TS_SUMMARY | SITM_SUPPLIER_ITEM_PK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ALL_ALL_PK | VARCHAR2 | (40) | Unique identifier | |
ALL_ALL_PK_KEY | NUMBER | System generated unique identifier | ||
ALL_NAME | VARCHAR2 | (80) | All name | |
SITM_INSTANCE | VARCHAR2 | (40) | Source database instance for supplier item | |
SITM_NAME | VARCHAR2 | (40) | Supplier item name | |
SITM_SUPPLIER_ITEM_DP | VARCHAR2 | (120) | Unique supplier item name | |
SITM_SUPPLIER_ITEM_PK | VARCHAR2 | (480) | Unique identifier | |
SITM_SUPPLIER_ITEM_PK_KEY | NUMBER | Yes | System generated unique identifier | |
SITM_SUPPLIER_NAME | VARCHAR2 | (480) | Supplier name | |
SITM_SUPPLIER_SITE_CODE | VARCHAR2 | (120) | Unique code assigned to supplier site by the source database application | |
SITM_SUPPLIER_SITE_ITEM_DP | VARCHAR2 | (480) | Unique supplier site name | |
SITM_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
SITM_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
SITM_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
SITM_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
SITM_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT ALL_ALL_PK
, ALL_ALL_PK_KEY
, ALL_NAME
, SITM_INSTANCE
, SITM_NAME
, SITM_SUPPLIER_ITEM_DP
, SITM_SUPPLIER_ITEM_PK
, SITM_SUPPLIER_ITEM_PK_KEY
, SITM_SUPPLIER_NAME
, SITM_SUPPLIER_SITE_CODE
, SITM_SUPPLIER_SITE_ITEM_DP
, SITM_USER_ATTRIBUTE1
, SITM_USER_ATTRIBUTE2
, SITM_USER_ATTRIBUTE3
, SITM_USER_ATTRIBUTE4
, SITM_USER_ATTRIBUTE5
, CREATION_DATE
, LAST_UPDATE_DATE
FROM POA.EDW_POA_SPLRITEM_M;
POA.EDW_POA_SPLRITEM_M does not reference any database object
POA.EDW_POA_SPLRITEM_M is referenced by following:
|
|
|