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

TABLE: ISC.MLOG$_ISC_BOOK_SUM2_PDUE2_

Object Details
Object Name: MLOG$_ISC_BOOK_SUM2_PDUE2_
Object Type: TABLE
Owner: ISC
Subobject Name:
Status: VALID

snapshot log for master table ISC.ISC_BOOK_SUM2_PDUE2_F

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

DAYS_LATE NUMBER

DAYS_LATE_PROMISE NUMBER

HEADER_ID NUMBER

INVENTORY_ITEM_ID NUMBER

INV_ORG_ID NUMBER

LATE_PROMISE_FLAG NUMBER

LATE_SCHEDULE_FLAG NUMBER

LINE_NUMBER VARCHAR2 (240)
ORDER_NUMBER NUMBER

PDUE_AMT_F NUMBER

PDUE_AMT_G NUMBER

PDUE_AMT_G1 NUMBER

PDUE_LINE_CNT NUMBER

PDUE_QTY NUMBER

TIME_BOOKED_DATE_ID DATE

TIME_SNAPSHOT_DATE_ID DATE

UOM VARCHAR2 (30)
M_ROW$$ VARCHAR2 (255)
SEQUENCE$$ NUMBER

SNAPTIME$$ DATE

DMLTYPE$$ VARCHAR2 (1)
OLD_NEW$$ VARCHAR2 (1)
CHANGE_VECTOR$$ RAW (255)
ITEM_TYPE_CODE VARCHAR2 (80)
LINE_ID NUMBER

TOP_MODEL_LINE_ID NUMBER

Query Text

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


SELECT CUSTOMER_ID
,      DAYS_LATE
,      DAYS_LATE_PROMISE
,      HEADER_ID
,      INVENTORY_ITEM_ID
,      INV_ORG_ID
,      LATE_PROMISE_FLAG
,      LATE_SCHEDULE_FLAG
,      LINE_NUMBER
,      ORDER_NUMBER
,      PDUE_AMT_F
,      PDUE_AMT_G
,      PDUE_AMT_G1
,      PDUE_LINE_CNT
,      PDUE_QTY
,      TIME_BOOKED_DATE_ID
,      TIME_SNAPSHOT_DATE_ID
,      UOM
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
,      ITEM_TYPE_CODE
,      LINE_ID
,      TOP_MODEL_LINE_ID
FROM ISC.MLOG$_ISC_BOOK_SUM2_PDUE2_;

Dependencies

[top of page]

ISC.MLOG$_ISC_BOOK_SUM2_PDUE2_ does not reference any database object

ISC.MLOG$_ISC_BOOK_SUM2_PDUE2_ is referenced by following:

SchemaAPPS
SynonymMLOG$_ISC_BOOK_SUM2_PDUE2_