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.

VIEW: BIM.BIM_R_LEAD_AGE_SUM_MV#

Source

View Text - Preformatted


select GROUP_ID GROUP_ID, GROUP_NAME GROUP_NAME, AGE_0_TO_1 AGE_0_TO_1, AGE_2_TO_3 AGE_2_TO_3, AGE_3_TO_7 AGE_3_TO_7, AGE_8_TO_14 AGE_8_TO_14, AGE_15_TO_21 AGE_15_TO_21, AGE_22_TO_28 AGE_22_TO_28, AGE_29_TO_35 AGE_29_TO_35, AGE_36_TO_42 AGE_36_TO_42, AGE_43_TO_ABOVE AGE_43_TO_ABOVE, SAGE_0_TO_1 SAGE_0_TO_1, SAGE_2_TO_3 SAGE_2_TO_3, SAGE_3_TO_7 SAGE_3_TO_7, SAGE_8_TO_14 SAGE_8_TO_14, SAGE_15_TO_21 SAGE_15_TO_21, SAGE_22_TO_28 SAGE_22_TO_28, SAGE_29_TO_35 SAGE_29_TO_35, SAGE_36_TO_42 SAGE_36_TO_42, SAGE_43_TO_ABOVE SAGE_43_TO_ABOVE from "BIM"."BIM_R_LEAD_AGE_SUM_MV"

View Text - HTML Formatted

SELECT GROUP_ID GROUP_ID
, GROUP_NAME GROUP_NAME
, AGE_0_TO_1 AGE_0_TO_1
, AGE_2_TO_3 AGE_2_TO_3
, AGE_3_TO_7 AGE_3_TO_7
, AGE_8_TO_14 AGE_8_TO_14
, AGE_15_TO_21 AGE_15_TO_21
, AGE_22_TO_28 AGE_22_TO_28
, AGE_29_TO_35 AGE_29_TO_35
, AGE_36_TO_42 AGE_36_TO_42
, AGE_43_TO_ABOVE AGE_43_TO_ABOVE
, SAGE_0_TO_1 SAGE_0_TO_1
, SAGE_2_TO_3 SAGE_2_TO_3
, SAGE_3_TO_7 SAGE_3_TO_7
, SAGE_8_TO_14 SAGE_8_TO_14
, SAGE_15_TO_21 SAGE_15_TO_21
, SAGE_22_TO_28 SAGE_22_TO_28
, SAGE_29_TO_35 SAGE_29_TO_35
, SAGE_36_TO_42 SAGE_36_TO_42
, SAGE_43_TO_ABOVE SAGE_43_TO_ABOVE
FROM "BIM"."BIM_R_LEAD_AGE_SUM_MV"