VIEW: APPS.ASO_OA_PRICE_ADJ_HDR_V

Source

View Text - Preformatted

SELECT PRICE_ADJUSTMENT_ID , CREATION_DATE , CREATED_BY , LAST_UPDATE_DATE , LAST_UPDATED_BY , LAST_UPDATE_LOGIN , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , REQUEST_ID , QUOTE_HEADER_ID , MODIFIER_HEADER_ID , MODIFIER_LINE_ID , MODIFIER_LINE_TYPE_CODE , MODIFIER_MECHANISM_TYPE_CODE , MODIFIED_FROM , MODIFIED_TO , OPERAND , ARITHMETIC_OPERATOR , AUTOMATIC_FLAG , UPDATE_ALLOWABLE_FLAG , UPDATED_FLAG , APPLIED_FLAG , ON_INVOICE_FLAG , PRICING_PHASE_ID , ATTRIBUTE_CATEGORY , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , ATTRIBUTE16 , ATTRIBUTE17 , ATTRIBUTE18 , ATTRIBUTE19 , ATTRIBUTE20 , ORIG_SYS_DISCOUNT_REF , CHANGE_SEQUENCE , LIST_HEADER_ID , LIST_LINE_ID , LIST_LINE_TYPE_CODE , UPDATE_ALLOWED , CHANGE_REASON_CODE , CHANGE_REASON_TEXT , 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 , 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 , REBATE_TRANSACTION_TYPE_CODE , REBATE_TRANSACTION_REFERENCE , REBATE_PAYMENT_SYSTEM_CODE , REDEEMED_DATE , REDEEMED_FLAG , MODIFIER_LEVEL_CODE , PRICE_BREAK_TYPE_CODE , SUBSTITUTION_ATTRIBUTE , PRORATION_TYPE_CODE , INCLUDE_ON_RETURNS_FLAG , CREDIT_OR_CHARGE_FLAG , QUOTE_SHIPMENT_ID , SECURITY_GROUP_ID , OBJECT_VERSION_NUMBER, 'S' FROM ASO_PRICE_ADJUSTMENTS WHERE QUOTE_LINE_ID IS NULL

View Text - HTML Formatted

SELECT PRICE_ADJUSTMENT_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, QUOTE_HEADER_ID
, MODIFIER_HEADER_ID
, MODIFIER_LINE_ID
, MODIFIER_LINE_TYPE_CODE
, MODIFIER_MECHANISM_TYPE_CODE
, MODIFIED_FROM
, MODIFIED_TO
, OPERAND
, ARITHMETIC_OPERATOR
, AUTOMATIC_FLAG
, UPDATE_ALLOWABLE_FLAG
, UPDATED_FLAG
, APPLIED_FLAG
, ON_INVOICE_FLAG
, PRICING_PHASE_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ORIG_SYS_DISCOUNT_REF
, CHANGE_SEQUENCE
, LIST_HEADER_ID
, LIST_LINE_ID
, LIST_LINE_TYPE_CODE
, UPDATE_ALLOWED
, CHANGE_REASON_CODE
, CHANGE_REASON_TEXT
, 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
, 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
, REBATE_TRANSACTION_TYPE_CODE
, REBATE_TRANSACTION_REFERENCE
, REBATE_PAYMENT_SYSTEM_CODE
, REDEEMED_DATE
, REDEEMED_FLAG
, MODIFIER_LEVEL_CODE
, PRICE_BREAK_TYPE_CODE
, SUBSTITUTION_ATTRIBUTE
, PRORATION_TYPE_CODE
, INCLUDE_ON_RETURNS_FLAG
, CREDIT_OR_CHARGE_FLAG
, QUOTE_SHIPMENT_ID
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
, 'S'
FROM ASO_PRICE_ADJUSTMENTS
WHERE QUOTE_LINE_ID IS NULL