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: WSH.WSH_INBOUND_TXN_HISTORY

Object Details

Object Name:	WSH_INBOUND_TXN_HISTORY
Object Type:	TABLE
Owner:	WSH
FND Design Data:	WSH.WSH_INBOUND_TXN_HISTORY
Subobject Name:
Status:	VALID

WSH_INBOUND_TXN_HISTORY Stores the following Inbound related transactions :
- Routing Request
- Routing Response
- ASN
- Receipt
- Receipt Correction (Positive and Negative)
- Return To Vendor
- Return To Vendor (Positive and Negative)
- Add to Receipt

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WSH_INBOUND_TXN_HISTORY_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID
WSH_INBOUND_TXN_HISTORY_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECEIPT_NUMBER
WSH_INBOUND_TXN_HISTORY_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUPPLIER_ID TRANSACTION_TYPE
WSH_INBOUND_TXN_HISTORY_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHIPMENT_HEADER_ID
WSH_INBOUND_TXN_HISTORY_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHIPMENT_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER		Yes	Primary key to identify the transaction
TRANSACTION_TYPE	VARCHAR2	(50)	Yes	Transaction type
STATUS	VARCHAR2	(50)	Yes	Status of the transaction
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
SHIPMENT_HEADER_ID	NUMBER			Transaction header identifier
RECEIPT_NUMBER	VARCHAR2	(40)		Receipt number
REVISION_NUMBER	NUMBER			Revision number for the routing request/response
SHIPMENT_NUMBER	VARCHAR2	(30)		Shipment number
PARENT_SHIPMENT_HEADER_ID	NUMBER			Parent transaction's header Identifier
ORGANIZATION_ID	NUMBER			Source organization unique identifier
SUPPLIER_ID	NUMBER			Source supplier unique identifier
SHIPPED_DATE	DATE			Shipping date
RECEIPT_DATE	DATE			Arrival date of the shipment
MAX_RCV_TRANSACTION_ID	NUMBER			Last or latest transaction identifier under a receipt
CARRIER_ID	NUMBER			Carrier identifier
MATCH_REVERTED_BY	NUMBER			Transaction reverted by
MATCHED_BY	NUMBER			Transaction matched by
SHIPMENT_LINE_ID	NUMBER			Shipment line identifier
OBJECT_VERSION_NUMBER	NUMBER			This column is used for locking purposes
SHIP_FROM_LOCATION_ID	NUMBER			Ship from location identifier

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

WSH.WSH_INBOUND_TXN_HISTORY does not reference any database object

WSH.WSH_INBOUND_TXN_HISTORY is referenced by following:

WSH: WSH_INBOUND_TXN_HISTORY#