Skip to content

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

VIEW: BIM.BIM_R_CAMP_LOAD#

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

[View Source]

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

CAMPAIGN_ID NUMBER

SCHEDULE_ID NUMBER

PARENT_CAMPAIGN_ID NUMBER

CAMPAIGN_REGION VARCHAR2 (30)
SCHEDULE_REGION VARCHAR2 (30)
CAMPAIGN_COUNTRY NUMBER (30)
SCHEDULE_COUNTRY NUMBER (30)
CAMPAIGN_SOURCE_CODE VARCHAR2 (30)
SCHEDULE_SOURCE_CODE VARCHAR2 (30)
START_DATE DATE

END_DATE DATE

BUSINESS_UNIT_ID NUMBER

CAMPAIGN_TYPE VARCHAR2 (30)
SCHEDULE_ACTIVITY_TYPE VARCHAR2 (30)
SCHEDULE_ACTIVITY_ID NUMBER

CAMPAIGN_PURPOSE VARCHAR2 (240)
SCHEDULE_PURPOSE VARCHAR2 (240)
CAMPAIGN_STATUS VARCHAR2 (30)
CAMPAIGN_BUDGET_FC NUMBER

SCHEDULE_BUDGET_FC NUMBER

SCHEDULE_STATUS VARCHAR2 (30)
LEADS_QUALIFIED NUMBER

LEADS_QUALIFIED_AMT NUMBER

LEADS_UNQUALIFIED NUMBER

LEADS_UNQUALIFIED_AMT NUMBER

OPPORTUNITIES NUMBER

OPPORTUNITY_AMT NUMBER

ORDERS NUMBER

ORDERS_ACTIVE NUMBER

ORDERS_ACTIVE_AMT NUMBER

ORDERS_CANCELLED NUMBER

ORDERS_CANCELLED_AMT NUMBER

POSITIVE_RESPONSES NUMBER

FORECASTED_COST NUMBER

ACTUAL_COST NUMBER

REVENUE NUMBER

TARGETED_CUSTOMERS NUMBER

BUDGET_REQUESTED NUMBER

BUDGET_APPROVED NUMBER

NEW_CUSTOMERS NUMBER

CURRENCY_CODE VARCHAR2 (15)
TRANSACTION_CREATE_DATE DATE
Yes
DELETE_FLAG VARCHAR2 (1)
ORG_ID NUMBER

SECURITY_GROUP_CODE NUMBER

SECURITY_GROUP_ID NUMBER

LOAD_DATE DATE

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

ACTUAL_REVENUE NUMBER

FORECASTED_RESPONSES NUMBER

ORDERS_BOOKED NUMBER

ORDERS_BOOKED_AMT NUMBER

LEADS_OPEN NUMBER

LEADS_OPEN_AMT NUMBER

LEADS_CLOSED NUMBER

LEADS_CLOSED_AMT NUMBER

LEADS_NEW NUMBER

LEADS_NEW_AMT NUMBER

LEADS_HOT NUMBER

LEADS_CONVERTED 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

Query Text

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


SELECT CAMPAIGN_DAILY_TRANSACTION_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CAMPAIGN_ID
,      SCHEDULE_ID
,      PARENT_CAMPAIGN_ID
,      CAMPAIGN_REGION
,      SCHEDULE_REGION
,      CAMPAIGN_COUNTRY
,      SCHEDULE_COUNTRY
,      CAMPAIGN_SOURCE_CODE
,      SCHEDULE_SOURCE_CODE
,      START_DATE
,      END_DATE
,      BUSINESS_UNIT_ID
,      CAMPAIGN_TYPE
,      SCHEDULE_ACTIVITY_TYPE
,      SCHEDULE_ACTIVITY_ID
,      CAMPAIGN_PURPOSE
,      SCHEDULE_PURPOSE
,      CAMPAIGN_STATUS
,      CAMPAIGN_BUDGET_FC
,      SCHEDULE_BUDGET_FC
,      SCHEDULE_STATUS
,      LEADS_QUALIFIED
,      LEADS_QUALIFIED_AMT
,      LEADS_UNQUALIFIED
,      LEADS_UNQUALIFIED_AMT
,      OPPORTUNITIES
,      OPPORTUNITY_AMT
,      ORDERS
,      ORDERS_ACTIVE
,      ORDERS_ACTIVE_AMT
,      ORDERS_CANCELLED
,      ORDERS_CANCELLED_AMT
,      POSITIVE_RESPONSES
,      FORECASTED_COST
,      ACTUAL_COST
,      REVENUE
,      TARGETED_CUSTOMERS
,      BUDGET_REQUESTED
,      BUDGET_APPROVED
,      NEW_CUSTOMERS
,      CURRENCY_CODE
,      RELATED_EVENT_TYPE
,      RELATED_EVENT_ID
,      TRANSACTION_CREATE_DATE
,      DELETE_FLAG
,      ORG_ID
,      SECURITY_GROUP_CODE
,      SECURITY_GROUP_ID
,      LOAD_DATE
,      MONTH
,      QTR
,      YEAR
,      FORECASTED_REVENUE
,      ACTUAL_REVENUE
,      FORECASTED_RESPONSES
,      ORDERS_BOOKED
,      ORDERS_BOOKED_AMT
,      LEADS_OPEN
,      LEADS_OPEN_AMT
,      LEADS_CLOSED
,      LEADS_CLOSED_AMT
,      LEADS_NEW
,      LEADS_NEW_AMT
,      LEADS_HOT
,      LEADS_CONVERTED
,      METRIC1
,      METRIC2
,      METRIC3
,      METRIC4
,      METRIC5
,      METRIC6
,      METRIC7
,      METRIC8
,      METRIC9
,      METRIC10
,      METRIC11
,      METRIC12
,      METRIC13
,      METRIC14
,      METRIC15
FROM BIM.BIM_R_CAMP_LOAD#;

Dependencies

[top of page]

BIM.BIM_R_CAMP_LOAD# references the following:

SchemaBIM
TableBIM_R_CAMP_LOAD
BIM.BIM_R_CAMP_LOAD# is referenced by following:

SchemaAPPS
SynonymBIM_R_CAMP_LOAD