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

TABLE: MTH.MTH_RESOURCES_ERR

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


Error table for MTH_RESOURCES_D


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
RESOURCE_PK VARCHAR2 (120) Yes Resource identifier
RESOURCE_TYPE VARCHAR2 (80) Yes Resource type, Machine or Person
EBS_RESOURCE_ID NUMBER

Oracle E-business Suite resource identifier
EBS_DEPARTMENT_ID NUMBER

Oracle E-business Suite department identifier
EBS_ORGANIZATION_ID NUMBER

Oracle E-business Suite organization identifier
USAGE_UOM VARCHAR2 (5)
Resource usage unit of measure
CAPACITY_UNITS NUMBER

Resource capacity
AVAILABLE_24_HOUR_FLAG VARCHAR2 (1)
Flag to indicate whether resource is 24 hour available or shift based
SYSTEM_FK VARCHAR2 (120)
Reference to source system
DISABLE_DATE DATE

Resource disabled date
RESOURCE_NAME VARCHAR2 (32) Yes Resource name
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_ATTR6 VARCHAR2 (150)
User-defined attribute
USER_ATTR7 VARCHAR2 (150)
User-defined attribute
USER_ATTR8 VARCHAR2 (150)
User-defined attribute
USER_ATTR9 VARCHAR2 (150)
User-defined attribute
USER_ATTR10 VARCHAR2 (150)
User-defined attribute
USER_ATTR11 VARCHAR2 (150)
User-defined attribute
USER_ATTR12 VARCHAR2 (150)
User-defined attribute
USER_ATTR13 VARCHAR2 (150)
User-defined attribute
USER_ATTR14 VARCHAR2 (150)
User-defined attribute
USER_ATTR15 VARCHAR2 (150)
User-defined attribute
USER_ATTR16 VARCHAR2 (150)
User-defined attribute
USER_ATTR17 VARCHAR2 (150)
User-defined attribute
USER_ATTR18 VARCHAR2 (150)
User-defined attribute
USER_ATTR19 VARCHAR2 (150)
User-defined attribute
USER_ATTR20 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
REPROCESS_READY_YN VARCHAR2 (1)
Flag to indicate reprocessing of errored rows
SOURCE_ORG_CODE VARCHAR2 (120)
Organization code in the source system
RESOURCE_DESCRIPTION VARCHAR2 (240)
Resource description
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 resource in percentage
STD_EFFICIENCY NUMBER

Standard efficiency of resource in percentage
ERR_CODE VARCHAR2 (240)
Error code
PRODUCTION_RESOURCE VARCHAR2 (80)
Y indicates production and N indicates Non-production
STATUS VARCHAR2 (80)
Indicate the status whether it is active or not
BUSINESS_FUNCTION VARCHAR2 (100)
Manufacturing, Administration, Planning, Purchasing, Stores, Maintenance, Sales
Query Text

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


SELECT RESOURCE_PK
,      RESOURCE_TYPE
,      EBS_RESOURCE_ID
,      EBS_DEPARTMENT_ID
,      EBS_ORGANIZATION_ID
,      USAGE_UOM
,      CAPACITY_UNITS
,      AVAILABLE_24_HOUR_FLAG
,      SYSTEM_FK
,      DISABLE_DATE
,      RESOURCE_NAME
,      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
,      REPROCESS_READY_YN
,      SOURCE_ORG_CODE
,      RESOURCE_DESCRIPTION
,      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
,      PRODUCTION_RESOURCE
,      STATUS
,      BUSINESS_FUNCTION
FROM MTH.MTH_RESOURCES_ERR;

Dependencies

[top of page]

MTH.MTH_RESOURCES_ERR does not reference any database object

MTH.MTH_RESOURCES_ERR is referenced by following:

SchemaMTH
ViewMTH_RESOURCES_ERR#