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

TABLE: POA.EDW_UNSPSC_M

Object Details
Object Name: EDW_UNSPSC_M
Object Type: TABLE
Owner: POA
FND Design Data: TablePOA.EDW_UNSPSC_M
Subobject Name:
Status: VALID


This is the denormalized star table for the UNSPSC dimension. It contains records for the lowest level of the UNSPSC dimension and their parentage up to the top level, across all hierarchies.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 30
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EDW_UNSPSC_M_U1 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnFNCT_FUNCTION_PK
ColumnFNCT_FUNCTION_PK_KEY
EDW_UNSPSC_M_U2 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnFNCT_FUNCTION_PK_KEY
Columns
Name Datatype Length Mandatory Comments
SGMT_SEGMENT_PK_KEY NUMBER

System generated unique identier
FMLY_FAMILY_PK_KEY NUMBER

System generated unique identier
CLAS_CLASS_PK_KEY NUMBER

System generated unique identier
ALL_ALL_PK_KEY NUMBER

System generated unique identier
CMDT_COMMODITY_PK_KEY NUMBER

System generated unique identier
FNCT_FUNCTION_PK_KEY NUMBER
Yes System generated unique identier
SGMT_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
SGMT_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
SGMT_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
SGMT_SEGMENT_PK VARCHAR2 (40)
Unique identier for Segment
SGMT_SEGMENT_DP VARCHAR2 (120)
Unique name for Segment
SGMT_SEGMENT_CODE VARCHAR2 (40)
Segment code
SGMT_NAME VARCHAR2 (120)
Segment name
SGMT_INSTANCE VARCHAR2 (40)
Source database instance
FMLY_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
FMLY_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
FMLY_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
FMLY_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
FMLY_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
FMLY_NAME VARCHAR2 (120)
Family name
FMLY_INSTANCE VARCHAR2 (40)
Source database instance
FMLY_FAMILY_PK VARCHAR2 (40)
Unique identier for Family
FMLY_FAMILY_DP VARCHAR2 (120)
Unique Family name
FMLY_FAMILY_CODE VARCHAR2 (40)
Family code
CLAS_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
CLAS_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
CLAS_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
CLAS_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
CLAS_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
CLAS_NAME VARCHAR2 (120)
Classification name
CLAS_INSTANCE VARCHAR2 (40)
Source database instance
CLAS_CLASS_PK VARCHAR2 (40)
Unique identifier for Class
CLAS_CLASS_DP VARCHAR2 (120)
Unique name for Class
CLAS_CLASS_CODE VARCHAR2 (40)
Class code
CMDT_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
CMDT_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
CMDT_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
CMDT_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
CMDT_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
CMDT_UNSPSC_DESCRIPTION VARCHAR2 (120)
UNSPSC code description
CMDT_UNSPSC VARCHAR2 (40)
UNSPSC code
CMDT_NAME VARCHAR2 (120)
Commodity name
CMDT_INSTANCE VARCHAR2 (40)
Source database instance
CMDT_COMMODITY_PK VARCHAR2 (40)
Unique identifier for Commodity
CMDT_COMMODITY_DP VARCHAR2 (120)
Unique name for Commodity
ALL_NAME VARCHAR2 (80)
All name
ALL_ALL_PK VARCHAR2 (40)
Unique identifier for All
SGMT_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
SGMT_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
CMDT_COMMODITY_CODE VARCHAR2 (40)
Commodity code
FNCT_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
FNCT_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
FNCT_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
FNCT_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
FNCT_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
FNCT_NAME VARCHAR2 (120)
Function name
FNCT_INSTANCE VARCHAR2 (120)
Source database instance
FNCT_FUNCTION_PK VARCHAR2 (40)
Unique identifier for Function
FNCT_FUNCTION_DP VARCHAR2 (120)
Unique name for Function
FNCT_FUNCTION_CODE VARCHAR2 (40)
Function code
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
Query Text

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


SELECT SGMT_SEGMENT_PK_KEY
,      FMLY_FAMILY_PK_KEY
,      CLAS_CLASS_PK_KEY
,      ALL_ALL_PK_KEY
,      CMDT_COMMODITY_PK_KEY
,      FNCT_FUNCTION_PK_KEY
,      SGMT_USER_ATTRIBUTE3
,      SGMT_USER_ATTRIBUTE2
,      SGMT_USER_ATTRIBUTE1
,      SGMT_SEGMENT_PK
,      SGMT_SEGMENT_DP
,      SGMT_SEGMENT_CODE
,      SGMT_NAME
,      SGMT_INSTANCE
,      FMLY_USER_ATTRIBUTE5
,      FMLY_USER_ATTRIBUTE4
,      FMLY_USER_ATTRIBUTE3
,      FMLY_USER_ATTRIBUTE2
,      FMLY_USER_ATTRIBUTE1
,      FMLY_NAME
,      FMLY_INSTANCE
,      FMLY_FAMILY_PK
,      FMLY_FAMILY_DP
,      FMLY_FAMILY_CODE
,      CLAS_USER_ATTRIBUTE5
,      CLAS_USER_ATTRIBUTE4
,      CLAS_USER_ATTRIBUTE3
,      CLAS_USER_ATTRIBUTE2
,      CLAS_USER_ATTRIBUTE1
,      CLAS_NAME
,      CLAS_INSTANCE
,      CLAS_CLASS_PK
,      CLAS_CLASS_DP
,      CLAS_CLASS_CODE
,      CMDT_USER_ATTRIBUTE5
,      CMDT_USER_ATTRIBUTE4
,      CMDT_USER_ATTRIBUTE3
,      CMDT_USER_ATTRIBUTE2
,      CMDT_USER_ATTRIBUTE1
,      CMDT_UNSPSC_DESCRIPTION
,      CMDT_UNSPSC
,      CMDT_NAME
,      CMDT_INSTANCE
,      CMDT_COMMODITY_PK
,      CMDT_COMMODITY_DP
,      ALL_NAME
,      ALL_ALL_PK
,      SGMT_USER_ATTRIBUTE5
,      SGMT_USER_ATTRIBUTE4
,      CMDT_COMMODITY_CODE
,      FNCT_USER_ATTRIBUTE5
,      FNCT_USER_ATTRIBUTE4
,      FNCT_USER_ATTRIBUTE3
,      FNCT_USER_ATTRIBUTE2
,      FNCT_USER_ATTRIBUTE1
,      FNCT_NAME
,      FNCT_INSTANCE
,      FNCT_FUNCTION_PK
,      FNCT_FUNCTION_DP
,      FNCT_FUNCTION_CODE
,      CREATION_DATE
,      LAST_UPDATE_DATE
FROM POA.EDW_UNSPSC_M;

Dependencies

[top of page]

POA.EDW_UNSPSC_M does not reference any database object

POA.EDW_UNSPSC_M is referenced by following:

SchemaAPPS
SynonymEDW_UNSPSC_M