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


TABLE: MTH.MTH_RESOURCES_D

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


This table stores information about resources. It holds information like Resource name, Resource description, Resource type, Usage UOM, Resource capacity, whether the resource is available for 24 hours or shift based, Disable date, Department and Organization.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTH_RESOURCES_D_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESOURCE_PK
Columns
Name Datatype Length Mandatory Comments
RESOURCE_PK_KEY NUMBER
Yes System generated surrogate key for resource
RESOURCE_PK VARCHAR2 (120) Yes Resource identifier
RESOURCE_TYPE NUMBER
Yes Resource type
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_UNIT NUMBER

Resource capacity
AVAILABLE_24_HOUR_FLAG NUMBER

Flag to indicate whether resource is 24 hour available or shift based
PLANT_FK_KEY NUMBER
Yes Reference to plant
SOURCE_ORG_CODE VARCHAR2 (120)
Organization code in the source system
SYSTEM_FK_KEY NUMBER
Yes Reference to system
DISABLE_DATE DATE

Resource disabled date
RESOURCE_NAME VARCHAR2 (32) Yes Resource name
RESOURCE_DESCRIPTION VARCHAR2 (240)
Resource description
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
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
STD_UTILIZATION NUMBER

Standard utilization of resource in percentage
STD_EFFICIENCY NUMBER

Standard efficiency of resource in percentage
Query Text

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


SELECT RESOURCE_PK_KEY
,      RESOURCE_PK
,      RESOURCE_TYPE
,      EBS_RESOURCE_ID
,      EBS_DEPARTMENT_ID
,      EBS_ORGANIZATION_ID
,      USAGE_UOM
,      CAPACITY_UNIT
,      AVAILABLE_24_HOUR_FLAG
,      PLANT_FK_KEY
,      SOURCE_ORG_CODE
,      SYSTEM_FK_KEY
,      DISABLE_DATE
,      RESOURCE_NAME
,      RESOURCE_DESCRIPTION
,      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
,      STD_UTILIZATION
,      STD_EFFICIENCY
FROM MTH.MTH_RESOURCES_D;

Dependencies

[top of page]

MTH.MTH_RESOURCES_D does not reference any database object

MTH.MTH_RESOURCES_D is referenced by following:

SchemaAPPS
SynonymMTH_RESOURCES_D