[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
INV.MTL_INTERORG_SHIP_METHODS does not reference any database object
INV.MTL_INTERORG_SHIP_METHODS is referenced by following:
|
|
|