View: WSHFV_FREIGHT_CHARGE

Product:	OE - Order Entry
Description:	- Retrofitted
Implementation/DBA Data:	APPS.WSHFV_FREIGHT_CHARGE

View Text

SELECT FC.FREIGHT_CHARGE_ID
, FC.CREATION_DATE
, FC.CREATED_BY
, FC.LAST_UPDATE_DATE
, FC.LAST_UPDATED_BY
, FC.LAST_UPDATE_LOGIN
, FC.DELIVERY_ID
, WDL.NAME DELIVERY_NAME
, H.HEADER_ID
, H.ORDER_NUMBER
, FC.PICKING_LINE_DETAIL_ID
, FC.CONTAINER_ID
, PC.SEQUENCE_NUMBER CONTAINER
, FT.DESCRIPTION CHARGE_TYPE_DESCRIPTION
, FC.FREIGHT_CHARGE_TYPE_ID
, FT.NAME FREIGHT_CHARGE_TYPE_NAME
, FT.FREIGHT_CHARGE_TYPE_CODE
, FC.PICKING_HEADER_ID
, FC.AMOUNT
, FC.CURRENCY_CODE
, FC.CONVERSION_DATE CURRENCY_CONVERSION_DATE
, FC.CONVERSION_RATE CURRENCY_CONVERSION_RATE
, FC.CONVERSION_TYPE_CODE CURRENCY_CONVERSION_TYPE_CODE
, FC.INVOICE_STATUS
FROM SO_FREIGHT_CHARGE_TYPES FT
, SO_FREIGHT_CHARGES FC
, SO_PICKING_HEADERS_ALL PH
, SO_HEADERS_ALL H
, WSH_PACKED_CONTAINERS PC
, WSH_DELIVERIES WDL
WHERE FT.FREIGHT_CHARGE_TYPE_ID = FC.FREIGHT_CHARGE_TYPE_ID
AND PH.PICKING_HEADER_ID(+) = FC.PICKING_HEADER_ID
AND H.HEADER_ID(+) = PH.ORDER_HEADER_ID
AND PC.CONTAINER_ID(+) = FC.CONTAINER_ID
AND WDL.DELIVERY_ID (+) = FC.DELIVERY_ID

Columns