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_HEADERS

Object Details

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

This table holds the Main Body of the ShowShipment message
This table is tied to the FTE_SHIPMENT_STATUS_DETAILS table via a synthetic many to many relationship: Each header has one or many details, although the details may be shared by more than one header. A detail is determined to belong to a header if its report date is on or before the header's generation date and the delivery leg is the same.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FTE_SHIPMENT_STATUS_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SHIPMENT_STATUS_ID
FTE_SHIP_STATUS_HEADERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID
FTE_SHIP_STATUS_HEADERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DELIVERY_ID
FTE_SHIP_STATUS_HEADERS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DELIVERY_LEG_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DELIVERY_ID	NUMBER			FK Delivery ID
DELIVERY_LEG_ID	NUMBER			Delivery Leg ID. FK to delivery legs
MESSAGE_TYPE	VARCHAR2	(10)		Message Type
SHIPMENT_STATUS_ID	NUMBER		Yes	Shipment Status ID, Primary key
CARRIER_NAME	VARCHAR2	(30)		Carrier Name
GENERATION_DATE	DATE			date this message was generated
STATUS	VARCHAR2	(15)		Shipment status
TRACKING_ID	VARCHAR2	(30)		Tracking ID number
TRACKING_ID_TYPE	VARCHAR2	(50)		Type of Tracking ID number
BILL_OF_LADING	VARCHAR2	(60)		Bill of Lading
CARRIER_SERVICE_LEVEL	VARCHAR2	(15)		Carrier Service Level
CONTAINER_ID	NUMBER			Container ID
CONTAINER_SEAL	VARCHAR2	(30)		Seal Code
ARRIVAL_DATE	DATE			Arrival Date
RECEIVED_DATE	DATE			Received Date
DELIVERY_SCHEDULED_DATE	DATE			Scheduled Delivery Date
DEPARTURE_DATE	DATE			Departure Date
ESTIMATED_ARRIVAL_DATE	DATE			Estimated Arrival Date
ESTIMATED_DEPARTURE_DATE	DATE			Estimated Departure Date
BEGIN_LOADING_DATE	DATE			Date (Time) Loading began
END_LOADING_DATE	DATE			Date (Time) Loading ended
PROMISED_SHIPMENT_DATE	DATE			Promised Shipment Date
PROMISED_DELIVERY_DATE	DATE			Promised Delivery Date
SHIPPED_DATE	DATE			Shipped Date
EXPECTED_SHIPMENT_DATE	DATE			Expected Shipment Date
BEGIN_UNLOADING_DATE	DATE			Date (Time) Unloading began
END_UNLOADING_DATE	DATE			Date (Time) unloading finished
DESCRIPTION	VARCHAR2	(2000)		description
FREIGHT_CLASS	VARCHAR2	(10)		freight class
HAZARDOUS_MATERIAL	VARCHAR2	(30)		Hazardous material class
LOAD_POINT	VARCHAR2	(60)		Loading Point
NOTES1	VARCHAR2	(2000)		notes
NOTES2	VARCHAR2	(2000)		notes
NOTES3	VARCHAR2	(2000)		notes
NOTES4	VARCHAR2	(2000)		notes
NOTES5	VARCHAR2	(2000)		notes
NOTES6	VARCHAR2	(2000)		notes
NOTES7	VARCHAR2	(2000)		notes
NOTES8	VARCHAR2	(2000)		notes
NOTES9	VARCHAR2	(2000)		notes
SHIP_UNIT_QUANTITY	NUMBER			ship unit quantity
SHIP_UNIT_UOM	VARCHAR2	(30)		ship unit quantity Unit of Measure
VOLUME	NUMBER			volume
VOLUME_UOM	VARCHAR2	(30)		volume unit of measure
WEIGHT	NUMBER			weight
WEIGHT_UOM	VARCHAR2	(30)		weight unit of measure
ROUTE_ID	VARCHAR2	(30)		route id
ROUTE_TYPE	VARCHAR2	(15)		Route Type
SHIP_NOTES	VARCHAR2	(2000)		Ship Notes
SHIPPER_NUMBER	NUMBER			Shipper Number
SHIP_POINT	VARCHAR2	(60)		Ship Point
SPECIAL_HANDLING	VARCHAR2	(2000)		Special Handling
STOP_NUMBER	NUMBER			Stop Number
SHIPPING_METHOD	VARCHAR2	(15)		Shipping Method
SHIP_FROM_PARTNER	NUMBER			Ship From Partner FK to Partners table
SHIP_TO_PARTNER	NUMBER			Ship To Partner FK to Partners table
CARRIER_PARTNER	NUMBER			Carrier Partner FK to Partners table
BILL_TO_PARTNER	NUMBER			Bill To Partner FK to Partners table
NOTIFY_PARTNER	NUMBER			Notify Partner FK to Partners table
HOLD_AT_PARTNER	NUMBER			Hold at Partner FK to Partners table
RETURN_TO_PARTNER	NUMBER			Return To Partner FK to Partners table
MARK_FOR_PARTNER	NUMBER			Mark For Partner FK to Partners table
IMPORTER_PARTNER	NUMBER			Importer Partner FK to Partners table
EXPORTER_PARTNER	NUMBER			Exporter Partner FK to Partners table
DELIVERY_DETAIL_ID	NUMBER			Delivery Detail Id
LICENSE_PLATE_NUMBER	VARCHAR2	(30)		License Plate Number
CREATED_BY	NUMBER			Standard WHO column
CREATION_DATE	DATE			Standard WHO column
LAST_UPDATED_BY	NUMBER			Standard WHO column
LAST_UPDATE_DATE	DATE			Standard WHO column
LAST_UPDATE_LOGIN	NUMBER			Standard WHO column
REASON_CODE	VARCHAR2	(2000)		Reason Code
TRANSACTION_ID	NUMBER			Transaction Id the unique identifier for this XML transaction
ACTIVITY_ID	NUMBER			Activity ID
VEHICLE_NUMBER	VARCHAR2	(35)		Vehicle Number
OPERATOR	VARCHAR2	(150)		Operator
CARRIER_REF_NUMBER	VARCHAR2	(30)		Carrier Reference Number
WF_ITEM_KEY	VARCHAR2	(240)		Workflow Item Key

