View: WSH_FREIGHT_COSTS_V

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

View Text

SELECT FC.ROWID
, FC.FREIGHT_COST_ID
, FC.FREIGHT_COST_TYPE_ID
, FCT.NAME
, FCT.FREIGHT_COST_TYPE_CODE
, WSHLU.MEANING
, FC.UNIT_AMOUNT
, FC.CALCULATION_METHOD
, FC.UOM
, FC.QUANTITY
, FC.TOTAL_AMOUNT
, FC.CURRENCY_CODE
, FC.CONVERSION_DATE
, FC.CONVERSION_RATE
, FC.CONVERSION_TYPE_CODE
, FC.TRIP_ID
, TR.NAME
, FC.STOP_ID
, DECODE(NVL(FC.DELIVERY_DETAIL_ID
, 0)
, 0
, FC.DELIVERY_ID
, NULL)
, DEL.NAME
, FC.DELIVERY_LEG_ID
, FC.DELIVERY_DETAIL_ID
, FC.ATTRIBUTE_CATEGORY
, FC.ATTRIBUTE1
, FC.ATTRIBUTE2
, FC.ATTRIBUTE3
, FC.ATTRIBUTE4
, FC.ATTRIBUTE5
, FC.ATTRIBUTE6
, FC.ATTRIBUTE7
, FC.ATTRIBUTE8
, FC.ATTRIBUTE9
, FC.ATTRIBUTE10
, FC.ATTRIBUTE11
, FC.ATTRIBUTE12
, FC.ATTRIBUTE13
, FC.ATTRIBUTE14
, FC.ATTRIBUTE15
, FC.CREATION_DATE
, FC.CREATED_BY
, FC.LAST_UPDATE_DATE
, FC.LAST_UPDATED_BY
, FC.LAST_UPDATE_LOGIN
, FC.FREIGHT_CODE
, FC.LINE_TYPE_CODE
, FC.PRICING_LIST_HEADER_ID
, FC.PRICING_LIST_LINE_ID
, FC.APPLIED_TO_CHARGE_ID
, FC.CHARGE_UNIT_VALUE
, FC.CHARGE_SOURCE_CODE
, FC.ESTIMATED_FLAG
, FC.FTE_TRIP_ID
FROM WSH_FREIGHT_COSTS FC
, WSH_FREIGHT_COST_TYPES FCT
, WSH_TRIPS TR
, WSH_NEW_DELIVERIES DEL
, WSH_LOOKUPS WSHLU
WHERE FCT.FREIGHT_COST_TYPE_ID = FC.FREIGHT_COST_TYPE_ID
AND FC.TRIP_ID = TR.TRIP_ID(+)
AND FC.DELIVERY_ID = DEL.DELIVERY_ID(+)
AND NVL(FC.CHARGE_SOURCE_CODE
, 'MANUAL') IN ('PRICING_ENGINE'
, 'MANUAL')
AND WSHLU.LOOKUP_TYPE = 'FREIGHT_COST_TYPE'
AND WSHLU.LOOKUP_CODE = FCT.FREIGHT_COST_TYPE_CODE
AND NVL(DEL.SHIPMENT_DIRECTION
, 'O') IN ('O'
, 'IO')

Columns