Product: | WSH - Shipping Execution |
---|---|
Description: | |
Implementation/DBA Data: |
![]() |
SELECT DISTINCT WFC.DELIVERY_ID DELIVERY_ID
, WFC.DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID
, WFCT.NAME CHARGE_CODE
, WFC.UNIT_AMOUNT OPERATION_AMOUNT
, WFC.CURRENCY_CODE CURRENCY_CODE
, WFC.ATTRIBUTE_CATEGORY CHARGE_ATTRIBUTE_CATEGORY
, WFC.ATTRIBUTE1 CHARGE_ATTRIBUTE1
, WFC.ATTRIBUTE2 CHARGE_ATTRIBUTE2
, WFC.ATTRIBUTE3 CHARGE_ATTRIBUTE3
, WFC.ATTRIBUTE4 CHARGE_ATTRIBUTE4
, WFC.ATTRIBUTE5 CHARGE_ATTRIBUTE5
, WFC.ATTRIBUTE6 CHARGE_ATTRIBUTE6
, WFC.ATTRIBUTE7 CHARGE_ATTRIBUTE7
, WFC.ATTRIBUTE8 CHARGE_ATTRIBUTE8
, WFC.ATTRIBUTE9 CHARGE_ATTRIBUTE9
, WFC.ATTRIBUTE10 CHARGE_ATTRIBUTE10
, WFC.ATTRIBUTE11 CHARGE_ATTRIBUTE11
, WFC.ATTRIBUTE12 CHARGE_ATTRIBUTE12
, WFC.ATTRIBUTE13 CHARGE_ATTRIBUTE13
, WFC.ATTRIBUTE14 CHARGE_ATTRIBUTE14
, WFC.ATTRIBUTE15 CHARGE_ATTRIBUTE15 FROM WSH_FREIGHT_COSTS WFC
, WSH_FREIGHT_COST_TYPES WFCT
WHERE WFC.FREIGHT_COST_TYPE_ID = WFCT.FREIGHT_COST_TYPE_ID (+)