View: WSH_DSNO_ALLOWANCE_CHARGES_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_DSNO_ALLOWANCE_CHARGES_V

View Text

SELECT WDD.DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID
, WDD.SOURCE_HEADER_ID ORDER_HEADER_ID
, WDD.SOURCE_LINE_ID ORDER_LINE_ID
, WDD.INVENTORY_ITEM_ID ITEM_ID
, DECODE(SIGN(NVL(OCL.CHARGE_AMOUNT
, 0))
, -1
, 'A'
, 0
, 'C'
, 1
, 'C'
, 'C') AC_INDICATOR
, ABS(WSH_FC_INTERFACE_PKG.PRORATE_FREIGHT_CHARGE(WDD.DELIVERY_DETAIL_ID
, OCL.CHARGE_ID)) AC_AMOUNT
, OCL.CHARGE_NAME AC_CHARGE_NAME
, OCL.CURRENCY_CODE CURRENCY_CODE
, OCL.CONVERSION_TYPE_CODE CURRENCY_CONVERSION_TYPE_CODE
, OCL.CONVERSION_DATE CURRENCY_CONVERSION_DATE
, OCL.CONVERSION_RATE CURRENCY_CONVERSION_RATE
, OCL.CONTEXT FC_CONTEXT
, OCL.ATTRIBUTE1 FC_ATTRIBUTE1
, OCL.ATTRIBUTE2 FC_ATTRIBUTE2
, OCL.ATTRIBUTE3 FC_ATTRIBUTE3
, OCL.ATTRIBUTE4 FC_ATTRIBUTE4
, OCL.ATTRIBUTE5 FC_ATTRIBUTE5
, OCL.ATTRIBUTE6 FC_ATTRIBUTE6
, OCL.ATTRIBUTE7 FC_ATTRIBUTE7
, OCL.ATTRIBUTE8 FC_ATTRIBUTE8
, OCL.ATTRIBUTE9 FC_ATTRIBUTE9
, OCL.ATTRIBUTE10 FC_ATTRIBUTE10
, OCL.ATTRIBUTE11 FC_ATTRIBUTE11
, OCL.ATTRIBUTE12 FC_ATTRIBUTE12
, OCL.ATTRIBUTE13 FC_ATTRIBUTE13
, OCL.ATTRIBUTE14 FC_ATTRIBUTE14
, OCL.ATTRIBUTE15 FC_ATTRIBUTE15
FROM OE_CHARGE_LINES_V OCL
, WSH_DELIVERY_DETAILS WDD
WHERE OCL.HEADER_ID = WDD.SOURCE_HEADER_ID
AND WDD.SOURCE_CODE='OE'
AND OCL.LINE_ID = WDD.SOURCE_LINE_ID
AND WDD.CONTAINER_FLAG = 'N'
AND NVL(WDD.SHIPPED_QUANTITY
, 0) > 0

Columns