FND Design Data [Home] [Help]

View: WSH_DSNO_ALLOWANCE_CHARGES_V

Product: WSH - Shipping Execution
Description:
Implementation/DBA Data: ViewAPPS.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

Name
DELIVERY_DETAIL_ID
ORDER_HEADER_ID
ORDER_LINE_ID
ITEM_ID
AC_INDICATOR
AC_AMOUNT
AC_CHARGE_NAME
CURRENCY_CODE
CURRENCY_CONVERSION_TYPE_CODE
CURRENCY_CONVERSION_DATE
CURRENCY_CONVERSION_RATE
FC_CONTEXT
FC_ATTRIBUTE1
FC_ATTRIBUTE2
FC_ATTRIBUTE3
FC_ATTRIBUTE4
FC_ATTRIBUTE5
FC_ATTRIBUTE6
FC_ATTRIBUTE7
FC_ATTRIBUTE8
FC_ATTRIBUTE9
FC_ATTRIBUTE10
FC_ATTRIBUTE11
FC_ATTRIBUTE12
FC_ATTRIBUTE13
FC_ATTRIBUTE14
FC_ATTRIBUTE15