DBA Data[Home] [Help]

APPS.ASO_QUOTE_PUB_W dependencies on ASO_PRICE_ADJUSTMENTS

Line 14306: FROM ASO_PRICE_ADJUSTMENTS

14302: price adjusted amount for a quote line */
14303: CURSOR C_Ttl_Line_Manu_Prc_Adj_Amt (p_quote_line_id IN NUMBER)
14304: IS
14305: SELECT SUM(NVL(adjusted_amount, 0))
14306: FROM ASO_PRICE_ADJUSTMENTS
14307: WHERE applied_flag = 'Y'
14308: AND update_allowed = 'Y'
14309: AND NVL(modifier_line_type_code, 'X') <> 'FREIGHT_CHARGE'
14310: AND quote_line_id = p_quote_line_id

Line 14319: FROM ASO_PRICE_ADJUSTMENTS apa

14315: CURSOR C_Ttl_Hdr_Manu_Prc_Adj_Op (p_quote_header_id IN NUMBER)
14316: IS
14317: SELECT SUM(NVL(apa.operand, 0) *
14318: DECODE(NVL(apa.modifier_line_type_code, 'X'), 'SUR', -1, 1))
14319: FROM ASO_PRICE_ADJUSTMENTS apa
14320: WHERE apa.quote_line_id IS NULL
14321: AND NVL(apa.modifier_line_type_code, 'X') <> 'FREIGHT_CHARGE'
14322: AND apa.update_allowed = 'Y'
14323: AND apa.applied_flag = 'Y'