VIEW: MTH.MTH_RESOURCES_I_STG#

Source

View Text - Preformatted

select RESOURCE_ID RESOURCE_ID, DEPARTMENT_ID DEPARTMENT_ID, ORGANIZATION_ID ORGANIZATION_ID, RESOURCE_TYPE RESOURCE_TYPE, USAGE_UOM USAGE_UOM, CAPACITY_UNITS CAPACITY_UNITS, AVAILABLE_24_HOUR_FLAG AVAILABLE_24_HOUR_FLAG, DISABLE_DATE DISABLE_DATE, RESOURCE_NAME RESOURCE_NAME, HUB_ORGANIZATION_CODE HUB_ORGANIZATION_CODE, DEPARTMENT_CODE DEPARTMENT_CODE, RESOURCE_GROUP_NAME RESOURCE_GROUP_NAME, DB_GLOBAL_NAME DB_GLOBAL_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, RES_DEPT_EFFECTIVE_DATE RES_DEPT_EFFECTIVE_DATE, RES_RESGRP_EFFECTIVE_DATE RES_RESGRP_EFFECTIVE_DATE, STD_EFFICIENCY STD_EFFICIENCY, STD_UTILIZATION STD_UTILIZATION from "MTH"."MTH_RESOURCES_I_STG"

View Text - HTML Formatted

SELECT RESOURCE_ID RESOURCE_ID
, DEPARTMENT_ID DEPARTMENT_ID
, ORGANIZATION_ID ORGANIZATION_ID
, RESOURCE_TYPE RESOURCE_TYPE
, USAGE_UOM USAGE_UOM
, CAPACITY_UNITS CAPACITY_UNITS
, AVAILABLE_24_HOUR_FLAG AVAILABLE_24_HOUR_FLAG
, DISABLE_DATE DISABLE_DATE
, RESOURCE_NAME RESOURCE_NAME
, HUB_ORGANIZATION_CODE HUB_ORGANIZATION_CODE
, DEPARTMENT_CODE DEPARTMENT_CODE
, RESOURCE_GROUP_NAME RESOURCE_GROUP_NAME
, DB_GLOBAL_NAME DB_GLOBAL_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
, RES_DEPT_EFFECTIVE_DATE RES_DEPT_EFFECTIVE_DATE
, RES_RESGRP_EFFECTIVE_DATE RES_RESGRP_EFFECTIVE_DATE
, STD_EFFICIENCY STD_EFFICIENCY
, STD_UTILIZATION STD_UTILIZATION
FROM "MTH"."MTH_RESOURCES_I_STG"