[Home] [Help] [Dependency Information]
Object Name: | BIM_R_CMP_SUMMARY_MV |
---|---|
Object Type: | TABLE |
Owner: | BIM |
Subobject Name: | |
Status: | VALID |
Campaign Summary MV
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 0 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BIM_R_CMP_SUMMARY_MV_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
RESOURCE_ID
CAMPAIGN_ID |
BIM_R_CMP_SUMMARY_MV_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
RESOURCE_ID
QTR MONTH YEAR |
BIM_R_CMP_SUMMARY_MV_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
RESOURCE_ID
QTR MONTH YEAR CAMPAIGN_ID |
BIM_R_CMP_SUMMARY_MV_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
RESOURCE_ID
LEADS_OPEN |
BIM_R_CMP_SUMMARY_MV_N6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
RESOURCE_ID
OPPORTUNITIES |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
YEAR | VARCHAR2 | (30) | Year | |
CAMPAIGN_ID | NUMBER | Campaign Identifier | ||
CAMPAIGN_NAME | VARCHAR2 | (240) | Campaign Name | |
CAMPAIGN_SOURCE_CODE | VARCHAR2 | (30) | Campaign Source Code | |
CAMPAIGN_AREA2 | VARCHAR2 | (30) | Campaign Area | |
CAMPAIGN_COUNTRY | VARCHAR2 | (30) | Campaign Country | |
BUSINESS_UNIT_ID | NUMBER | Business Unit Identifier | ||
RESOURCE_ID | NUMBER | Resource Identifier | ||
QTR | VARCHAR2 | (30) | Quarter | |
MONTH | VARCHAR2 | (30) | Month | |
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 | ||
OPPORTUNITIES | NUMBER | Opportunities | ||
OPPORTUNITY_AMT | NUMBER | Opportunity Amount | ||
ORDERS_BOOKED | NUMBER | Count of Booked Orders | ||
ORDERS_BOOKED_AMT | NUMBER | Amount of Booked Orders | ||
ORDERS_CANCELLED | NUMBER | Count of Cancelled Orders | ||
ORDERS_CANCELLED_AMT | NUMBER | Amount of Cancelled 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 | ||
POSITIVE_RESPONSES | NUMBER | Positive Responses | ||
TARGETED_CUSTOMERS | NUMBER | Targeted Customers | ||
BUDGET_REQUESTED | NUMBER | Requested Budget Amount | ||
BUDGET_APPROVED | NUMBER | Approved Budget Amount | ||
PREVIOUS_COUNT_VALUE | NUMBER | Previous Count Value | ||
PREVIOUS_STARTED_VALUE | NUMBER | Previous Started Value | ||
PREVIOUS_ENDED_VALUE | NUMBER | Previous Ended Value | ||
CURRENT_COUNT_VALUE | NUMBER | Current Count value | ||
CURRENT_STARTED_VALUE | NUMBER | Current Started Value | ||
CURRENT_ENDED_VALUE | NUMBER | Current Ended Value |
Cut, paste (and edit) the following text to query this object:
SELECT YEAR
, CAMPAIGN_ID
, CAMPAIGN_NAME
, CAMPAIGN_SOURCE_CODE
, CAMPAIGN_AREA2
, CAMPAIGN_COUNTRY
, BUSINESS_UNIT_ID
, RESOURCE_ID
, QTR
, MONTH
, LEADS_OPEN
, LEADS_OPEN_AMT
, LEADS_CLOSED
, LEADS_CLOSED_AMT
, OPPORTUNITIES
, OPPORTUNITY_AMT
, ORDERS_BOOKED
, ORDERS_BOOKED_AMT
, ORDERS_CANCELLED
, ORDERS_CANCELLED_AMT
, FORECASTED_COST
, ACTUAL_COST
, FORECASTED_REVENUE
, ACTUAL_REVENUE
, FORECASTED_RESPONSES
, POSITIVE_RESPONSES
, TARGETED_CUSTOMERS
, BUDGET_REQUESTED
, BUDGET_APPROVED
, PREVIOUS_COUNT_VALUE
, PREVIOUS_STARTED_VALUE
, PREVIOUS_ENDED_VALUE
, CURRENT_COUNT_VALUE
, CURRENT_STARTED_VALUE
, CURRENT_ENDED_VALUE
FROM BIM.BIM_R_CMP_SUMMARY_MV;
BIM.BIM_R_CMP_SUMMARY_MV does not reference any database object
BIM.BIM_R_CMP_SUMMARY_MV is referenced by following:
|
|
|