VIEW: APPS.WSHBV_FREIGHT_COSTS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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