[Home] [Help]
| Product: | FTE - Transportation Execution |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT LOAD_DETAIL_ID
, PARENT_LOAD_DETAIL_ID
, LOAD_ID
, CONTAINER_FLAG
, CONTAINER_SERIAL_NUMBER
, TARE_WEIGHT
, GROSS_WEIGHT
, WEIGHT_UOM
, 'VOLUME' "VOLUME_QUALIFIER"
, VOLUME
, VOLUME_UOM
, COMM_PO_NUMBER
, HAZARD_CODE
, SEAL_CODE
, CONTAINER_TYPE
, DESCRIPTION
, PRODUCT_CODE
, IMDG_CODE
, LENGTH
, WIDTH
, HEIGHT
, DIM_UOM
, LINE_NUMBER
, CONTAINER_REMARKS
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, OPERATOR_ID
, MARK_NUMBER
, PACKAGE_TYPE
, NUM_PACKAGES
, 'REQUIRED' "QUANTITY_QUALIFIER"
, QUANTITY
, QUANTITY_UOM
, CURRENCY_CODE
, COMMODITY_PRICE
, SPLIT_FLAG
, COMM_TYPE_CODE
, COMM_TYPE_DESC
, FTE_XML_TRANS_UTIL.GET_OUT_MAPPING(CREATED_BY
, ADDITIONAL_SERVICES) AS ADDITIONAL_SERVICES
, SPLIT_QUANTITY
, CARRIER_TRACKING_NUMBER
, RECEIVED_QUANTITY
, RECEIVED_FLAG
, DELIVERED_QUANTITY
, DELIVERED_FLAG
, CARRIER_NOTES
, CONSIGNEE_NOTES
, FREIGHT_CLASS
, SOURCE_HEADER_NUMBER
FROM FTE_LOAD_DETAILS