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

TABLE: FII.MLOG$_FII_FIN_ITEM_LEAF_HI

Object Details
Object Name: MLOG$_FII_FIN_ITEM_LEAF_HI
Object Type: TABLE
Owner: FII
Subobject Name:
Status: VALID

snapshot log for master table FII.FII_FIN_ITEM_LEAF_HIERS

Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
AGGREGATE_NEXT_LEVEL_FLAG VARCHAR2 (1)
CHILD_FIN_CAT_ID NUMBER (15)
CHILD_FLEX_VALUE_SET_ID NUMBER (15)
CHILD_LEVEL NUMBER

IS_LEAF_FLAG VARCHAR2 (1)
IS_TO_BE_ROLLED_UP_FLAG VARCHAR2 (1)
NEXT_LEVEL NUMBER

NEXT_LEVEL_FIN_CAT_ID NUMBER (15)
NEXT_LEVEL_FIN_CAT_SORT_ORDER NUMBER (15)
NEXT_LEVEL_IS_LEAF_FLAG VARCHAR2 (1)
PARENT_FIN_CAT_ID NUMBER (15)
PARENT_FLEX_VALUE_SET_ID NUMBER (15)
PARENT_LEVEL NUMBER

TOP_NODE_FIN_CAT_TYPE VARCHAR2 (10)
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 AGGREGATE_NEXT_LEVEL_FLAG
,      CHILD_FIN_CAT_ID
,      CHILD_FLEX_VALUE_SET_ID
,      CHILD_LEVEL
,      IS_LEAF_FLAG
,      IS_TO_BE_ROLLED_UP_FLAG
,      NEXT_LEVEL
,      NEXT_LEVEL_FIN_CAT_ID
,      NEXT_LEVEL_FIN_CAT_SORT_ORDER
,      NEXT_LEVEL_IS_LEAF_FLAG
,      PARENT_FIN_CAT_ID
,      PARENT_FLEX_VALUE_SET_ID
,      PARENT_LEVEL
,      TOP_NODE_FIN_CAT_TYPE
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM FII.MLOG$_FII_FIN_ITEM_LEAF_HI;

Dependencies

[top of page]

FII.MLOG$_FII_FIN_ITEM_LEAF_HI does not reference any database object

FII.MLOG$_FII_FIN_ITEM_LEAF_HI is referenced by following:

SchemaAPPS
SynonymMLOG$_FII_FIN_ITEM_LEAF_HI