eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: ISC.ISC_DBI_DEL_LEGS_F

Object Details

Object Name:	ISC_DBI_DEL_LEGS_F
Object Type:	TABLE
Owner:	ISC
Subobject Name:
Status:	VALID

Base summary table for Transportation Management page. It is mainly built on WSH_DELIVERY_LEGS table. It contains the following dimensions: organization, shipment direction, carrier, mode of transport, service level and time. It contains the rated freight cost, gross weight in global weight uom and volume in global volume, among other delivery leg-level information.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	30
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ISC_DBI_DEL_LEGS_F_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	DELIVERY_LEG_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DELIVERY_LEG_ID	NUMBER		Yes	Primary key to identify delivery leg
CARRIER_ID	NUMBER			Freight carrier identifier
SHIPMENT_DIRECTION	VARCHAR2	(80)		Shipment direction. I=Inbound, O=Outbound, IO=Internal Sales Order, D=Drop shipment
MODE_OF_TRANSPORT	VARCHAR2	(80)		Mode of transport identifier
ORGANIZATION_ID	NUMBER			Inventory organization identifier
SERVICE_LEVEL	VARCHAR2	(80)		Service level identifier
TIME_INIT_DEPT_DATE_ID	DATE			Initial departure (truncated) date of the corresponding trip
DELIVERY_ID	NUMBER			Delivery identifier
DROP_OFF_STOP_ID	NUMBER			Drop-off stop identifier for the delivery leg
FREIGHT_COST_F	NUMBER			Freight cost amount in functional currency
FREIGHT_COST_G	NUMBER			Freight cost amount in primary global currency
FREIGHT_COST_G1	NUMBER			Freight cost amount in secondary global currency
FREIGHT_VOLUME_G	NUMBER			Freight volume in reporting volume unit of measure
FREIGHT_VOLUME_TRX	NUMBER			Freight volume in transaction unit of measure
FREIGHT_WEIGHT_G	NUMBER			Freight weight in reporting weight unit of measure
FREIGHT_WEIGHT_TRX	NUMBER			Freight weight in transaction weight unit of measure
PICK_UP_STOP_ID	NUMBER			Pick-up stop identifier for the delivery leg
TRIP_ID	NUMBER			Trip identifier
VOLUME_UOM_CODE	VARCHAR2	(30)		Transaction unit of measure for volume
WEIGHT_UOM_CODE	VARCHAR2	(30)		Transaction unit of measure for weight
CREATED_BY	NUMBER		Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO Column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER			Standard WHO Column
PROGRAM_APPLICATION_ID	NUMBER			Standard WHO Column
PROGRAM_ID	NUMBER			Standard WHO Column
PROGRAM_UPDATE_DATE	DATE			Standard WHO Column
REQUEST_ID	NUMBER			Standard WHO Column
DELIVERY_TYPE	VARCHAR2	(30)		Delivery Type
PARENT_DELIVERY_LEG_ID	NUMBER			Parent Delivery Leg Id

Query Text

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


SELECT DELIVERY_LEG_ID
,      CARRIER_ID
,      SHIPMENT_DIRECTION
,      MODE_OF_TRANSPORT
,      ORGANIZATION_ID
,      SERVICE_LEVEL
,      TIME_INIT_DEPT_DATE_ID
,      DELIVERY_ID
,      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
,      PICK_UP_STOP_ID
,      TRIP_ID
,      VOLUME_UOM_CODE
,      WEIGHT_UOM_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      DELIVERY_TYPE
,      PARENT_DELIVERY_LEG_ID
FROM ISC.ISC_DBI_DEL_LEGS_F;

Dependencies

[top of page]

ISC.ISC_DBI_DEL_LEGS_F does not reference any database object

ISC.ISC_DBI_DEL_LEGS_F is referenced by following:

APPS: ISC_DBI_DEL_LEGS_F; ISC_TRN_000_MV