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_EQUIPMENT_DENORM_D#

Source

View Text - Preformatted


select DIMENSION_KEY DIMENSION_KEY, LEVEL1_LEVEL_KEY LEVEL1_LEVEL_KEY, LEVEL1_DESCRIPTION LEVEL1_DESCRIPTION, LEVEL1_HIERARCHY_KEY LEVEL1_HIERARCHY_KEY, LEVEL1_ID LEVEL1_ID, LEVEL2_HIERARCHY_KEY LEVEL2_HIERARCHY_KEY, LEVEL2_DESCRIPTION LEVEL2_DESCRIPTION, LEVEL2_EFFECTIVE_DATE LEVEL2_EFFECTIVE_DATE, LEVEL2_EXPIRATION_DATE LEVEL2_EXPIRATION_DATE, LEVEL2_ID LEVEL2_ID, LEVEL2_LEVEL_KEY LEVEL2_LEVEL_KEY, LEVEL2_PARENT_KEY LEVEL2_PARENT_KEY, LEVEL3_PARENT_KEY LEVEL3_PARENT_KEY, LEVEL3_DESCRIPTION LEVEL3_DESCRIPTION, LEVEL3_EFFECTIVE_DATE LEVEL3_EFFECTIVE_DATE, LEVEL3_LEVEL_KEY LEVEL3_LEVEL_KEY, LEVEL3_ID LEVEL3_ID, LEVEL3_HIERARCHY_KEY LEVEL3_HIERARCHY_KEY, LEVEL3_EXPIRATION_DATE LEVEL3_EXPIRATION_DATE, LEVEL4_EXPIRATION_DATE LEVEL4_EXPIRATION_DATE, LEVEL4_DESCRIPTION LEVEL4_DESCRIPTION, LEVEL4_LEVEL_KEY LEVEL4_LEVEL_KEY, LEVEL4_ID LEVEL4_ID, LEVEL4_HIERARCHY_KEY LEVEL4_HIERARCHY_KEY, LEVEL4_PARENT_KEY LEVEL4_PARENT_KEY, LEVEL4_EFFECTIVE_DATE LEVEL4_EFFECTIVE_DATE, LEVEL5_ID LEVEL5_ID, LEVEL5_LEVEL_KEY LEVEL5_LEVEL_KEY, LEVEL5_DESCRIPTION LEVEL5_DESCRIPTION, LEVEL5_EXPIRATION_DATE LEVEL5_EXPIRATION_DATE, LEVEL5_HIERARCHY_KEY LEVEL5_HIERARCHY_KEY, LEVEL5_PARENT_KEY LEVEL5_PARENT_KEY, LEVEL5_EFFECTIVE_DATE LEVEL5_EFFECTIVE_DATE, LEVEL6_DESCRIPTION LEVEL6_DESCRIPTION, LEVEL6_LEVEL_KEY LEVEL6_LEVEL_KEY, LEVEL6_PARENT_KEY LEVEL6_PARENT_KEY, LEVEL6_HIERARCHY_KEY LEVEL6_HIERARCHY_KEY, LEVEL6_ID LEVEL6_ID, LEVEL6_EFFECTIVE_DATE LEVEL6_EFFECTIVE_DATE, LEVEL6_EXPIRATION_DATE LEVEL6_EXPIRATION_DATE, LEVEL7_EFFECTIVE_DATE LEVEL7_EFFECTIVE_DATE, LEVEL7_PARENT_KEY LEVEL7_PARENT_KEY, LEVEL7_LEVEL_KEY LEVEL7_LEVEL_KEY, LEVEL7_DESCRIPTION LEVEL7_DESCRIPTION, LEVEL7_HIERARCHY_KEY LEVEL7_HIERARCHY_KEY, LEVEL7_EXPIRATION_DATE LEVEL7_EXPIRATION_DATE, LEVEL7_ID LEVEL7_ID, LEVEL8_HIERARCHY_KEY LEVEL8_HIERARCHY_KEY, LEVEL8_PARENT_KEY LEVEL8_PARENT_KEY, LEVEL8_DESCRIPTION LEVEL8_DESCRIPTION, LEVEL8_LEVEL_KEY LEVEL8_LEVEL_KEY, LEVEL8_ID LEVEL8_ID, LEVEL8_EXPIRATION_DATE LEVEL8_EXPIRATION_DATE, LEVEL8_EFFECTIVE_DATE LEVEL8_EFFECTIVE_DATE, LEVEL9_PARENT_KEY LEVEL9_PARENT_KEY, LEVEL9_ID LEVEL9_ID, LEVEL9_EXPIRATION_DATE LEVEL9_EXPIRATION_DATE, LEVEL9_EFFECTIVE_DATE LEVEL9_EFFECTIVE_DATE, LEVEL9_HIERARCHY_KEY LEVEL9_HIERARCHY_KEY, LEVEL9_LEVEL_KEY LEVEL9_LEVEL_KEY, LEVEL9_DESCRIPTION LEVEL9_DESCRIPTION, EQUIPMENT_FK_KEY EQUIPMENT_FK_KEY, EQUIPMENT_EXPIRATION_DATE EQUIPMENT_EXPIRATION_DATE, EQUIPMENT_HIERARCHY_KEY EQUIPMENT_HIERARCHY_KEY, EQUIPMENT_ID EQUIPMENT_ID, EQUIPMENT_PARENT_KEY EQUIPMENT_PARENT_KEY, EQUIPMENT_DESCRIPTION EQUIPMENT_DESCRIPTION, EQUIPMENT_EFFECTIVE_DATE EQUIPMENT_EFFECTIVE_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LEVEL1_LEVEL_NAME LEVEL1_LEVEL_NAME, LEVEL2_LEVEL_NAME LEVEL2_LEVEL_NAME, LEVEL3_LEVEL_NAME LEVEL3_LEVEL_NAME, LEVEL4_LEVEL_NAME LEVEL4_LEVEL_NAME, LEVEL5_LEVEL_NAME LEVEL5_LEVEL_NAME, LEVEL6_LEVEL_NAME LEVEL6_LEVEL_NAME, LEVEL7_LEVEL_NAME LEVEL7_LEVEL_NAME, LEVEL8_LEVEL_NAME LEVEL8_LEVEL_NAME, LEVEL9_LEVEL_NAME LEVEL9_LEVEL_NAME, EQUIPMENT_LEVEL_NAME EQUIPMENT_LEVEL_NAME, LEVEL_NUM LEVEL_NUM from "MTH"."MTH_EQUIPMENT_DENORM_D"

