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

VIEW: BIM.BIM_I_MARKETING_FACTS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

TRANSACTION_CREATE_DATE DATE

METRIC_TYPE VARCHAR2 (15)
LEAD_ID NUMBER

SOURCE_CODE_ID NUMBER

OBJECT_TYPE VARCHAR2 (30)
OBJECT_ID NUMBER

CHILD_OBJECT_TYPE VARCHAR2 (30)
CHILD_OBJECT_ID NUMBER

OBJECT_COUNTRY VARCHAR2 (30)
LEAD_RANK_ID NUMBER

OBJECT_REGION VARCHAR2 (30)
CHILD_OBJECT_COUNTRY VARCHAR2 (30)
CHILD_OBJECT_REGION VARCHAR2 (30)
BUSINESS_UNIT_ID NUMBER

START_DATE DATE

END_DATE DATE

OBJECT_STATUS VARCHAR2 (30)
CHILD_OBJECT_STATUS VARCHAR2 (30)
OBJECT_PURPOSE VARCHAR2 (240)
CHILD_OBJECT_PURPOSE VARCHAR2 (240)
ACTIVITY_ID NUMBER

CATEGORY_ID NUMBER

FROM_CURRENCY VARCHAR2 (30)
CONVERSION_RATE NUMBER

CONVERSION_RATE_S NUMBER

LEADS NUMBER

OPPORTUNITIES NUMBER

OPPORTUNITY_AMT NUMBER

OPPORTUNITY_AMT_S NUMBER

OPPORTUNITIES_OPEN NUMBER

ACTIVITY_TYPE VARCHAR2 (30)
ORDERS_BOOKED NUMBER

ORDERS_BOOKED_AMT NUMBER

ORDERS_BOOKED_AMT_S NUMBER

REVENUE_FORECASTED NUMBER

REVENUE_FORECASTED_S NUMBER

REVENUE_ACTUAL NUMBER

REVENUE_ACTUAL_S NUMBER

COST_ACTUAL NUMBER

COST_ACTUAL_S NUMBER

BUDGET_APPROVED NUMBER

BUDGET_APPROVED_S NUMBER

BUDGET_REQUESTED NUMBER

BUDGET_REQUESTED_S NUMBER

RESPONSES_FORECASTED NUMBER

RESPONSES_POSITIVE NUMBER

CUSTOMERS_NEW NUMBER

CUSTOMERS_TARGETED NUMBER

COST_FORECASTED NUMBER

COST_FORECASTED_S NUMBER

REGISTRATIONS NUMBER

CANCELLATIONS NUMBER

ATTENDANCE 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

Query Text

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


SELECT CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRANSACTION_CREATE_DATE
,      METRIC_TYPE
,      LEAD_ID
,      SOURCE_CODE_ID
,      OBJECT_TYPE
,      OBJECT_ID
,      CHILD_OBJECT_TYPE
,      CHILD_OBJECT_ID
,      OBJECT_COUNTRY
,      LEAD_RANK_ID
,      OBJECT_REGION
,      CHILD_OBJECT_COUNTRY
,      CHILD_OBJECT_REGION
,      BUSINESS_UNIT_ID
,      START_DATE
,      END_DATE
,      OBJECT_STATUS
,      CHILD_OBJECT_STATUS
,      OBJECT_PURPOSE
,      CHILD_OBJECT_PURPOSE
,      ACTIVITY_ID
,      CATEGORY_ID
,      FROM_CURRENCY
,      CONVERSION_RATE
,      CONVERSION_RATE_S
,      LEADS
,      OPPORTUNITIES
,      OPPORTUNITY_AMT
,      OPPORTUNITY_AMT_S
,      OPPORTUNITIES_OPEN
,      ACTIVITY_TYPE
,      ORDERS_BOOKED
,      ORDERS_BOOKED_AMT
,      ORDERS_BOOKED_AMT_S
,      REVENUE_FORECASTED
,      REVENUE_FORECASTED_S
,      REVENUE_ACTUAL
,      REVENUE_ACTUAL_S
,      COST_ACTUAL
,      COST_ACTUAL_S
,      BUDGET_APPROVED
,      BUDGET_APPROVED_S
,      BUDGET_REQUESTED
,      BUDGET_REQUESTED_S
,      RESPONSES_FORECASTED
,      RESPONSES_POSITIVE
,      CUSTOMERS_NEW
,      CUSTOMERS_TARGETED
,      COST_FORECASTED
,      COST_FORECASTED_S
,      REGISTRATIONS
,      CANCELLATIONS
,      ATTENDANCE
,      METRIC1
,      METRIC2
,      METRIC3
,      METRIC4
,      METRIC5
,      METRIC6
,      METRIC7
,      METRIC8
,      METRIC9
,      METRIC10
,      METRIC11
,      METRIC12
,      METRIC13
,      METRIC14
,      METRIC15
,      SECURITY_GROUP_ID
FROM BIM.BIM_I_MARKETING_FACTS#;

Dependencies

[top of page]

BIM.BIM_I_MARKETING_FACTS# references the following:

SchemaBIM
TableBIM_I_MARKETING_FACTS
BIM.BIM_I_MARKETING_FACTS# is referenced by following:

SchemaAPPS
SynonymBIM_I_MARKETING_FACTS