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


TABLE: APPS.MLOG$_MTH_MTL_CONS_IT_MV

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

snapshot log for master table APPS.MTH_MTL_CONS_IT_MV

Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ACTUAL_USAGE_QTY_G NUMBER

ACTUAL_USAGE_QTY_G_COUNT NUMBER

ACTUAL_USAGE_QTY_SG NUMBER

ACTUAL_USAGE_QTY_SG_COUNT NUMBER

ACTUAL_USAGE_VAL NUMBER

ACTUAL_USAGE_VAL_COUNT NUMBER

CALENDAR_MONTH_ID NUMBER

DAY_ID NUMBER

ITEM_LEVEL9_KEY NUMBER

PLANNED_USAGE_QTY_G NUMBER

PLANNED_USAGE_QTY_G_COUNT NUMBER

PLANNED_USAGE_QTY_SG NUMBER

PLANNED_USAGE_QTY_SG_COUNT NUMBER

PLANNED_USAGE_VAL NUMBER

PLANNED_USAGE_VAL_COUNT NUMBER

PRODUCT_FK_KEY NUMBER

PRODUCT_LEVEL9_KEY NUMBER

TOTAL_COUNT NUMBER

UNIT_STANDARD_QTY_G NUMBER

UNIT_STANDARD_QTY_G_COUNT NUMBER

UNIT_STANDARD_QTY_SG NUMBER

UNIT_STANDARD_QTY_SG_COUNT NUMBER

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 ACTUAL_USAGE_QTY_G
,      ACTUAL_USAGE_QTY_G_COUNT
,      ACTUAL_USAGE_QTY_SG
,      ACTUAL_USAGE_QTY_SG_COUNT
,      ACTUAL_USAGE_VAL
,      ACTUAL_USAGE_VAL_COUNT
,      CALENDAR_MONTH_ID
,      DAY_ID
,      ITEM_LEVEL9_KEY
,      PLANNED_USAGE_QTY_G
,      PLANNED_USAGE_QTY_G_COUNT
,      PLANNED_USAGE_QTY_SG
,      PLANNED_USAGE_QTY_SG_COUNT
,      PLANNED_USAGE_VAL
,      PLANNED_USAGE_VAL_COUNT
,      PRODUCT_FK_KEY
,      PRODUCT_LEVEL9_KEY
,      TOTAL_COUNT
,      UNIT_STANDARD_QTY_G
,      UNIT_STANDARD_QTY_G_COUNT
,      UNIT_STANDARD_QTY_SG
,      UNIT_STANDARD_QTY_SG_COUNT
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM APPS.MLOG$_MTH_MTL_CONS_IT_MV;

Dependencies

[top of page]

APPS.MLOG$_MTH_MTL_CONS_IT_MV does not reference any database object

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