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]

TABLE: INV.MTL_INTERORG_SHIP_METHODS

Object Details

Object Name:	MTL_INTERORG_SHIP_METHODS
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.MTL_INTERORG_SHIP_METHODS
Subobject Name:
Status:	VALID

MTL_INTERORG_SHIP_METHODS stores the relationships between
inter-organization shipping networks and shipment methods. These
relationships are one to many, tying multiple shipment methods to one
shipping network. Each shipping network is identified by its from
and to organizations. Each inter-organization shipment method is
characterized by a shipment method name and an intransit lead time.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_INTERORG_SHIP_METHODS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	FROM_ORGANIZATION_ID SHIP_METHOD
MTL_INTERORG_SHIP_METHODS_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	FROM_ORGANIZATION_ID TO_ORGANIZATION_ID SHIP_METHOD
MTL_INTERORG_SHIP_METHODS_N3	NORMAL	NONUNIQUE	APPS_TS_SEED	FROM_LOCATION_ID TO_LOCATION_ID SHIP_METHOD

Columns

Name	Datatype	Length	Mandatory	Comments
FROM_ORGANIZATION_ID	NUMBER			Unique identifier for the ship from organization in the shipment method relationship
TO_ORGANIZATION_ID	NUMBER			Unique identifier for the ship to organization in the shipment method relationship
SHIP_METHOD	VARCHAR2	(30)	Yes	Unique identifier for the shipment method used in the shipment method relationship
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column
TIME_UOM_CODE	VARCHAR2	(3)		Unique identifier for the unit of measure used to specify the intransit lead time for the shipment method relationship
INTRANSIT_TIME	NUMBER		Yes	Used to specify the numerical value for the intransit lead timeof the shipment method relationship
DEFAULT_FLAG	NUMBER			Used to specify whether the shipment method relationshipis the default shipment method for an inter-organization shipping network relationship. Used by MRP to determine which shipment methodto use for intransit lead time information
FROM_LOCATION_ID	NUMBER			Unique identifier for the ship from location in the shipment method relationship
TO_LOCATION_ID	NUMBER			Unique identifier for the ship to location in the shipment method relationship
LOAD_WEIGHT_UOM_CODE	VARCHAR2	(3)		Abbreviated unit of measure code
VOLUME_UOM_CODE	VARCHAR2	(3)		Abbreviated unit of measure code
CURRENCY_CODE	VARCHAR2	(15)		Currency code
DAILY_LOAD_WEIGHT_CAPACITY	NUMBER			Daily load weight capacity
COST_PER_UNIT_LOAD_WEIGHT	NUMBER			Cost per unit load weight
DAILY_VOLUME_CAPACITY	NUMBER			Daily volume capacity
COST_PER_UNIT_LOAD_VOLUME	NUMBER			Cost per unit load volume
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
TO_REGION_ID	NUMBER			Destination region or zone identifier
DESTINATION_TYPE	VARCHAR2	(1)		Denotes type of destination: 'L' - location, 'R' - region, 'Z' - zone
ORIGIN_TYPE	VARCHAR2	(1)		Type of origin: 'L' - location, 'R' - region, 'Z' - zone
FROM_REGION_ID	NUMBER			From Region ID

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FROM_ORGANIZATION_ID
,      TO_ORGANIZATION_ID
,      SHIP_METHOD
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      TIME_UOM_CODE
,      INTRANSIT_TIME
,      DEFAULT_FLAG
,      FROM_LOCATION_ID
,      TO_LOCATION_ID
,      LOAD_WEIGHT_UOM_CODE
,      VOLUME_UOM_CODE
,      CURRENCY_CODE
,      DAILY_LOAD_WEIGHT_CAPACITY
,      COST_PER_UNIT_LOAD_WEIGHT
,      DAILY_VOLUME_CAPACITY
,      COST_PER_UNIT_LOAD_VOLUME
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      TO_REGION_ID
,      DESTINATION_TYPE
,      ORIGIN_TYPE
,      FROM_REGION_ID
FROM INV.MTL_INTERORG_SHIP_METHODS;

Dependencies

[top of page]

INV.MTL_INTERORG_SHIP_METHODS does not reference any database object

INV.MTL_INTERORG_SHIP_METHODS is referenced by following:

APPS: MTL_INTERORG_SHIP_METHODS