[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | BIM_R_LEAD_GEN_SUM_MV_BASE |
|---|---|
| Object Type: | TABLE |
| Owner: | BIM |
| Subobject Name: | |
| Status: | VALID |
Base Summary MV for Lead Generation
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 0 |
| PCT Used: |
| 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 number of leads | ||
| LEADS_OPEN | NUMBER | Number of open leads | ||
| LEADS_CLOSED | NUMBER | Number of closed leads | ||
| LEADS_NEW | NUMBER | Number of new leads | ||
| LEADS_DEAD | NUMBER | Number of dead leads | ||
| LEADS_CHANGED | NUMBER | Number of changed leads | ||
| LEADS_UNCHANGED | NUMBER | Number of unchanged leads | ||
| LEADS_ASSIGNED | NUMBER | Number of assigned leads | ||
| OPPS_TOTAL | NUMBER | total opportunities | ||
| OPPS_OPEN | NUMBER | open opportunities | ||
| QUOTES_TOTAL | NUMBER | Total number of quotes | ||
| QUOTES_OPEN | NUMBER | Total number of open quotes | ||
| ORDERS | NUMBER | Orders | ||
| SLEADS_TOTAL | NUMBER | total number of 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 | Number of unchanged sales leads | ||
| SLEADS_ASSIGNED | NUMBER | Number of assigned sales leads | ||
| SOPPS_TOTAL | NUMBER | total opportunities | ||
| SOPPS_OPEN | NUMBER | open opportunities | ||
| SQUOTES_TOTAL | NUMBER | Total number of quotes | ||
| SQUOTES_OPEN | NUMBER | Total number of open quotes | ||
| SORDERS | NUMBER | orders |
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_BASE;
BIM.BIM_R_LEAD_GEN_SUM_MV_BASE does not reference any database object
BIM.BIM_R_LEAD_GEN_SUM_MV_BASE is referenced by following:
BIM
BIM_R_LEAD_GEN_SUM_MV_BASE#
|
|
|
|