Skip to content

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

VIEW: BIM.BIM_I_LEAD_FACTS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_CREATE_DATE DATE

LEAD_CREATION_DATE DATE

LEAD_TOUCHED_DATE DATE

LEAD_CONVERTED_DATE DATE

LEAD_DEAD_DATE DATE

LEAD_CLOSED_DATE DATE

METRIC_TYPE VARCHAR2 (15)
LEAD_ID NUMBER

LEAD_LINE_ID NUMBER

GROUP_ID NUMBER

RESOURCE_ID NUMBER

LEAD_RANK_ID NUMBER

LEAD_SOURCE VARCHAR2 (30)
LEAD_STATUS VARCHAR2 (30)
OPEN_FLAG VARCHAR2 (30)
LEAD_REGION VARCHAR2 (30)
LEAD_COUNTRY VARCHAR2 (30)
PRODUCT_CATEGORY_ID NUMBER

ITEM_ID NUMBER

ORGANIZATION_ID NUMBER

SOURCE_CODE_ID NUMBER

OBJECT_TYPE VARCHAR2 (30)
OBJECT_ID NUMBER

CHILD_OBJECT_TYPE VARCHAR2 (30)
CHILD_OBJECT_ID NUMBER

OBJECT_REGION VARCHAR2 (30)
OBJECT_COUNTRY VARCHAR2 (30)
OBJECT_STATUS VARCHAR2 (30)
OBJECT_PURPOSE VARCHAR2 (240)
CHILD_OBJECT_REGION VARCHAR2 (30)
CHILD_OBJECT_COUNTRY VARCHAR2 (30)
CHILD_OBJECT_STATUS VARCHAR2 (30)
CHILD_OBJECT_PURPOSE VARCHAR2 (240)
BUSINESS_UNIT_ID NUMBER

OBJECT_CATEGORY_ID NUMBER

LEADS NUMBER

LEADS_OPEN NUMBER

LEADS_CLOSED NUMBER

LEADS_NEW NUMBER

LEADS_DEAD NUMBER

LEADS_DECLINED NUMBER

LEADS_CHANGED NUMBER

LEADS_UNCHANGED NUMBER

LEADS_ASSIGNED NUMBER

OPPORTUNITIES NUMBER

OPPORTUNITIES_OPEN NUMBER

OPPORTUNITY_AMT NUMBER

QUOTES NUMBER

QUOTES_OPEN NUMBER

ORDERS_BOOKED NUMBER

ORDERS_BOOKED_AMT NUMBER

METRIC1 NUMBER

METRIC2 NUMBER

METRIC3 NUMBER

METRIC4 NUMBER

METRIC5 NUMBER

METRIC6 NUMBER

METRIC7 NUMBER

METRIC8 NUMBER

METRIC9 NUMBER

METRIC10 NUMBER

METRIC11 NUMBER

METRIC12 NUMBER

METRIC13 NUMBER

METRIC14 NUMBER

METRIC15 NUMBER

SECURITY_GROUP_ID NUMBER

CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

QUALIFIED_FLAG VARCHAR2 (1)
ACCEPT_FLAG VARCHAR2 (1)
CHANNEL_CODE VARCHAR2 (30)
CLOSE_REASON VARCHAR2 (30)
CUST_CATEGORY VARCHAR2 (30)
CUSTOMER_FLAG VARCHAR2 (1)
CUSTOMER_ID NUMBER

SOURCE_PRIMARY_REFERENCE VARCHAR2 (240)
SOURCE_SECONDARY_REFERENCE VARCHAR2 (240)
LEAD_AMOUNT NUMBER

STATUS_OPEN_FLAG VARCHAR2 (1)
LEAD_RANK_SCORE NUMBER

EXPIRATION_DATE DATE

LEAD_NAME VARCHAR2 (2000)
Query Text

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


SELECT TRANSACTION_CREATE_DATE
,      LEAD_CREATION_DATE
,      LEAD_TOUCHED_DATE
,      LEAD_CONVERTED_DATE
,      LEAD_DEAD_DATE
,      LEAD_CLOSED_DATE
,      METRIC_TYPE
,      LEAD_ID
,      LEAD_LINE_ID
,      GROUP_ID
,      RESOURCE_ID
,      LEAD_RANK_ID
,      LEAD_SOURCE
,      LEAD_STATUS
,      OPEN_FLAG
,      LEAD_REGION
,      LEAD_COUNTRY
,      PRODUCT_CATEGORY_ID
,      ITEM_ID
,      ORGANIZATION_ID
,      SOURCE_CODE_ID
,      OBJECT_TYPE
,      OBJECT_ID
,      CHILD_OBJECT_TYPE
,      CHILD_OBJECT_ID
,      OBJECT_REGION
,      OBJECT_COUNTRY
,      OBJECT_STATUS
,      OBJECT_PURPOSE
,      CHILD_OBJECT_REGION
,      CHILD_OBJECT_COUNTRY
,      CHILD_OBJECT_STATUS
,      CHILD_OBJECT_PURPOSE
,      BUSINESS_UNIT_ID
,      OBJECT_CATEGORY_ID
,      LEADS
,      LEADS_OPEN
,      LEADS_CLOSED
,      LEADS_NEW
,      LEADS_DEAD
,      LEADS_DECLINED
,      LEADS_CHANGED
,      LEADS_UNCHANGED
,      LEADS_ASSIGNED
,      OPPORTUNITIES
,      OPPORTUNITIES_OPEN
,      OPPORTUNITY_AMT
,      QUOTES
,      QUOTES_OPEN
,      ORDERS_BOOKED
,      ORDERS_BOOKED_AMT
,      METRIC1
,      METRIC2
,      METRIC3
,      METRIC4
,      METRIC5
,      METRIC6
,      METRIC7
,      METRIC8
,      METRIC9
,      METRIC10
,      METRIC11
,      METRIC12
,      METRIC13
,      METRIC14
,      METRIC15
,      SECURITY_GROUP_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      QUALIFIED_FLAG
,      ACCEPT_FLAG
,      CHANNEL_CODE
,      CLOSE_REASON
,      CUST_CATEGORY
,      CUSTOMER_FLAG
,      CUSTOMER_ID
,      SOURCE_PRIMARY_REFERENCE
,      SOURCE_SECONDARY_REFERENCE
,      LEAD_AMOUNT
,      STATUS_OPEN_FLAG
,      LEAD_RANK_SCORE
,      EXPIRATION_DATE
,      LEAD_NAME
FROM BIM.BIM_I_LEAD_FACTS#;

Dependencies

[top of page]

BIM.BIM_I_LEAD_FACTS# references the following:

SchemaBIM
TableBIM_I_LEAD_FACTS
BIM.BIM_I_LEAD_FACTS# is referenced by following:

SchemaAPPS
SynonymBIM_I_LEAD_FACTS