View: WSHBV_FREIGHT_COSTS

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSHBV_FREIGHT_COSTS

View Text

SELECT FC.FREIGHT_COST_ID
, FC.CREATION_DATE
, FC.CREATED_BY
, FC.LAST_UPDATE_DATE
, FC.LAST_UPDATED_BY
, FC.LAST_UPDATE_LOGIN
, FC.DELIVERY_ID
, FC.DELIVERY_DETAIL_ID
, FC.FREIGHT_COST_TYPE_ID
, FC.UNIT_AMOUNT
, FC.CALCULATION_METHOD
, FC.UOM
, FC.QUANTITY
, FC.TOTAL_AMOUNT
, FC.TRIP_ID
, FC.STOP_ID
, FC.DELIVERY_LEG_ID
, FC.FREIGHT_CODE
, FC.CURRENCY_CODE
, FC.CONVERSION_DATE CONVERSION_DATE
, FC.CONVERSION_RATE CONVERSION_RATE
, FC.CONVERSION_TYPE_CODE CONVERSION_TYPE_CODE
FROM WSH_FREIGHT_COSTS FC
, WSH_NEW_DELIVERIES WND
, WSH_TRIPS WT
, WSH_TRIP_STOPS WTS
, WSH_DELIVERY_DETAILS WDD
WHERE FC.DELIVERY_ID = WND.DELIVERY_ID (+)
AND FC.TRIP_ID = WT.TRIP_ID (+)
AND FC.STOP_ID = WTS.STOP_ID (+)
AND FC.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID (+)
AND NVL(WND.SHIPMENT_DIRECTION
, 'O') IN ('O'
, 'IO')
AND NVL(WT.SHIPMENTS_TYPE_FLAG
, 'O') IN ('O'
, 'M')
AND NVL(WTS.SHIPMENTS_TYPE_FLAG
, 'O') IN ('O'
, 'M')
AND NVL(WDD.LINE_DIRECTION
, 'O') IN ('O'
, 'IO') WITH READ ONLY

Columns