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: MSC.MSC_SHIPMENTS

Object Details

Object Name:	MSC_SHIPMENTS
Object Type:	TABLE
Owner:	MSC
Subobject Name:
Status:	VALID

Shipments for DRP

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_SHIPMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PLAN_ID SHIPMENT_ID SR_INSTANCE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SHIPMENT_ID	NUMBER		Yes	Shipment ID
PLAN_ID	NUMBER		Yes	PLAN_ID
SR_INSTANCE_ID	NUMBER		Yes	From org instance ID
TO_SR_INSTANCE_ID	NUMBER		Yes	To organization id
SHIP_DATE	DATE		Yes	Ship date
DOCK_DATE	DATE		Yes	Dock date
FROM_ORGANIZATION_ID	NUMBER		Yes	From organization ID
TO_ORGANIZATION_ID	NUMBER		Yes	To organization ID
WEIGHT	NUMBER			Weight
WEIGHT_CAPACITY	NUMBER			Weight capacity
WEIGHT_UOM_CODE	VARCHAR2	(3)		Weight UOM
VOLUME	NUMBER			Volume
VOLUME_CAPACITY	NUMBER			Volume capacity
VOLUME_UOM_CODE	VARCHAR2	(3)		Volume UOM
SHIP_METHOD	VARCHAR2	(30)		Ship method
RELEASED_FLAG	VARCHAR2	(1)		'Y' if shipment is released
TRIP_NAME	VARCHAR2	(30)		Trip name if shipment corresponds to preexisting trips
PLANNED_FLAG	VARCHAR2	(1)		Planned flag
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	VARCHAR2	(240)		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
FIRM_FLAG	NUMBER			Firm Flag
STATUS	NUMBER			Status to indicate if the record is changed
APPLIED	NUMBER			to indicate if the record changed has been applied
LEAD_TIME	NUMBER			Intransit lead time

Query Text

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


SELECT SHIPMENT_ID
,      PLAN_ID
,      SR_INSTANCE_ID
,      TO_SR_INSTANCE_ID
,      SHIP_DATE
,      DOCK_DATE
,      FROM_ORGANIZATION_ID
,      TO_ORGANIZATION_ID
,      WEIGHT
,      WEIGHT_CAPACITY
,      WEIGHT_UOM_CODE
,      VOLUME
,      VOLUME_CAPACITY
,      VOLUME_UOM_CODE
,      SHIP_METHOD
,      RELEASED_FLAG
,      TRIP_NAME
,      PLANNED_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      FIRM_FLAG
,      STATUS
,      APPLIED
,      LEAD_TIME
FROM MSC.MSC_SHIPMENTS;

Dependencies

[top of page]

MSC.MSC_SHIPMENTS does not reference any database object

MSC.MSC_SHIPMENTS is referenced by following:

APPS: MSC_SHIPMENTS