[Home] [Help] [Dependency Information]
Object Name: | BIM_SGMT_VAL_F_MV |
---|---|
Object Type: | MATERIALIZED VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
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 |
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
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 |
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;
APPS.BIM_SGMT_VAL_F_MV is not referenced by any database object
|
|
|