[Home] [Help] [Dependency Information]
Object Name: | BIM_SUMV_CAMP_COST |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BIM.BIM_SUMV_CAMP_COST |
Subobject Name: | |
Status: | VALID |
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.
.
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 |
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;
APPS.BIM_SUMV_CAMP_COST is not referenced by any database object
|
|
|