View Text - HTML Formatted

SELECT DIMENSION_KEY DIMENSION_KEY
, LEVEL1_LEVEL_KEY LEVEL1_LEVEL_KEY
, LEVEL1_DESCRIPTION LEVEL1_DESCRIPTION
, LEVEL1_HIERARCHY_KEY LEVEL1_HIERARCHY_KEY
, LEVEL1_ID LEVEL1_ID
, LEVEL2_HIERARCHY_KEY LEVEL2_HIERARCHY_KEY
, LEVEL2_DESCRIPTION LEVEL2_DESCRIPTION
, LEVEL2_EFFECTIVE_DATE LEVEL2_EFFECTIVE_DATE
, LEVEL2_EXPIRATION_DATE LEVEL2_EXPIRATION_DATE
, LEVEL2_ID LEVEL2_ID
, LEVEL2_LEVEL_KEY LEVEL2_LEVEL_KEY
, LEVEL2_PARENT_KEY LEVEL2_PARENT_KEY
, LEVEL3_PARENT_KEY LEVEL3_PARENT_KEY
, LEVEL3_DESCRIPTION LEVEL3_DESCRIPTION
, LEVEL3_EFFECTIVE_DATE LEVEL3_EFFECTIVE_DATE
, LEVEL3_LEVEL_KEY LEVEL3_LEVEL_KEY
, LEVEL3_ID LEVEL3_ID
, LEVEL3_HIERARCHY_KEY LEVEL3_HIERARCHY_KEY
, LEVEL3_EXPIRATION_DATE LEVEL3_EXPIRATION_DATE
, LEVEL4_EXPIRATION_DATE LEVEL4_EXPIRATION_DATE
, LEVEL4_DESCRIPTION LEVEL4_DESCRIPTION
, LEVEL4_LEVEL_KEY LEVEL4_LEVEL_KEY
, LEVEL4_ID LEVEL4_ID
, LEVEL4_HIERARCHY_KEY LEVEL4_HIERARCHY_KEY
, LEVEL4_PARENT_KEY LEVEL4_PARENT_KEY
, LEVEL4_EFFECTIVE_DATE LEVEL4_EFFECTIVE_DATE
, LEVEL5_ID LEVEL5_ID
, LEVEL5_LEVEL_KEY LEVEL5_LEVEL_KEY
, LEVEL5_DESCRIPTION LEVEL5_DESCRIPTION
, LEVEL5_EXPIRATION_DATE LEVEL5_EXPIRATION_DATE
, LEVEL5_HIERARCHY_KEY LEVEL5_HIERARCHY_KEY
, LEVEL5_PARENT_KEY LEVEL5_PARENT_KEY
, LEVEL5_EFFECTIVE_DATE LEVEL5_EFFECTIVE_DATE
, LEVEL6_DESCRIPTION LEVEL6_DESCRIPTION
, LEVEL6_LEVEL_KEY LEVEL6_LEVEL_KEY
, LEVEL6_PARENT_KEY LEVEL6_PARENT_KEY
, LEVEL6_HIERARCHY_KEY LEVEL6_HIERARCHY_KEY
, LEVEL6_ID LEVEL6_ID
, LEVEL6_EFFECTIVE_DATE LEVEL6_EFFECTIVE_DATE
, LEVEL6_EXPIRATION_DATE LEVEL6_EXPIRATION_DATE
, LEVEL7_EFFECTIVE_DATE LEVEL7_EFFECTIVE_DATE
, LEVEL7_PARENT_KEY LEVEL7_PARENT_KEY
, LEVEL7_LEVEL_KEY LEVEL7_LEVEL_KEY
, LEVEL7_DESCRIPTION LEVEL7_DESCRIPTION
, LEVEL7_HIERARCHY_KEY LEVEL7_HIERARCHY_KEY
, LEVEL7_EXPIRATION_DATE LEVEL7_EXPIRATION_DATE
, LEVEL7_ID LEVEL7_ID
, LEVEL8_HIERARCHY_KEY LEVEL8_HIERARCHY_KEY
, LEVEL8_PARENT_KEY LEVEL8_PARENT_KEY
, LEVEL8_DESCRIPTION LEVEL8_DESCRIPTION
, LEVEL8_LEVEL_KEY LEVEL8_LEVEL_KEY
, LEVEL8_ID LEVEL8_ID
, LEVEL8_EXPIRATION_DATE LEVEL8_EXPIRATION_DATE
, LEVEL8_EFFECTIVE_DATE LEVEL8_EFFECTIVE_DATE
, LEVEL9_PARENT_KEY LEVEL9_PARENT_KEY
, LEVEL9_ID LEVEL9_ID
, LEVEL9_EXPIRATION_DATE LEVEL9_EXPIRATION_DATE
, LEVEL9_EFFECTIVE_DATE LEVEL9_EFFECTIVE_DATE
, LEVEL9_HIERARCHY_KEY LEVEL9_HIERARCHY_KEY
, LEVEL9_LEVEL_KEY LEVEL9_LEVEL_KEY
, LEVEL9_DESCRIPTION LEVEL9_DESCRIPTION
, EQUIPMENT_FK_KEY EQUIPMENT_FK_KEY
, EQUIPMENT_EXPIRATION_DATE EQUIPMENT_EXPIRATION_DATE
, EQUIPMENT_HIERARCHY_KEY EQUIPMENT_HIERARCHY_KEY
, EQUIPMENT_ID EQUIPMENT_ID
, EQUIPMENT_PARENT_KEY EQUIPMENT_PARENT_KEY
, EQUIPMENT_DESCRIPTION EQUIPMENT_DESCRIPTION
, EQUIPMENT_EFFECTIVE_DATE EQUIPMENT_EFFECTIVE_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LEVEL1_LEVEL_NAME LEVEL1_LEVEL_NAME
, LEVEL2_LEVEL_NAME LEVEL2_LEVEL_NAME
, LEVEL3_LEVEL_NAME LEVEL3_LEVEL_NAME
, LEVEL4_LEVEL_NAME LEVEL4_LEVEL_NAME
, LEVEL5_LEVEL_NAME LEVEL5_LEVEL_NAME
, LEVEL6_LEVEL_NAME LEVEL6_LEVEL_NAME
, LEVEL7_LEVEL_NAME LEVEL7_LEVEL_NAME
, LEVEL8_LEVEL_NAME LEVEL8_LEVEL_NAME
, LEVEL9_LEVEL_NAME LEVEL9_LEVEL_NAME
, EQUIPMENT_LEVEL_NAME EQUIPMENT_LEVEL_NAME
, LEVEL_NUM LEVEL_NUM
FROM "MTH"."MTH_EQUIPMENT_DENORM_D"