[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 30 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ISC_DBI_DEL_DETAILS_F_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | DELIVERY_DETAIL_ID |
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 |
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;
ISC.ISC_DBI_DEL_DETAILS_F does not reference any database object
ISC.ISC_DBI_DEL_DETAILS_F is referenced by following:
|
|
|