VIEW: MSC.MSC_INTERORG_SHIP_METHODS#

Source

View Text - Preformatted

select FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID, TO_ORGANIZATION_ID TO_ORGANIZATION_ID, SHIP_METHOD SHIP_METHOD, TIME_UOM_CODE TIME_UOM_CODE, DEFAULT_FLAG DEFAULT_FLAG, FROM_LOCATION_ID FROM_LOCATION_ID, TO_LOCATION_ID TO_LOCATION_ID, WEIGHT_CAPACITY WEIGHT_CAPACITY, WEIGHT_UOM WEIGHT_UOM, VOLUME_CAPACITY VOLUME_CAPACITY, VOLUME_UOM VOLUME_UOM, COST_PER_WEIGHT_UNIT COST_PER_WEIGHT_UNIT, COST_PER_VOLUME_UNIT COST_PER_VOLUME_UNIT, FROM_LOCATION_NAME FROM_LOCATION_NAME, TO_LOCATION_NAME TO_LOCATION_NAME, FROM_LOCATION_DESCR FROM_LOCATION_DESCR, TO_LOCATION_DESCR TO_LOCATION_DESCR, INTRANSIT_TIME INTRANSIT_TIME, SR_INSTANCE_ID SR_INSTANCE_ID, TRANSPORT_CAP_OVER_UTIL_COST TRANSPORT_CAP_OVER_UTIL_COST, SR_INSTANCE_ID2 SR_INSTANCE_ID2, REFRESH_NUMBER REFRESH_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_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, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, TRANSACTION_ID TRANSACTION_ID, PLAN_ID PLAN_ID, TO_REGION_ID TO_REGION_ID, COLLECTED_FLAG COLLECTED_FLAG, FROM_REGION_ID FROM_REGION_ID, SHIPMENT_WEIGHT SHIPMENT_WEIGHT, SHIPMENT_VOLUME SHIPMENT_VOLUME, SHIPMENT_WEIGHT_UOM SHIPMENT_WEIGHT_UOM, SHIPMENT_VOLUME_UOM SHIPMENT_VOLUME_UOM, CURRENCY CURRENCY, LEADTIME_VARIABILITY LEADTIME_VARIABILITY, SHIP_METHOD_TEXT SHIP_METHOD_TEXT from "MSC"."MSC_INTERORG_SHIP_METHODS"

View Text - HTML Formatted

SELECT FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID
, TO_ORGANIZATION_ID TO_ORGANIZATION_ID
, SHIP_METHOD SHIP_METHOD
, TIME_UOM_CODE TIME_UOM_CODE
, DEFAULT_FLAG DEFAULT_FLAG
, FROM_LOCATION_ID FROM_LOCATION_ID
, TO_LOCATION_ID TO_LOCATION_ID
, WEIGHT_CAPACITY WEIGHT_CAPACITY
, WEIGHT_UOM WEIGHT_UOM
, VOLUME_CAPACITY VOLUME_CAPACITY
, VOLUME_UOM VOLUME_UOM
, COST_PER_WEIGHT_UNIT COST_PER_WEIGHT_UNIT
, COST_PER_VOLUME_UNIT COST_PER_VOLUME_UNIT
, FROM_LOCATION_NAME FROM_LOCATION_NAME
, TO_LOCATION_NAME TO_LOCATION_NAME
, FROM_LOCATION_DESCR FROM_LOCATION_DESCR
, TO_LOCATION_DESCR TO_LOCATION_DESCR
, INTRANSIT_TIME INTRANSIT_TIME
, SR_INSTANCE_ID SR_INSTANCE_ID
, TRANSPORT_CAP_OVER_UTIL_COST TRANSPORT_CAP_OVER_UTIL_COST
, SR_INSTANCE_ID2 SR_INSTANCE_ID2
, REFRESH_NUMBER REFRESH_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_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
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, TRANSACTION_ID TRANSACTION_ID
, PLAN_ID PLAN_ID
, TO_REGION_ID TO_REGION_ID
, COLLECTED_FLAG COLLECTED_FLAG
, FROM_REGION_ID FROM_REGION_ID
, SHIPMENT_WEIGHT SHIPMENT_WEIGHT
, SHIPMENT_VOLUME SHIPMENT_VOLUME
, SHIPMENT_WEIGHT_UOM SHIPMENT_WEIGHT_UOM
, SHIPMENT_VOLUME_UOM SHIPMENT_VOLUME_UOM
, CURRENCY CURRENCY
, LEADTIME_VARIABILITY LEADTIME_VARIABILITY
, SHIP_METHOD_TEXT SHIP_METHOD_TEXT
FROM "MSC"."MSC_INTERORG_SHIP_METHODS"