View: WSH_SS2_SHIPMENT_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_SS2_SHIPMENT_V

View Text

SELECT WTH.DOCUMENT_NUMBER DOCUMENT_NUMBER
, WSB.BATCH_ID SHIPMENT_BATCH_ID
, WTH.ACTION_TYPE ACTION_TYPE
, WTH.CREATION_DATE CREATION_DATE
, WSB.ORGANIZATION_ID ORGANIZATION_ID
, OOG.ORGANIZATION_CODE ORGANIZATION_CODE
, WSB.SHIP_FROM_LOCATION_ID SHIP_FROM_LOCATION_ID
, WSB.CUSTOMER_ID CUSTOMER_ID
, WSB.SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, WSB.INVOICE_TO_SITE_USE_ID INVOICE_TO_SITE_USE_ID
, WSB.DELIVER_TO_SITE_USE_ID DELIVER_TO_SITE_USE_ID
, WSB.SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID
, WSB.INVOICE_TO_CONTACT_ID INVOICE_TO_CONTACT_ID
, WSB.DELIVER_TO_CONTACT_ID DELIVER_TO_CONTACT_ID
, WSB.SHIP_METHOD_CODE SHIP_METHOD_CODE
, WSB.FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE
, WSB.FOB_CODE FOB_CODE
, WSB.CURRENCY_CODE CURRENCY_CODE
, WSB.ORG_ID ORG_ID
, WSB.PENDING_REQUEST_FLAG PENDING_REQUEST_FLAG
FROM WSH_TRANSACTIONS_HISTORY WTH
, WSH_SHIPMENT_BATCHES WSB
, ORG_ORGANIZATION_DEFINITIONS OOG
WHERE WTH.ENTITY_NUMBER = WSB.NAME
AND WTH.ENTITY_TYPE = 'BATCH'
AND WTH.DOCUMENT_DIRECTION = 'O'
AND WTH.DOCUMENT_TYPE = 'SR'
AND WSB.ORGANIZATION_ID = OOG.ORGANIZATION_ID

Columns