VIEW: APPS.ASO_PVT_LINE_CHARGES_UI_V

Source

View Text - Preformatted

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