VIEW: WMS.WMS_SHIPPING_TRANSACTION_TEMP#

Source

View Text - Preformatted

select ORGANIZATION_ID ORGANIZATION_ID, DOCK_DOOR_ID DOCK_DOOR_ID, TRIP_ID TRIP_ID, TRIP_NAME TRIP_NAME, DELIVERY_ID DELIVERY_ID, DELIVERY_NAME DELIVERY_NAME, DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID, LPN_CONTENT_ID LPN_CONTENT_ID, PARENT_LPN_ID PARENT_LPN_ID, PARENT_LPN PARENT_LPN, OUTERMOST_LPN_ID OUTERMOST_LPN_ID, OUTERMOST_LPN OUTERMOST_LPN, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, STAGING_LANE_ID STAGING_LANE_ID, REQUESTED_QUANTITY REQUESTED_QUANTITY, QUANTITY QUANTITY, DOCK_APPOINT_FLAG DOCK_APPOINT_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, DIRECT_SHIP_FLAG DIRECT_SHIP_FLAG, ORIG_RELEASE_STATUS ORIG_RELEASE_STATUS from "WMS"."WMS_SHIPPING_TRANSACTION_TEMP"

View Text - HTML Formatted

SELECT ORGANIZATION_ID ORGANIZATION_ID
, DOCK_DOOR_ID DOCK_DOOR_ID
, TRIP_ID TRIP_ID
, TRIP_NAME TRIP_NAME
, DELIVERY_ID DELIVERY_ID
, DELIVERY_NAME DELIVERY_NAME
, DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID
, LPN_CONTENT_ID LPN_CONTENT_ID
, PARENT_LPN_ID PARENT_LPN_ID
, PARENT_LPN PARENT_LPN
, OUTERMOST_LPN_ID OUTERMOST_LPN_ID
, OUTERMOST_LPN OUTERMOST_LPN
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, STAGING_LANE_ID STAGING_LANE_ID
, REQUESTED_QUANTITY REQUESTED_QUANTITY
, QUANTITY QUANTITY
, DOCK_APPOINT_FLAG DOCK_APPOINT_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DIRECT_SHIP_FLAG DIRECT_SHIP_FLAG
, ORIG_RELEASE_STATUS ORIG_RELEASE_STATUS
FROM "WMS"."WMS_SHIPPING_TRANSACTION_TEMP"