VIEW: WSH.WSH_INBOUND_TXN_HISTORY#

Source

View Text - Preformatted

select TRANSACTION_ID TRANSACTION_ID, TRANSACTION_TYPE TRANSACTION_TYPE, STATUS STATUS, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID, RECEIPT_NUMBER RECEIPT_NUMBER, REVISION_NUMBER REVISION_NUMBER, SHIPMENT_NUMBER SHIPMENT_NUMBER, PARENT_SHIPMENT_HEADER_ID PARENT_SHIPMENT_HEADER_ID, ORGANIZATION_ID ORGANIZATION_ID, SUPPLIER_ID SUPPLIER_ID, SHIPPED_DATE SHIPPED_DATE, RECEIPT_DATE RECEIPT_DATE, MAX_RCV_TRANSACTION_ID MAX_RCV_TRANSACTION_ID, CARRIER_ID CARRIER_ID, MATCH_REVERTED_BY MATCH_REVERTED_BY, MATCHED_BY MATCHED_BY, SHIPMENT_LINE_ID SHIPMENT_LINE_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SHIP_FROM_LOCATION_ID SHIP_FROM_LOCATION_ID from "WSH"."WSH_INBOUND_TXN_HISTORY"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, TRANSACTION_TYPE TRANSACTION_TYPE
, STATUS STATUS
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID
, RECEIPT_NUMBER RECEIPT_NUMBER
, REVISION_NUMBER REVISION_NUMBER
, SHIPMENT_NUMBER SHIPMENT_NUMBER
, PARENT_SHIPMENT_HEADER_ID PARENT_SHIPMENT_HEADER_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SUPPLIER_ID SUPPLIER_ID
, SHIPPED_DATE SHIPPED_DATE
, RECEIPT_DATE RECEIPT_DATE
, MAX_RCV_TRANSACTION_ID MAX_RCV_TRANSACTION_ID
, CARRIER_ID CARRIER_ID
, MATCH_REVERTED_BY MATCH_REVERTED_BY
, MATCHED_BY MATCHED_BY
, SHIPMENT_LINE_ID SHIPMENT_LINE_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SHIP_FROM_LOCATION_ID SHIP_FROM_LOCATION_ID
FROM "WSH"."WSH_INBOUND_TXN_HISTORY"