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

MATERIALIZED VIEW: APPS.BIM_SGMT_VAL_B_MV

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

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

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
UMARK NUMBER

SEGMENT_ID NUMBER

TRANSACTION_CREATE_DATE DATE

ACQUIRED_CUSTOMERS NUMBER

TOTAL_CUSTOMERS NUMBER

LOST_CUSTOMERS NUMBER

SEGMENT_SIZE NUMBER

SEGEMENT_SIZE_C NUMBER

BOOKED_AMT NUMBER

BOOKED_AMT_C NUMBER

BOOKED_AMT_S NUMBER

BOOKED_AMT_S_C NUMBER

BOOKED_COUNT NUMBER

REVENUE NUMBER

REVENUE_C NUMBER

REVENUE_S NUMBER

REVENUE_S_C NUMBER

COUNT_ALL NUMBER

Query Text

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


SELECT UMARK
,      SEGMENT_ID
,      TRANSACTION_CREATE_DATE
,      ACQUIRED_CUSTOMERS
,      TOTAL_CUSTOMERS
,      LOST_CUSTOMERS
,      SEGMENT_SIZE
,      SEGEMENT_SIZE_C
,      BOOKED_AMT
,      BOOKED_AMT_C
,      BOOKED_AMT_S
,      BOOKED_AMT_S_C
,      BOOKED_COUNT
,      REVENUE
,      REVENUE_C
,      REVENUE_S
,      REVENUE_S_C
,      COUNT_ALL
FROM APPS.BIM_SGMT_VAL_B_MV;

Dependencies

[top of page]

APPS.BIM_SGMT_VAL_B_MV references the following:

SchemaAPPS
SynonymBIM_I_PARTY_SGMT_FACTS
SynonymBIM_I_SGMT_FACTS
TableBIM_SGMT_VAL_B_MV
SchemaBIM
TableBIM_I_PARTY_SGMT_FACTS
TableBIM_I_SGMT_FACTS
SchemaFII
TableFII_AR_REVENUE_B
SchemaISC
TableISC_BOOK_SUM2_F
APPS.BIM_SGMT_VAL_B_MV is referenced by following:

SchemaAPPS
Materialized ViewBIM_SGMT_VAL_F_MV