VIEW: APPS.OKX_ORD_PRC_ADJMNTS_V

Source

View Text - Preformatted

SELECT PRICE_ADJUSTMENT_ID,HEADER_ID,AUTOMATIC_FLAG,DISCOUNT_ID,DISCOUNT_LINE_ID,PERCENT,LINE_ID,CONTEXT,ATTRIBUTE1, ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9, ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15, ORIG_SYS_DISCOUNT_REF,CHANGE_SEQUENCE,LIST_HEADER_ID,LIST_LINE_ID,LIST_LINE_TYPE_CODE, MODIFIED_FROM,MODIFIED_TO,UPDATE_ALLOWED,CHANGE_REASON_CODE,CHANGE_REASON_TEXT,UPDATED_FLAG, APPLIED_FLAG,OPERAND,ARITHMETIC_OPERATOR,COST_ID,TAX_CODE,INVOICED_FLAG,ESTIMATED_FLAG, ADJUSTED_AMOUNT,PRICING_PHASE_ID,CHARGE_TYPE_CODE,CHARGE_SUBTYPE_CODE,RANGE_BREAK_QUANTITY, ACCRUAL_CONVERSION_RATE,PRICING_GROUP_SEQUENCE,ACCRUAL_FLAG,LIST_LINE_NO,SOURCE_SYSTEM_CODE, BENEFIT_QTY,BENEFIT_UOM_CODE,PRINT_ON_INVOICE_FLAG,EXPIRATION_DATE,Proration_type_code, REBATE_TRANSACTION_TYPE_CODE,REBATE_TRANSACTION_REFERENCE,REBATE_PAYMENT_SYSTEM_CODE, REDEEMED_DATE,REDEEMED_FLAG,MODIFIER_LEVEL_CODE,PRICE_BREAK_TYPE_CODE, SUBSTITUTION_ATTRIBUTE,INCLUDE_ON_RETURNS_FLAG,CREDIT_OR_CHARGE_FLAG,LOCK_CONTROL, OPERAND_PER_PQTY,ADJUSTED_AMOUNT_PER_PQTY FROM OE_PRICE_ADJUSTMENTS

View Text - HTML Formatted

SELECT PRICE_ADJUSTMENT_ID
, HEADER_ID
, AUTOMATIC_FLAG
, DISCOUNT_ID
, DISCOUNT_LINE_ID
, PERCENT
, LINE_ID
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ORIG_SYS_DISCOUNT_REF
, CHANGE_SEQUENCE
, LIST_HEADER_ID
, LIST_LINE_ID
, LIST_LINE_TYPE_CODE
, MODIFIED_FROM
, MODIFIED_TO
, UPDATE_ALLOWED
, CHANGE_REASON_CODE
, CHANGE_REASON_TEXT
, UPDATED_FLAG
, APPLIED_FLAG
, OPERAND
, ARITHMETIC_OPERATOR
, COST_ID
, TAX_CODE
, INVOICED_FLAG
, ESTIMATED_FLAG
, ADJUSTED_AMOUNT
, PRICING_PHASE_ID
, CHARGE_TYPE_CODE
, CHARGE_SUBTYPE_CODE
, RANGE_BREAK_QUANTITY
, ACCRUAL_CONVERSION_RATE
, PRICING_GROUP_SEQUENCE
, ACCRUAL_FLAG
, LIST_LINE_NO
, SOURCE_SYSTEM_CODE
, BENEFIT_QTY
, BENEFIT_UOM_CODE
, PRINT_ON_INVOICE_FLAG
, EXPIRATION_DATE
, PRORATION_TYPE_CODE
, REBATE_TRANSACTION_TYPE_CODE
, REBATE_TRANSACTION_REFERENCE
, REBATE_PAYMENT_SYSTEM_CODE
, REDEEMED_DATE
, REDEEMED_FLAG
, MODIFIER_LEVEL_CODE
, PRICE_BREAK_TYPE_CODE
, SUBSTITUTION_ATTRIBUTE
, INCLUDE_ON_RETURNS_FLAG
, CREDIT_OR_CHARGE_FLAG
, LOCK_CONTROL
, OPERAND_PER_PQTY
, ADJUSTED_AMOUNT_PER_PQTY
FROM OE_PRICE_ADJUSTMENTS