Subject: Need to fetch Sales Order Shipment Shipping Cost Query.
Navigation: Supply Chain Execution > Inventory Management > Shipment > Manage Shipment > Enter Order No and Search
SELECT
SUM(UNIT_AMOUNT) SHIPPING_COST
FROM
WSH_FREIGHT_COSTS WFC,
WSH_DELIVERY_DETAILS WDD
WHERE WFC.DELIVERY_DETAIL_ID=WDD.DELIVERY_DETAIL_ID
AND WDD.SOURCE_HEADER_NUMBER='1531' --SO ORDER NUM
No comments:
Post a Comment