[Home] [Help] [Dependency Information]
Object Name: | MLOG$_ISC_DBI_FM_0000_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
snapshot log for master table APPS.ISC_DBI_FM_0000_MV
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 60 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AGG_LEVEL | NUMBER | |||
BOOK_TO_SHIP_DAYS | NUMBER | |||
BOOK_TO_SHIP_DAYS_LATE | NUMBER | |||
BOOK_TO_SHIP_DAYS_LATE_P | NUMBER | |||
BUCKET10_LINE_CNT | NUMBER | |||
BUCKET1_LINE_CNT | NUMBER | |||
BUCKET2_LINE_CNT | NUMBER | |||
BUCKET3_LINE_CNT | NUMBER | |||
BUCKET4_LINE_CNT | NUMBER | |||
BUCKET5_LINE_CNT | NUMBER | |||
BUCKET6_LINE_CNT | NUMBER | |||
BUCKET7_LINE_CNT | NUMBER | |||
BUCKET8_LINE_CNT | NUMBER | |||
BUCKET9_LINE_CNT | NUMBER | |||
CUSTOMER_FLAG | NUMBER | |||
CUSTOMER_ID | NUMBER | |||
DAYS_LATE | NUMBER | |||
DAYS_LATE_PROMISE | NUMBER | |||
EARLY_LINE_CNT | NUMBER | |||
FREIGHT_CHARGE_AMT_F | NUMBER | |||
FREIGHT_CHARGE_AMT_G | NUMBER | |||
FREIGHT_CHARGE_AMT_G1 | NUMBER | |||
FREIGHT_COST_AMT_F | NUMBER | |||
FREIGHT_COST_AMT_G | NUMBER | |||
FREIGHT_COST_AMT_G1 | NUMBER | |||
INV_ORG_ID | NUMBER | |||
ITEM_CATEGORY_ID | NUMBER | |||
ITEM_CAT_FLAG | NUMBER | |||
ITEM_ID | VARCHAR2 | (81) | ||
LATE_LINE_CNT | NUMBER | |||
LATE_LINE_PROMISE_CNT | NUMBER | |||
ON_TIME_LINE_CNT | NUMBER | |||
PERIOD_TYPE_ID | NUMBER | |||
PROD_CATEGORY_ID | NUMBER | |||
SHIPPED_LATE_P_QTY | NUMBER | |||
SHIPPED_LATE_QTY | NUMBER | |||
SHIPPED_LINE_CNT | NUMBER | |||
SHIPPED_QTY | NUMBER | |||
TIME_ID | NUMBER | |||
UOM | VARCHAR2 | (30) | ||
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 AGG_LEVEL
, BOOK_TO_SHIP_DAYS
, BOOK_TO_SHIP_DAYS_LATE
, BOOK_TO_SHIP_DAYS_LATE_P
, BUCKET10_LINE_CNT
, BUCKET1_LINE_CNT
, BUCKET2_LINE_CNT
, BUCKET3_LINE_CNT
, BUCKET4_LINE_CNT
, BUCKET5_LINE_CNT
, BUCKET6_LINE_CNT
, BUCKET7_LINE_CNT
, BUCKET8_LINE_CNT
, BUCKET9_LINE_CNT
, CUSTOMER_FLAG
, CUSTOMER_ID
, DAYS_LATE
, DAYS_LATE_PROMISE
, EARLY_LINE_CNT
, FREIGHT_CHARGE_AMT_F
, FREIGHT_CHARGE_AMT_G
, FREIGHT_CHARGE_AMT_G1
, FREIGHT_COST_AMT_F
, FREIGHT_COST_AMT_G
, FREIGHT_COST_AMT_G1
, INV_ORG_ID
, ITEM_CATEGORY_ID
, ITEM_CAT_FLAG
, ITEM_ID
, LATE_LINE_CNT
, LATE_LINE_PROMISE_CNT
, ON_TIME_LINE_CNT
, PERIOD_TYPE_ID
, PROD_CATEGORY_ID
, SHIPPED_LATE_P_QTY
, SHIPPED_LATE_QTY
, SHIPPED_LINE_CNT
, SHIPPED_QTY
, TIME_ID
, UOM
, M_ROW$$
, SEQUENCE$$
, SNAPTIME$$
, DMLTYPE$$
, OLD_NEW$$
, CHANGE_VECTOR$$
FROM APPS.MLOG$_ISC_DBI_FM_0000_MV;
APPS.MLOG$_ISC_DBI_FM_0000_MV does not reference any database object
APPS.MLOG$_ISC_DBI_FM_0000_MV is not referenced by any database object
|
|
|