eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: BIM.BIM_R_IRES_SUM_MV

Object Details

Object Name:	BIM_R_IRES_SUM_MV
Object Type:	TABLE
Owner:	BIM
Subobject Name:
Status:	VALID

Summary table for the Response Bin

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	0
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIM_R_IRES_SUM_MV_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ID SCHEDULE_ACTIVITY_ID MONTH QTR YEAR
BIM_R_IRES_SUM_MV_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ID CAMPAIGN_ID MONTH QTR YEAR

Columns

Name	Datatype	Length	Comments
SCHEDULE_REGION	VARCHAR2	(30)	Schedule region
SCHEDULE_COUNTRY	VARCHAR2	(30)	Schedule country
CAMPAIGN_REGION	VARCHAR2	(30)	Campaign region
CAMPAIGN_COUNTRY	VARCHAR2	(30)	Campaign country
BUSINESS_UNIT_ID	NUMBER		Business unit identifier
SCHEDULE_ACTIVITY_ID	NUMBER		Schedule Activity Identifier
CAMPAIGN_ID	NUMBER		Campaign Identifier
CAMPAIGN_NAME	VARCHAR2	(240)	Name of the campaign
REPORT_TYPE	VARCHAR2	(30)	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)	type of display
COST_CURR_PERIOD	NUMBER		Cost in current period
CURRENT_PR_COUNT	NUMBER		Current PR Count
CURRENT_PR_ADDED	NUMBER		Current PR Added
PREVIOUS_PR_COUNT	NUMBER		Previous PR Count
PREVIOUS_PR_ADDED	NUMBER		Previous PR Added
CURRENT_CONVERTED	NUMBER		Current converted
PREVIOUS_CONVERTED	NUMBER		previous converted
CAMPAIGN_COUNT	NUMBER		Campaign count
FORECASTED_RESPONSES	NUMBER		Forecasted responses
TARGETED_CUSTOMERS	NUMBER		targeted customers
RESOURCE_ID	NUMBER		Resource identifier

Query Text

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


SELECT SCHEDULE_REGION
,      SCHEDULE_COUNTRY
,      CAMPAIGN_REGION
,      CAMPAIGN_COUNTRY
,      BUSINESS_UNIT_ID
,      SCHEDULE_ACTIVITY_ID
,      CAMPAIGN_ID
,      CAMPAIGN_NAME
,      REPORT_TYPE
,      YEAR
,      QTR
,      MONTH
,      MONTH_ORDER
,      AGGREGATE_BY
,      DISPLAY_TYPE
,      COST_CURR_PERIOD
,      CURRENT_PR_COUNT
,      CURRENT_PR_ADDED
,      PREVIOUS_PR_COUNT
,      PREVIOUS_PR_ADDED
,      CURRENT_CONVERTED
,      PREVIOUS_CONVERTED
,      CAMPAIGN_COUNT
,      FORECASTED_RESPONSES
,      TARGETED_CUSTOMERS
,      RESOURCE_ID
FROM BIM.BIM_R_IRES_SUM_MV;

Dependencies

[top of page]

BIM.BIM_R_IRES_SUM_MV does not reference any database object

BIM.BIM_R_IRES_SUM_MV is referenced by following:

BIM: BIM_R_IRES_SUM_MV#