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

TABLE: ISC.MLOG$_ISC_DBI_DEL_LEGS_F

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

snapshot log for master table ISC.ISC_DBI_DEL_LEGS_F

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

DELIVERY_ID NUMBER

DELIVERY_LEG_ID NUMBER

DELIVERY_TYPE VARCHAR2 (30)
DROP_OFF_STOP_ID NUMBER

FREIGHT_COST_F NUMBER

FREIGHT_COST_G NUMBER

FREIGHT_COST_G1 NUMBER

FREIGHT_VOLUME_G NUMBER

FREIGHT_VOLUME_TRX NUMBER

FREIGHT_WEIGHT_G NUMBER

FREIGHT_WEIGHT_TRX NUMBER

MODE_OF_TRANSPORT VARCHAR2 (80)
ORGANIZATION_ID NUMBER

PARENT_DELIVERY_LEG_ID NUMBER

PICK_UP_STOP_ID NUMBER

SERVICE_LEVEL VARCHAR2 (80)
SHIPMENT_DIRECTION VARCHAR2 (80)
TIME_INIT_DEPT_DATE_ID DATE

TRIP_ID NUMBER

VOLUME_UOM_CODE VARCHAR2 (30)
WEIGHT_UOM_CODE 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 CARRIER_ID
,      DELIVERY_ID
,      DELIVERY_LEG_ID
,      DELIVERY_TYPE
,      DROP_OFF_STOP_ID
,      FREIGHT_COST_F
,      FREIGHT_COST_G
,      FREIGHT_COST_G1
,      FREIGHT_VOLUME_G
,      FREIGHT_VOLUME_TRX
,      FREIGHT_WEIGHT_G
,      FREIGHT_WEIGHT_TRX
,      MODE_OF_TRANSPORT
,      ORGANIZATION_ID
,      PARENT_DELIVERY_LEG_ID
,      PICK_UP_STOP_ID
,      SERVICE_LEVEL
,      SHIPMENT_DIRECTION
,      TIME_INIT_DEPT_DATE_ID
,      TRIP_ID
,      VOLUME_UOM_CODE
,      WEIGHT_UOM_CODE
,      M_ROW$$
,      SEQUENCE$$
,      SNAPTIME$$
,      DMLTYPE$$
,      OLD_NEW$$
,      CHANGE_VECTOR$$
FROM ISC.MLOG$_ISC_DBI_DEL_LEGS_F;

Dependencies

[top of page]

ISC.MLOG$_ISC_DBI_DEL_LEGS_F does not reference any database object

ISC.MLOG$_ISC_DBI_DEL_LEGS_F is referenced by following:

SchemaAPPS
SynonymMLOG$_ISC_DBI_DEL_LEGS_F