eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: MTH.MTH_RESOURCES_STG#

Source

View Text - Preformatted


select RESOURCE_PK RESOURCE_PK, RESOURCE_TYPE RESOURCE_TYPE, EBS_RESOURCE_ID EBS_RESOURCE_ID, EBS_DEPARTMENT_ID EBS_DEPARTMENT_ID, EBS_ORGANIZATION_ID EBS_ORGANIZATION_ID, USAGE_UOM USAGE_UOM, CAPACITY_UNITS CAPACITY_UNITS, AVAILABLE_24_HOUR_FLAG AVAILABLE_24_HOUR_FLAG, SYSTEM_FK SYSTEM_FK, DISABLE_DATE DISABLE_DATE, RESOURCE_NAME RESOURCE_NAME, USER_ATTR1 USER_ATTR1, USER_ATTR2 USER_ATTR2, USER_ATTR3 USER_ATTR3, USER_ATTR4 USER_ATTR4, USER_ATTR5 USER_ATTR5, USER_ATTR6 USER_ATTR6, USER_ATTR7 USER_ATTR7, USER_ATTR8 USER_ATTR8, USER_ATTR9 USER_ATTR9, USER_ATTR10 USER_ATTR10, USER_ATTR11 USER_ATTR11, USER_ATTR12 USER_ATTR12, USER_ATTR13 USER_ATTR13, USER_ATTR14 USER_ATTR14, USER_ATTR15 USER_ATTR15, USER_ATTR16 USER_ATTR16, USER_ATTR17 USER_ATTR17, USER_ATTR18 USER_ATTR18, USER_ATTR19 USER_ATTR19, USER_ATTR20 USER_ATTR20, USER_MEASURE1 USER_MEASURE1, USER_MEASURE2 USER_MEASURE2, USER_MEASURE3 USER_MEASURE3, USER_MEASURE4 USER_MEASURE4, USER_MEASURE5 USER_MEASURE5, SOURCE_ORG_CODE SOURCE_ORG_CODE, RESOURCE_DESCRIPTION RESOURCE_DESCRIPTION, STD_UTILIZATION STD_UTILIZATION, STD_EFFICIENCY STD_EFFICIENCY, PROCESSING_FLAG PROCESSING_FLAG, PRODUCTION_RESOURCE PRODUCTION_RESOURCE, BUSINESS_FUNCTION BUSINESS_FUNCTION, STATUS STATUS from "MTH"."MTH_RESOURCES_STG"

View Text - HTML Formatted

SELECT RESOURCE_PK RESOURCE_PK
, RESOURCE_TYPE RESOURCE_TYPE
, EBS_RESOURCE_ID EBS_RESOURCE_ID
, EBS_DEPARTMENT_ID EBS_DEPARTMENT_ID
, EBS_ORGANIZATION_ID EBS_ORGANIZATION_ID
, USAGE_UOM USAGE_UOM
, CAPACITY_UNITS CAPACITY_UNITS
, AVAILABLE_24_HOUR_FLAG AVAILABLE_24_HOUR_FLAG
, SYSTEM_FK SYSTEM_FK
, DISABLE_DATE DISABLE_DATE
, RESOURCE_NAME RESOURCE_NAME
, USER_ATTR1 USER_ATTR1
, USER_ATTR2 USER_ATTR2
, USER_ATTR3 USER_ATTR3
, USER_ATTR4 USER_ATTR4
, USER_ATTR5 USER_ATTR5
, USER_ATTR6 USER_ATTR6
, USER_ATTR7 USER_ATTR7
, USER_ATTR8 USER_ATTR8
, USER_ATTR9 USER_ATTR9
, USER_ATTR10 USER_ATTR10
, USER_ATTR11 USER_ATTR11
, USER_ATTR12 USER_ATTR12
, USER_ATTR13 USER_ATTR13
, USER_ATTR14 USER_ATTR14
, USER_ATTR15 USER_ATTR15
, USER_ATTR16 USER_ATTR16
, USER_ATTR17 USER_ATTR17
, USER_ATTR18 USER_ATTR18
, USER_ATTR19 USER_ATTR19
, USER_ATTR20 USER_ATTR20
, USER_MEASURE1 USER_MEASURE1
, USER_MEASURE2 USER_MEASURE2
, USER_MEASURE3 USER_MEASURE3
, USER_MEASURE4 USER_MEASURE4
, USER_MEASURE5 USER_MEASURE5
, SOURCE_ORG_CODE SOURCE_ORG_CODE
, RESOURCE_DESCRIPTION RESOURCE_DESCRIPTION
, STD_UTILIZATION STD_UTILIZATION
, STD_EFFICIENCY STD_EFFICIENCY
, PROCESSING_FLAG PROCESSING_FLAG
, PRODUCTION_RESOURCE PRODUCTION_RESOURCE
, BUSINESS_FUNCTION BUSINESS_FUNCTION
, STATUS STATUS
FROM "MTH"."MTH_RESOURCES_STG"