Skip to content

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

MATERIALIZED VIEW: APPS.BIM_I_CPB_REGN_MV

Object Details
Object Name: BIM_I_CPB_REGN_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: BIM_I_CPB_REGN_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: GENERAL
Refresh Mode: DEMAND
Refresh Method: FAST
Build Mode: DEFERRED
Fast Refreshable: DIRLOAD_DML
MV Log Dependencies:

BIM_I_CPB_METR_MV
     BIM_I_MKT_CPB_MV
          BIM_I_MKT_FCT_MV
               BIM_I_EXT_COL_MV
                    BIL_BI_OPDTL_MV
                         BIL_BI_OPDTL_F
                         ENI_OLTP_ITEM_STAR
                         FII_TIME_DAY
                         JTF_RS_GROUP_USAGES
                    BIM_I_LD_BASE_MV
                         BIM_I_LD_HEADER_MV
                              BIM_I_LEAD_FACTS
                         BIM_R_CODE_DEFINITIONS
                    BIM_I_ORD_COL_MV
                         BIM_I_SOURCE_CODES
                         ENI_OLTP_ITEM_STAR
                         ISC_BOOK_SUM2_F
                    BIM_I_ORD_INT_MV
                         BIM_I_ORD_COL_MV
                              BIM_I_SOURCE_CODES
                              ENI_OLTP_ITEM_STAR
                              ISC_BOOK_SUM2_F
                         ENI_DENORM_HIERARCHIES
                         MTL_DEFAULT_CATEGORY_SETS
                    BIM_I_SOURCE_CODES
                    BIX_CALL_PRESP_MV
                         BIX_CALL_DETAILS_F
               BIM_I_MARKETING_FACTS
               BIM_I_SOURCE_CODES
          FII_TIME_DAY
     BIM_I_SOURCE_DENORM

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
TIME_ID NUMBER

PERIOD_TYPE_ID NUMBER

SOURCE_CODE_ID NUMBER (30)
IMMEDIATE_PARENT_ID NUMBER

OBJECT_REGION VARCHAR2 (30)
OBJECT_COUNTRY VARCHAR2 (30)
OBJECT_COUNTRY_C VARCHAR2 (30)
CATEGORY_ID NUMBER

CATEGORY_ID_C NUMBER

TOTAL_LEADS NUMBER

TOTAL_LEADS_C NUMBER

TOTAL_COST NUMBER

TOTAL_COST_C NUMBER

BOOKED_AMT NUMBER

BOOKED_AMT_C NUMBER

INVOICED_AMT NUMBER

INVOICED_AMT_C NUMBER

WON_OPPORTUNITY_AMT NUMBER

WON_OPPORTUNITY_AMT_C NUMBER

BUDGET_APPROVED NUMBER

BUDGET_APPROVED_C NUMBER

ACTUAL_COST NUMBER

ACTUAL_COST_C NUMBER

CUSTOMERS_TARGETED NUMBER

CUSTOMERS_TARGETED_C NUMBER

RESPONSES_FORECASTED NUMBER

RESPONSES_FORECASTED_C NUMBER

RESPONSES_POSITIVE NUMBER

RESPONSES_POSITIVE_C NUMBER

TOTAL_COST_S NUMBER

TOTAL_COST_S_C NUMBER

BOOKED_AMT_S NUMBER

BOOKED_AMT_S_C NUMBER

INVOICED_AMT_S NUMBER

INVOICED_AMT_S_C NUMBER

WON_OPPORTUNITY_AMT_S NUMBER

WON_OPPORTUNITY_AMT_S_C NUMBER

BUDGET_APPROVED_S NUMBER

BUDGET_APPROVED_S_C NUMBER

ACTUAL_COST_S NUMBER

ACTUAL_COST_S_C NUMBER

BUDGET_APPROVED_SCH NUMBER

BUDGET_APPROVED_SCH_C NUMBER

BUDGET_APPROVED_SCH_S NUMBER

BUDGET_APPROVED_SCH_S_C NUMBER

ALL_C NUMBER

GROUPING_ID NUMBER

Query Text

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


SELECT TIME_ID
,      PERIOD_TYPE_ID
,      SOURCE_CODE_ID
,      IMMEDIATE_PARENT_ID
,      OBJECT_REGION
,      OBJECT_COUNTRY
,      OBJECT_COUNTRY_C
,      CATEGORY_ID
,      CATEGORY_ID_C
,      TOTAL_LEADS
,      TOTAL_LEADS_C
,      TOTAL_COST
,      TOTAL_COST_C
,      BOOKED_AMT
,      BOOKED_AMT_C
,      INVOICED_AMT
,      INVOICED_AMT_C
,      WON_OPPORTUNITY_AMT
,      WON_OPPORTUNITY_AMT_C
,      BUDGET_APPROVED
,      BUDGET_APPROVED_C
,      ACTUAL_COST
,      ACTUAL_COST_C
,      CUSTOMERS_TARGETED
,      CUSTOMERS_TARGETED_C
,      RESPONSES_FORECASTED
,      RESPONSES_FORECASTED_C
,      RESPONSES_POSITIVE
,      RESPONSES_POSITIVE_C
,      TOTAL_COST_S
,      TOTAL_COST_S_C
,      BOOKED_AMT_S
,      BOOKED_AMT_S_C
,      INVOICED_AMT_S
,      INVOICED_AMT_S_C
,      WON_OPPORTUNITY_AMT_S
,      WON_OPPORTUNITY_AMT_S_C
,      BUDGET_APPROVED_S
,      BUDGET_APPROVED_S_C
,      ACTUAL_COST_S
,      ACTUAL_COST_S_C
,      BUDGET_APPROVED_SCH
,      BUDGET_APPROVED_SCH_C
,      BUDGET_APPROVED_SCH_S
,      BUDGET_APPROVED_SCH_S_C
,      ALL_C
,      GROUPING_ID
FROM APPS.BIM_I_CPB_REGN_MV;

Dependencies

[top of page]

APPS.BIM_I_CPB_REGN_MV references the following:

SchemaAPPS
TableBIM_I_CPB_METR_MV
Materialized ViewBIM_I_CPB_METR_MV
TableBIM_I_CPB_REGN_MV

APPS.BIM_I_CPB_REGN_MV is not referenced by any database object