Skip to content

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

MATERIALIZED VIEW: APPS.BIM_SGMT_VAL_F_MV

Object Details
Object Name: BIM_SGMT_VAL_F_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: BIM_SGMT_VAL_F_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_SGMT_VAL_B_MV
     BIM_I_PARTY_SGMT_FACTS
     BIM_I_PARTY_SGMT_FACTS
     BIM_I_SGMT_FACTS
     BIM_I_SGMT_FACTS
     FII_AR_REVENUE_B
     ISC_BOOK_SUM2_F
FII_TIME_DAY

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
TIME_ID NUMBER

PERIOD_TYPE_ID NUMBER

SEGMENT_ID NUMBER

ACQUIRED_CUSTOMERS NUMBER

TOTAL_CUSTOMERS NUMBER

LOST_CUSTOMERS NUMBER

SEGMENT_SIZE NUMBER

BOOKED_AMT NUMBER

BOOKED_AMT_S NUMBER

BOOKED_COUNT NUMBER

REVENUE NUMBER

REVENUE_S NUMBER

ACQUIRED_CUSTOMERS_C NUMBER

TOTAL_CUSTOMERS_C NUMBER

LOST_CUSTOMERS_C NUMBER

SEGMENT_SIZE_C NUMBER

BOOKED_AMT_C NUMBER

BOOKED_AMT_S_C NUMBER

BOOKED_COUNT_C NUMBER

REVENUE_C NUMBER

REVENUE_S_C NUMBER

DUMMY1_FR NUMBER

DUMMY2_FR NUMBER

DUMMY3_FR NUMBER

DUMMY4_FR NUMBER

DUMMY5_FR NUMBER

DUMMY6_FR NUMBER

ALL_C NUMBER

Query Text

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


SELECT TIME_ID
,      PERIOD_TYPE_ID
,      SEGMENT_ID
,      ACQUIRED_CUSTOMERS
,      TOTAL_CUSTOMERS
,      LOST_CUSTOMERS
,      SEGMENT_SIZE
,      BOOKED_AMT
,      BOOKED_AMT_S
,      BOOKED_COUNT
,      REVENUE
,      REVENUE_S
,      ACQUIRED_CUSTOMERS_C
,      TOTAL_CUSTOMERS_C
,      LOST_CUSTOMERS_C
,      SEGMENT_SIZE_C
,      BOOKED_AMT_C
,      BOOKED_AMT_S_C
,      BOOKED_COUNT_C
,      REVENUE_C
,      REVENUE_S_C
,      DUMMY1_FR
,      DUMMY2_FR
,      DUMMY3_FR
,      DUMMY4_FR
,      DUMMY5_FR
,      DUMMY6_FR
,      ALL_C
FROM APPS.BIM_SGMT_VAL_F_MV;

Dependencies

[top of page]

APPS.BIM_SGMT_VAL_F_MV references the following:

SchemaAPPS
TableBIM_SGMT_VAL_B_MV
Materialized ViewBIM_SGMT_VAL_B_MV
TableBIM_SGMT_VAL_F_MV
SchemaFII
TableFII_TIME_DAY

APPS.BIM_SGMT_VAL_F_MV is not referenced by any database object