VIEW: APPS.OE_AK_LINE_PRCADJS_V

Source

View Text - Preformatted

SELECT attribute1 , attribute10 , attribute11 , attribute12 , attribute13 , attribute14 , attribute15 , attribute2 , attribute3 , attribute4 , attribute5 , attribute6 , attribute7 , attribute8 , attribute9 , automatic_flag , context , created_by , creation_date , discount_id , discount_line_id , header_id , last_updated_by , last_update_date , last_update_login , line_id , percent , price_adjustment_id , program_application_id , program_id , program_update_date , request_id , rpad('X',1,'-') , rpad('X',1,'-') , rpad('X',30,'-') , 1 , list_header_id , list_line_id , list_line_type_code , modifier_mechanism_type_code , modified_from , modified_to , updated_flag , update_allowed , applied_flag , change_reason_code , change_reason_text , operand , arithmetic_operator , cost_id , tax_code , tax_exempt_flag , tax_exempt_number , tax_exempt_reason_code , parent_adjustment_id , invoiced_flag , estimated_flag , inc_in_sales_performance , split_action_code , adjusted_amount , pricing_phase_id , charge_type_code , charge_subtype_code ,list_line_no ,source_system_code ,benefit_qty ,benefit_uom_code ,print_on_invoice_flag ,expiration_date ,rebate_transaction_type_code ,rebate_transaction_reference ,rebate_payment_system_code ,redeemed_date ,redeemed_flag ,accrual_flag , range_break_quantity , accrual_conversion_rate , pricing_group_sequence , modifier_level_code , price_break_type_code , substitution_attribute , proration_type_code , credit_or_charge_flag , include_on_returns_flag , AC_CONTEXT , AC_ATTRIBUTE1 , AC_ATTRIBUTE2 , AC_ATTRIBUTE3 , AC_ATTRIBUTE4 , AC_ATTRIBUTE5 , AC_ATTRIBUTE6 , AC_ATTRIBUTE7 , AC_ATTRIBUTE8 , AC_ATTRIBUTE9 , AC_ATTRIBUTE10 , AC_ATTRIBUTE11 , AC_ATTRIBUTE12 , AC_ATTRIBUTE13 , AC_ATTRIBUTE14 , AC_ATTRIBUTE15 , operand_per_pqty , adjusted_amount_per_pqty , invoiced_amount ,tax_rate_id FROM OE_PRICE_ADJUSTMENTS_V

View Text - HTML Formatted

SELECT ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, AUTOMATIC_FLAG
, CONTEXT
, CREATED_BY
, CREATION_DATE
, DISCOUNT_ID
, DISCOUNT_LINE_ID
, HEADER_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LINE_ID
, PERCENT
, PRICE_ADJUSTMENT_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, RPAD('X'
, 1
, '-')
, RPAD('X'
, 1
, '-')
, RPAD('X'
, 30
, '-')
, 1
, LIST_HEADER_ID
, LIST_LINE_ID
, LIST_LINE_TYPE_CODE
, MODIFIER_MECHANISM_TYPE_CODE
, MODIFIED_FROM
, MODIFIED_TO
, UPDATED_FLAG
, UPDATE_ALLOWED
, APPLIED_FLAG
, CHANGE_REASON_CODE
, CHANGE_REASON_TEXT
, OPERAND
, ARITHMETIC_OPERATOR
, COST_ID
, TAX_CODE
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, PARENT_ADJUSTMENT_ID
, INVOICED_FLAG
, ESTIMATED_FLAG
, INC_IN_SALES_PERFORMANCE
, SPLIT_ACTION_CODE
, ADJUSTED_AMOUNT
, PRICING_PHASE_ID
, CHARGE_TYPE_CODE
, CHARGE_SUBTYPE_CODE
, LIST_LINE_NO
, SOURCE_SYSTEM_CODE
, BENEFIT_QTY
, BENEFIT_UOM_CODE
, PRINT_ON_INVOICE_FLAG
, EXPIRATION_DATE
, REBATE_TRANSACTION_TYPE_CODE
, REBATE_TRANSACTION_REFERENCE
, REBATE_PAYMENT_SYSTEM_CODE
, REDEEMED_DATE
, REDEEMED_FLAG
, ACCRUAL_FLAG
, RANGE_BREAK_QUANTITY
, ACCRUAL_CONVERSION_RATE
, PRICING_GROUP_SEQUENCE
, MODIFIER_LEVEL_CODE
, PRICE_BREAK_TYPE_CODE
, SUBSTITUTION_ATTRIBUTE
, PRORATION_TYPE_CODE
, CREDIT_OR_CHARGE_FLAG
, INCLUDE_ON_RETURNS_FLAG
, AC_CONTEXT
, AC_ATTRIBUTE1
, AC_ATTRIBUTE2
, AC_ATTRIBUTE3
, AC_ATTRIBUTE4
, AC_ATTRIBUTE5
, AC_ATTRIBUTE6
, AC_ATTRIBUTE7
, AC_ATTRIBUTE8
, AC_ATTRIBUTE9
, AC_ATTRIBUTE10
, AC_ATTRIBUTE11
, AC_ATTRIBUTE12
, AC_ATTRIBUTE13
, AC_ATTRIBUTE14
, AC_ATTRIBUTE15
, OPERAND_PER_PQTY
, ADJUSTED_AMOUNT_PER_PQTY
, INVOICED_AMOUNT
, TAX_RATE_ID
FROM OE_PRICE_ADJUSTMENTS_V