[Home] [Help] [Dependency Information]
Object Name: | MLOG$_BIM_SGMT_VAL_B_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
snapshot log for master table APPS.BIM_SGMT_VAL_B_MV
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 60 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEGMENT_ID | NUMBER | |||
TRANSACTION_CREATE_DATE | DATE | |||
ACQUIRED_CUSTOMERS | NUMBER | |||
LOST_CUSTOMERS | NUMBER | |||
TOTAL_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 | |||
M_ROW$$ | VARCHAR2 | (255) | ||
SEQUENCE$$ | NUMBER | |||
SNAPTIME$$ | DATE | |||
DMLTYPE$$ | VARCHAR2 | (1) | ||
OLD_NEW$$ | VARCHAR2 | (1) | ||
CHANGE_VECTOR$$ | RAW | (255) |
Cut, paste (and edit) the following text to query this object:
SELECT SEGMENT_ID
, TRANSACTION_CREATE_DATE
, ACQUIRED_CUSTOMERS
, LOST_CUSTOMERS
, TOTAL_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
, M_ROW$$
, SEQUENCE$$
, SNAPTIME$$
, DMLTYPE$$
, OLD_NEW$$
, CHANGE_VECTOR$$
FROM APPS.MLOG$_BIM_SGMT_VAL_B_MV;
APPS.MLOG$_BIM_SGMT_VAL_B_MV does not reference any database object
APPS.MLOG$_BIM_SGMT_VAL_B_MV is not referenced by any database object
|
|
|