VIEW: APPS.ASO_PVT_HDR_PRICE_ADJ_UI_V

Source

View Text - Preformatted

SELECT PRICE_ADJ.QUOTE_HEADER_ID , PRICE_ADJ.MODIFIER_HEADER_ID , PRICE_ADJ.MODIFIER_LINE_ID , SUM( price_adj.adjusted_amount * DECODE(qte_lines.quantity, null, 1, qte_lines.quantity)) , PRICE_ADJ.MODIFIER_LEVEL_CODE, PRICE_ADJ.LIST_LINE_NO , PRICE_ADJ.list_header_id, PRICE_ADJ.list_line_id , PRICE_ADJ.APPLIED_FLAG, QPLH.NAME, QPLH.DESCRIPTION , QPLB.COMMENTS, PRICE_ADJ.PRICING_GROUP_SEQUENCE, PRICE_ADJ.substitution_attribute, PRICE_ADJ.modifier_line_type_code , price_adj.arithmetic_operator FROM ASO_PRICE_ADJUSTMENTS PRICE_ADJ, QP_LIST_HEADERS_TL QPLH, QP_LIST_HEADERS_B QPLB, aso_quote_lines qte_lines WHERE PRICE_ADJ.MODIFIER_HEADER_ID =QPLH.LIST_HEADER_ID AND QPLH.LIST_HEADER_ID = QPLB.LIST_HEADER_ID AND QPLH.LANGUAGE = userenv('LANG') AND qte_lines.quote_line_id(+) = price_adj.quote_line_id and price_adj.applied_flag='Y' GROUP BY PRICE_ADJ.modifier_line_id, PRICE_ADJ.modifier_header_id, PRICE_ADJ.modifier_level_code, PRICE_ADJ.modifier_line_type_code, price_adj.arithmetic_operator, QPLH.name, QPLH.description, QPLB.comments, PRICE_ADJ.quote_header_id, PRICE_ADJ.applied_flag, PRICE_ADJ.arithmetic_operator,PRICE_ADJ.list_line_no,PRICE_ADJ.list_header_id, PRICE_ADJ.list_line_id, PRICE_ADJ.PRICING_GROUP_SEQUENCE, PRICE_ADJ.substitution_attribute, PRICE_ADJ.modifier_line_type_code

View Text - HTML Formatted

SELECT PRICE_ADJ.QUOTE_HEADER_ID
, PRICE_ADJ.MODIFIER_HEADER_ID
, PRICE_ADJ.MODIFIER_LINE_ID
, SUM( PRICE_ADJ.ADJUSTED_AMOUNT * DECODE(QTE_LINES.QUANTITY
, NULL
, 1
, QTE_LINES.QUANTITY))
, PRICE_ADJ.MODIFIER_LEVEL_CODE
, PRICE_ADJ.LIST_LINE_NO
, PRICE_ADJ.LIST_HEADER_ID
, PRICE_ADJ.LIST_LINE_ID
, PRICE_ADJ.APPLIED_FLAG
, QPLH.NAME
, QPLH.DESCRIPTION
, QPLB.COMMENTS
, PRICE_ADJ.PRICING_GROUP_SEQUENCE
, PRICE_ADJ.SUBSTITUTION_ATTRIBUTE
, PRICE_ADJ.MODIFIER_LINE_TYPE_CODE
, PRICE_ADJ.ARITHMETIC_OPERATOR
FROM ASO_PRICE_ADJUSTMENTS PRICE_ADJ
, QP_LIST_HEADERS_TL QPLH
, QP_LIST_HEADERS_B QPLB
, ASO_QUOTE_LINES QTE_LINES
WHERE PRICE_ADJ.MODIFIER_HEADER_ID =QPLH.LIST_HEADER_ID
AND QPLH.LIST_HEADER_ID = QPLB.LIST_HEADER_ID
AND QPLH.LANGUAGE = USERENV('LANG')
AND QTE_LINES.QUOTE_LINE_ID(+) = PRICE_ADJ.QUOTE_LINE_ID
AND PRICE_ADJ.APPLIED_FLAG='Y' GROUP BY PRICE_ADJ.MODIFIER_LINE_ID
, PRICE_ADJ.MODIFIER_HEADER_ID
, PRICE_ADJ.MODIFIER_LEVEL_CODE
, PRICE_ADJ.MODIFIER_LINE_TYPE_CODE
, PRICE_ADJ.ARITHMETIC_OPERATOR
, QPLH.NAME
, QPLH.DESCRIPTION
, QPLB.COMMENTS
, PRICE_ADJ.QUOTE_HEADER_ID
, PRICE_ADJ.APPLIED_FLAG
, PRICE_ADJ.ARITHMETIC_OPERATOR
, PRICE_ADJ.LIST_LINE_NO
, PRICE_ADJ.LIST_HEADER_ID
, PRICE_ADJ.LIST_LINE_ID
, PRICE_ADJ.PRICING_GROUP_SEQUENCE
, PRICE_ADJ.SUBSTITUTION_ATTRIBUTE
, PRICE_ADJ.MODIFIER_LINE_TYPE_CODE