Skip to content

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

TABLE: BIM.BIM_R_CAMP_ACT_SUMMARY_MV

Object Details
Object Name: BIM_R_CAMP_ACT_SUMMARY_MV
Object Type: TABLE
Owner: BIM
Subobject Name:
Status: VALID


Summation Data for Campaign Activity Bin


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 0
PCT Used:
Columns
Name Datatype Length Mandatory Comments
SCHEDULE_AREA2 VARCHAR2 (30)
Schedule Area
SCHEDULE_COUNTRY VARCHAR2 (30)
Schedule Country
BUSINESS_UNIT_ID NUMBER

Business Unit Identifer
SCHEDULE_ACTIVITY NUMBER

Schedule Activity
CAMPAIGN_ID NUMBER

Campaign Identifier
CAMPAIGN_NAME VARCHAR2 (240)
Name of the campaign
REPORT_TYPE VARCHAR2 (15)
Report type
YEAR VARCHAR2 (30)
Year
QTR VARCHAR2 (30)
Quarter
MONTH VARCHAR2 (30)
Month
MONTH_ORDER NUMBER

Month Order
AGGREGATE_BY VARCHAR2 (30)
Summation By
DISPLAY_TYPE VARCHAR2 (30)
Display Type
CURRENT_COUNT_VALUE NUMBER

Current Count value
PREVIOUS_COUNT_VALUE NUMBER

Previous count value
CAMPAIGN_COUNT NUMBER

Campaign count
FORECASTED_RESPONSES NUMBER

Forecasted responses
TARGETED_CUSTOMERS NUMBER

Targeted customers
PREV_TARGETED_CUSTOMERS NUMBER

Previous targeted customers
BUDGET_APPROVED NUMBER

Approved budget amount
RESOURCE_ID NUMBER

Resource Identifer
Query Text

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


SELECT SCHEDULE_AREA2
,      SCHEDULE_COUNTRY
,      BUSINESS_UNIT_ID
,      SCHEDULE_ACTIVITY
,      CAMPAIGN_ID
,      CAMPAIGN_NAME
,      REPORT_TYPE
,      YEAR
,      QTR
,      MONTH
,      MONTH_ORDER
,      AGGREGATE_BY
,      DISPLAY_TYPE
,      CURRENT_COUNT_VALUE
,      PREVIOUS_COUNT_VALUE
,      CAMPAIGN_COUNT
,      FORECASTED_RESPONSES
,      TARGETED_CUSTOMERS
,      PREV_TARGETED_CUSTOMERS
,      BUDGET_APPROVED
,      RESOURCE_ID
FROM BIM.BIM_R_CAMP_ACT_SUMMARY_MV;

Dependencies

[top of page]

BIM.BIM_R_CAMP_ACT_SUMMARY_MV does not reference any database object

BIM.BIM_R_CAMP_ACT_SUMMARY_MV is referenced by following:

SchemaBIM
ViewBIM_R_CAMP_ACT_SUMMARY_MV#