VIEW: MSC.MSC_ST_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, INSTRANSIT_TIME INSTRANSIT_TIME, DEFAULT_FLAG DEFAULT_FLAG, FROM_LOCATION_ID FROM_LOCATION_ID, TO_LOCATION_ID TO_LOCATION_ID, AVAILABILITY_DATE AVAILABILITY_DATE, 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, INTRANSIT_TIME INTRANSIT_TIME, DELETED_FLAG DELETED_FLAG, 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, REFRESH_ID REFRESH_ID, SR_INSTANCE_ID SR_INSTANCE_ID, TRANSPORT_CAP_OVER_UTIL_COST TRANSPORT_CAP_OVER_UTIL_COST, SR_INSTANCE_ID2 SR_INSTANCE_ID2, TO_REGION_ID TO_REGION_ID, FROM_ORGANIZATION_CODE FROM_ORGANIZATION_CODE, TO_ORGANIZATION_CODE TO_ORGANIZATION_CODE, SR_INSTANCE_CODE SR_INSTANCE_CODE, MESSAGE_ID MESSAGE_ID, PROCESS_FLAG PROCESS_FLAG, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, ST_TRANSACTION_ID ST_TRANSACTION_ID, ERROR_TEXT ERROR_TEXT, BATCH_ID BATCH_ID, COMPANY_NAME COMPANY_NAME, FROM_LOCATION_CODE FROM_LOCATION_CODE, TO_LOCATION_CODE TO_LOCATION_CODE, FROM_REGION_ID FROM_REGION_ID, CURRENCY CURRENCY, TO_REGION_TYPE TO_REGION_TYPE, TO_COUNTRY TO_COUNTRY, TO_COUNTRY_CODE TO_COUNTRY_CODE, TO_STATE TO_STATE, TO_STATE_CODE TO_STATE_CODE, TO_CITY TO_CITY, TO_CITY_CODE TO_CITY_CODE, TO_POSTAL_CODE_FROM TO_POSTAL_CODE_FROM, TO_POSTAL_CODE_TO TO_POSTAL_CODE_TO, TO_ZONE TO_ZONE, FROM_REGION_TYPE FROM_REGION_TYPE, FROM_COUNTRY FROM_COUNTRY, FROM_COUNTRY_CODE FROM_COUNTRY_CODE, FROM_STATE FROM_STATE, FROM_STATE_CODE FROM_STATE_CODE, FROM_CITY FROM_CITY, FROM_CITY_CODE FROM_CITY_CODE, FROM_POSTAL_CODE_FROM FROM_POSTAL_CODE_FROM, FROM_POSTAL_CODE_TO FROM_POSTAL_CODE_TO, FROM_ZONE FROM_ZONE, SHIPMENT_WEIGHT SHIPMENT_WEIGHT, SHIPMENT_VOLUME SHIPMENT_VOLUME, SHIPMENT_WEIGHT_UOM SHIPMENT_WEIGHT_UOM, SHIPMENT_VOLUME_UOM SHIPMENT_VOLUME_UOM, LEADTIME_VARIABILITY LEADTIME_VARIABILITY, SHIP_METHOD_TEXT SHIP_METHOD_TEXT from "MSC"."MSC_ST_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
, INSTRANSIT_TIME INSTRANSIT_TIME
, DEFAULT_FLAG DEFAULT_FLAG
, FROM_LOCATION_ID FROM_LOCATION_ID
, TO_LOCATION_ID TO_LOCATION_ID
, AVAILABILITY_DATE AVAILABILITY_DATE
, 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
, INTRANSIT_TIME INTRANSIT_TIME
, DELETED_FLAG DELETED_FLAG
, 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
, REFRESH_ID REFRESH_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, TRANSPORT_CAP_OVER_UTIL_COST TRANSPORT_CAP_OVER_UTIL_COST
, SR_INSTANCE_ID2 SR_INSTANCE_ID2
, TO_REGION_ID TO_REGION_ID
, FROM_ORGANIZATION_CODE FROM_ORGANIZATION_CODE
, TO_ORGANIZATION_CODE TO_ORGANIZATION_CODE
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, MESSAGE_ID MESSAGE_ID
, PROCESS_FLAG PROCESS_FLAG
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, ERROR_TEXT ERROR_TEXT
, BATCH_ID BATCH_ID
, COMPANY_NAME COMPANY_NAME
, FROM_LOCATION_CODE FROM_LOCATION_CODE
, TO_LOCATION_CODE TO_LOCATION_CODE
, FROM_REGION_ID FROM_REGION_ID
, CURRENCY CURRENCY
, TO_REGION_TYPE TO_REGION_TYPE
, TO_COUNTRY TO_COUNTRY
, TO_COUNTRY_CODE TO_COUNTRY_CODE
, TO_STATE TO_STATE
, TO_STATE_CODE TO_STATE_CODE
, TO_CITY TO_CITY
, TO_CITY_CODE TO_CITY_CODE
, TO_POSTAL_CODE_FROM TO_POSTAL_CODE_FROM
, TO_POSTAL_CODE_TO TO_POSTAL_CODE_TO
, TO_ZONE TO_ZONE
, FROM_REGION_TYPE FROM_REGION_TYPE
, FROM_COUNTRY FROM_COUNTRY
, FROM_COUNTRY_CODE FROM_COUNTRY_CODE
, FROM_STATE FROM_STATE
, FROM_STATE_CODE FROM_STATE_CODE
, FROM_CITY FROM_CITY
, FROM_CITY_CODE FROM_CITY_CODE
, FROM_POSTAL_CODE_FROM FROM_POSTAL_CODE_FROM
, FROM_POSTAL_CODE_TO FROM_POSTAL_CODE_TO
, FROM_ZONE FROM_ZONE
, SHIPMENT_WEIGHT SHIPMENT_WEIGHT
, SHIPMENT_VOLUME SHIPMENT_VOLUME
, SHIPMENT_WEIGHT_UOM SHIPMENT_WEIGHT_UOM
, SHIPMENT_VOLUME_UOM SHIPMENT_VOLUME_UOM
, LEADTIME_VARIABILITY LEADTIME_VARIABILITY
, SHIP_METHOD_TEXT SHIP_METHOD_TEXT
FROM "MSC"."MSC_ST_INTERORG_SHIP_METHODS"