VIEW: BIM.BIM_R_EVEN_LIS_MV#

Source

View Text - Preformatted

select EVENT_HEADER_ID EVENT_HEADER_ID, EVENT_NAME EVENT_NAME, EVENT_OFFER_ID EVENT_OFFER_ID, SOURCE_CODE SOURCE_CODE, START_DATE START_DATE, END_DATE END_DATE, EVENT_HEADER_AREA1 EVENT_HEADER_AREA1, EVENT_HEADER_AREA2 EVENT_HEADER_AREA2, EVENT_COUNTRY EVENT_COUNTRY, EVENT_TYPE EVENT_TYPE, EVENT_OFFER_TYPE EVENT_OFFER_TYPE, BUSINESS_UNIT_ID BUSINESS_UNIT_ID, STATUS STATUS, EVENT_VENUE_ID EVENT_VENUE_ID, MONTH MONTH, QTR QTR, YEAR YEAR, REGISTRATIONS REGISTRATIONS, CANCELLATIONS CANCELLATIONS, LEADS_OPEN LEADS_OPEN, LEADS_OPEN_AMT LEADS_OPEN_AMT, LEADS_CLOSED LEADS_CLOSED, LEADS_CLOSED_AMT LEADS_CLOSED_AMT, OPPORTUNITIES OPPORTUNITIES, OPPORTUNITY_AMT OPPORTUNITY_AMT, ATTENDANCE ATTENDANCE, FORECASTED_COST FORECASTED_COST, FORECASTED_REVENUE FORECASTED_REVENUE, ACTUAL_COST ACTUAL_COST, REVENUE REVENUE, ORDER_AMT ORDER_AMT, BUDGET_REQUESTED BUDGET_REQUESTED, BUDGET_APPROVED BUDGET_APPROVED from "BIM"."BIM_R_EVEN_LIS_MV"

View Text - HTML Formatted

SELECT EVENT_HEADER_ID EVENT_HEADER_ID
, EVENT_NAME EVENT_NAME
, EVENT_OFFER_ID EVENT_OFFER_ID
, SOURCE_CODE SOURCE_CODE
, START_DATE START_DATE
, END_DATE END_DATE
, EVENT_HEADER_AREA1 EVENT_HEADER_AREA1
, EVENT_HEADER_AREA2 EVENT_HEADER_AREA2
, EVENT_COUNTRY EVENT_COUNTRY
, EVENT_TYPE EVENT_TYPE
, EVENT_OFFER_TYPE EVENT_OFFER_TYPE
, BUSINESS_UNIT_ID BUSINESS_UNIT_ID
, STATUS STATUS
, EVENT_VENUE_ID EVENT_VENUE_ID
, MONTH MONTH
, QTR QTR
, YEAR YEAR
, REGISTRATIONS REGISTRATIONS
, CANCELLATIONS CANCELLATIONS
, LEADS_OPEN LEADS_OPEN
, LEADS_OPEN_AMT LEADS_OPEN_AMT
, LEADS_CLOSED LEADS_CLOSED
, LEADS_CLOSED_AMT LEADS_CLOSED_AMT
, OPPORTUNITIES OPPORTUNITIES
, OPPORTUNITY_AMT OPPORTUNITY_AMT
, ATTENDANCE ATTENDANCE
, FORECASTED_COST FORECASTED_COST
, FORECASTED_REVENUE FORECASTED_REVENUE
, ACTUAL_COST ACTUAL_COST
, REVENUE REVENUE
, ORDER_AMT ORDER_AMT
, BUDGET_REQUESTED BUDGET_REQUESTED
, BUDGET_APPROVED BUDGET_APPROVED
FROM "BIM"."BIM_R_EVEN_LIS_MV"