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

VIEW: BIM.BIM_R_IRES_SUM_MV#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
SCHEDULE_REGION VARCHAR2 (30)
SCHEDULE_COUNTRY VARCHAR2 (30)
CAMPAIGN_REGION VARCHAR2 (30)
CAMPAIGN_COUNTRY VARCHAR2 (30)
BUSINESS_UNIT_ID NUMBER

SCHEDULE_ACTIVITY_ID NUMBER

CAMPAIGN_ID NUMBER

CAMPAIGN_NAME VARCHAR2 (240)
REPORT_TYPE VARCHAR2 (30)
YEAR VARCHAR2 (30)
QTR VARCHAR2 (30)
MONTH VARCHAR2 (30)
MONTH_ORDER NUMBER

AGGREGATE_BY VARCHAR2 (30)
DISPLAY_TYPE VARCHAR2 (30)
COST_CURR_PERIOD NUMBER

CURRENT_PR_COUNT NUMBER

CURRENT_PR_ADDED NUMBER

PREVIOUS_PR_COUNT NUMBER

PREVIOUS_PR_ADDED NUMBER

CURRENT_CONVERTED NUMBER

PREVIOUS_CONVERTED NUMBER

CAMPAIGN_COUNT NUMBER

FORECASTED_RESPONSES NUMBER

TARGETED_CUSTOMERS NUMBER

RESOURCE_ID NUMBER

Query Text

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


SELECT SCHEDULE_REGION
,      SCHEDULE_COUNTRY
,      CAMPAIGN_REGION
,      CAMPAIGN_COUNTRY
,      BUSINESS_UNIT_ID
,      SCHEDULE_ACTIVITY_ID
,      CAMPAIGN_ID
,      CAMPAIGN_NAME
,      REPORT_TYPE
,      YEAR
,      QTR
,      MONTH
,      MONTH_ORDER
,      AGGREGATE_BY
,      DISPLAY_TYPE
,      COST_CURR_PERIOD
,      CURRENT_PR_COUNT
,      CURRENT_PR_ADDED
,      PREVIOUS_PR_COUNT
,      PREVIOUS_PR_ADDED
,      CURRENT_CONVERTED
,      PREVIOUS_CONVERTED
,      CAMPAIGN_COUNT
,      FORECASTED_RESPONSES
,      TARGETED_CUSTOMERS
,      RESOURCE_ID
FROM BIM.BIM_R_IRES_SUM_MV#;

Dependencies

[top of page]

BIM.BIM_R_IRES_SUM_MV# references the following:

SchemaBIM
TableBIM_R_IRES_SUM_MV
BIM.BIM_R_IRES_SUM_MV# is referenced by following:

SchemaAPPS
SynonymBIM_R_IRES_SUM_MV