VIEW: APPS.WSH_FREIGHT_COSTS_V

Source

View Text - Preformatted

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, FC.DELIVERY_ID, 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, FC.BILLABLE_QUANTITY, FC.BILLABLE_UOM, FC.BILLABLE_BASIS 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') AND NVL(DEL.delivery_type, 'STANDARD') = 'STANDARD'

View Text - HTML Formatted

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
, FC.DELIVERY_ID
, 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
, FC.BILLABLE_QUANTITY
, FC.BILLABLE_UOM
, FC.BILLABLE_BASIS
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')
AND NVL(DEL.DELIVERY_TYPE
, 'STANDARD') = 'STANDARD'