Skip to content

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

TABLE: BIM.BIM_R_LEAD_QUCP_SUM_MV

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


Lead Quality Campaign Summary MV


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 0
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BIM_R_LEAD_QUCP_SUM_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGROUP_ID
ColumnCAMPAIGN_NAME
ColumnREGION
ColumnCOUNTRY
ColumnBUSINESS_UNIT_ID
Columns
Name Datatype Length Mandatory Comments
GROUP_ID NUMBER

Group identifier
CAMPAIGN_NAME VARCHAR2 (240)
Campaign name
REGION VARCHAR2 (30)
Region
COUNTRY VARCHAR2 (30)
Country
BUSINESS_UNIT_ID NUMBER

Business unit identifier
YEAR VARCHAR2 (30)
year
QTR VARCHAR2 (30)
quarter
MONTH VARCHAR2 (30)
Month
MONTH_ORDER NUMBER

Month order
AGGREGATE_BY VARCHAR2 (9)
Summation by
DISPLAY_TYPE VARCHAR2 (7)
Type of display
CURR_A NUMBER

Curr A
CURR_B NUMBER

Curr B
CURR_C NUMBER

Curr C
CURR_D NUMBER

Curr D
CURR_E NUMBER

Curr E
CURR_F NUMBER

Curr F
CURR_G NUMBER

Curr G
CURR_H NUMBER

Curr H
CURR_I NUMBER

Curr I
CURR_J NUMBER

Curr J
CURR_OTHERS NUMBER

Curr Others
Query Text

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


SELECT GROUP_ID
,      CAMPAIGN_NAME
,      REGION
,      COUNTRY
,      BUSINESS_UNIT_ID
,      YEAR
,      QTR
,      MONTH
,      MONTH_ORDER
,      AGGREGATE_BY
,      DISPLAY_TYPE
,      CURR_A
,      CURR_B
,      CURR_C
,      CURR_D
,      CURR_E
,      CURR_F
,      CURR_G
,      CURR_H
,      CURR_I
,      CURR_J
,      CURR_OTHERS
FROM BIM.BIM_R_LEAD_QUCP_SUM_MV;

Dependencies

[top of page]

BIM.BIM_R_LEAD_QUCP_SUM_MV does not reference any database object

BIM.BIM_R_LEAD_QUCP_SUM_MV is referenced by following:

SchemaBIM
ViewBIM_R_LEAD_QUCP_SUM_MV#