DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.BIM_SUMV_CAMP_COST

Object Details
Object Name: BIM_SUMV_CAMP_COST
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBIM.BIM_SUMV_CAMP_COST
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


BIM_SUMV_CAMP_COST is a view that joins the summary table to the dimension views. It is used by the following reports: Campaign Activity Profitability, Campaign Cost, Campaign Revenue, Marketing Channel Profitability.
.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CAMPAIGN_ID NUMBER
Yes campaign id
PERIOD_NAME VARCHAR2 (25) Yes name of the campaign period
START_DATE DATE
Yes campaign start date
END_DATE DATE
Yes campaign end date
MEDIA_ID NUMBER
Yes media id
MEDIA_NAME VARCHAR2 (120)
media name
MEDIA_TYPE VARCHAR2 (30)
media type
MEDIA_TYPE_NAME VARCHAR2 (80)
media type name
CHANNEL_ID VARCHAR2 (80) Yes channel id
CHANNEL_NAME VARCHAR2 (240)
channel name
FORECASTED_REVENUE NUMBER

forecasted revenue
FORECASTED_COST NUMBER

forecasted cost
INITIATED_REVENUE NUMBER

initiated revenue
ACTUAL_COST NUMBER

actual cost
NUM_OF_LEADS NUMBER

number of leads
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CAMPAIGN_ID
,      PERIOD_NAME
,      START_DATE
,      END_DATE
,      MEDIA_ID
,      MEDIA_NAME
,      MEDIA_TYPE
,      MEDIA_TYPE_NAME
,      CHANNEL_ID
,      CHANNEL_NAME
,      FORECASTED_REVENUE
,      FORECASTED_COST
,      INITIATED_REVENUE
,      ACTUAL_COST
,      NUM_OF_LEADS
FROM APPS.BIM_SUMV_CAMP_COST;

Dependencies

[top of page]

APPS.BIM_SUMV_CAMP_COST references the following:

SchemaAPPS
SynonymBIM_CMPGN_REVCOST_SUMM
ViewBIM_DIMV_MEDIA_CHANNELS
PL/SQL PackageFND_GLOBAL - show dependent code

APPS.BIM_SUMV_CAMP_COST is not referenced by any database object