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_DETAILS

Object Details

Object Name:	ISC_DBI_TMP_DEL_DETAILS
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_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	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
BATCH_ID	NUMBER			Batch Id
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

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
,      BATCH_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
FROM ISC.ISC_DBI_TMP_DEL_DETAILS;

Dependencies

[top of page]

ISC.ISC_DBI_TMP_DEL_DETAILS does not reference any database object

ISC.ISC_DBI_TMP_DEL_DETAILS is referenced by following:

APPS: ISC_DBI_TMP_DEL_DETAILS