Skip to content

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 Comments
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:

SchemaFTE
TableFTE_SHIPMENT_STATUS_HEADERS
FTE.FTE_SHIPMENT_STATUS_HEADERS# is referenced by following:

SchemaAPPS
SynonymFTE_SHIPMENT_STATUS_HEADERS