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

TABLE: APPS.MLOG$_OPI_INV_VAL_SUM_MV

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

snapshot log for master table APPS.OPI_INV_VAL_SUM_MV

Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 60
PCT Used:
Columns
Name Datatype Length Mandatory Comments
AGGREGATION_LEVEL_FLAG NUMBER

DAY_ID NUMBER

GRP_ID NUMBER

INTRANSIT_VALUE_B NUMBER

INTRANSIT_VALUE_G NUMBER

INTRANSIT_VALUE_SG NUMBER

INV_CATEGORY_ID NUMBER

INV_TOTAL_VALUE_B NUMBER

INV_TOTAL_VALUE_G NUMBER

INV_TOTAL_VALUE_SG NUMBER

ITEM_ORG_ID VARCHAR2 (81)
MONTH_ID NUMBER

ONHAND_VALUE_B NUMBER

ONHAND_VALUE_G NUMBER

ONHAND_VALUE_SG NUMBER

ORGANIZATION_ID NUMBER

QTR_ID NUMBER

SOURCE NUMBER

TIME_ID NUMBER

WEEK_ID NUMBER

WIP_VALUE_B NUMBER

WIP_VALUE_G NUMBER

WIP_VALUE_SG NUMBER

YEAR_ID 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 AGGREGATION_LEVEL_FLAG
,      DAY_ID
,      GRP_ID
,      INTRANSIT_VALUE_B
,      INTRANSIT_VALUE_G
,      INTRANSIT_VALUE_SG
,      INV_CATEGORY_ID
,      INV_TOTAL_VALUE_B
,      INV_TOTAL_VALUE_G
,      INV_TOTAL_VALUE_SG
,      ITEM_ORG_ID
,      MONTH_ID
,      ONHAND_VALUE_B
,      ONHAND_VALUE_G
,      ONHAND_VALUE_SG
,      ORGANIZATION_ID
,      QTR_ID
,      SOURCE
,      TIME_ID
,      WEEK_ID
,      WIP_VALUE_B
,      WIP_VALUE_G
,      WIP_VALUE_SG
,      YEAR_ID
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM APPS.MLOG$_OPI_INV_VAL_SUM_MV;

Dependencies

[top of page]

APPS.MLOG$_OPI_INV_VAL_SUM_MV does not reference any database object

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