VIEW: APPS.WSHFV_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 , 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

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
, 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