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]

VIEW: FTE.FTE_SHIPMENT_STATUS_HEADERS#

Object Details

Object Name:	FTE_SHIPMENT_STATUS_HEADERS#
Object Type:	VIEW
Owner:	FTE
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
DELIVERY_ID	NUMBER
DELIVERY_LEG_ID	NUMBER
MESSAGE_TYPE	VARCHAR2	(10)
SHIPMENT_STATUS_ID	NUMBER		Yes
CARRIER_NAME	VARCHAR2	(30)
GENERATION_DATE	DATE
STATUS	VARCHAR2	(15)
TRACKING_ID	VARCHAR2	(30)
TRACKING_ID_TYPE	VARCHAR2	(50)
BILL_OF_LADING	VARCHAR2	(60)
CARRIER_SERVICE_LEVEL	VARCHAR2	(15)
CONTAINER_ID	NUMBER
CONTAINER_SEAL	VARCHAR2	(30)
ARRIVAL_DATE	DATE
RECEIVED_DATE	DATE
DELIVERY_SCHEDULED_DATE	DATE
DEPARTURE_DATE	DATE
ESTIMATED_ARRIVAL_DATE	DATE
ESTIMATED_DEPARTURE_DATE	DATE
BEGIN_LOADING_DATE	DATE
END_LOADING_DATE	DATE
PROMISED_SHIPMENT_DATE	DATE
PROMISED_DELIVERY_DATE	DATE
SHIPPED_DATE	DATE
EXPECTED_SHIPMENT_DATE	DATE
BEGIN_UNLOADING_DATE	DATE
END_UNLOADING_DATE	DATE
DESCRIPTION	VARCHAR2	(2000)
FREIGHT_CLASS	VARCHAR2	(10)
HAZARDOUS_MATERIAL	VARCHAR2	(30)
LOAD_POINT	VARCHAR2	(60)
NOTES1	VARCHAR2	(2000)
NOTES2	VARCHAR2	(2000)
NOTES3	VARCHAR2	(2000)
NOTES4	VARCHAR2	(2000)
NOTES5	VARCHAR2	(2000)
NOTES6	VARCHAR2	(2000)
NOTES7	VARCHAR2	(2000)
NOTES8	VARCHAR2	(2000)
NOTES9	VARCHAR2	(2000)
SHIP_UNIT_QUANTITY	NUMBER
SHIP_UNIT_UOM	VARCHAR2	(30)
VOLUME	NUMBER
VOLUME_UOM	VARCHAR2	(30)
WEIGHT	NUMBER
WEIGHT_UOM	VARCHAR2	(30)
ROUTE_ID	VARCHAR2	(30)
ROUTE_TYPE	VARCHAR2	(15)
SHIP_NOTES	VARCHAR2	(2000)
SHIPPER_NUMBER	NUMBER
SHIP_POINT	VARCHAR2	(60)
SPECIAL_HANDLING	VARCHAR2	(2000)
STOP_NUMBER	NUMBER
SHIPPING_METHOD	VARCHAR2	(15)
SHIP_FROM_PARTNER	NUMBER
SHIP_TO_PARTNER	NUMBER
CARRIER_PARTNER	NUMBER
BILL_TO_PARTNER	NUMBER
NOTIFY_PARTNER	NUMBER
HOLD_AT_PARTNER	NUMBER
RETURN_TO_PARTNER	NUMBER
MARK_FOR_PARTNER	NUMBER
IMPORTER_PARTNER	NUMBER
EXPORTER_PARTNER	NUMBER
DELIVERY_DETAIL_ID	NUMBER
LICENSE_PLATE_NUMBER	VARCHAR2	(30)
CREATED_BY	NUMBER
CREATION_DATE	DATE
LAST_UPDATED_BY	NUMBER
LAST_UPDATE_DATE	DATE
LAST_UPDATE_LOGIN	NUMBER
REASON_CODE	VARCHAR2	(2000)
TRANSACTION_ID	NUMBER
ACTIVITY_ID	NUMBER
VEHICLE_NUMBER	VARCHAR2	(35)
OPERATOR	VARCHAR2	(150)
CARRIER_REF_NUMBER	VARCHAR2	(30)
WF_ITEM_KEY	VARCHAR2	(240)

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# references the following:

FTE: FTE_SHIPMENT_STATUS_HEADERS

FTE.FTE_SHIPMENT_STATUS_HEADERS# is referenced by following:

APPS: FTE_SHIPMENT_STATUS_HEADERS