DBA Data[Home] [Help]

VIEW: BIM.BIM_R_LEAD_QU_BIN_MV#

Source

View Text - Preformatted

select GROUP_ID GROUP_ID, LEAD_STATUS LEAD_STATUS, OPEN_FLAG OPEN_FLAG, REGION REGION, COUNTRY COUNTRY, BUSINESS_UNIT_ID BUSINESS_UNIT_ID, YEAR YEAR, QTR QTR, MONTH MONTH, MONTH_ORDER MONTH_ORDER, AGGREGATE_BY AGGREGATE_BY, DISPLAY_TYPE DISPLAY_TYPE, CURR_A CURR_A, PREV_A PREV_A, CURR_B CURR_B, PREV_B PREV_B, CURR_C CURR_C, PREV_C PREV_C, CURR_D CURR_D, PREV_D PREV_D, CURR_E CURR_E, PREV_E PREV_E, CURR_F CURR_F, PREV_F PREV_F, CURR_G CURR_G, PREV_G PREV_G, CURR_H CURR_H, PREV_H PREV_H, CURR_I CURR_I, PREV_I PREV_I, CURR_J CURR_J, PREV_J PREV_J, CURR_OTHERS CURR_OTHERS, PREV_OTHERS PREV_OTHERS from "BIM"."BIM_R_LEAD_QU_BIN_MV"
View Text - HTML Formatted

SELECT GROUP_ID GROUP_ID
, LEAD_STATUS LEAD_STATUS
, OPEN_FLAG OPEN_FLAG
, REGION REGION
, COUNTRY COUNTRY
, BUSINESS_UNIT_ID BUSINESS_UNIT_ID
, YEAR YEAR
, QTR QTR
, MONTH MONTH
, MONTH_ORDER MONTH_ORDER
, AGGREGATE_BY AGGREGATE_BY
, DISPLAY_TYPE DISPLAY_TYPE
, CURR_A CURR_A
, PREV_A PREV_A
, CURR_B CURR_B
, PREV_B PREV_B
, CURR_C CURR_C
, PREV_C PREV_C
, CURR_D CURR_D
, PREV_D PREV_D
, CURR_E CURR_E
, PREV_E PREV_E
, CURR_F CURR_F
, PREV_F PREV_F
, CURR_G CURR_G
, PREV_G PREV_G
, CURR_H CURR_H
, PREV_H PREV_H
, CURR_I CURR_I
, PREV_I PREV_I
, CURR_J CURR_J
, PREV_J PREV_J
, CURR_OTHERS CURR_OTHERS
, PREV_OTHERS PREV_OTHERS
FROM "BIM"."BIM_R_LEAD_QU_BIN_MV"