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

VIEW: MTH.MTH_RESOURCES_D#

Object Details
Object Name: MTH_RESOURCES_D#
Object Type: VIEW
Owner: MTH
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
RESOURCE_PK_KEY NUMBER
Yes
RESOURCE_PK VARCHAR2 (120) Yes
RESOURCE_TYPE VARCHAR2 (30) Yes
EBS_RESOURCE_ID NUMBER

EBS_DEPARTMENT_ID NUMBER

EBS_ORGANIZATION_ID NUMBER

USAGE_UOM VARCHAR2 (5)
CAPACITY_UNIT NUMBER

AVAILABLE_24_HOUR_FLAG VARCHAR2 (1)
PLANT_FK_KEY NUMBER
Yes
SOURCE_ORG_CODE VARCHAR2 (120)
SYSTEM_FK_KEY NUMBER
Yes
DISABLE_DATE DATE

RESOURCE_NAME VARCHAR2 (32) Yes
RESOURCE_DESCRIPTION VARCHAR2 (240)
USER_ATTR1 VARCHAR2 (150)
USER_ATTR2 VARCHAR2 (150)
USER_ATTR3 VARCHAR2 (150)
USER_ATTR4 VARCHAR2 (150)
USER_ATTR5 VARCHAR2 (150)
USER_ATTR6 VARCHAR2 (150)
USER_ATTR7 VARCHAR2 (150)
USER_ATTR8 VARCHAR2 (150)
USER_ATTR9 VARCHAR2 (150)
USER_ATTR10 VARCHAR2 (150)
USER_ATTR11 VARCHAR2 (150)
USER_ATTR12 VARCHAR2 (150)
USER_ATTR13 VARCHAR2 (150)
USER_ATTR14 VARCHAR2 (150)
USER_ATTR15 VARCHAR2 (150)
USER_ATTR16 VARCHAR2 (150)
USER_ATTR17 VARCHAR2 (150)
USER_ATTR18 VARCHAR2 (150)
USER_ATTR19 VARCHAR2 (150)
USER_ATTR20 VARCHAR2 (150)
USER_MEASURE1 NUMBER

USER_MEASURE2 NUMBER

USER_MEASURE3 NUMBER

USER_MEASURE4 NUMBER

USER_MEASURE5 NUMBER

CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
CREATION_SYSTEM_ID NUMBER
Yes
LAST_UPDATE_SYSTEM_ID NUMBER
Yes
CREATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATED_BY NUMBER (15)
STD_UTILIZATION NUMBER

STD_EFFICIENCY NUMBER

PRODUCTION_RESOURCE VARCHAR2 (1)
STATUS VARCHAR2 (30)
BUSINESS_FUNCTION VARCHAR2 (100)
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
,      PRODUCTION_RESOURCE
,      STATUS
,      BUSINESS_FUNCTION
FROM MTH.MTH_RESOURCES_D#;

Dependencies

[top of page]

MTH.MTH_RESOURCES_D# references the following:

SchemaMTH
TableMTH_RESOURCES_D
MTH.MTH_RESOURCES_D# is referenced by following:

SchemaAPPS
SynonymMTH_RESOURCES_D