DBA Data[Home] [Help]

VIEW: APPS.WSH_DSNO_ALLOWANCE_CHARGES_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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