VIEW: APPS.ASO_PVT_LINE_PRICE_ADJ_UI_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.NAME , QPLH.DESCRIPTION, B.COMMENTS FROM ASO_PRICE_ADJUSTMENTS PRICE_ADJ, QP_LIST_HEADERS_TL QPLH, QP_LIST_HEADERS_B B WHERE PRICE_ADJ.MODIFIER_HEADER_ID = QPLH.LIST_HEADER_ID AND QPLH.LANGUAGE = userenv('LANG') AND B.LIST_HEADER_ID = QPLH.LIST_HEADER_ID

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.NAME
, QPLH.DESCRIPTION
, B.COMMENTS
FROM ASO_PRICE_ADJUSTMENTS PRICE_ADJ
, QP_LIST_HEADERS_TL QPLH
, QP_LIST_HEADERS_B B
WHERE PRICE_ADJ.MODIFIER_HEADER_ID = QPLH.LIST_HEADER_ID
AND QPLH.LANGUAGE = USERENV('LANG')
AND B.LIST_HEADER_ID = QPLH.LIST_HEADER_ID