[Home] [Help] [Dependency Information]
Object Name: | MSC_SUPPLIERORG_SHIP_METHODS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FROM_SR_INSTANCE_ID | NUMBER | Yes | From source instance id | |
TO_SR_INSTANCE_ID | NUMBER | Yes | To source instance id | |
FROM_SUPPLIER_SITE_ID | NUMBER | From supplier site id | ||
TO_ORGANIZATION_ID | NUMBER | To organization id | ||
FROM_ORGANIZATION_ID | NUMBER | From organization id | ||
TO_LOCATION_ID | NUMBER | Yes | To location id | |
SHIP_METHOD | VARCHAR2 | (30) | Yes | Ship method |
INTRANSIT_TIME | NUMBER | Intransit time | ||
DEFAULT_FLAG | NUMBER | Yes | Default flag | |
REGION_ID | NUMBER | Region id | ||
TRANSACTION_ID | NUMBER | Yes | Transaction id | |
TIME_UOM_CODE | VARCHAR2 | (10) | Time UOM code | |
FROM_LOCATION_ID | NUMBER | Yes | From location id | |
WEIGHT_CAPACITY | NUMBER | Weight capacity | ||
WEIGHT_UOM | VARCHAR2 | (3) | Weight UOM | |
VOLUME_CAPACITY | NUMBER | Volume capacity | ||
VOLUME_UOM | VARCHAR2 | (3) | Volume UOM | |
COST_PER_WEIGHT_UNIT | NUMBER | Cost per weight unit | ||
COST_PER_VOLUME_UNIT | NUMBER | Cost per volume unit | ||
FROM_LOCATION_NAME | VARCHAR2 | (10) | From location name | |
TO_LOCATION_NAME | VARCHAR2 | (10) | To location name | |
FROM_LOCATION_DESCR | VARCHAR2 | (80) | From location description | |
TO_LOCATION_DESCR | VARCHAR2 | (80) | To location description | |
TRANSPORT_CAP_OVER_UTIL_COST | NUMBER | Transport capacity over unilization cost | ||
LEADTIME_VARIABILITY | NUMBER | Supplier Lead time variability ( Standard Deviation) |
Cut, paste (and edit) the following text to query this object:
SELECT FROM_SR_INSTANCE_ID
, TO_SR_INSTANCE_ID
, FROM_SUPPLIER_SITE_ID
, TO_ORGANIZATION_ID
, FROM_ORGANIZATION_ID
, TO_LOCATION_ID
, SHIP_METHOD
, INTRANSIT_TIME
, DEFAULT_FLAG
, REGION_ID
, TRANSACTION_ID
, TIME_UOM_CODE
, FROM_LOCATION_ID
, WEIGHT_CAPACITY
, WEIGHT_UOM
, VOLUME_CAPACITY
, VOLUME_UOM
, COST_PER_WEIGHT_UNIT
, COST_PER_VOLUME_UNIT
, FROM_LOCATION_NAME
, TO_LOCATION_NAME
, FROM_LOCATION_DESCR
, TO_LOCATION_DESCR
, TRANSPORT_CAP_OVER_UTIL_COST
, LEADTIME_VARIABILITY
FROM APPS.MSC_SUPPLIERORG_SHIP_METHODS_V;
APPS.MSC_SUPPLIERORG_SHIP_METHODS_V is not referenced by any database object
|
|
|