[Home] [Help] [Dependency Information]
Object Name: | MTH_ITEMS_D |
---|---|
Object Type: | TABLE |
Owner: | MTH |
FND Design Data: | MTH.MTH_ITEMS_D |
Subobject Name: | |
Status: | VALID |
This table stores information on items and its attributes. It holds information like Item name, Item description, Base item, Primary UOM, Secondary UOM, Unit weight, Weight UOM, Unit volume and Volume UOM.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MTH_ITEMS_D_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ITEM_PK |
MTH_ITEMS_D_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ITEM_NAME
ITEM_PK_KEY |
MTH_ITEMS_D_U3 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ITEM_PK_KEY
ITEM_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_PK_KEY | NUMBER | Yes | System generated surrogate key for item | |
ITEM_PK | VARCHAR2 | (120) | Yes | Item identifier |
PRIMARY_UOM | VARCHAR2 | (5) | Yes | Primary unit of measure |
PLANT_FK_KEY | NUMBER | Yes | Reference to plant | |
SYSTEM_FK_KEY | NUMBER | Yes | Reference to system | |
SECONDARY_UOM | VARCHAR2 | (5) | Secondary unit of measure | |
EBS_ITEM_ID | NUMBER | Oracle E-business suite item identifier | ||
EBS_ORGANIZATION_ID | NUMBER | Oracle E-business suite organization identifier | ||
UNIT_WEIGHT | NUMBER | Unit weight | ||
WEIGHT_UOM | VARCHAR2 | (5) | Weight unit of measure | |
UNIT_VOLUME | NUMBER | Unit volume | ||
VOLUME_UOM | VARCHAR2 | (5) | Volume unit of measure | |
ITEM_NAME | VARCHAR2 | (240) | Yes | Item name |
DESCRIPTION | VARCHAR2 | (240) | Item description | |
BASE_ITEM | VARCHAR2 | (240) | Model number | |
SOURCE_ORG_CODE | VARCHAR2 | (120) | Organization code in source system | |
USER_ATTR1 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR2 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR3 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR4 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR5 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR6 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR7 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR8 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR9 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR10 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR11 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR12 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR13 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR14 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR15 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR16 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR17 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR18 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR19 | VARCHAR2 | (240) | User-defined attribute | |
USER_ATTR20 | VARCHAR2 | (240) | User-defined attribute | |
USER_MEASURE1 | NUMBER | User-defined measure | ||
USER_MEASURE2 | NUMBER | User-defined measure | ||
USER_MEASURE3 | NUMBER | User-defined measure | ||
USER_MEASURE4 | NUMBER | User-defined measure | ||
USER_MEASURE5 | NUMBER | User-defined measure | ||
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
CREATION_SYSTEM_ID | NUMBER | Yes | Standard who column | |
LAST_UPDATE_SYSTEM_ID | NUMBER | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT ITEM_PK_KEY
, ITEM_PK
, PRIMARY_UOM
, PLANT_FK_KEY
, SYSTEM_FK_KEY
, SECONDARY_UOM
, EBS_ITEM_ID
, EBS_ORGANIZATION_ID
, UNIT_WEIGHT
, WEIGHT_UOM
, UNIT_VOLUME
, VOLUME_UOM
, ITEM_NAME
, DESCRIPTION
, BASE_ITEM
, SOURCE_ORG_CODE
, USER_ATTR1
, USER_ATTR2
, USER_ATTR3
, USER_ATTR4
, USER_ATTR5
, USER_ATTR6
, USER_ATTR7
, USER_ATTR8
, USER_ATTR9
, USER_ATTR10
, USER_ATTR11
, USER_ATTR12
, USER_ATTR13
, USER_ATTR14
, USER_ATTR15
, USER_ATTR16
, USER_ATTR17
, USER_ATTR18
, USER_ATTR19
, USER_ATTR20
, USER_MEASURE1
, USER_MEASURE2
, USER_MEASURE3
, USER_MEASURE4
, USER_MEASURE5
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATION_SYSTEM_ID
, LAST_UPDATE_SYSTEM_ID
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
FROM MTH.MTH_ITEMS_D;
MTH.MTH_ITEMS_D does not reference any database object
MTH.MTH_ITEMS_D is referenced by following:
|
|
|