VIEW: BIM.BIM_EVENT_PERF_SUMM#

Source

View Text - Preformatted

select EVENT_ID EVENT_ID, PERIOD_NAME PERIOD_NAME, 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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PERIOD_START_DATE PERIOD_START_DATE, PERIOD_END_DATE PERIOD_END_DATE, EVENT_OFFERING_ID EVENT_OFFERING_ID, CAMPAIGN_ID CAMPAIGN_ID, MARKET_SEGMENT_ID MARKET_SEGMENT_ID, SALES_CHANNEL_CODE SALES_CHANNEL_CODE, INTEREST_TYPE_ID INTEREST_TYPE_ID, PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE_ID, SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID, SHIP_TO_GEOGRAPHY_CODE SHIP_TO_GEOGRAPHY_CODE, BILL_TO_GEOGRAPHY_CODE BILL_TO_GEOGRAPHY_CODE, LEAD_ID LEAD_ID, INITIATED_REVENUE INITIATED_REVENUE, SECURITY_GROUP_ID SECURITY_GROUP_ID from "BIM"."BIM_EVENT_PERF_SUMM"

View Text - HTML Formatted

SELECT EVENT_ID EVENT_ID
, PERIOD_NAME PERIOD_NAME
, 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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PERIOD_START_DATE PERIOD_START_DATE
, PERIOD_END_DATE PERIOD_END_DATE
, EVENT_OFFERING_ID EVENT_OFFERING_ID
, CAMPAIGN_ID CAMPAIGN_ID
, MARKET_SEGMENT_ID MARKET_SEGMENT_ID
, SALES_CHANNEL_CODE SALES_CHANNEL_CODE
, INTEREST_TYPE_ID INTEREST_TYPE_ID
, PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE_ID
, SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID
, SHIP_TO_GEOGRAPHY_CODE SHIP_TO_GEOGRAPHY_CODE
, BILL_TO_GEOGRAPHY_CODE BILL_TO_GEOGRAPHY_CODE
, LEAD_ID LEAD_ID
, INITIATED_REVENUE INITIATED_REVENUE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "BIM"."BIM_EVENT_PERF_SUMM"