View: WSHFV_FREIGHT_COSTS

Product:	WSH - Shipping Execution
Description:	Full BIS Business View for Freight Costs.
Implementation/DBA Data:	APPS.WSHFV_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
, WND.NAME
, FC.DELIVERY_DETAIL_ID
, WDD.CONTAINER_FLAG
, FC.FREIGHT_COST_TYPE_ID
, FCT.FREIGHT_COST_TYPE_CODE
, FCT.NAME FREIGHT_COST_TYPE_NAME
, FCT.DESCRIPTION FREIGHT_COST_DESCRIPTION
, FC.UNIT_AMOUNT
, FC.CALCULATION_METHOD
, FC.UOM
, FC.QUANTITY
, FC.TOTAL_AMOUNT
, FC.TRIP_ID
, WTP.NAME TRIP_NAME
, FC.STOP_ID
, LOC.SOURCE_LOCATION_ID STOP_LOCATION_ID
, LOC.UI_LOCATION_CODE
, FC.DELIVERY_LEG_ID
, '_DF:WSH:WSH_FREIGHT_COSTS:FC'
, FC.FREIGHT_CODE
, OFR.FREIGHT_CODE_TL
, 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 WTP
, WSH_TRIP_STOPS WTS
, WSH_FREIGHT_COST_TYPES FCT
, ORG_FREIGHT_TL OFR
, WSH_DELIVERY_DETAILS WDD
, WSH_LOCATIONS LOC
WHERE FC.DELIVERY_ID = WND.DELIVERY_ID(+)
AND FC.TRIP_ID = WTP.TRIP_ID(+)
AND FC.STOP_ID = WTS.STOP_ID(+)
AND FC.FREIGHT_COST_TYPE_ID = FCT.FREIGHT_COST_TYPE_ID
AND FC.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID(+)
AND FC.FREIGHT_CODE = OFR.FREIGHT_CODE(+)
AND USERENV('LANG') = OFR.LANGUAGE(+)
AND WTS.STOP_LOCATION_ID = LOC.WSH_LOCATION_ID(+)
AND NVL(WND.SHIPMENT_DIRECTION
, 'O') IN ('O'
, 'IO')
AND NVL(WTP.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