[Home] [Help] [Dependency Information]
Object Name: | BIM_R_CAMP_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_CAMP_SUMMARY_MV_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
RESOURCE_ID
CAMPAIGN_ID SCHEDULE_ID |
BIM_R_CAMP_SUMMARY_MV_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
RESOURCE_ID
QTR MONTH YEAR SCHEDULE_ID |
BIM_R_CAMP_SUMMARY_MV_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
RESOURCE_ID
QTR MONTH YEAR SCHEDULE_ID CAMPAIGN_ID |
BIM_R_CAMP_SUMMARY_MV_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
RESOURCE_ID
LEADS_OPEN |
BIM_R_CAMP_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 | |
SCHEDULE_ID | NUMBER | Schedule Identifier | ||
CAMPAIGN_SOURCE_CODE | VARCHAR2 | (30) | Campaign Source Code | |
SCHEDULE_SOURCE_CODE | VARCHAR2 | (30) | Schedule Source Code | |
START_DATE | DATE | Start date | ||
END_DATE | DATE | End date | ||
CAMPAIGN_AREA2 | VARCHAR2 | (30) | Campaign Area | |
SCHEDULE_AREA2 | VARCHAR2 | (30) | Schedule Area | |
CAMPAIGN_COUNTRY | VARCHAR2 | (30) | Campaign Country | |
SCHEDULE_COUNTRY | VARCHAR2 | (30) | Schedule 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 | ||
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
, SCHEDULE_ID
, CAMPAIGN_SOURCE_CODE
, SCHEDULE_SOURCE_CODE
, START_DATE
, END_DATE
, CAMPAIGN_AREA2
, SCHEDULE_AREA2
, CAMPAIGN_COUNTRY
, SCHEDULE_COUNTRY
, BUSINESS_UNIT_ID
, RESOURCE_ID
, SCHEDULE_ACTIVITY_TYPE
, SCHEDULE_ACTIVITY
, 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_CAMP_SUMMARY_MV;
BIM.BIM_R_CAMP_SUMMARY_MV does not reference any database object
BIM.BIM_R_CAMP_SUMMARY_MV is referenced by following:
|
|
|