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

TABLE: MTH.MTH_ITEMS_ERR

Object Details
Object Name: MTH_ITEMS_ERR
Object Type: TABLE
Owner: MTH
FND Design Data: TableMTH.MTH_ITEMS_ERR
Subobject Name:
Status: VALID


Error table for MTH_ITEMS_D


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ITEM_PK VARCHAR2 (120) Yes Item identifier
SYSTEM_FK VARCHAR2 (120)
Reference to source system
SOURCE_ORG_CODE VARCHAR2 (120) Yes Organization code in source system
ITEM_NAME VARCHAR2 (240) Yes Item name
PRIMARY_UOM VARCHAR2 (5) Yes Primary unit of measure
SECONDARY_UOM VARCHAR2 (5)
Secondary unit of measure
EBS_ITEM_ID NUMBER

Oracle E-business suite item identifier
EBS_ORG_ID NUMBER

Oracle E-business suite organization identifier
DESCRIPTION VARCHAR2 (240)
Item description
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
REPROCESS_READY_YN VARCHAR2 (1)
Flag to indicate reprocessing of errored rows
BASE_ITEM VARCHAR2 (240)
Model number
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
ERR$$$_AUDIT_RUN_ID NUMBER (22)
Internal column
ERR$$$_AUDIT_DETAIL_ID NUMBER (22)
Internal column
ERR$$$_ERROR_ID NUMBER (22)
Internal column
ERR$$$_ERROR_REASON VARCHAR2 (2000)
Internal column
ERR$$$_SEVERITY VARCHAR2 (1)
Internal column
ERR$$$_OPERATOR_NAME VARCHAR2 (30)
Internal column
ERR$$$_ERROR_OBJECT_NAME VARCHAR2 (30)
Internal column
ERR_CODE VARCHAR2 (240)
Error code
USER_ATTR21 VARCHAR2 (240)
User-defined attribute
USER_ATTR22 VARCHAR2 (240)
User-defined attribute
USER_ATTR23 VARCHAR2 (240)
User-defined attribute
USER_ATTR24 VARCHAR2 (240)
User-defined attribute
USER_ATTR25 VARCHAR2 (240)
User-defined attribute
USER_ATTR26 VARCHAR2 (240)
User-defined attribute
USER_ATTR27 VARCHAR2 (240)
User-defined attribute
USER_ATTR28 VARCHAR2 (240)
User-defined attribute
USER_ATTR29 VARCHAR2 (240)
User-defined attribute
USER_ATTR30 VARCHAR2 (240)
User-defined attribute
Query Text

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


SELECT ITEM_PK
,      SYSTEM_FK
,      SOURCE_ORG_CODE
,      ITEM_NAME
,      PRIMARY_UOM
,      SECONDARY_UOM
,      EBS_ITEM_ID
,      EBS_ORG_ID
,      DESCRIPTION
,      UNIT_WEIGHT
,      WEIGHT_UOM
,      UNIT_VOLUME
,      VOLUME_UOM
,      REPROCESS_READY_YN
,      BASE_ITEM
,      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
,      ERR$$$_AUDIT_RUN_ID
,      ERR$$$_AUDIT_DETAIL_ID
,      ERR$$$_ERROR_ID
,      ERR$$$_ERROR_REASON
,      ERR$$$_SEVERITY
,      ERR$$$_OPERATOR_NAME
,      ERR$$$_ERROR_OBJECT_NAME
,      ERR_CODE
,      USER_ATTR21
,      USER_ATTR22
,      USER_ATTR23
,      USER_ATTR24
,      USER_ATTR25
,      USER_ATTR26
,      USER_ATTR27
,      USER_ATTR28
,      USER_ATTR29
,      USER_ATTR30
FROM MTH.MTH_ITEMS_ERR;

Dependencies

[top of page]

MTH.MTH_ITEMS_ERR does not reference any database object

MTH.MTH_ITEMS_ERR is referenced by following:

SchemaMTH
ViewMTH_ITEMS_ERR#