View: BIM_SUMV_EVENT_RSLTS

Product:	BIM - Marketing Intelligence(Obsolete)
Description:	Joins the summary table to the dimension views.
Implementation/DBA Data:	APPS.BIM_SUMV_EVENT_RSLTS

View Text

SELECT BER.EVENT_ID EVENT_ID
, BER.EVENT_OFFERING_ID EVENT_OFFERING_ID
, BEH.EVENT_NAME EVENT_NAME
, BEH.EVENT_OFFER_NAME EVENT_OFFERING_NAME
, BEH.EVENT_TYPE_CODE EVENT_TYPE
, BER.PERIOD_NAME PERIOD_NAME
, BER.PERIOD_START_DATE START_DATE
, BER.PERIOD_END_DATE END_DATE
, BER.NUM_AVAILABLE NUM_AVAILABLE
, BER.NUM_TARGETED NUM_TARGETED
, BER.NUM_RESPONDED NUM_RESPONDED
, BER.NUM_ENROLLED NUM_ENROLLED
, BER.NUM_ATTENDED NUM_ATTENDED
, BER.NUM_CANCELLED NUM_CANCELLED
FROM BIM_EVENT_RESP_SUMM BER
, BIM_DIMV_EVENT_HIER BEH
WHERE BER.EVENT_OFFERING_ID = BEH.EVENT_OFFER_ID WITH READ ONLY

Columns