[Home] [Help]
[Dependency Information]
Object Name: | MTH_RESOURCES_D |
---|---|
Object Type: | TABLE |
Owner: | MTH |
FND Design Data: | ![]() |
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.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MTH_RESOURCES_D_U1 | NORMAL | UNIQUE |
![]() |
![]() |
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 |
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;
MTH.MTH_RESOURCES_D does not reference any database object
MTH.MTH_RESOURCES_D is referenced by following:
|
|
|