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

TABLE: BIM.BIM_R_LEAD_LO_SUM_MV_BASE

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


Base Summary MV for Lead Opportunities


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 0
PCT Used:
Columns
Name Datatype Length Mandatory Comments
GROUP_ID NUMBER

Group Identifier
CAMPAIGN_NAME VARCHAR2 (240)
name of the campaign
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

open leads
LEADS_CLOSED NUMBER

closed leads
LEADS_NEW NUMBER

New leads
LEADS_DEAD NUMBER

Dead leads
LEADS_CHANGED NUMBER

Changed leads
LEADS_UNCHANGED NUMBER

Unchanged leads
LEADS_ASSIGNED NUMBER

Leads assigned
OPPS_TOTAL NUMBER

Total opportunities
OPPS_OPEN NUMBER

Open opportunities
QUOTES_TOTAL NUMBER

Total quotes
QUOTES_OPEN NUMBER

open quotes
ORDERS NUMBER

orders
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
,      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
FROM BIM.BIM_R_LEAD_LO_SUM_MV_BASE;

Dependencies

[top of page]

BIM.BIM_R_LEAD_LO_SUM_MV_BASE does not reference any database object

BIM.BIM_R_LEAD_LO_SUM_MV_BASE is referenced by following:

SchemaBIM
ViewBIM_R_LEAD_LO_SUM_MV_BASE#