[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| 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.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| 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
|
| 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 |
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;
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
|
|
|
|