[Home] [Help] [Dependency Information]
Object Name: | EDW_UNSPSC_M_IV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
FNCT_FUNCTION_PK_KEY | NUMBER | Yes | ||
FNCT_FUNCTION_CODE | VARCHAR2 | (40) | ||
FNCT_FUNCTION_DP | VARCHAR2 | (120) | ||
FNCT_FUNCTION_PK | VARCHAR2 | (40) | ||
FNCT_INSTANCE | VARCHAR2 | (120) | ||
FNCT_NAME | VARCHAR2 | (120) | ||
FNCT_USER_ATTRIBUTE1 | VARCHAR2 | (240) | ||
FNCT_USER_ATTRIBUTE2 | VARCHAR2 | (240) | ||
FNCT_USER_ATTRIBUTE3 | VARCHAR2 | (240) | ||
FNCT_USER_ATTRIBUTE4 | VARCHAR2 | (240) | ||
FNCT_USER_ATTRIBUTE5 | VARCHAR2 | (240) | ||
CMDT_COMMODITY_PK_KEY | NUMBER | |||
CMDT_COMMODITY_CODE | VARCHAR2 | (40) | ||
SGMT_USER_ATTRIBUTE4 | VARCHAR2 | (240) | ||
SGMT_USER_ATTRIBUTE5 | VARCHAR2 | (240) | ||
ALL_ALL_PK_KEY | NUMBER | |||
ALL_ALL_PK | VARCHAR2 | (40) | ||
ALL_NAME | VARCHAR2 | (80) | ||
CMDT_COMMODITY_DP | VARCHAR2 | (120) | ||
CMDT_COMMODITY_PK | VARCHAR2 | (40) | ||
CMDT_INSTANCE | VARCHAR2 | (40) | ||
CMDT_NAME | VARCHAR2 | (120) | ||
CMDT_UNSPSC | VARCHAR2 | (40) | ||
CMDT_UNSPSC_DESCRIPTION | VARCHAR2 | (120) | ||
CMDT_USER_ATTRIBUTE1 | VARCHAR2 | (240) | ||
CMDT_USER_ATTRIBUTE2 | VARCHAR2 | (240) | ||
CMDT_USER_ATTRIBUTE3 | VARCHAR2 | (240) | ||
CMDT_USER_ATTRIBUTE4 | VARCHAR2 | (240) | ||
CMDT_USER_ATTRIBUTE5 | VARCHAR2 | (240) | ||
CLAS_CLASS_PK_KEY | NUMBER | |||
CLAS_CLASS_CODE | VARCHAR2 | (40) | ||
CLAS_CLASS_DP | VARCHAR2 | (120) | ||
CLAS_CLASS_PK | VARCHAR2 | (40) | ||
CLAS_INSTANCE | VARCHAR2 | (40) | ||
CLAS_NAME | VARCHAR2 | (120) | ||
CLAS_USER_ATTRIBUTE1 | VARCHAR2 | (240) | ||
CLAS_USER_ATTRIBUTE2 | VARCHAR2 | (240) | ||
CLAS_USER_ATTRIBUTE3 | VARCHAR2 | (240) | ||
CLAS_USER_ATTRIBUTE4 | VARCHAR2 | (240) | ||
CLAS_USER_ATTRIBUTE5 | VARCHAR2 | (240) | ||
FMLY_FAMILY_PK_KEY | NUMBER | |||
FMLY_FAMILY_CODE | VARCHAR2 | (40) | ||
FMLY_FAMILY_DP | VARCHAR2 | (120) | ||
FMLY_FAMILY_PK | VARCHAR2 | (40) | ||
FMLY_INSTANCE | VARCHAR2 | (40) | ||
FMLY_NAME | VARCHAR2 | (120) | ||
FMLY_USER_ATTRIBUTE1 | VARCHAR2 | (240) | ||
FMLY_USER_ATTRIBUTE2 | VARCHAR2 | (240) | ||
FMLY_USER_ATTRIBUTE3 | VARCHAR2 | (240) | ||
FMLY_USER_ATTRIBUTE4 | VARCHAR2 | (240) | ||
FMLY_USER_ATTRIBUTE5 | VARCHAR2 | (240) | ||
SGMT_SEGMENT_PK_KEY | NUMBER | |||
SGMT_INSTANCE | VARCHAR2 | (40) | ||
SGMT_NAME | VARCHAR2 | (120) | ||
SGMT_SEGMENT_CODE | VARCHAR2 | (40) | ||
SGMT_SEGMENT_DP | VARCHAR2 | (120) | ||
SGMT_SEGMENT_PK | VARCHAR2 | (40) | ||
SGMT_USER_ATTRIBUTE1 | VARCHAR2 | (240) | ||
SGMT_USER_ATTRIBUTE2 | VARCHAR2 | (240) | ||
SGMT_USER_ATTRIBUTE3 | VARCHAR2 | (240) | ||
OPERATION_CODE | VARCHAR2 | (40) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, FNCT_FUNCTION_PK_KEY
, FNCT_FUNCTION_CODE
, FNCT_FUNCTION_DP
, FNCT_FUNCTION_PK
, FNCT_INSTANCE
, FNCT_NAME
, FNCT_USER_ATTRIBUTE1
, FNCT_USER_ATTRIBUTE2
, FNCT_USER_ATTRIBUTE3
, FNCT_USER_ATTRIBUTE4
, FNCT_USER_ATTRIBUTE5
, CMDT_COMMODITY_PK_KEY
, CMDT_COMMODITY_CODE
, SGMT_USER_ATTRIBUTE4
, SGMT_USER_ATTRIBUTE5
, ALL_ALL_PK_KEY
, ALL_ALL_PK
, ALL_NAME
, CMDT_COMMODITY_DP
, CMDT_COMMODITY_PK
, CMDT_INSTANCE
, CMDT_NAME
, CMDT_UNSPSC
, CMDT_UNSPSC_DESCRIPTION
, CMDT_USER_ATTRIBUTE1
, CMDT_USER_ATTRIBUTE2
, CMDT_USER_ATTRIBUTE3
, CMDT_USER_ATTRIBUTE4
, CMDT_USER_ATTRIBUTE5
, CLAS_CLASS_PK_KEY
, CLAS_CLASS_CODE
, CLAS_CLASS_DP
, CLAS_CLASS_PK
, CLAS_INSTANCE
, CLAS_NAME
, CLAS_USER_ATTRIBUTE1
, CLAS_USER_ATTRIBUTE2
, CLAS_USER_ATTRIBUTE3
, CLAS_USER_ATTRIBUTE4
, CLAS_USER_ATTRIBUTE5
, FMLY_FAMILY_PK_KEY
, FMLY_FAMILY_CODE
, FMLY_FAMILY_DP
, FMLY_FAMILY_PK
, FMLY_INSTANCE
, FMLY_NAME
, FMLY_USER_ATTRIBUTE1
, FMLY_USER_ATTRIBUTE2
, FMLY_USER_ATTRIBUTE3
, FMLY_USER_ATTRIBUTE4
, FMLY_USER_ATTRIBUTE5
, SGMT_SEGMENT_PK_KEY
, SGMT_INSTANCE
, SGMT_NAME
, SGMT_SEGMENT_CODE
, SGMT_SEGMENT_DP
, SGMT_SEGMENT_PK
, SGMT_USER_ATTRIBUTE1
, SGMT_USER_ATTRIBUTE2
, SGMT_USER_ATTRIBUTE3
, OPERATION_CODE
FROM APPS.EDW_UNSPSC_M_IV;
APPS.EDW_UNSPSC_M_IV is not referenced by any database object
|
|
|