View: OE_PRICE_ADJUSTMENTS_V

Product:	ONT - Order Management
Description:	This is a view on table OE_PRICE_ADJUSTMENTS.
Implementation/DBA Data:	APPS.OE_PRICE_ADJUSTMENTS_V

View Text

SELECT ADJ.ROWID ROW_ID
, ADJ.PRICE_ADJUSTMENT_ID
, ADJ.CREATION_DATE
, ADJ.CREATED_BY
, ADJ.LAST_UPDATE_DATE
, ADJ.LAST_UPDATED_BY
, ADJ.LAST_UPDATE_LOGIN
, ADJ.PROGRAM_APPLICATION_ID
, ADJ.PROGRAM_ID
, ADJ.PROGRAM_UPDATE_DATE
, ADJ.REQUEST_ID
, ADJ.HEADER_ID
, ADJ.DISCOUNT_ID
, ADJ.DISCOUNT_LINE_ID
, ADJ.AUTOMATIC_FLAG
, ADJ.PERCENT
, ADJ.LINE_ID
, ADJ.CONTEXT
, ADJ.ATTRIBUTE1
, ADJ.ATTRIBUTE2
, ADJ.ATTRIBUTE3
, ADJ.ATTRIBUTE4
, ADJ.ATTRIBUTE5
, ADJ.ATTRIBUTE6
, ADJ.ATTRIBUTE7
, ADJ.ATTRIBUTE8
, ADJ.ATTRIBUTE9
, ADJ.ATTRIBUTE10
, ADJ.ATTRIBUTE11
, ADJ.ATTRIBUTE12
, ADJ.ATTRIBUTE13
, ADJ.ATTRIBUTE14
, ADJ.ATTRIBUTE15
, ORIG_SYS_DISCOUNT_REF
, ADJ.LIST_HEADER_ID
, ADJ.LIST_LINE_ID
, ADJ.LIST_LINE_TYPE_CODE
, ADJ.MODIFIER_MECHANISM_TYPE_CODE
, ADJ.MODIFIED_FROM
, ADJ.MODIFIED_TO
, ADJ.UPDATED_FLAG
, ADJ.UPDATE_ALLOWED
, ADJ.APPLIED_FLAG
, ADJ.CHANGE_REASON_CODE
, ADJ.CHANGE_REASON_TEXT
, QPLH.NAME ADJUSTMENT_NAME
, ADJ.LIST_LINE_TYPE_CODE ADJUSTMENT_TYPE_CODE
, ADJ.UPDATE_ALLOWED OVERRIDE_ALLOWED_FLAG
, NULL ADJUSTMENT_TYPE_NAME
, ADJ.OPERAND
, ADJ.ARITHMETIC_OPERATOR
, ADJ.COST_ID
, ADJ.TAX_CODE
, ADJ.TAX_EXEMPT_FLAG
, ADJ.TAX_EXEMPT_NUMBER
, ADJ.TAX_EXEMPT_REASON_CODE
, ADJ.PARENT_ADJUSTMENT_ID
, ADJ.INVOICED_FLAG
, ADJ.ESTIMATED_FLAG
, ADJ.INC_IN_SALES_PERFORMANCE
, ADJ.SPLIT_ACTION_CODE
, ADJ.PRICING_PHASE_ID
, ADJ.ADJUSTED_AMOUNT
, ADJ.CHARGE_TYPE_CODE
, ADJ.CHARGE_SUBTYPE_CODE
, ADJ.LIST_LINE_NO
, ADJ.SOURCE_SYSTEM_CODE
, ADJ.BENEFIT_QTY
, ADJ.BENEFIT_UOM_CODE
, ADJ.PRINT_ON_INVOICE_FLAG
, ADJ.EXPIRATION_DATE
, ADJ.REBATE_TRANSACTION_TYPE_CODE
, ADJ.REBATE_TRANSACTION_REFERENCE
, ADJ.REBATE_PAYMENT_SYSTEM_CODE
, ADJ.REDEEMED_DATE
, ADJ.REDEEMED_FLAG
, ADJ.ACCRUAL_FLAG
, ADJ.RANGE_BREAK_QUANTITY
, ADJ.ACCRUAL_CONVERSION_RATE
, ADJ.PRICING_GROUP_SEQUENCE
, ADJ.MODIFIER_LEVEL_CODE
, ADJ.PRICE_BREAK_TYPE_CODE
, ADJ.SUBSTITUTION_ATTRIBUTE
, ADJ.PRORATION_TYPE_CODE
, ADJ.CREDIT_OR_CHARGE_FLAG
, ADJ.INCLUDE_ON_RETURNS_FLAG
, QPLH.DESCRIPTION
, ADJ.AC_CONTEXT
, ADJ.AC_ATTRIBUTE1
, ADJ.AC_ATTRIBUTE2
, ADJ.AC_ATTRIBUTE3
, ADJ.AC_ATTRIBUTE4
, ADJ.AC_ATTRIBUTE5
, ADJ.AC_ATTRIBUTE6
, ADJ.AC_ATTRIBUTE7
, ADJ.AC_ATTRIBUTE8
, ADJ.AC_ATTRIBUTE9
, ADJ.AC_ATTRIBUTE10
, ADJ.AC_ATTRIBUTE11
, ADJ.AC_ATTRIBUTE12
, ADJ.AC_ATTRIBUTE13
, ADJ.AC_ATTRIBUTE14
, ADJ.AC_ATTRIBUTE15
, ADJ.LOCK_CONTROL
, OPERAND_PER_PQTY
, ADJUSTED_AMOUNT_PER_PQTY
, INVOICED_AMOUNT
, ADJ.RETROBILL_REQUEST_ID
, ADJ.TAX_RATE_ID
FROM OE_PRICE_ADJUSTMENTS ADJ
, QP_LIST_HEADERS_TL QPLH
WHERE ADJ.LIST_HEADER_ID=QPLH.LIST_HEADER_ID(+)
AND QPLH.LANGUAGE(+) = USERENV('LANG')

Columns