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

TABLE: BIM.BIM_R_LEAD_GEN_SUM_MV

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


Contains Information about the Lead Generation


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 0
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BIM_R_LEAD_GEN_SUM_MV_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGROUP_ID
ColumnMONTH
ColumnQTR
ColumnYEAR
Columns
Name Datatype Length Mandatory Comments
GROUP_ID NUMBER

Group Identifier
GROUP_NAME VARCHAR2 (60)
Group 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 (30)
Summation By
DISPLAY_TYPE VARCHAR2 (30)
Type of display
LEADS_TOTAL NUMBER

Total Leads
LEADS_OPEN NUMBER

Number of leads open
LEADS_CLOSED NUMBER

Number of leads closed
LEADS_NEW NUMBER

Count of new leads
LEADS_DEAD NUMBER

Count of dead leads
LEADS_CHANGED NUMBER

Count of changed leads
LEADS_UNCHANGED NUMBER

Count of unchanged leads
LEADS_ASSIGNED NUMBER

Count of assigned leads
OPPS_TOTAL NUMBER

Total opportunities
OPPS_OPEN NUMBER

Number of open opportunities
QUOTES_TOTAL NUMBER

Total number of quotes
QUOTES_OPEN NUMBER

Number of open quotes
ORDERS NUMBER

Number of orders
SLEADS_TOTAL NUMBER

Total sales leads
SLEADS_OPEN NUMBER

Number of open sales leads
SLEADS_CLOSED NUMBER

Number of closed sales leads
SLEADS_NEW NUMBER

Number of new sales leads
SLEADS_DEAD NUMBER

Number of dead sales leads
SLEADS_CHANGED NUMBER

Number of changed sales leads
SLEADS_UNCHANGED NUMBER

Count of unchanged leads
SLEADS_ASSIGNED NUMBER

Count of assigned leads
SOPPS_TOTAL NUMBER

Total opportunities
SOPPS_OPEN NUMBER

Number of open opportunities
SQUOTES_TOTAL NUMBER

Total number of quotes
SQUOTES_OPEN NUMBER

Number of open quotes
SORDERS NUMBER

Number of orders
Query Text

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


SELECT GROUP_ID
,      GROUP_NAME
,      REGION
,      COUNTRY
,      BUSINESS_UNIT_ID
,      YEAR
,      QTR
,      MONTH
,      MONTH_ORDER
,      AGGREGATE_BY
,      DISPLAY_TYPE
,      LEADS_TOTAL
,      LEADS_OPEN
,      LEADS_CLOSED
,      LEADS_NEW
,      LEADS_DEAD
,      LEADS_CHANGED
,      LEADS_UNCHANGED
,      LEADS_ASSIGNED
,      OPPS_TOTAL
,      OPPS_OPEN
,      QUOTES_TOTAL
,      QUOTES_OPEN
,      ORDERS
,      SLEADS_TOTAL
,      SLEADS_OPEN
,      SLEADS_CLOSED
,      SLEADS_NEW
,      SLEADS_DEAD
,      SLEADS_CHANGED
,      SLEADS_UNCHANGED
,      SLEADS_ASSIGNED
,      SOPPS_TOTAL
,      SOPPS_OPEN
,      SQUOTES_TOTAL
,      SQUOTES_OPEN
,      SORDERS
FROM BIM.BIM_R_LEAD_GEN_SUM_MV;

Dependencies

[top of page]

BIM.BIM_R_LEAD_GEN_SUM_MV does not reference any database object

BIM.BIM_R_LEAD_GEN_SUM_MV is referenced by following:

SchemaBIM
ViewBIM_R_LEAD_GEN_SUM_MV#