VIEW: BIM.BIM_R_EVEN_LOAD#

Source

View Text - Preformatted

select EVENT_DAILY_TRANSACTION_ID EVENT_DAILY_TRANSACTION_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, EVENT_HEADER_ID EVENT_HEADER_ID, EVENT_OFFER_ID EVENT_OFFER_ID, PARENT_ID PARENT_ID, EVENT_TYPE EVENT_TYPE, EVENT_OFFER_TYPE EVENT_OFFER_TYPE, HDR_SOURCE_CODE HDR_SOURCE_CODE, SOURCE_CODE SOURCE_CODE, BUSINESS_UNIT_ID BUSINESS_UNIT_ID, COUNTRY COUNTRY, STATUS STATUS, EVENT_BUDGET_AMT_FC EVENT_BUDGET_AMT_FC, OFFER_BUDGET_AMT_FC OFFER_BUDGET_AMT_FC, START_DATE START_DATE, END_DATE END_DATE, EVENT_VENUE_ID EVENT_VENUE_ID, REGISTRATIONS REGISTRATIONS, CANCELLATIONS CANCELLATIONS, LEADS_QUALIFIED LEADS_QUALIFIED, LEADS_QUALIFIED_AMT LEADS_QUALIFIED_AMT, LEADS_UNQUALIFIED LEADS_UNQUALIFIED, LEADS_UNQUALIFIED_AMT LEADS_UNQUALIFIED_AMT, OPPORTUNITIES OPPORTUNITIES, OPPORTUNITY_AMT OPPORTUNITY_AMT, ATTENDANCE ATTENDANCE, FORECASTED_COST FORECASTED_COST, ACTUAL_COST ACTUAL_COST, REVENUE REVENUE, ORDER_AMT ORDER_AMT, BUDGET_REQUESTED BUDGET_REQUESTED, BUDGET_APPROVED BUDGET_APPROVED, CUSTOMER CUSTOMER, CURRENCY_CODE CURRENCY_CODE, TRANSACTION_CREATE_DATE TRANSACTION_CREATE_DATE, ASSOCIATED_OBJECT_TYPE ASSOCIATED_OBJECT_TYPE, ASSOCIATED_OBJECT_ID ASSOCIATED_OBJECT_ID, DELETE_FLAG DELETE_FLAG, SECURITY_GROUP_CODE SECURITY_GROUP_CODE, SECURITY_GROUP_ID SECURITY_GROUP_ID, LOAD_DATE LOAD_DATE, ORG_ID ORG_ID, MONTH MONTH, QTR QTR, YEAR YEAR, ACTUAL_REVENUE ACTUAL_REVENUE, FORECASTED_REVENUE FORECASTED_REVENUE, BOOKED_ORDERS BOOKED_ORDERS, BOOKED_ORDERS_AMT BOOKED_ORDERS_AMT, LEADS_OPEN LEADS_OPEN, LEADS_OPEN_AMT LEADS_OPEN_AMT, LEADS_CLOSED LEADS_CLOSED, LEADS_CLOSED_AMT LEADS_CLOSED_AMT, LEADS_NEW LEADS_NEW, LEADS_NEW_AMT LEADS_NEW_AMT, LEADS_HOT LEADS_HOT, LEADS_CONVERTED LEADS_CONVERTED, METRIC1 METRIC1, METRIC2 METRIC2, METRIC3 METRIC3, METRIC4 METRIC4, METRIC5 METRIC5, METRIC6 METRIC6, METRIC7 METRIC7, METRIC8 METRIC8, METRIC9 METRIC9, METRIC10 METRIC10, METRIC11 METRIC11, METRIC12 METRIC12, METRIC13 METRIC13, METRIC14 METRIC14, METRIC15 METRIC15 from "BIM"."BIM_R_EVEN_LOAD"

View Text - HTML Formatted

SELECT EVENT_DAILY_TRANSACTION_ID EVENT_DAILY_TRANSACTION_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, EVENT_HEADER_ID EVENT_HEADER_ID
, EVENT_OFFER_ID EVENT_OFFER_ID
, PARENT_ID PARENT_ID
, EVENT_TYPE EVENT_TYPE
, EVENT_OFFER_TYPE EVENT_OFFER_TYPE
, HDR_SOURCE_CODE HDR_SOURCE_CODE
, SOURCE_CODE SOURCE_CODE
, BUSINESS_UNIT_ID BUSINESS_UNIT_ID
, COUNTRY COUNTRY
, STATUS STATUS
, EVENT_BUDGET_AMT_FC EVENT_BUDGET_AMT_FC
, OFFER_BUDGET_AMT_FC OFFER_BUDGET_AMT_FC
, START_DATE START_DATE
, END_DATE END_DATE
, EVENT_VENUE_ID EVENT_VENUE_ID
, REGISTRATIONS REGISTRATIONS
, CANCELLATIONS CANCELLATIONS
, LEADS_QUALIFIED LEADS_QUALIFIED
, LEADS_QUALIFIED_AMT LEADS_QUALIFIED_AMT
, LEADS_UNQUALIFIED LEADS_UNQUALIFIED
, LEADS_UNQUALIFIED_AMT LEADS_UNQUALIFIED_AMT
, OPPORTUNITIES OPPORTUNITIES
, OPPORTUNITY_AMT OPPORTUNITY_AMT
, ATTENDANCE ATTENDANCE
, FORECASTED_COST FORECASTED_COST
, ACTUAL_COST ACTUAL_COST
, REVENUE REVENUE
, ORDER_AMT ORDER_AMT
, BUDGET_REQUESTED BUDGET_REQUESTED
, BUDGET_APPROVED BUDGET_APPROVED
, CUSTOMER CUSTOMER
, CURRENCY_CODE CURRENCY_CODE
, TRANSACTION_CREATE_DATE TRANSACTION_CREATE_DATE
, ASSOCIATED_OBJECT_TYPE ASSOCIATED_OBJECT_TYPE
, ASSOCIATED_OBJECT_ID ASSOCIATED_OBJECT_ID
, DELETE_FLAG DELETE_FLAG
, SECURITY_GROUP_CODE SECURITY_GROUP_CODE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, LOAD_DATE LOAD_DATE
, ORG_ID ORG_ID
, MONTH MONTH
, QTR QTR
, YEAR YEAR
, ACTUAL_REVENUE ACTUAL_REVENUE
, FORECASTED_REVENUE FORECASTED_REVENUE
, BOOKED_ORDERS BOOKED_ORDERS
, BOOKED_ORDERS_AMT BOOKED_ORDERS_AMT
, LEADS_OPEN LEADS_OPEN
, LEADS_OPEN_AMT LEADS_OPEN_AMT
, LEADS_CLOSED LEADS_CLOSED
, LEADS_CLOSED_AMT LEADS_CLOSED_AMT
, LEADS_NEW LEADS_NEW
, LEADS_NEW_AMT LEADS_NEW_AMT
, LEADS_HOT LEADS_HOT
, LEADS_CONVERTED LEADS_CONVERTED
, METRIC1 METRIC1
, METRIC2 METRIC2
, METRIC3 METRIC3
, METRIC4 METRIC4
, METRIC5 METRIC5
, METRIC6 METRIC6
, METRIC7 METRIC7
, METRIC8 METRIC8
, METRIC9 METRIC9
, METRIC10 METRIC10
, METRIC11 METRIC11
, METRIC12 METRIC12
, METRIC13 METRIC13
, METRIC14 METRIC14
, METRIC15 METRIC15
FROM "BIM"."BIM_R_EVEN_LOAD"