View: BIM_SUMV_SLIST_PROFIT

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

View Text

SELECT BSP.SOURCE_LIST_ID SOURCE_LIST_ID
, BSL.SOURCE_LIST_NAME SOURCE_LIST_NAME
, BSP.PERIOD_NAME PERIOD_NAME
, BSP.PERIOD_START_DATE START_DATE
, BSP.PERIOD_END_DATE END_DATE
, BSP.INITIATED_REVENUE INITIATED_REVENUE
, BSP.ACTUAL_COST ACTUAL_COST
FROM BIM_SLIST_PROFIT_SUMM BSP
, BIM_DIMV_SOURCE_LISTS BSL
WHERE BSP.SOURCE_LIST_ID = BSL.SOURCE_LIST_ID WITH READ ONLY

Columns