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_DETAILS_F

Object Details

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

Base summary table for Warehouse Management page and Transportation Management page. It is mainly built on WSH_DELIVERY_DETAILS, WSH_DELIVERY_ASSIGNMENTS and WSH_NEW_DELIVERIES tables. It contains the following dimensions: item, subinventory, organization, shipment direction and time. It contains the pick-released quantity, ship-confirmed quantity in primary uom, among other delivery detail-level information.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	30
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ISC_DBI_DEL_DETAILS_F_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	DELIVERY_DETAIL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DELIVERY_DETAIL_ID	NUMBER		Yes	Primary Key to identify delivery detail line
INVENTORY_ITEM_ID	NUMBER			Inventory Item Identifier
SHIPMENT_DIRECTION	VARCHAR2	(80)		Shipment direction. I=Inbound, O=Outbound, IO=Internal Sales Order, D=Drop Shipment
ORGANIZATION_ID	NUMBER			Inventory organization identifier
SUBINVENTORY_CODE	VARCHAR2	(30)		Subinventory code
TIME_IP_DATE_ID	DATE			Ship confirmed (truncated) date
TIME_PR_DATE_ID	DATE			Pick release (truncated) date
DELIVERY_ID	NUMBER			Delivery identifier
INITIAL_PICKUP_DATE	DATE			Initial pickup date
MOVE_ORDER_LINE_ID	NUMBER			Move order line identifier
PICK_RELEASED_DATE	DATE			Pick released date
RELEASED_STATUS	VARCHAR2	(30)		Pick release status
REQUESTED_QUANTITY	NUMBER			As shipping quantity for customer
REQUESTED_QUANTITY_UOM	VARCHAR2	(30)		Unit of measure for requested quantity
SHIPPED_QUANTITY	NUMBER			Shipped quantity in shipping_quantity_uom
WMS_ENABLED_FLAG	VARCHAR2	(30)		Flag to indicate if this is a WMS enabled organization
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

Query Text

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


SELECT DELIVERY_DETAIL_ID
,      INVENTORY_ITEM_ID
,      SHIPMENT_DIRECTION
,      ORGANIZATION_ID
,      SUBINVENTORY_CODE
,      TIME_IP_DATE_ID
,      TIME_PR_DATE_ID
,      DELIVERY_ID
,      INITIAL_PICKUP_DATE
,      MOVE_ORDER_LINE_ID
,      PICK_RELEASED_DATE
,      RELEASED_STATUS
,      REQUESTED_QUANTITY
,      REQUESTED_QUANTITY_UOM
,      SHIPPED_QUANTITY
,      WMS_ENABLED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
FROM ISC.ISC_DBI_DEL_DETAILS_F;

Dependencies

[top of page]

ISC.ISC_DBI_DEL_DETAILS_F does not reference any database object

ISC.ISC_DBI_DEL_DETAILS_F is referenced by following:

APPS: ISC_DBI_DEL_DETAILS_F; ISC_WMS_000_MV; ISC_WMS_001_MV