VIEW: APPS.BIM_SUMV_EVENT_PERF

Source

View Text - Preformatted

SELECT BEP.EVENT_ID EVENT_ID , BEP.EVENT_OFFERING_ID EVENT_OFFERING_ID , BEH.EVENT_NAME EVENT_NAME , BEH.EVENT_OFFER_NAME EVENT_OFFERING_NAME , BEH.EVENT_TYPE_CODE EVENT_TYPE , BEP.CAMPAIGN_ID CAMPAIGN_ID , BEP.PERIOD_NAME PERIOD_NAME , BEP.PERIOD_START_DATE START_DATE , BEP.PERIOD_END_DATE END_DATE , BEP.MARKET_SEGMENT_ID MARKET_SEGMENT_ID , BMS.MARKET_SEGMENT_NAME MARKET_SEGMENT_NAME , BEP.SALES_CHANNEL_CODE SALES_CHANNEL_CODE , BSC.SALES_CHANNEL_NAME SALES_CHANNEL_NAME , BEP.INTEREST_TYPE_ID INTEREST_TYPE_ID , BPR.INTEREST_TYPE INTEREST_TYPE , BEP.PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE_ID , BPR.PRIMARY_INTEREST_CODE PRIMARY_INTEREST_CODE , BEP.SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID , BPR.SECONDARY_INTEREST_CODE SECONDARY_INTEREST_CODE , BEP.BILL_TO_GEOGRAPHY_CODE GEOGRAPHY_CODE , BEP.LEAD_ID LEAD_ID , BEP.INITIATED_REVENUE INITIATED_REVENUE FROM BIM_EVENT_PERF_SUMM BEP , BIM_DIMV_EVENT_HIER BEH , BIM_DIMV_MARKET_SGMTS BMS , BIM_DIMV_SALES_CHANNELS BSC , BIM_DIMV_PROD_LOV BPR WHERE BEP.EVENT_OFFERING_ID = BEH.EVENT_OFFER_ID AND BEP.MARKET_SEGMENT_ID = BMS.MARKET_SEGMENT_ID AND BEP.SALES_CHANNEL_CODE = BSC.SALES_CHANNEL_CODE AND BEP.INTEREST_TYPE_ID = BPR.INTEREST_TYPE_ID AND BEP.PRIMARY_INTEREST_CODE_ID = BPR.PRIMARY_INTEREST_CODE_ID AND BEP.SECONDARY_INTEREST_CODE_ID = BPR.SECONDARY_INTEREST_CODE_ID WITH READ ONLY

View Text - HTML Formatted

SELECT BEP.EVENT_ID EVENT_ID
, BEP.EVENT_OFFERING_ID EVENT_OFFERING_ID
, BEH.EVENT_NAME EVENT_NAME
, BEH.EVENT_OFFER_NAME EVENT_OFFERING_NAME
, BEH.EVENT_TYPE_CODE EVENT_TYPE
, BEP.CAMPAIGN_ID CAMPAIGN_ID
, BEP.PERIOD_NAME PERIOD_NAME
, BEP.PERIOD_START_DATE START_DATE
, BEP.PERIOD_END_DATE END_DATE
, BEP.MARKET_SEGMENT_ID MARKET_SEGMENT_ID
, BMS.MARKET_SEGMENT_NAME MARKET_SEGMENT_NAME
, BEP.SALES_CHANNEL_CODE SALES_CHANNEL_CODE
, BSC.SALES_CHANNEL_NAME SALES_CHANNEL_NAME
, BEP.INTEREST_TYPE_ID INTEREST_TYPE_ID
, BPR.INTEREST_TYPE INTEREST_TYPE
, BEP.PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE_ID
, BPR.PRIMARY_INTEREST_CODE PRIMARY_INTEREST_CODE
, BEP.SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID
, BPR.SECONDARY_INTEREST_CODE SECONDARY_INTEREST_CODE
, BEP.BILL_TO_GEOGRAPHY_CODE GEOGRAPHY_CODE
, BEP.LEAD_ID LEAD_ID
, BEP.INITIATED_REVENUE INITIATED_REVENUE
FROM BIM_EVENT_PERF_SUMM BEP
, BIM_DIMV_EVENT_HIER BEH
, BIM_DIMV_MARKET_SGMTS BMS
, BIM_DIMV_SALES_CHANNELS BSC
, BIM_DIMV_PROD_LOV BPR
WHERE BEP.EVENT_OFFERING_ID = BEH.EVENT_OFFER_ID
AND BEP.MARKET_SEGMENT_ID = BMS.MARKET_SEGMENT_ID
AND BEP.SALES_CHANNEL_CODE = BSC.SALES_CHANNEL_CODE
AND BEP.INTEREST_TYPE_ID = BPR.INTEREST_TYPE_ID
AND BEP.PRIMARY_INTEREST_CODE_ID = BPR.PRIMARY_INTEREST_CODE_ID
AND BEP.SECONDARY_INTEREST_CODE_ID = BPR.SECONDARY_INTEREST_CODE_ID WITH READ ONLY