Skip to content

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

TABLE: BIM.BIM_R_CAMP_DIM_SUM_MV

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


Campaign Dimension Summary MV


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 0
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BIM_R_CAMP_DIM_SUM_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESOURCE_ID
ColumnCAMPAIGN_AREA2
ColumnCAMPAIGN_COUNTRY
ColumnBUSINESS_UNIT_ID
ColumnSCHEDULE_ACTIVITY_TYPE
ColumnSCHEDULE_ACTIVITY
ColumnYEAR
ColumnQTR
ColumnMONTH
BIM_R_CAMP_DIM_SUM_MV_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESOURCE_ID
ColumnQTR
ColumnMONTH
ColumnYEAR
Columns
Name Datatype Length Mandatory Comments
CAMPAIGN_AREA2 VARCHAR2 (30)
Campaign Area
CAMPAIGN_COUNTRY VARCHAR2 (30)
Campaign Country
BUSINESS_UNIT_ID NUMBER

Business Unit Identifier
RESOURCE_ID NUMBER

Resource Identifier
SCHEDULE_ACTIVITY_TYPE VARCHAR2 (30)
Schedule Activity Type
SCHEDULE_ACTIVITY NUMBER

Schedule Activity
YEAR VARCHAR2 (30)
Year
QTR VARCHAR2 (30)
Quarter
MONTH VARCHAR2 (30)
Month
MONTH_ORDER NUMBER

Month Order
AGGREGATE_BY VARCHAR2 (5)
Summation By
SCHEDULE_COUNT NUMBER

Schedule Count
LEADS_QUALIFIED NUMBER

Count of Qualified Leads
LEADS_QUALIFIED_AMT NUMBER

Amount of Leads Qualified
LEADS_UNQUALIFIED NUMBER

Count of Unqualified Leads
LEADS_UNQUALIFIED_AMT NUMBER

Amount of Unqualified Leads
OPPORTUNITIES NUMBER

Opportunities
OPPORTUNITY_AMT NUMBER

Opportunity Amount
ORDERS_ACTIVE NUMBER

Count of Active Orders
ORDERS_CANCELLED NUMBER

Count of Cancelled Orders
ORDERS_ACTIVE_AMT NUMBER

Amount of Active Orders
ORDERS_CANCELLED_AMT NUMBER

Amount of Cancelled Orders
FORECASTED_COST NUMBER

Forecasted cost
ACTUAL_COST NUMBER

Actual Cost
REVENUE NUMBER

Revenue
TARGETED_CUSTOMERS NUMBER

Targeted Customers
BUDGET_REQUESTED NUMBER

Requested Budget Amount
BUDGET_APPROVED NUMBER

Approved Budget Amount
LEADS_OPEN NUMBER

Count of Open Leads
LEADS_OPEN_AMT NUMBER

Amount of Open Leads
LEADS_CLOSED NUMBER

Count of Closed Leads
LEADS_CLOSED_AMT NUMBER

Amount of Closed Leads
LEADS_NEW NUMBER

New Leads Count
LEADS_NEW_AMT NUMBER

Amount of New Leads
LEADS_HOT NUMBER

Hot Leads
LEADS_CONVERTED NUMBER

Converted Leads
POSITIVE_RESPONSES NUMBER

Positive Responses
ACTUAL_REVENUE NUMBER

Actual Revenue
FORECASTED_REVENUE NUMBER

Forecasted Revenue
FORECASTED_RESPONSES NUMBER

Forecasted Responses
ORDERS_BOOKED NUMBER

Count of Booked Orders
ORDERS_BOOKED_AMT NUMBER

Amount of Booked Orders
DISPLAY_TYPE VARCHAR2 (1)
Display Type
Query Text

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


SELECT CAMPAIGN_AREA2
,      CAMPAIGN_COUNTRY
,      BUSINESS_UNIT_ID
,      RESOURCE_ID
,      SCHEDULE_ACTIVITY_TYPE
,      SCHEDULE_ACTIVITY
,      YEAR
,      QTR
,      MONTH
,      MONTH_ORDER
,      AGGREGATE_BY
,      SCHEDULE_COUNT
,      LEADS_QUALIFIED
,      LEADS_QUALIFIED_AMT
,      LEADS_UNQUALIFIED
,      LEADS_UNQUALIFIED_AMT
,      OPPORTUNITIES
,      OPPORTUNITY_AMT
,      ORDERS_ACTIVE
,      ORDERS_CANCELLED
,      ORDERS_ACTIVE_AMT
,      ORDERS_CANCELLED_AMT
,      FORECASTED_COST
,      ACTUAL_COST
,      REVENUE
,      TARGETED_CUSTOMERS
,      BUDGET_REQUESTED
,      BUDGET_APPROVED
,      LEADS_OPEN
,      LEADS_OPEN_AMT
,      LEADS_CLOSED
,      LEADS_CLOSED_AMT
,      LEADS_NEW
,      LEADS_NEW_AMT
,      LEADS_HOT
,      LEADS_CONVERTED
,      POSITIVE_RESPONSES
,      ACTUAL_REVENUE
,      FORECASTED_REVENUE
,      FORECASTED_RESPONSES
,      ORDERS_BOOKED
,      ORDERS_BOOKED_AMT
,      DISPLAY_TYPE
FROM BIM.BIM_R_CAMP_DIM_SUM_MV;

Dependencies

[top of page]

BIM.BIM_R_CAMP_DIM_SUM_MV does not reference any database object

BIM.BIM_R_CAMP_DIM_SUM_MV is referenced by following:

SchemaBIM
ViewBIM_R_CAMP_DIM_SUM_MV#