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

VIEW: BIM.BIM_R_LEAD_GEN_SUM_MV#

Object Details
Object Name: BIM_R_LEAD_GEN_SUM_MV#
Object Type: VIEW
Owner: BIM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
GROUP_ID NUMBER

GROUP_NAME VARCHAR2 (60)
REGION VARCHAR2 (30)
COUNTRY VARCHAR2 (30)
BUSINESS_UNIT_ID NUMBER

YEAR VARCHAR2 (30)
QTR VARCHAR2 (30)
MONTH VARCHAR2 (30)
MONTH_ORDER NUMBER

AGGREGATE_BY VARCHAR2 (30)
DISPLAY_TYPE VARCHAR2 (30)
LEADS_TOTAL NUMBER

LEADS_OPEN NUMBER

LEADS_CLOSED NUMBER

LEADS_NEW NUMBER

LEADS_DEAD NUMBER

LEADS_CHANGED NUMBER

LEADS_UNCHANGED NUMBER

LEADS_ASSIGNED NUMBER

OPPS_TOTAL NUMBER

OPPS_OPEN NUMBER

QUOTES_TOTAL NUMBER

QUOTES_OPEN NUMBER

ORDERS NUMBER

SLEADS_TOTAL NUMBER

SLEADS_OPEN NUMBER

SLEADS_CLOSED NUMBER

SLEADS_NEW NUMBER

SLEADS_DEAD NUMBER

SLEADS_CHANGED NUMBER

SLEADS_UNCHANGED NUMBER

SLEADS_ASSIGNED NUMBER

SOPPS_TOTAL NUMBER

SOPPS_OPEN NUMBER

SQUOTES_TOTAL NUMBER

SQUOTES_OPEN NUMBER

SORDERS NUMBER

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# references the following:

SchemaBIM
TableBIM_R_LEAD_GEN_SUM_MV
BIM.BIM_R_LEAD_GEN_SUM_MV# is referenced by following:

SchemaAPPS
SynonymBIM_R_LEAD_GEN_SUM_MV