View: ASO_PRICE_ADJUSTMENTS_V

Product:	ASO - Order Capture
Description:	view based on aso_price_adjustments
Implementation/DBA Data:	APPS.ASO_PRICE_ADJUSTMENTS_V

View Text

SELECT PRICE_ADJ.ROWID
, PRICE_ADJ.PRICE_ADJUSTMENT_ID
, PRICE_ADJ.CREATION_DATE
, PRICE_ADJ.CREATED_BY
, PRICE_ADJ.LAST_UPDATE_DATE
, PRICE_ADJ.LAST_UPDATED_BY
, PRICE_ADJ.LAST_UPDATE_LOGIN
, PRICE_ADJ.PROGRAM_APPLICATION_ID
, PRICE_ADJ.PROGRAM_ID
, PRICE_ADJ.PROGRAM_UPDATE_DATE
, PRICE_ADJ.REQUEST_ID
, PRICE_ADJ.QUOTE_HEADER_ID
, PRICE_ADJ.QUOTE_LINE_ID
, PRICE_ADJ.MODIFIER_HEADER_ID
, PRICE_ADJ.MODIFIER_LINE_ID
, PRICE_ADJ.MODIFIER_LINE_TYPE_CODE
, PRICE_ADJ.MODIFIER_MECHANISM_TYPE_CODE
, PRICE_ADJ.MODIFIED_FROM
, PRICE_ADJ.MODIFIED_TO
, PRICE_ADJ.OPERAND
, PRICE_ADJ.ARITHMETIC_OPERATOR
, PRICE_ADJ.AUTOMATIC_FLAG
, PRICE_ADJ.UPDATE_ALLOWABLE_FLAG
, PRICE_ADJ.UPDATED_FLAG
, PRICE_ADJ.APPLIED_FLAG
, PRICE_ADJ.ON_INVOICE_FLAG
, PRICE_ADJ.PRICING_PHASE_ID
, PRICE_ADJ.ATTRIBUTE_CATEGORY
, PRICE_ADJ.ATTRIBUTE1
, PRICE_ADJ.ATTRIBUTE2
, PRICE_ADJ.ATTRIBUTE3
, PRICE_ADJ.ATTRIBUTE4
, PRICE_ADJ.ATTRIBUTE5
, PRICE_ADJ.ATTRIBUTE6
, PRICE_ADJ.ATTRIBUTE7
, PRICE_ADJ.ATTRIBUTE8
, PRICE_ADJ.ATTRIBUTE9
, PRICE_ADJ.ATTRIBUTE10
, PRICE_ADJ.ATTRIBUTE11
, PRICE_ADJ.ATTRIBUTE12
, PRICE_ADJ.ATTRIBUTE13
, PRICE_ADJ.ATTRIBUTE14
, PRICE_ADJ.ATTRIBUTE15
, PRICE_ADJ.ORIG_SYS_DISCOUNT_REF
, PRICE_ADJ.CHANGE_SEQUENCE
, PRICE_ADJ.LIST_HEADER_ID
, PRICE_ADJ.LIST_LINE_ID
, PRICE_ADJ.LIST_LINE_TYPE_CODE
, PRICE_ADJ.UPDATE_ALLOWED
, PRICE_ADJ.CHANGE_REASON_CODE
, PRICE_ADJ.CHANGE_REASON_TEXT
, PRICE_ADJ.COST_ID
, PRICE_ADJ.TAX_CODE
, PRICE_ADJ.TAX_EXEMPT_FLAG
, PRICE_ADJ.TAX_EXEMPT_NUMBER
, PRICE_ADJ.TAX_EXEMPT_REASON_CODE
, PRICE_ADJ.PARENT_ADJUSTMENT_ID
, PRICE_ADJ.INVOICED_FLAG
, PRICE_ADJ.ESTIMATED_FLAG
, PRICE_ADJ.INC_IN_SALES_PERFORMANCE
, PRICE_ADJ.SPLIT_ACTION_CODE
, PRICE_ADJ.ADJUSTED_AMOUNT
, PRICE_ADJ.CHARGE_TYPE_CODE
, PRICE_ADJ.CHARGE_SUBTYPE_CODE
, PRICE_ADJ.RANGE_BREAK_QUANTITY
, PRICE_ADJ.ACCRUAL_CONVERSION_RATE
, PRICE_ADJ.PRICING_GROUP_SEQUENCE
, PRICE_ADJ.ACCRUAL_FLAG
, PRICE_ADJ.LIST_LINE_NO
, PRICE_ADJ.SOURCE_SYSTEM_CODE
, PRICE_ADJ.BENEFIT_QTY
, PRICE_ADJ.BENEFIT_UOM_CODE
, PRICE_ADJ.PRINT_ON_INVOICE_FLAG
, PRICE_ADJ.EXPIRATION_DATE
, PRICE_ADJ.REBATE_TRANSACTION_TYPE_CODE
, PRICE_ADJ.REBATE_TRANSACTION_REFERENCE
, PRICE_ADJ.REBATE_PAYMENT_SYSTEM_CODE
, PRICE_ADJ.REDEEMED_DATE
, PRICE_ADJ.REDEEMED_FLAG
, PRICE_ADJ.MODIFIER_LEVEL_CODE
, PRICE_ADJ.PRICE_BREAK_TYPE_CODE
, PRICE_ADJ.SUBSTITUTION_ATTRIBUTE
, PRICE_ADJ.PRORATION_TYPE_CODE
, PRICE_ADJ.INCLUDE_ON_RETURNS_FLAG
, PRICE_ADJ.CREDIT_OR_CHARGE_FLAG
, QPLH.NAME
, QPLH.DESCRIPTION
FROM ASO_PRICE_ADJUSTMENTS PRICE_ADJ
, QP_LIST_HEADERS_TL QPLH
WHERE PRICE_ADJ.MODIFIER_HEADER_ID =QPLH.LIST_HEADER_ID(+)
AND QPLH.LANGUAGE(+) = USERENV('LANG')

Columns