[Home] [Help] [Dependency Information]
Object Name: | ISC_DBI_TMP_DEL_LEGS |
---|---|
Object Type: | TABLE |
Owner: | ISC |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 30 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ISC_DBI_TMP_DEL_LEGS_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE | DELIVERY_LEG_ID |
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 |
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;
ISC.ISC_DBI_TMP_DEL_LEGS does not reference any database object
ISC.ISC_DBI_TMP_DEL_LEGS is referenced by following:
|
|
|