DBA Data[Home] [Help] [Dependency Information]

VIEW: WSH.WSH_INBOUND_TXN_HISTORY#

Object Details
Object Name: WSH_INBOUND_TXN_HISTORY#
Object Type: VIEW
Owner: WSH
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER
Yes
TRANSACTION_TYPE VARCHAR2 (50) Yes
STATUS VARCHAR2 (50) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

SHIPMENT_HEADER_ID NUMBER

RECEIPT_NUMBER VARCHAR2 (40)
REVISION_NUMBER NUMBER

SHIPMENT_NUMBER VARCHAR2 (30)
PARENT_SHIPMENT_HEADER_ID NUMBER

ORGANIZATION_ID NUMBER

SUPPLIER_ID NUMBER

SHIPPED_DATE DATE

RECEIPT_DATE DATE

MAX_RCV_TRANSACTION_ID NUMBER

CARRIER_ID NUMBER

MATCH_REVERTED_BY NUMBER

MATCHED_BY NUMBER

SHIPMENT_LINE_ID NUMBER

OBJECT_VERSION_NUMBER NUMBER

SHIP_FROM_LOCATION_ID NUMBER

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# references the following:

SchemaWSH
TableWSH_INBOUND_TXN_HISTORY
WSH.WSH_INBOUND_TXN_HISTORY# is referenced by following:

SchemaAPPS
SynonymWSH_INBOUND_TXN_HISTORY