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_TMP_DEL_LEGS

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	30
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ISC_DBI_TMP_DEL_LEGS_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	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
BATCH_ID	NUMBER			Batch identifier
CONVERSION_DATE	DATE			Currency conversion date
CONVERSION_RATE	NUMBER			Currency conversion rate
CONVERSION_TYPE_CODE	VARCHAR2	(80)		Currency conversion type code
DELIVERY_ID	NUMBER			Delivery identifier
DROP_OFF_STOP_ID	NUMBER			Drop-off stop identifier for the delivery leg
FREIGHT_COST_TRX	NUMBER			Freight cost in transaction
FREIGHT_VOLUME_TRX	NUMBER			Freight volume in transaction 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
TRX_CURRENCY_CODE	VARCHAR2	(30)		Transactional currency code
VOLUME_UOM_CODE	VARCHAR2	(30)		Transaction unit of measure for volume
WEIGHT_UOM_CODE	VARCHAR2	(30)		Transaction unit of measure for weight
WH_CURRENCY_CODE	VARCHAR2	(30)		Warehouse currency code
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
,      BATCH_ID
,      CONVERSION_DATE
,      CONVERSION_RATE
,      CONVERSION_TYPE_CODE
,      DELIVERY_ID
,      DROP_OFF_STOP_ID
,      FREIGHT_COST_TRX
,      FREIGHT_VOLUME_TRX
,      FREIGHT_WEIGHT_TRX
,      PICK_UP_STOP_ID
,      TRIP_ID
,      TRX_CURRENCY_CODE
,      VOLUME_UOM_CODE
,      WEIGHT_UOM_CODE
,      WH_CURRENCY_CODE
,      DELIVERY_TYPE
,      PARENT_DELIVERY_LEG_ID
FROM ISC.ISC_DBI_TMP_DEL_LEGS;

Dependencies

[top of page]

ISC.ISC_DBI_TMP_DEL_LEGS does not reference any database object

ISC.ISC_DBI_TMP_DEL_LEGS is referenced by following:

APPS: ISC_DBI_TMP_DEL_LEGS