VIEW: APPS.WSH_SS_CHARGE_V

Source

View Text - Preformatted

SELECT 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 (+)

View Text - HTML Formatted

SELECT 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 (+)