eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: ECE_DSNO_ALLOWANCE_CHARGES_V

Product:	EC - e-Commerce Gateway
Description:	No longer used
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SFC.DELIVERY_ID DELIVERY_ID
, DLV.ACTUAL_DEPARTURE_ID DEPARTURE_ID
, SFC.CONTAINER_ID CONTAINER_ID
, SPL.ORDER_LINE_ID ORDER_LINE_ID
, SPL.INVENTORY_ITEM_ID ITEM_ID
, SPLD.PICKING_LINE_ID PICKING_LINE_ID
, SFC.PICKING_LINE_DETAIL_ID PICKING_LINE_DETAIL_ID
, DECODE(SIGN(NVL(SFC.AMOUNT
, 0))
, -1
, 'A'
, 0
, 'C'
, 1
, 'C'
, 'C') AC_INDICATOR
, ABS(SFC.AMOUNT) AC_AMOUNT
, SFC.CURRENCY_CODE CURRENCY_CODE
, SFC.CONVERSION_TYPE_CODE CURRENCY_CONVERSION_TYPE_CODE
, SFC.CONVERSION_DATE CURRENCY_CONVERSION_DATE
, SFC.CONVERSION_RATE CURRENCY_CONVERSION_RATE
, SFCT.NAME AC_HANDLING_CODE_INT
, SFC.AC_ATTRIBUTE_CATEGORY AC_CATEGORY
, SFC.AC_ATTRIBUTE1 AC_SPECIAL_SERVICES_CODE
, SFC.AC_ATTRIBUTE2 AC_SPECIAL_CHARGES_CODE
, SFC.AC_ATTRIBUTE3 AETC_NUMBER
, SFC.AC_ATTRIBUTE4 AETC_RESPONSIBILITY_CODE
, SFC.AC_ATTRIBUTE5 AETC_REASON_CODE
, SFC.AC_ATTRIBUTE6 AC_ATTRIBUTE6_INT
, SFC.AC_ATTRIBUTE7 AC_ATTRIBUTE7_INT
, SFC.AC_ATTRIBUTE8 AC_ATTRIBUTE8_INT
, SFC.AC_ATTRIBUTE9 AC_ATTRIBUTE9_INT
, SFC.AC_ATTRIBUTE10 AC_ATTRIBUTE10_INT
, SFC.AC_ATTRIBUTE11 AC_ATTRIBUTE11_INT
, SFC.AC_ATTRIBUTE12 AC_ATTRIBUTE12_INT
, SFC.AC_ATTRIBUTE13 AC_ATTRIBUTE13_INT
, SFC.AC_ATTRIBUTE14 AC_ATTRIBUTE14_INT
, SFC.AC_ATTRIBUTE15 AC_ATTRIBUTE15_INT
, SFC.CONTEXT FC_CONTEXT
, SFC.ATTRIBUTE1 FC_ATTRIBUTE1
, SFC.ATTRIBUTE2 FC_ATTRIBUTE2
, SFC.ATTRIBUTE3 FC_ATTRIBUTE3
, SFC.ATTRIBUTE4 FC_ATTRIBUTE4
, SFC.ATTRIBUTE5 FC_ATTRIBUTE5
, SFC.ATTRIBUTE6 FC_ATTRIBUTE6
, SFC.ATTRIBUTE7 FC_ATTRIBUTE7
, SFC.ATTRIBUTE8 FC_ATTRIBUTE8
, SFC.ATTRIBUTE9 FC_ATTRIBUTE9
, SFC.ATTRIBUTE10 FC_ATTRIBUTE10
, SFC.ATTRIBUTE11 FC_ATTRIBUTE11
, SFC.ATTRIBUTE12 FC_ATTRIBUTE12
, SFC.ATTRIBUTE13 FC_ATTRIBUTE13
, SFC.ATTRIBUTE14 FC_ATTRIBUTE14
, SFC.ATTRIBUTE15 FC_ATTRIBUTE15
FROM SO_PICKING_LINES_ALL SPL
, SO_PICKING_LINE_DETAILS SPLD
, WSH_DELIVERIES DLV
, SO_FREIGHT_CHARGE_TYPES SFCT
, SO_FREIGHT_CHARGES SFC
WHERE SPLD.PICKING_LINE_ID = SPL.PICKING_LINE_ID (+) AND SFC.PICKING_LINE_DETAIL_ID = SPLD.PICKING_LINE_DETAIL_ID (+) AND SFC.FREIGHT_CHARGE_TYPE_ID = SFCT.FREIGHT_CHARGE_TYPE_ID AND NVL(SPLD.SHIPPED_QUANTITY
, 0) > 0
AND SFC.DELIVERY_ID = DLV.DELIVERY_ID

Columns

Name
DELIVERY_ID
DEPARTURE_ID
CONTAINER_ID
ORDER_LINE_ID
ITEM_ID
PICKING_LINE_ID
PICKING_LINE_DETAIL_ID
AC_INDICATOR
AC_AMOUNT
CURRENCY_CODE
CURRENCY_CONVERSION_TYPE_CODE
CURRENCY_CONVERSION_DATE
CURRENCY_CONVERSION_RATE
AC_HANDLING_CODE_INT
AC_CATEGORY
AC_SPECIAL_SERVICES_CODE
AC_SPECIAL_CHARGES_CODE
AETC_NUMBER
AETC_RESPONSIBILITY_CODE
AETC_REASON_CODE
AC_ATTRIBUTE6_INT
AC_ATTRIBUTE7_INT
AC_ATTRIBUTE8_INT
AC_ATTRIBUTE9_INT
AC_ATTRIBUTE10_INT
AC_ATTRIBUTE11_INT
AC_ATTRIBUTE12_INT
AC_ATTRIBUTE13_INT
AC_ATTRIBUTE14_INT
AC_ATTRIBUTE15_INT
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