VIEW: APPS.ASO_PRICE_ADJUSTMENTS_V

Source

View Text - Preformatted

SELECT PRICE_ADJ.ROWID ,PRICE_ADJ.PRICE_ADJUSTMENT_ID ,PRICE_ADJ.CREATION_DATE ,PRICE_ADJ.CREATED_BY ,PRICE_ADJ.LAST_UPDATE_DATE ,PRICE_ADJ.LAST_UPDATED_BY ,PRICE_ADJ.LAST_UPDATE_LOGIN ,PRICE_ADJ.PROGRAM_APPLICATION_ID ,PRICE_ADJ.PROGRAM_ID ,PRICE_ADJ.PROGRAM_UPDATE_DATE ,PRICE_ADJ.REQUEST_ID ,PRICE_ADJ.QUOTE_HEADER_ID ,PRICE_ADJ.QUOTE_LINE_ID ,PRICE_ADJ.MODIFIER_HEADER_ID ,PRICE_ADJ.MODIFIER_LINE_ID ,PRICE_ADJ.MODIFIER_LINE_TYPE_CODE ,PRICE_ADJ.MODIFIER_MECHANISM_TYPE_CODE ,PRICE_ADJ.MODIFIED_FROM ,PRICE_ADJ.MODIFIED_TO ,PRICE_ADJ.OPERAND ,PRICE_ADJ.ARITHMETIC_OPERATOR ,PRICE_ADJ.AUTOMATIC_FLAG ,PRICE_ADJ.UPDATE_ALLOWABLE_FLAG ,PRICE_ADJ.UPDATED_FLAG ,PRICE_ADJ.APPLIED_FLAG ,PRICE_ADJ.ON_INVOICE_FLAG ,PRICE_ADJ.PRICING_PHASE_ID ,PRICE_ADJ.ATTRIBUTE_CATEGORY ,PRICE_ADJ.ATTRIBUTE1 ,PRICE_ADJ.ATTRIBUTE2 ,PRICE_ADJ.ATTRIBUTE3 ,PRICE_ADJ.ATTRIBUTE4 ,PRICE_ADJ.ATTRIBUTE5 ,PRICE_ADJ.ATTRIBUTE6 ,PRICE_ADJ.ATTRIBUTE7 ,PRICE_ADJ.ATTRIBUTE8 ,PRICE_ADJ.ATTRIBUTE9 ,PRICE_ADJ.ATTRIBUTE10 ,PRICE_ADJ.ATTRIBUTE11 ,PRICE_ADJ.ATTRIBUTE12 ,PRICE_ADJ.ATTRIBUTE13 ,PRICE_ADJ.ATTRIBUTE14 ,PRICE_ADJ.ATTRIBUTE15 ,PRICE_ADJ.ORIG_SYS_DISCOUNT_REF ,PRICE_ADJ.CHANGE_SEQUENCE ,PRICE_ADJ.LIST_HEADER_ID ,PRICE_ADJ.LIST_LINE_ID ,PRICE_ADJ.LIST_LINE_TYPE_CODE ,PRICE_ADJ.UPDATE_ALLOWED ,PRICE_ADJ.CHANGE_REASON_CODE ,PRICE_ADJ.CHANGE_REASON_TEXT ,PRICE_ADJ.COST_ID ,PRICE_ADJ.TAX_CODE ,PRICE_ADJ.TAX_EXEMPT_FLAG ,PRICE_ADJ.TAX_EXEMPT_NUMBER ,PRICE_ADJ.TAX_EXEMPT_REASON_CODE ,PRICE_ADJ.PARENT_ADJUSTMENT_ID ,PRICE_ADJ.INVOICED_FLAG ,PRICE_ADJ.ESTIMATED_FLAG ,PRICE_ADJ.INC_IN_SALES_PERFORMANCE ,PRICE_ADJ.SPLIT_ACTION_CODE ,PRICE_ADJ.ADJUSTED_AMOUNT ,PRICE_ADJ.CHARGE_TYPE_CODE ,PRICE_ADJ.CHARGE_SUBTYPE_CODE ,PRICE_ADJ.RANGE_BREAK_QUANTITY ,PRICE_ADJ.ACCRUAL_CONVERSION_RATE ,PRICE_ADJ.PRICING_GROUP_SEQUENCE ,PRICE_ADJ.ACCRUAL_FLAG ,PRICE_ADJ.LIST_LINE_NO ,PRICE_ADJ.SOURCE_SYSTEM_CODE ,PRICE_ADJ.BENEFIT_QTY ,PRICE_ADJ.BENEFIT_UOM_CODE ,PRICE_ADJ.PRINT_ON_INVOICE_FLAG ,PRICE_ADJ.EXPIRATION_DATE ,PRICE_ADJ.REBATE_TRANSACTION_TYPE_CODE ,PRICE_ADJ.REBATE_TRANSACTION_REFERENCE ,PRICE_ADJ.REBATE_PAYMENT_SYSTEM_CODE ,PRICE_ADJ.REDEEMED_DATE ,PRICE_ADJ.REDEEMED_FLAG ,PRICE_ADJ.MODIFIER_LEVEL_CODE ,PRICE_ADJ.PRICE_BREAK_TYPE_CODE ,PRICE_ADJ.SUBSTITUTION_ATTRIBUTE ,PRICE_ADJ.PRORATION_TYPE_CODE ,PRICE_ADJ.INCLUDE_ON_RETURNS_FLAG ,PRICE_ADJ.CREDIT_OR_CHARGE_FLAG ,QPLH.DESCRIPTION ,QPLB.COMMENTS from ASO_PRICE_ADJUSTMENTS PRICE_ADJ, QP_LIST_HEADERS_TL QPLH, QP_LIST_HEADERS_B QPLB WHERE PRICE_ADJ.MODIFIER_HEADER_ID =QPLH.LIST_HEADER_ID AND QPLH.LIST_HEADER_ID = QPLB.LIST_HEADER_ID AND QPLH.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT PRICE_ADJ.ROWID
, PRICE_ADJ.PRICE_ADJUSTMENT_ID
, PRICE_ADJ.CREATION_DATE
, PRICE_ADJ.CREATED_BY
, PRICE_ADJ.LAST_UPDATE_DATE
, PRICE_ADJ.LAST_UPDATED_BY
, PRICE_ADJ.LAST_UPDATE_LOGIN
, PRICE_ADJ.PROGRAM_APPLICATION_ID
, PRICE_ADJ.PROGRAM_ID
, PRICE_ADJ.PROGRAM_UPDATE_DATE
, PRICE_ADJ.REQUEST_ID
, PRICE_ADJ.QUOTE_HEADER_ID
, PRICE_ADJ.QUOTE_LINE_ID
, PRICE_ADJ.MODIFIER_HEADER_ID
, PRICE_ADJ.MODIFIER_LINE_ID
, PRICE_ADJ.MODIFIER_LINE_TYPE_CODE
, PRICE_ADJ.MODIFIER_MECHANISM_TYPE_CODE
, PRICE_ADJ.MODIFIED_FROM
, PRICE_ADJ.MODIFIED_TO
, PRICE_ADJ.OPERAND
, PRICE_ADJ.ARITHMETIC_OPERATOR
, PRICE_ADJ.AUTOMATIC_FLAG
, PRICE_ADJ.UPDATE_ALLOWABLE_FLAG
, PRICE_ADJ.UPDATED_FLAG
, PRICE_ADJ.APPLIED_FLAG
, PRICE_ADJ.ON_INVOICE_FLAG
, PRICE_ADJ.PRICING_PHASE_ID
, PRICE_ADJ.ATTRIBUTE_CATEGORY
, PRICE_ADJ.ATTRIBUTE1
, PRICE_ADJ.ATTRIBUTE2
, PRICE_ADJ.ATTRIBUTE3
, PRICE_ADJ.ATTRIBUTE4
, PRICE_ADJ.ATTRIBUTE5
, PRICE_ADJ.ATTRIBUTE6
, PRICE_ADJ.ATTRIBUTE7
, PRICE_ADJ.ATTRIBUTE8
, PRICE_ADJ.ATTRIBUTE9
, PRICE_ADJ.ATTRIBUTE10
, PRICE_ADJ.ATTRIBUTE11
, PRICE_ADJ.ATTRIBUTE12
, PRICE_ADJ.ATTRIBUTE13
, PRICE_ADJ.ATTRIBUTE14
, PRICE_ADJ.ATTRIBUTE15
, PRICE_ADJ.ORIG_SYS_DISCOUNT_REF
, PRICE_ADJ.CHANGE_SEQUENCE
, PRICE_ADJ.LIST_HEADER_ID
, PRICE_ADJ.LIST_LINE_ID
, PRICE_ADJ.LIST_LINE_TYPE_CODE
, PRICE_ADJ.UPDATE_ALLOWED
, PRICE_ADJ.CHANGE_REASON_CODE
, PRICE_ADJ.CHANGE_REASON_TEXT
, PRICE_ADJ.COST_ID
, PRICE_ADJ.TAX_CODE
, PRICE_ADJ.TAX_EXEMPT_FLAG
, PRICE_ADJ.TAX_EXEMPT_NUMBER
, PRICE_ADJ.TAX_EXEMPT_REASON_CODE
, PRICE_ADJ.PARENT_ADJUSTMENT_ID
, PRICE_ADJ.INVOICED_FLAG
, PRICE_ADJ.ESTIMATED_FLAG
, PRICE_ADJ.INC_IN_SALES_PERFORMANCE
, PRICE_ADJ.SPLIT_ACTION_CODE
, PRICE_ADJ.ADJUSTED_AMOUNT
, PRICE_ADJ.CHARGE_TYPE_CODE
, PRICE_ADJ.CHARGE_SUBTYPE_CODE
, PRICE_ADJ.RANGE_BREAK_QUANTITY
, PRICE_ADJ.ACCRUAL_CONVERSION_RATE
, PRICE_ADJ.PRICING_GROUP_SEQUENCE
, PRICE_ADJ.ACCRUAL_FLAG
, PRICE_ADJ.LIST_LINE_NO
, PRICE_ADJ.SOURCE_SYSTEM_CODE
, PRICE_ADJ.BENEFIT_QTY
, PRICE_ADJ.BENEFIT_UOM_CODE
, PRICE_ADJ.PRINT_ON_INVOICE_FLAG
, PRICE_ADJ.EXPIRATION_DATE
, PRICE_ADJ.REBATE_TRANSACTION_TYPE_CODE
, PRICE_ADJ.REBATE_TRANSACTION_REFERENCE
, PRICE_ADJ.REBATE_PAYMENT_SYSTEM_CODE
, PRICE_ADJ.REDEEMED_DATE
, PRICE_ADJ.REDEEMED_FLAG
, PRICE_ADJ.MODIFIER_LEVEL_CODE
, PRICE_ADJ.PRICE_BREAK_TYPE_CODE
, PRICE_ADJ.SUBSTITUTION_ATTRIBUTE
, PRICE_ADJ.PRORATION_TYPE_CODE
, PRICE_ADJ.INCLUDE_ON_RETURNS_FLAG
, PRICE_ADJ.CREDIT_OR_CHARGE_FLAG
, QPLH.DESCRIPTION
, QPLB.COMMENTS
FROM ASO_PRICE_ADJUSTMENTS PRICE_ADJ
, QP_LIST_HEADERS_TL QPLH
, QP_LIST_HEADERS_B QPLB
WHERE PRICE_ADJ.MODIFIER_HEADER_ID =QPLH.LIST_HEADER_ID
AND QPLH.LIST_HEADER_ID = QPLB.LIST_HEADER_ID
AND QPLH.LANGUAGE = USERENV('LANG')