eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.MSC_SUPPLIERORG_SHIP_METHODS_V

Object Details

Object Name:	MSC_SUPPLIERORG_SHIP_METHODS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

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)

Query Text

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;

Dependencies

[top of page]

APPS.MSC_SUPPLIERORG_SHIP_METHODS_V references the following:

APPS: MSC_INTERORG_SHIP_METHODS; MSC_REGION_SITES; MSC_TRADING_PARTNER_SITES

APPS.MSC_SUPPLIERORG_SHIP_METHODS_V is not referenced by any database object