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

TABLE: MTH.MTH_EQUIPMENTS_ERR

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


Error table for MTH_EQUIPMENTS_D


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
EQUIPMENT_PK VARCHAR2 (120) Yes Equipment identifier
EBS_ORGANIZATION_ID NUMBER

Oracle E-business suite organization identifier
EBS_EQUIPMENT_ID NUMBER

Oracle E-business suite equipment identifier
SYSTEM_FK VARCHAR2 (120)
Reference to source system
USER_ATTR1 VARCHAR2 (150)
User-defined attribute
USER_ATTR2 VARCHAR2 (150)
User-defined attribute
USER_ATTR3 VARCHAR2 (150)
User-defined attribute
USER_ATTR4 VARCHAR2 (150)
User-defined attribute
USER_ATTR5 VARCHAR2 (150)
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
FIXED_ASSET_VALUE NUMBER

Fixed asset value
EQUIPMENT_NAME VARCHAR2 (100) Yes Equipment name
EQUIPMENT_DESCRIPTION VARCHAR2 (240)
Equipment description
REPROCESS_READY_YN VARCHAR2 (1)
Flag to indicate reprocessing of errored rows
SOURCE_ORG_CODE VARCHAR2 (120)
Organization code in source system
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
STD_UTILIZATION NUMBER

Standard utilization of equipment in percentage
STD_EFFICIENCY NUMBER

Standard efficiency of equipment in percentage
ERR_CODE VARCHAR2 (240)
Error code
EQUIPMENT_CRITICALITY VARCHAR2 (80)
Equipment criticality. Values - Critical, Non-Critical
SERIAL_NUMBER VARCHAR2 (30)
Serial number of production equipment that is linked to asset
PRODUCTION_EQUIPMENT VARCHAR2 (80)
Y - Production,N - Non-Production type
EQUIPMENT_MANUFACTURER VARCHAR2 (50)
Equipment manufacturer name
MODEL_NUMBER VARCHAR2 (100)
Manufacturer model number
INSTALLATION_DATE DATE

Date of installation of equipment
LAST_CALIBRATED DATE

Last calibration date
POWER_RATING NUMBER

Equipment Power Rating in KW
STANDARD_CAPACITY NUMBER

Standard throughput capacity
STD_CYCLE_TIME NUMBER

Standard Cycle Time in Hours
STATUS VARCHAR2 (80)
Indicate the status whether it is active or not
LOCATION VARCHAR2 (150)
Location of the equipment
Query Text

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


SELECT EQUIPMENT_PK
,      EBS_ORGANIZATION_ID
,      EBS_EQUIPMENT_ID
,      SYSTEM_FK
,      USER_ATTR1
,      USER_ATTR2
,      USER_ATTR3
,      USER_ATTR4
,      USER_ATTR5
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      FIXED_ASSET_VALUE
,      EQUIPMENT_NAME
,      EQUIPMENT_DESCRIPTION
,      REPROCESS_READY_YN
,      SOURCE_ORG_CODE
,      ERR$$$_AUDIT_RUN_ID
,      ERR$$$_AUDIT_DETAIL_ID
,      ERR$$$_ERROR_ID
,      ERR$$$_ERROR_REASON
,      ERR$$$_SEVERITY
,      ERR$$$_OPERATOR_NAME
,      ERR$$$_ERROR_OBJECT_NAME
,      STD_UTILIZATION
,      STD_EFFICIENCY
,      ERR_CODE
,      EQUIPMENT_CRITICALITY
,      SERIAL_NUMBER
,      PRODUCTION_EQUIPMENT
,      EQUIPMENT_MANUFACTURER
,      MODEL_NUMBER
,      INSTALLATION_DATE
,      LAST_CALIBRATED
,      POWER_RATING
,      STANDARD_CAPACITY
,      STD_CYCLE_TIME
,      STATUS
,      LOCATION
FROM MTH.MTH_EQUIPMENTS_ERR;

Dependencies

[top of page]

MTH.MTH_EQUIPMENTS_ERR does not reference any database object

MTH.MTH_EQUIPMENTS_ERR is referenced by following:

SchemaMTH
ViewMTH_EQUIPMENTS_ERR#