VIEW: APPS.OE_ORD_PRC_ADJ_HIST_V

Source

View Text - Preformatted

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 , null , 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_headers_all oh WHERE opa.header_id = oh.header_id and opa.line_id is null

View Text - HTML Formatted

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
, NULL
, 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_HEADERS_ALL OH
WHERE OPA.HEADER_ID = OH.HEADER_ID
AND OPA.LINE_ID IS NULL