VIEW: APPS.ASO_PVT_HEADER_CHARGES_UI_V

Source

View Text - Preformatted

SELECT Charges.MODIFIER_HEADER_ID , Charges.MODIFIER_LINE_ID , Charges.MODIFIER_LINE_TYPE_CODE , Charges.MODIFIER_LEVEL_CODE , Charges.charge_type_code, Charges.charge_subtype_code, QPLHT.NAME , QPLHT.DESCRIPTION, QPLHB.Comments, SUM(DECODE(aql.line_category_code, 'RETURN', -1, 1) * Charges.adjusted_amount * DECODE(AQL.quantity, null, 1, AQL.quantity)) charge_amount, Charges.quote_header_id, Charges.applied_flag, Charges.arithmetic_operator, Charges.list_line_no, Charges.list_header_id, Charges.list_line_id FROM aso_price_adjustments Charges, aso_quote_lines aql, qp_list_headers_tl QPLHT, qp_list_headers_b QPLHB WHERE Charges.adjusted_amount is not null AND aql.quote_line_id(+) = Charges.quote_line_id AND QPLHT.list_header_id = Charges.modifier_header_id AND QPLHT.list_header_id = QPLHB.list_header_id and QPLHT.language = userenv('LANG') GROUP BY Charges.modifier_line_id, Charges.modifier_header_id, Charges.modifier_level_code, Charges.modifier_line_type_code, Charges.charge_type_code, Charges.charge_subtype_code, QPLHT.name, QPLHT.description, QPLHB.comments, Charges.quote_header_id, Charges.applied_flag, Charges.arithmetic_operator,Charges.list_line_no,Charges.list_header_id, Charges.list_line_id

View Text - HTML Formatted

SELECT CHARGES.MODIFIER_HEADER_ID
, CHARGES.MODIFIER_LINE_ID
, CHARGES.MODIFIER_LINE_TYPE_CODE
, CHARGES.MODIFIER_LEVEL_CODE
, CHARGES.CHARGE_TYPE_CODE
, CHARGES.CHARGE_SUBTYPE_CODE
, QPLHT.NAME
, QPLHT.DESCRIPTION
, QPLHB.COMMENTS
, SUM(DECODE(AQL.LINE_CATEGORY_CODE
, 'RETURN'
, -1
, 1) * CHARGES.ADJUSTED_AMOUNT * DECODE(AQL.QUANTITY
, NULL
, 1
, AQL.QUANTITY)) CHARGE_AMOUNT
, CHARGES.QUOTE_HEADER_ID
, CHARGES.APPLIED_FLAG
, CHARGES.ARITHMETIC_OPERATOR
, CHARGES.LIST_LINE_NO
, CHARGES.LIST_HEADER_ID
, CHARGES.LIST_LINE_ID
FROM ASO_PRICE_ADJUSTMENTS CHARGES
, ASO_QUOTE_LINES AQL
, QP_LIST_HEADERS_TL QPLHT
, QP_LIST_HEADERS_B QPLHB
WHERE CHARGES.ADJUSTED_AMOUNT IS NOT NULL
AND AQL.QUOTE_LINE_ID(+) = CHARGES.QUOTE_LINE_ID
AND QPLHT.LIST_HEADER_ID = CHARGES.MODIFIER_HEADER_ID
AND QPLHT.LIST_HEADER_ID = QPLHB.LIST_HEADER_ID
AND QPLHT.LANGUAGE = USERENV('LANG') GROUP BY CHARGES.MODIFIER_LINE_ID
, CHARGES.MODIFIER_HEADER_ID
, CHARGES.MODIFIER_LEVEL_CODE
, CHARGES.MODIFIER_LINE_TYPE_CODE
, CHARGES.CHARGE_TYPE_CODE
, CHARGES.CHARGE_SUBTYPE_CODE
, QPLHT.NAME
, QPLHT.DESCRIPTION
, QPLHB.COMMENTS
, CHARGES.QUOTE_HEADER_ID
, CHARGES.APPLIED_FLAG
, CHARGES.ARITHMETIC_OPERATOR
, CHARGES.LIST_LINE_NO
, CHARGES.LIST_HEADER_ID
, CHARGES.LIST_LINE_ID