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


TABLE: APPS.BIM_SGMT_VAL_F_MV

Object Details
Object Name: BIM_SGMT_VAL_F_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.BIM_SGMT_VAL_F_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
I_SNAP$_BIM_SGMT_VAL_F_MV FUNCTION-BASED NORMAL UNIQUE TablespaceAPPS_TS_TX_DATA ColumnSYS_OP_MAP_NONNULL("SEGMENT_ID")
ColumnSYS_OP_MAP_NONNULL("DUMMY1_FR")
ColumnSYS_OP_MAP_NONNULL("DUMMY2_FR")
ColumnSYS_OP_MAP_NONNULL("DUMMY3_FR")
ColumnSYS_OP_MAP_NONNULL("DUMMY4_FR")
ColumnSYS_OP_MAP_NONNULL("DUMMY5_FR")
ColumnSYS_OP_MAP_NONNULL("DUMMY6_FR")
BIM_SGMT_VAL_F_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTIME_ID
ColumnPERIOD_TYPE_ID
ColumnSEGMENT_ID
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 does not reference any database object

APPS.BIM_SGMT_VAL_F_MV is referenced by following:

SchemaAPPS
Materialized ViewBIM_SGMT_VAL_F_MV