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: FTE.FTE_SHIPMENT_STATUS_DETAILS

Object Details

Object Name:	FTE_SHIPMENT_STATUS_DETAILS
Object Type:	TABLE
Owner:	FTE
FND Design Data:	FTE.FTE_SHIPMENT_STATUS_DETAILS
Subobject Name:
Status:	VALID

This table holds the shipment detail portion of the ShowShipment message

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FTE_SHIPMENT_STATUS_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SHIPMENT_STATUS_DETAIL_ID
FTE_SHIP_STATUS_DETAILS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID
FTE_SHIP_STATUS_DETAILS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DELIVERY_LEG_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SHIPMENT_STATUS_DETAIL_ID	NUMBER		Yes	PK
DELIVERY_LEG_ID	NUMBER			FK reference to delivery leg
REPORT_DATE	DATE			date reported as shown in message
SHIPMENT_STATUS	VARCHAR2	(20)		Status
CHANGED_STATUS_DATE	DATE			Date the status last changed
DESCRIPTION	VARCHAR2	(1000)		description
CREATED_BY	NUMBER			Created By
CREATION_DATE	DATE			Creation Date
LAST_UPDATED_BY	NUMBER			Last Updated By
LAST_UPDATE_DATE	DATE			Last Update Date
LAST_UPDATE_LOGIN	NUMBER			Last Update Login
TRANSACTION_ID	NUMBER			fk reference to transaction id on shipment headers table
SHIP_UNIT_SEQ	NUMBER			ship unit sequence number
SHIP_UNIT_TOTAL	NUMBER			ship unit total (highest sequence number)
TRACKING_ID	VARCHAR2	(30)		tracking id used in message
TRACKING_ID_TYPE	VARCHAR2	(50)		tracking id type

Query Text

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


SELECT SHIPMENT_STATUS_DETAIL_ID
,      DELIVERY_LEG_ID
,      REPORT_DATE
,      SHIPMENT_STATUS
,      CHANGED_STATUS_DATE
,      DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TRANSACTION_ID
,      SHIP_UNIT_SEQ
,      SHIP_UNIT_TOTAL
,      TRACKING_ID
,      TRACKING_ID_TYPE
FROM FTE.FTE_SHIPMENT_STATUS_DETAILS;

Dependencies

[top of page]

FTE.FTE_SHIPMENT_STATUS_DETAILS does not reference any database object

FTE.FTE_SHIPMENT_STATUS_DETAILS is referenced by following:

APPS: FTE_SHIPMENT_STATUS_DETAILS