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

TABLE: ISC.MLOG$_ISC_DBI_DEL_DETAILS_

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

snapshot log for master table ISC.ISC_DBI_DEL_DETAILS_F

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

DELIVERY_ID NUMBER

INITIAL_PICKUP_DATE DATE

INVENTORY_ITEM_ID NUMBER

MOVE_ORDER_LINE_ID NUMBER

ORGANIZATION_ID NUMBER

PICK_RELEASED_DATE DATE

RELEASED_STATUS VARCHAR2 (30)
REQUESTED_QUANTITY NUMBER

REQUESTED_QUANTITY_UOM VARCHAR2 (30)
SHIPMENT_DIRECTION VARCHAR2 (80)
SHIPPED_QUANTITY NUMBER

SUBINVENTORY_CODE VARCHAR2 (30)
TIME_IP_DATE_ID DATE

TIME_PR_DATE_ID DATE

WMS_ENABLED_FLAG VARCHAR2 (30)
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 DELIVERY_DETAIL_ID
,      DELIVERY_ID
,      INITIAL_PICKUP_DATE
,      INVENTORY_ITEM_ID
,      MOVE_ORDER_LINE_ID
,      ORGANIZATION_ID
,      PICK_RELEASED_DATE
,      RELEASED_STATUS
,      REQUESTED_QUANTITY
,      REQUESTED_QUANTITY_UOM
,      SHIPMENT_DIRECTION
,      SHIPPED_QUANTITY
,      SUBINVENTORY_CODE
,      TIME_IP_DATE_ID
,      TIME_PR_DATE_ID
,      WMS_ENABLED_FLAG
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM ISC.MLOG$_ISC_DBI_DEL_DETAILS_;

Dependencies

[top of page]

ISC.MLOG$_ISC_DBI_DEL_DETAILS_ does not reference any database object

ISC.MLOG$_ISC_DBI_DEL_DETAILS_ is referenced by following:

SchemaAPPS
SynonymMLOG$_ISC_DBI_DEL_DETAILS_