VIEW: WSH.WSH_SHIPMENT_BATCHES#

Source

View Text - Preformatted

select BATCH_ID BATCH_ID, NAME NAME, ORG_ID ORG_ID, CURRENCY_CODE CURRENCY_CODE, CUSTOMER_ID CUSTOMER_ID, ORGANIZATION_ID ORGANIZATION_ID, SHIP_FROM_LOCATION_ID SHIP_FROM_LOCATION_ID, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, INVOICE_TO_SITE_USE_ID INVOICE_TO_SITE_USE_ID, DELIVER_TO_SITE_USE_ID DELIVER_TO_SITE_USE_ID, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID, INVOICE_TO_CONTACT_ID INVOICE_TO_CONTACT_ID, DELIVER_TO_CONTACT_ID DELIVER_TO_CONTACT_ID, SHIP_METHOD_CODE SHIP_METHOD_CODE, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE, FOB_CODE FOB_CODE, PENDING_REQUEST_FLAG PENDING_REQUEST_FLAG, 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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "WSH"."WSH_SHIPMENT_BATCHES"

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, NAME NAME
, ORG_ID ORG_ID
, CURRENCY_CODE CURRENCY_CODE
, CUSTOMER_ID CUSTOMER_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SHIP_FROM_LOCATION_ID SHIP_FROM_LOCATION_ID
, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, INVOICE_TO_SITE_USE_ID INVOICE_TO_SITE_USE_ID
, DELIVER_TO_SITE_USE_ID DELIVER_TO_SITE_USE_ID
, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID
, INVOICE_TO_CONTACT_ID INVOICE_TO_CONTACT_ID
, DELIVER_TO_CONTACT_ID DELIVER_TO_CONTACT_ID
, SHIP_METHOD_CODE SHIP_METHOD_CODE
, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE
, FOB_CODE FOB_CODE
, PENDING_REQUEST_FLAG PENDING_REQUEST_FLAG
, 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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "WSH"."WSH_SHIPMENT_BATCHES"