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

VIEW: APPS.BIM_SUMV_CAMP_PERF

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

View Type

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


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


[View Source]

Columns
Name Datatype Length Mandatory Comments
CAMPAIGN_ID NUMBER
Yes campaign id
PERIOD_NAME VARCHAR2 (25) Yes period name
START_DATE DATE
Yes start date
END_DATE DATE
Yes 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
MARKET_SEGMENT_ID NUMBER
Yes market segment id
MARKET_SEGMENT_NAME VARCHAR2 (120)
market segment name
SALES_CHANNEL_CODE VARCHAR2 (30) Yes sales channel code
SALES_CHANNEL_NAME VARCHAR2 (80)
sales channel name
INTEREST_TYPE_ID NUMBER
Yes interest type id
INTEREST_TYPE VARCHAR2 (80)
interest type
PRIMARY_INTEREST_CODE_ID NUMBER
Yes primary interest code id
PRIMARY_INTEREST_CODE VARCHAR2 (100)
primary interest code
SECONDARY_INTEREST_CODE_ID NUMBER
Yes secondary interest code id
SECONDARY_INTEREST_CODE VARCHAR2 (100)
secondary interest code
GEOGRAPHY_CODE VARCHAR2 (240) Yes geograpphy code
CUST_ACCOUNT_ID NUMBER

customer acount id
INITIATED_REVENUE NUMBER

initiated revenue
ORDER_ID NUMBER

order id
COGS NUMBER

cost of good sold
LEAD_ID NUMBER

lead id
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
,      MARKET_SEGMENT_ID
,      MARKET_SEGMENT_NAME
,      SALES_CHANNEL_CODE
,      SALES_CHANNEL_NAME
,      INTEREST_TYPE_ID
,      INTEREST_TYPE
,      PRIMARY_INTEREST_CODE_ID
,      PRIMARY_INTEREST_CODE
,      SECONDARY_INTEREST_CODE_ID
,      SECONDARY_INTEREST_CODE
,      GEOGRAPHY_CODE
,      CUST_ACCOUNT_ID
,      INITIATED_REVENUE
,      ORDER_ID
,      COGS
,      LEAD_ID
FROM APPS.BIM_SUMV_CAMP_PERF;

Dependencies

[top of page]

APPS.BIM_SUMV_CAMP_PERF references the following:

SchemaAPPS
SynonymBIM_CMPGN_PERF_SUMM
ViewBIM_DIMV_MARKET_SGMTS
ViewBIM_DIMV_MEDIA_CHANNELS
ViewBIM_DIMV_PROD_LOV
ViewBIM_DIMV_SALES_CHANNELS
PL/SQL PackageFND_GLOBAL - show dependent code

APPS.BIM_SUMV_CAMP_PERF is not referenced by any database object