Query Text

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


SELECT DELIVERY_ID
,      DELIVERY_LEG_ID
,      MESSAGE_TYPE
,      SHIPMENT_STATUS_ID
,      CARRIER_NAME
,      GENERATION_DATE
,      STATUS
,      TRACKING_ID
,      TRACKING_ID_TYPE
,      BILL_OF_LADING
,      CARRIER_SERVICE_LEVEL
,      CONTAINER_ID
,      CONTAINER_SEAL
,      ARRIVAL_DATE
,      RECEIVED_DATE
,      DELIVERY_SCHEDULED_DATE
,      DEPARTURE_DATE
,      ESTIMATED_ARRIVAL_DATE
,      ESTIMATED_DEPARTURE_DATE
,      BEGIN_LOADING_DATE
,      END_LOADING_DATE
,      PROMISED_SHIPMENT_DATE
,      PROMISED_DELIVERY_DATE
,      SHIPPED_DATE
,      EXPECTED_SHIPMENT_DATE
,      BEGIN_UNLOADING_DATE
,      END_UNLOADING_DATE
,      DESCRIPTION
,      FREIGHT_CLASS
,      HAZARDOUS_MATERIAL
,      LOAD_POINT
,      NOTES1
,      NOTES2
,      NOTES3
,      NOTES4
,      NOTES5
,      NOTES6
,      NOTES7
,      NOTES8
,      NOTES9
,      SHIP_UNIT_QUANTITY
,      SHIP_UNIT_UOM
,      VOLUME
,      VOLUME_UOM
,      WEIGHT
,      WEIGHT_UOM
,      ROUTE_ID
,      ROUTE_TYPE
,      SHIP_NOTES
,      SHIPPER_NUMBER
,      SHIP_POINT
,      SPECIAL_HANDLING
,      STOP_NUMBER
,      SHIPPING_METHOD
,      SHIP_FROM_PARTNER
,      SHIP_TO_PARTNER
,      CARRIER_PARTNER
,      BILL_TO_PARTNER
,      NOTIFY_PARTNER
,      HOLD_AT_PARTNER
,      RETURN_TO_PARTNER
,      MARK_FOR_PARTNER
,      IMPORTER_PARTNER
,      EXPORTER_PARTNER
,      DELIVERY_DETAIL_ID
,      LICENSE_PLATE_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REASON_CODE
,      TRANSACTION_ID
,      ACTIVITY_ID
,      VEHICLE_NUMBER
,      OPERATOR
,      CARRIER_REF_NUMBER
,      WF_ITEM_KEY
FROM FTE.FTE_SHIPMENT_STATUS_HEADERS;

Dependencies

[top of page]

FTE.FTE_SHIPMENT_STATUS_HEADERS does not reference any database object

FTE.FTE_SHIPMENT_STATUS_HEADERS is referenced by following:

APPS: FTE_SHIPMENT_STATUS_HEADERS