VIEW: APPS.OE_PRICE_ADJS_HISTORY_V

Source

View Text - Preformatted

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 , adj.version_number , adj.retrobill_request_id , adj.phase_change_flag ,adj.tax_rate_id FROM OE_PRICE_ADJS_HISTORY ADJ , QP_LIST_HEADERS_TL QPLH WHERE adj.list_header_id=qplh.list_header_id(+) and qplh.language(+) = userenv('LANG')

View Text - HTML Formatted

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
, ADJ.VERSION_NUMBER
, ADJ.RETROBILL_REQUEST_ID
, ADJ.PHASE_CHANGE_FLAG
, ADJ.TAX_RATE_ID
FROM OE_PRICE_ADJS_HISTORY ADJ
, QP_LIST_HEADERS_TL QPLH
WHERE ADJ.LIST_HEADER_ID=QPLH.LIST_HEADER_ID(+)
AND QPLH.LANGUAGE(+) = USERENV('LANG')