VIEW: APPS.WSH_SS2_SHIPMENT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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