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_RESP_RSN_SUM_MV

Object Details

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

Summary MV for Response Reason

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	0
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIM_R_RESP_RSN_SUM_MV_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESPONSE_REGION
BIM_R_RESP_RSN_SUM_MV_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESPONSE_COUNTRY

Columns

Name	Datatype	Length	Comments
RESPONSE_REGION	VARCHAR2	(30)	Responses in a region
RESPONSE_COUNTRY	VARCHAR2	(30)	Responses in a country
BUSINESS_UNIT_ID	NUMBER		Business unit identifier
INVALID_REASON	VARCHAR2	(30)	Invalid reason
AGGREGATE_BY	VARCHAR2	(30)	Summation By
DISPLAY_TYPE	VARCHAR2	(30)	Typeof display
YEAR	VARCHAR2	(30)	Year
QTR	VARCHAR2	(30)	Quarter
MONTH	VARCHAR2	(30)	Month
MONTH_ORDER	NUMBER		Month order
INVALID_RESPONSES	NUMBER		Invalid responses

Query Text

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


SELECT RESPONSE_REGION
,      RESPONSE_COUNTRY
,      BUSINESS_UNIT_ID
,      INVALID_REASON
,      AGGREGATE_BY
,      DISPLAY_TYPE
,      YEAR
,      QTR
,      MONTH
,      MONTH_ORDER
,      INVALID_RESPONSES
FROM BIM.BIM_R_RESP_RSN_SUM_MV;

Dependencies

[top of page]

BIM.BIM_R_RESP_RSN_SUM_MV does not reference any database object

BIM.BIM_R_RESP_RSN_SUM_MV is referenced by following:

BIM: BIM_R_RESP_RSN_SUM_MV#