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_TRANSPORTATION_UPDATES

Object Details

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

Used to display updates received from Oracle Transportation Management.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_TRANSPORTATION_UPDATES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANS_UPDATE_ID
MSC_TRANSPORTATION_UPDATES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EBS_SR_INSTANCE_ID ORDER_TYPE PO_LINE_LOCATION_ID
MSC_TRANSPORTATION_UPDATES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EBS_SR_INSTANCE_ID ORDER_TYPE WSH_DELIVERY_DETAIL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANS_UPDATE_ID	NUMBER		Yes	Unique Identifier for transportation Updates
EBS_SR_INSTANCE_ID	NUMBER			OTM instance id. If null, take it from profile: MSC: OTM Instance Id
OTM_DOMAIN_NAME	NUMBER			Domain Name from OTM. If null, take it from profile: OTM: Domain Name
ORDER_TYPE	NUMBER			1-PO, 2-ISO Open issue: Shall we derive it from other columns
PO_LINE_LOCATION_ID	NUMBER			PO: Inbound logistics Info passed from OTM
PO_LINE_ID	NUMBER			PO: Inbound logistics Info passed from OTM
WSH_DELIVERY_DETAIL_ID	NUMBER			Stores WSH_DELIVERY_DETAILS .DELIVERY_DETAIL_ID
OTM_RELEASE_LINE_GID	VARCHAR2	(100)	Yes	Used for punch-out to OTM, For PO, it is PO-_ For ISO, it is
OTM_RELEASE_GID	VARCHAR2	(100)	Yes	Unique release id, used for punch-out to OTM
UPDATED_ARRIVAL_DATE	DATE		Yes	Latest Estimated ArrivalDate from OTM.
UPDATED_DUE_DATE	DATE			Due date. Offset UPDATED_ARRIVAL_DATE by item post leadtime based on calendar
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER			Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER		Yes	Standard Who Column

Query Text

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


SELECT TRANS_UPDATE_ID
,      EBS_SR_INSTANCE_ID
,      OTM_DOMAIN_NAME
,      ORDER_TYPE
,      PO_LINE_LOCATION_ID
,      PO_LINE_ID
,      WSH_DELIVERY_DETAIL_ID
,      OTM_RELEASE_LINE_GID
,      OTM_RELEASE_GID
,      UPDATED_ARRIVAL_DATE
,      UPDATED_DUE_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
FROM MSC.MSC_TRANSPORTATION_UPDATES;

Dependencies

[top of page]

MSC.MSC_TRANSPORTATION_UPDATES does not reference any database object

MSC.MSC_TRANSPORTATION_UPDATES is referenced by following:

MSC: MSC_TRANSPORTATION_UPDATES#