VIEW: APPS.OE_CHARGE_LINES_V

Source

View Text - Preformatted

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', decode(l.ordered_quantity, 0, 0, (-1) * (P.OPERAND)), (-1) * (L.ORDERED_QUANTITY*P.ADJUSTED_AMOUNT)), DECODE(P.ARITHMETIC_OPERATOR, 'LUMPSUM', decode(l.ordered_quantity, 0, 0, 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'

View Text - HTML Formatted

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'
, DECODE(L.ORDERED_QUANTITY
, 0
, 0
, (-1) * (P.OPERAND))
, (-1) * (L.ORDERED_QUANTITY*P.ADJUSTED_AMOUNT))
, DECODE(P.ARITHMETIC_OPERATOR
, 'LUMPSUM'
, DECODE(L.ORDERED_QUANTITY
, 0
, 0
, 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'