View: OE_CHARGE_LINES_V

Product:	ONT - Order Management
Description:	Used for Freight and Special Charges.
Implementation/DBA Data:	APPS.OE_CHARGE_LINES_V

View Text

SELECT P.HEADER_ID
, P.LINE_ID
, P.PRICE_ADJUSTMENT_ID
, ONT_CHARGE_UTIL.GET_MEANING(P.CHARGE_TYPE_CODE
, P.CHARGE_SUBTYPE_CODE)
, DECODE(P.LINE_ID
, NULL
, DECODE(P.CREDIT_OR_CHARGE_FLAG
, 'C'
, (-1) * P.OPERAND
, P.OPERAND)
, DECODE(P.CREDIT_OR_CHARGE_FLAG
, 'C'
, DECODE(P.ARITHMETIC_OPERATOR
, 'LUMPSUM'
, (-1) * (P.OPERAND)
, (-1) * (L.ORDERED_QUANTITY*P.ADJUSTED_AMOUNT))
, DECODE(P.ARITHMETIC_OPERATOR
, 'LUMPSUM'
, P.OPERAND
, (L.ORDERED_QUANTITY*P.ADJUSTED_AMOUNT))))
, H.TRANSACTIONAL_CURR_CODE
, H.CONVERSION_RATE
, H.CONVERSION_RATE_DATE
, H.CONVERSION_TYPE_CODE
, P.UPDATED_FLAG
, P.INVOICED_FLAG
, P.CONTEXT
, P.ATTRIBUTE1
, P.ATTRIBUTE2
, P.ATTRIBUTE3
, P.ATTRIBUTE4
, P.ATTRIBUTE5
, P.ATTRIBUTE6
, P.ATTRIBUTE7
, P.ATTRIBUTE8
, P.ATTRIBUTE9
, P.ATTRIBUTE10
, P.ATTRIBUTE11
, P.ATTRIBUTE12
, P.ATTRIBUTE13
, P.ATTRIBUTE14
, P.ATTRIBUTE15
, P.AC_CONTEXT
, P.AC_ATTRIBUTE1
, P.AC_ATTRIBUTE2
, P.AC_ATTRIBUTE3
, P.AC_ATTRIBUTE4
, P.AC_ATTRIBUTE5
, P.AC_ATTRIBUTE6
, P.AC_ATTRIBUTE7
, P.AC_ATTRIBUTE8
, P.AC_ATTRIBUTE9
, P.AC_ATTRIBUTE10
, P.AC_ATTRIBUTE11
, P.AC_ATTRIBUTE12
, P.AC_ATTRIBUTE13
, P.AC_ATTRIBUTE14
, P.AC_ATTRIBUTE15
, P.INTERCO_INVOICED_FLAG
, H.ORG_ID
, H.ORDER_NUMBER
, H.ORDERED_DATE
, H.FOB_POINT_CODE
, P.SOURCE_SYSTEM_CODE
, P.ESTIMATED_FLAG
, P.INVOICED_AMOUNT
FROM OE_PRICE_ADJUSTMENTS P
, OE_ORDER_LINES_ALL L
, OE_ORDER_HEADERS_ALL H
WHERE P.HEADER_ID = H.HEADER_ID
AND P.LINE_ID = L.LINE_ID(+)
AND P.LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE'
AND P.APPLIED_FLAG = 'Y'

Columns