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


TABLE: APPS.MLOG$_IBE_BI_CAT_MV

Object Details
Object Name: MLOG$_IBE_BI_CAT_MV
Object Type: TABLE
Owner: APPS
Subobject Name:
Status: VALID

snapshot log for master table APPS.IBE_BI_CAT_MV

Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 60
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ASSIST_FLAG VARCHAR2 (1)
BOOKED_AMT_F NUMBER

BOOKED_AMT_G NUMBER

BOOKED_AMT_G1 NUMBER

BOOKED_DATE_ID DATE

CATEGORY_ID NUMBER

CURRENCY_CD_F VARCHAR2 (30)
DISCOUNT_AMT_F NUMBER

DISCOUNT_AMT_G NUMBER

DISCOUNT_AMT_G1 NUMBER

D_BOOKED_AMT_F_CNT NUMBER

D_BOOKED_AMT_G1_CNT NUMBER

D_BOOKED_AMT_G_CNT NUMBER

D_DISCOUNT_AMT_F_CNT NUMBER

D_DISCOUNT_AMT_G1_CNT NUMBER

D_DISCOUNT_AMT_G_CNT NUMBER

D_GID NUMBER

D_LIST_AMT_F_CNT NUMBER

D_LIST_AMT_G1_CNT NUMBER

D_LIST_AMT_G_CNT NUMBER

D_TOT_CNT NUMBER

HEADER_ID NUMBER

LEAF_NODE VARCHAR2 (1)
LIST_AMT_F NUMBER

LIST_AMT_G NUMBER

LIST_AMT_G1 NUMBER

MINISITE_ID NUMBER

ORDER_ID NUMBER

PARENT_CATEGORY_ID NUMBER

TOP_NODE_FLAG VARCHAR2 (1)
UMARKER VARCHAR2 (6)
M_ROW$$ VARCHAR2 (255)
SEQUENCE$$ NUMBER

SNAPTIME$$ DATE

DMLTYPE$$ VARCHAR2 (1)
OLD_NEW$$ VARCHAR2 (1)
CHANGE_VECTOR$$ RAW (255)
Query Text

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


SELECT ASSIST_FLAG
,      BOOKED_AMT_F
,      BOOKED_AMT_G
,      BOOKED_AMT_G1
,      BOOKED_DATE_ID
,      CATEGORY_ID
,      CURRENCY_CD_F
,      DISCOUNT_AMT_F
,      DISCOUNT_AMT_G
,      DISCOUNT_AMT_G1
,      D_BOOKED_AMT_F_CNT
,      D_BOOKED_AMT_G1_CNT
,      D_BOOKED_AMT_G_CNT
,      D_DISCOUNT_AMT_F_CNT
,      D_DISCOUNT_AMT_G1_CNT
,      D_DISCOUNT_AMT_G_CNT
,      D_GID
,      D_LIST_AMT_F_CNT
,      D_LIST_AMT_G1_CNT
,      D_LIST_AMT_G_CNT
,      D_TOT_CNT
,      HEADER_ID
,      LEAF_NODE
,      LIST_AMT_F
,      LIST_AMT_G
,      LIST_AMT_G1
,      MINISITE_ID
,      ORDER_ID
,      PARENT_CATEGORY_ID
,      TOP_NODE_FLAG
,      UMARKER
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM APPS.MLOG$_IBE_BI_CAT_MV;

Dependencies

[top of page]

APPS.MLOG$_IBE_BI_CAT_MV does not reference any database object

APPS.MLOG$_IBE_BI_CAT_MV is not referenced by any database object