VIEW: MSC.MSC_SHIPMENTS#

Source

View Text - Preformatted

select SHIPMENT_ID SHIPMENT_ID, PLAN_ID PLAN_ID, SR_INSTANCE_ID SR_INSTANCE_ID, TO_SR_INSTANCE_ID TO_SR_INSTANCE_ID, SHIP_DATE SHIP_DATE, DOCK_DATE DOCK_DATE, FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID, TO_ORGANIZATION_ID TO_ORGANIZATION_ID, WEIGHT WEIGHT, WEIGHT_CAPACITY WEIGHT_CAPACITY, WEIGHT_UOM_CODE WEIGHT_UOM_CODE, VOLUME VOLUME, VOLUME_CAPACITY VOLUME_CAPACITY, VOLUME_UOM_CODE VOLUME_UOM_CODE, SHIP_METHOD SHIP_METHOD, RELEASED_FLAG RELEASED_FLAG, TRIP_NAME TRIP_NAME, PLANNED_FLAG PLANNED_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, FIRM_FLAG FIRM_FLAG, STATUS STATUS, APPLIED APPLIED, LEAD_TIME LEAD_TIME from "MSC"."MSC_SHIPMENTS"

View Text - HTML Formatted

SELECT SHIPMENT_ID SHIPMENT_ID
, PLAN_ID PLAN_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, TO_SR_INSTANCE_ID TO_SR_INSTANCE_ID
, SHIP_DATE SHIP_DATE
, DOCK_DATE DOCK_DATE
, FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID
, TO_ORGANIZATION_ID TO_ORGANIZATION_ID
, WEIGHT WEIGHT
, WEIGHT_CAPACITY WEIGHT_CAPACITY
, WEIGHT_UOM_CODE WEIGHT_UOM_CODE
, VOLUME VOLUME
, VOLUME_CAPACITY VOLUME_CAPACITY
, VOLUME_UOM_CODE VOLUME_UOM_CODE
, SHIP_METHOD SHIP_METHOD
, RELEASED_FLAG RELEASED_FLAG
, TRIP_NAME TRIP_NAME
, PLANNED_FLAG PLANNED_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, FIRM_FLAG FIRM_FLAG
, STATUS STATUS
, APPLIED APPLIED
, LEAD_TIME LEAD_TIME
FROM "MSC"."MSC_SHIPMENTS"