[Home] [Help] [Dependency Information]
Object Name: | WMS_SHIPPING_TRANSACTION_TEMP# |
---|---|
Object Type: | VIEW |
Owner: | WMS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | |||
DOCK_DOOR_ID | NUMBER | |||
TRIP_ID | NUMBER | |||
TRIP_NAME | VARCHAR2 | (30) | ||
DELIVERY_ID | NUMBER | |||
DELIVERY_NAME | VARCHAR2 | (30) | ||
DELIVERY_DETAIL_ID | NUMBER | |||
LPN_CONTENT_ID | NUMBER | |||
PARENT_LPN_ID | NUMBER | |||
PARENT_LPN | VARCHAR2 | (30) | ||
OUTERMOST_LPN_ID | NUMBER | |||
OUTERMOST_LPN | VARCHAR2 | (30) | ||
INVENTORY_ITEM_ID | NUMBER | |||
STAGING_LANE_ID | NUMBER | |||
REQUESTED_QUANTITY | NUMBER | |||
QUANTITY | NUMBER | |||
DOCK_APPOINT_FLAG | VARCHAR2 | (1) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
DIRECT_SHIP_FLAG | VARCHAR2 | (1) | ||
ORIG_RELEASE_STATUS | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, DOCK_DOOR_ID
, TRIP_ID
, TRIP_NAME
, DELIVERY_ID
, DELIVERY_NAME
, DELIVERY_DETAIL_ID
, LPN_CONTENT_ID
, PARENT_LPN_ID
, PARENT_LPN
, OUTERMOST_LPN_ID
, OUTERMOST_LPN
, INVENTORY_ITEM_ID
, STAGING_LANE_ID
, REQUESTED_QUANTITY
, QUANTITY
, DOCK_APPOINT_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, DIRECT_SHIP_FLAG
, ORIG_RELEASE_STATUS
FROM WMS.WMS_SHIPPING_TRANSACTION_TEMP#;
|
|
|