Product: | ONT - Order Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OE_LINE_PRC_ADJ_HIST_V |
SELECT OPA.HIST_CREATED_BY
, OPA.RESPONSIBILITY_ID
, OPA.HIST_CREATION_DATE
, OPA.HEADER_ID
, OPA.LINE_ID
, OPA.PRICE_ADJUSTMENT_ID
, OH.SOLD_TO_ORG_ID
, OH.ORDER_TYPE_ID
, OH.ORDER_NUMBER
, OL.LINE_NUMBER
, OPA.HIST_TYPE_CODE
, OPA.DISCOUNT_ID
, OPA.DISCOUNT_LINE_ID
, OPA.AUTOMATIC_FLAG
, OPA.PERCENT
, OPA.ACCRUAL_FLAG
, OPA.ACCRUAL_CONVERSION_RATE
, OPA.INVOICED_FLAG
, OPA.INC_IN_SALES_PERFORMANCE
, OPA.ESTIMATED_FLAG
, OPA.SUBSTITUTION_ATTRIBUTE
, OPA.PRORATION_TYPE_CODE
, OPA.PRICING_GROUP_SEQUENCE
, OPA.COST_ID
, OPA.ARITHMETIC_OPERATOR
, OPA.APPLIED_FLAG
, OPA.INCLUDE_ON_RETURNS_FLAG
, OPA.CREDIT_OR_CHARGE_FLAG
, OPA.PRICING_PHASE_ID
, OPA.ADJUSTED_AMOUNT
, OPA.REBATE_TRANSACTION_REFERENCE
, OPA.REBATE_PAYMENT_SYSTEM_CODE
, OPA.RANGE_BREAK_QUANTITY
, OPA.PRINT_ON_INVOICE_FLAG
, OPA.LIST_LINE_NO
, OPA.EXPIRATION_DATE
, OPA.BENEFIT_UOM_CODE
, OPA.BENEFIT_QTY
, OPA.CHARGE_TYPE_CODE
, OPA.CHARGE_SUBTYPE_CODE
, OPA.TAX_EXEMPT_REASON_CODE
, OPA.TAX_EXEMPT_NUMBER
, OPA.TAX_EXEMPT_FLAG
, OPA.TAX_CODE
, OPA.SPLIT_ACTION_CODE
, OPA.PARENT_ADJUSTMENT_ID
, OPA.UPDATE_ALLOWED
, OPA.UPDATED_FLAG
, OPA.OPERAND
, OPA.MODIFIED_TO
, OPA.MODIFIED_FROM
, OPA.LIST_LINE_TYPE_CODE
, OPA.LIST_LINE_ID
, OPA.LIST_HEADER_ID
, OPA.CHANGE_REASON_TEXT
, OPA.CHANGE_REASON_CODE
, OPA.PRICE_BREAK_TYPE_CODE
, OPA.MODIFIER_LEVEL_CODE
, OPA.SOURCE_SYSTEM_CODE
, OPA.REDEEMED_FLAG
, OPA.REDEEMED_DATE
, OPA.REBATE_TRANSACTION_TYPE_CODE
, OPA.CONTEXT
, OPA.ATTRIBUTE1
, OPA.ATTRIBUTE2
, OPA.ATTRIBUTE3
, OPA.ATTRIBUTE4
, OPA.ATTRIBUTE5
, OPA.ATTRIBUTE6
, OPA.ATTRIBUTE7
, OPA.ATTRIBUTE8
, OPA.ATTRIBUTE9
, OPA.ATTRIBUTE10
, OPA.ATTRIBUTE11
, OPA.ATTRIBUTE12
, OPA.ATTRIBUTE13
, OPA.ATTRIBUTE14
, OPA.ATTRIBUTE15
, OPA.CREATION_DATE
, OPA.CREATED_BY
, OPA.LAST_UPDATE_DATE
, OPA.LAST_UPDATED_BY
, OPA.LAST_UPDATE_LOGIN
, OPA.PROGRAM_APPLICATION_ID
, OPA.PROGRAM_ID
, OPA.PROGRAM_UPDATE_DATE
, OPA.REQUEST_ID
, OPA.REASON_ID
, OPA.AUDIT_FLAG
, OPA.VERSION_FLAG
, OPA.PHASE_CHANGE_FLAG
, OPA.VERSION_NUMBER
, OPA.RETROBILL_REQUEST_ID
FROM OE_PRICE_ADJS_HISTORY OPA
, OE_ORDER_LINES_ALL OL
, OE_ORDER_HEADERS_ALL OH
WHERE OH.HEADER_ID = OPA.HEADER_ID
AND OL.HEADER_ID=OPA.HEADER_ID
AND OL.LINE_ID = OPA.LINE_ID