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

TABLE: MSC.MSC_ST_INTERORG_SHIP_METHODS

Object Details
Object Name: MSC_ST_INTERORG_SHIP_METHODS
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_ST_INTERORG_SHIP_METHODS
Subobject Name:
Status: VALID


The staging table used by the collection program to validate and process data for table MSC_INTERORG_SHIP_METHODS.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
FROM_ORGANIZATION_ID NUMBER

Organization identifier for the origin organization
TO_ORGANIZATION_ID NUMBER

Organization identifier for the destination organization'
SHIP_METHOD VARCHAR2 (30)
Ship method
TIME_UOM_CODE VARCHAR2 (10)
Unit of measure used to specify the intransit lead time
INSTRANSIT_TIME NUMBER

Instransit time
DEFAULT_FLAG NUMBER

Flag to indicate if this is a default ship method
FROM_LOCATION_ID NUMBER

Location identifier of the origin location
TO_LOCATION_ID NUMBER

Location identifier of the destination location
AVAILABILITY_DATE DATE

Availability date
WEIGHT_CAPACITY NUMBER

Weight capacity of this ship method.
WEIGHT_UOM VARCHAR2 (3)
Weight unit of measure.
VOLUME_CAPACITY NUMBER

Weight capacity.
VOLUME_UOM VARCHAR2 (3)
Volume unit of measure.
COST_PER_WEIGHT_UNIT NUMBER

Cost per weight unit
COST_PER_VOLUME_UNIT NUMBER

Cost per volume unit
INTRANSIT_TIME NUMBER

Intransit time
DELETED_FLAG NUMBER

Deleted flag
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Concurrent Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who column
PROGRAM_ID NUMBER

Concurrent Who column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
REFRESH_ID NUMBER

Refresh identifier
SR_INSTANCE_ID NUMBER

Source application instance identifier of the source org
TRANSPORT_CAP_OVER_UTIL_COST NUMBER

Transport cap over utilized cost
SR_INSTANCE_ID2 NUMBER

Source application instance identifier of the destination org
TO_REGION_ID NUMBER

To Region Id
FROM_ORGANIZATION_CODE VARCHAR2 (7)
Source Organization Code
TO_ORGANIZATION_CODE VARCHAR2 (7)
Receipt Organization Code
SR_INSTANCE_CODE VARCHAR2 (3)
Instance Code
MESSAGE_ID NUMBER

This is a foriegn key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML
PROCESS_FLAG NUMBER

Processing flag indicating the status of records during pre-processing 1-New record, 2-Inprocess, 3-Error , 4- Propagated error, 5-Successfully Processed
DATA_SOURCE_TYPE VARCHAR2 (15)
Source type indicating the source of records
ST_TRANSACTION_ID NUMBER

Transaction ID generated during pre-processing to uniquely identify a record
ERROR_TEXT VARCHAR2 (2000)
If PROCESS_FLAG=3 for a record, then this will describe the reason for the error
BATCH_ID NUMBER

Batch Identifier generated during pre-processing
COMPANY_NAME VARCHAR2 (255)
Company Name
FROM_LOCATION_CODE VARCHAR2 (60)
Ship from location in the shipment method relationship
TO_LOCATION_CODE VARCHAR2 (60)
Ship to location in the shipment method relationship
FROM_REGION_ID NUMBER

From Region Identifier
CURRENCY VARCHAR2 (40)
Currency Code
TO_REGION_TYPE NUMBER

Region type of destination region
TO_COUNTRY VARCHAR2 (60)
Country name of destination region
TO_COUNTRY_CODE VARCHAR2 (10)
Country code of destination region
TO_STATE VARCHAR2 (60)
State name of the destination region
TO_STATE_CODE VARCHAR2 (10)
State code of the destination region
TO_CITY VARCHAR2 (60)
Name of the city of the destination region
TO_CITY_CODE VARCHAR2 (10)
City code of the destination region
TO_POSTAL_CODE_FROM VARCHAR2 (30)
Start of postal code range of the destination region
TO_POSTAL_CODE_TO VARCHAR2 (30)
End of Postal code range of the destination region
TO_ZONE VARCHAR2 (60)
Destination Zone name
FROM_REGION_TYPE NUMBER

Region type of origin region
FROM_COUNTRY VARCHAR2 (60)
Country name of origin region
FROM_COUNTRY_CODE VARCHAR2 (10)
Country code of origin region
FROM_STATE VARCHAR2 (60)
State name of origin region
FROM_STATE_CODE VARCHAR2 (10)
State code of origin region
FROM_CITY VARCHAR2 (60)
City name of origin region
FROM_CITY_CODE VARCHAR2 (10)
City code of origin region
FROM_POSTAL_CODE_FROM VARCHAR2 (30)
Start of postal code range of the origin region
FROM_POSTAL_CODE_TO VARCHAR2 (30)
End of postal code range of the origin region
FROM_ZONE VARCHAR2 (60)
Origin zone name
SHIPMENT_WEIGHT NUMBER

Max weight capacity for a shipment
SHIPMENT_VOLUME NUMBER

Max volume capacity for a shipment
SHIPMENT_WEIGHT_UOM VARCHAR2 (3)
weight UOM
SHIPMENT_VOLUME_UOM VARCHAR2 (3)
volume UOM
LEADTIME_VARIABILITY NUMBER

Interorg trasfer lead time vaiability (Standard Deviation)
SHIP_METHOD_TEXT VARCHAR2 (240)
Ship Method Text
Query Text

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;

Dependencies

[top of page]

MSC.MSC_ST_INTERORG_SHIP_METHODS does not reference any database object

MSC.MSC_ST_INTERORG_SHIP_METHODS is referenced by following:

SchemaAPPS
SynonymMSC_ST_INTERORG_SHIP_METHODS