VIEW: BIM.BIM_R_IRES_COLLECTION#

Source

View Text - Preformatted

select CAMPAIGN_REGION CAMPAIGN_REGION, CAMPAIGN_COUNTRY CAMPAIGN_COUNTRY, SCHEDULE_REGION SCHEDULE_REGION, SCHEDULE_COUNTRY SCHEDULE_COUNTRY, BUSINESS_UNIT_ID BUSINESS_UNIT_ID, CAMPAIGN_ID CAMPAIGN_ID, SCHEDULE_ACTIVITY_ID SCHEDULE_ACTIVITY_ID, YEAR YEAR, QTR QTR, MONTH MONTH, MONTH_ORDER MONTH_ORDER, AGGREGATE_BY AGGREGATE_BY, DISPLAY_TYPE DISPLAY_TYPE, REPORT_TYPE REPORT_TYPE, COST_CURR_PERIOD COST_CURR_PERIOD, CURRENT_PR_COUNT CURRENT_PR_COUNT, CURRENT_PR_ADDED CURRENT_PR_ADDED, PREVIOUS_PR_COUNT PREVIOUS_PR_COUNT, PREVIOUS_PR_ADDED PREVIOUS_PR_ADDED, CURRENT_CONVERTED CURRENT_CONVERTED, PREVIOUS_CONVERTED PREVIOUS_CONVERTED, CAMPAIGN_COUNT CAMPAIGN_COUNT, FORECASTED_RESPONSES FORECASTED_RESPONSES, TARGETED_CUSTOMERS TARGETED_CUSTOMERS from "BIM"."BIM_R_IRES_COLLECTION"

View Text - HTML Formatted

SELECT CAMPAIGN_REGION CAMPAIGN_REGION
, CAMPAIGN_COUNTRY CAMPAIGN_COUNTRY
, SCHEDULE_REGION SCHEDULE_REGION
, SCHEDULE_COUNTRY SCHEDULE_COUNTRY
, BUSINESS_UNIT_ID BUSINESS_UNIT_ID
, CAMPAIGN_ID CAMPAIGN_ID
, SCHEDULE_ACTIVITY_ID SCHEDULE_ACTIVITY_ID
, YEAR YEAR
, QTR QTR
, MONTH MONTH
, MONTH_ORDER MONTH_ORDER
, AGGREGATE_BY AGGREGATE_BY
, DISPLAY_TYPE DISPLAY_TYPE
, REPORT_TYPE REPORT_TYPE
, COST_CURR_PERIOD COST_CURR_PERIOD
, CURRENT_PR_COUNT CURRENT_PR_COUNT
, CURRENT_PR_ADDED CURRENT_PR_ADDED
, PREVIOUS_PR_COUNT PREVIOUS_PR_COUNT
, PREVIOUS_PR_ADDED PREVIOUS_PR_ADDED
, CURRENT_CONVERTED CURRENT_CONVERTED
, PREVIOUS_CONVERTED PREVIOUS_CONVERTED
, CAMPAIGN_COUNT CAMPAIGN_COUNT
, FORECASTED_RESPONSES FORECASTED_RESPONSES
, TARGETED_CUSTOMERS TARGETED_CUSTOMERS
FROM "BIM"."BIM_R_IRES_COLLECTION"