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

TABLE: BIM.BIM_R_CAMP_COLLECTION_COPY

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


This is used to create Marketing Activities Materialized views


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CAMPAIGN_AREA1 VARCHAR2 (30)
area1 info where campaign is held
CAMPAIGN_AREA2 VARCHAR2 (30)
area2 info where campaign is held
SCHEDULE_AREA1 VARCHAR2 (30)
area1 info where campaign schedule is held
SCHEDULE_AREA2 VARCHAR2 (30)
area1 info where campaign schedule is held
CAMPAIGN_COUNTRY VARCHAR2 (30)
country info where campaign is held
SCHEDULE_COUNTRY VARCHAR2 (30)
country info where campaign schedule is held
BUSINESS_UNIT_ID NUMBER

business unit id for campaign
CAMPAIGN_TYPE VARCHAR2 (30)
campaign type
SCHEDULE_ACTIVITY_TYPE VARCHAR2 (30)
campaign schedule activity type
SCHEDULE_ACTIVITY NUMBER

campaign schedule activity
CAMPAIGN_STATUS VARCHAR2 (30)
status of campaign
SCHEDULE_STATUS VARCHAR2 (30)
campaign schedule status
YEAR VARCHAR2 (30)
fiscal year
QTR VARCHAR2 (30)
fiscal quarter
MONTH VARCHAR2 (30)
fiscal month
MONTH_ORDER NUMBER

month order in the year
AGGREGATE_BY VARCHAR2 (30)
aggregation method
DISPLAY_TYPE VARCHAR2 (30)
value is:day/week/month/qtr/year when aggregate by is "increment", otherwise "z"
CURRENT_COUNT_VALUE NUMBER

number of active campaigns for the current period
CURRENT_STARTED_VALUE NUMBER

number of campaigns became active for the current period
CURRENT_ENDED_VALUE NUMBER

number of campaigns ended for the current period
PREVIOUS_COUNT_VALUE NUMBER

number of active campaigns for the current period
PREVIOUS_STARTED_VALUE NUMBER

number of campaigns became active for the current period
PREVIOUS_ENDED_VALUE NUMBER

number of campaigns ended for the current period
LEADS_OPEN NUMBER

leads opened for the current period
LEADS_CLOSED NUMBER

leads opened for the current period
LEADS_OPEN_AMT NUMBER

leads opened amount for the current period
LEADS_CLOSED_AMT NUMBER

leads closed amount for the current period
OPPORTUNITIES NUMBER

number of opportunities
OPPORTUNITY_AMT NUMBER

opportunity amount
ORDERS_BOOKED NUMBER

orders booked
ORDERS_BOOKED_AMT NUMBER

amount of booked orders
FORECASTED_COST NUMBER

forecasted cost
ACTUAL_COST NUMBER

actual cost
FORECASTED_REVENUE NUMBER

forecasted revenue
ACTUAL_REVENUE NUMBER

actual revenue
FORECASTED_RESPONSES NUMBER

forecasted responses
TARGETED_CUSTOMERS NUMBER

targeted customers
BUDGET_REQUESTED NUMBER

budget requested
BUDGET_APPROVED NUMBER

budget approved
PERIOD_START_DATE DATE

Period Start Date
Query Text

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


SELECT CAMPAIGN_AREA1
,      CAMPAIGN_AREA2
,      SCHEDULE_AREA1
,      SCHEDULE_AREA2
,      CAMPAIGN_COUNTRY
,      SCHEDULE_COUNTRY
,      BUSINESS_UNIT_ID
,      CAMPAIGN_TYPE
,      SCHEDULE_ACTIVITY_TYPE
,      SCHEDULE_ACTIVITY
,      CAMPAIGN_STATUS
,      SCHEDULE_STATUS
,      YEAR
,      QTR
,      MONTH
,      MONTH_ORDER
,      AGGREGATE_BY
,      DISPLAY_TYPE
,      CURRENT_COUNT_VALUE
,      CURRENT_STARTED_VALUE
,      CURRENT_ENDED_VALUE
,      PREVIOUS_COUNT_VALUE
,      PREVIOUS_STARTED_VALUE
,      PREVIOUS_ENDED_VALUE
,      LEADS_OPEN
,      LEADS_CLOSED
,      LEADS_OPEN_AMT
,      LEADS_CLOSED_AMT
,      OPPORTUNITIES
,      OPPORTUNITY_AMT
,      ORDERS_BOOKED
,      ORDERS_BOOKED_AMT
,      FORECASTED_COST
,      ACTUAL_COST
,      FORECASTED_REVENUE
,      ACTUAL_REVENUE
,      FORECASTED_RESPONSES
,      TARGETED_CUSTOMERS
,      BUDGET_REQUESTED
,      BUDGET_APPROVED
,      PERIOD_START_DATE
FROM BIM.BIM_R_CAMP_COLLECTION_COPY;

Dependencies

[top of page]

BIM.BIM_R_CAMP_COLLECTION_COPY does not reference any database object

BIM.BIM_R_CAMP_COLLECTION_COPY is referenced by following:

SchemaAPPS
SynonymBIM_R_CAMP_COLLECTION_COPY