[Home] [Help] [Dependency Information]
Object Name: | MSC_ST_INTERORG_SHIP_METHODS# |
---|---|
Object Type: | VIEW |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FROM_ORGANIZATION_ID | NUMBER | |||
TO_ORGANIZATION_ID | NUMBER | |||
SHIP_METHOD | VARCHAR2 | (30) | ||
TIME_UOM_CODE | VARCHAR2 | (10) | ||
INSTRANSIT_TIME | NUMBER | |||
DEFAULT_FLAG | NUMBER | |||
FROM_LOCATION_ID | NUMBER | |||
TO_LOCATION_ID | NUMBER | |||
AVAILABILITY_DATE | DATE | |||
WEIGHT_CAPACITY | NUMBER | |||
WEIGHT_UOM | VARCHAR2 | (3) | ||
VOLUME_CAPACITY | NUMBER | |||
VOLUME_UOM | VARCHAR2 | (3) | ||
COST_PER_WEIGHT_UNIT | NUMBER | |||
COST_PER_VOLUME_UNIT | NUMBER | |||
INTRANSIT_TIME | NUMBER | |||
DELETED_FLAG | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
REFRESH_ID | NUMBER | |||
SR_INSTANCE_ID | NUMBER | |||
TRANSPORT_CAP_OVER_UTIL_COST | NUMBER | |||
SR_INSTANCE_ID2 | NUMBER | |||
TO_REGION_ID | NUMBER | |||
FROM_ORGANIZATION_CODE | VARCHAR2 | (7) | ||
TO_ORGANIZATION_CODE | VARCHAR2 | (7) | ||
SR_INSTANCE_CODE | VARCHAR2 | (3) | ||
MESSAGE_ID | NUMBER | |||
PROCESS_FLAG | NUMBER | |||
DATA_SOURCE_TYPE | VARCHAR2 | (15) | ||
ST_TRANSACTION_ID | NUMBER | |||
ERROR_TEXT | VARCHAR2 | (2000) | ||
BATCH_ID | NUMBER | |||
COMPANY_NAME | VARCHAR2 | (255) | ||
FROM_LOCATION_CODE | VARCHAR2 | (60) | ||
TO_LOCATION_CODE | VARCHAR2 | (60) | ||
FROM_REGION_ID | NUMBER | |||
CURRENCY | VARCHAR2 | (40) | ||
TO_REGION_TYPE | NUMBER | |||
TO_COUNTRY | VARCHAR2 | (60) | ||
TO_COUNTRY_CODE | VARCHAR2 | (10) | ||
TO_STATE | VARCHAR2 | (60) | ||
TO_STATE_CODE | VARCHAR2 | (10) | ||
TO_CITY | VARCHAR2 | (60) | ||
TO_CITY_CODE | VARCHAR2 | (10) | ||
TO_POSTAL_CODE_FROM | VARCHAR2 | (30) | ||
TO_POSTAL_CODE_TO | VARCHAR2 | (30) | ||
TO_ZONE | VARCHAR2 | (60) | ||
FROM_REGION_TYPE | NUMBER | |||
FROM_COUNTRY | VARCHAR2 | (60) | ||
FROM_COUNTRY_CODE | VARCHAR2 | (10) | ||
FROM_STATE | VARCHAR2 | (60) | ||
FROM_STATE_CODE | VARCHAR2 | (10) | ||
FROM_CITY | VARCHAR2 | (60) | ||
FROM_CITY_CODE | VARCHAR2 | (10) | ||
FROM_POSTAL_CODE_FROM | VARCHAR2 | (30) | ||
FROM_POSTAL_CODE_TO | VARCHAR2 | (30) | ||
FROM_ZONE | VARCHAR2 | (60) | ||
SHIPMENT_WEIGHT | NUMBER | |||
SHIPMENT_VOLUME | NUMBER | |||
SHIPMENT_WEIGHT_UOM | VARCHAR2 | (3) | ||
SHIPMENT_VOLUME_UOM | VARCHAR2 | (3) | ||
LEADTIME_VARIABILITY | NUMBER | |||
SHIP_METHOD_TEXT | VARCHAR2 | (240) |
Cut, paste (and edit) the following text to query this object:
SELECT FROM_ORGANIZATION_ID
, TO_ORGANIZATION_ID
, SHIP_METHOD
, TIME_UOM_CODE
, INSTRANSIT_TIME
, DEFAULT_FLAG
, FROM_LOCATION_ID
, TO_LOCATION_ID
, AVAILABILITY_DATE
, WEIGHT_CAPACITY
, WEIGHT_UOM
, VOLUME_CAPACITY
, VOLUME_UOM
, COST_PER_WEIGHT_UNIT
, COST_PER_VOLUME_UNIT
, INTRANSIT_TIME
, DELETED_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REFRESH_ID
, SR_INSTANCE_ID
, TRANSPORT_CAP_OVER_UTIL_COST
, SR_INSTANCE_ID2
, TO_REGION_ID
, FROM_ORGANIZATION_CODE
, TO_ORGANIZATION_CODE
, SR_INSTANCE_CODE
, MESSAGE_ID
, PROCESS_FLAG
, DATA_SOURCE_TYPE
, ST_TRANSACTION_ID
, ERROR_TEXT
, BATCH_ID
, COMPANY_NAME
, FROM_LOCATION_CODE
, TO_LOCATION_CODE
, FROM_REGION_ID
, CURRENCY
, TO_REGION_TYPE
, TO_COUNTRY
, TO_COUNTRY_CODE
, TO_STATE
, TO_STATE_CODE
, TO_CITY
, TO_CITY_CODE
, TO_POSTAL_CODE_FROM
, TO_POSTAL_CODE_TO
, TO_ZONE
, FROM_REGION_TYPE
, FROM_COUNTRY
, FROM_COUNTRY_CODE
, FROM_STATE
, FROM_STATE_CODE
, FROM_CITY
, FROM_CITY_CODE
, FROM_POSTAL_CODE_FROM
, FROM_POSTAL_CODE_TO
, FROM_ZONE
, SHIPMENT_WEIGHT
, SHIPMENT_VOLUME
, SHIPMENT_WEIGHT_UOM
, SHIPMENT_VOLUME_UOM
, LEADTIME_VARIABILITY
, SHIP_METHOD_TEXT
FROM MSC.MSC_ST_INTERORG_SHIP_METHODS#;
|
|
|