APPS.ASO_SHIPPING_INT dependencies on ASO_PRICE_ADJUSTMENTS

Line 23: FROM aso_price_adjustments APA

19:
20: CURSOR header_freight_cursor(l_quote_header_id NUMBER) IS
21: SELECT APA.operand ,
22: APA.arithmetic_operator
23: FROM aso_price_adjustments APA
24: WHERE APA.modifier_line_type_code = 'FREIGHT_CHARGE'
25: AND APA.quote_header_id = l_quote_header_id
26: AND APA.quote_line_id IS NULL
27: AND APA.APPLIED_FLAG = 'Y';

Line 34: FROM aso_price_adjustments APA,

30: SELECT APA.operand ,
31: APA.arithmetic_operator,
32: AQLA.quantity ,
33: AQLA.line_list_price
34: FROM aso_price_adjustments APA,
35: aso_quote_lines_all AQLA
36: WHERE APA.modifier_line_type_code = 'FREIGHT_CHARGE'
37: AND APA.quote_header_id = l_quote_header_id
38: -- AND APA.quote_header_id = AQLA.quote_header_id

Line 81: from aso_price_adjustments p, aso_quote_lines_all l

77: l_adjusted_amount NUMBER;
78:
79: cursor c_line_charge(l_qte_header_id number, l_qte_line_id number ) is
80: select p.operand, p.arithmetic_operator, l.quantity, l.line_list_price,p.ADJUSTED_AMOUNT
81: from aso_price_adjustments p, aso_quote_lines_all l
82: where p.modifier_line_type_code = 'FREIGHT_CHARGE'
83: and p.quote_line_id = l.quote_line_id
84: and p.quote_header_id = l_qte_header_id
85: and p.quote_line_id = l_qte_line_id

Line 209: FROM aso_price_adjustments APA

205:
206: CURSOR header_freight_cursor(l_quote_header_id NUMBER) IS
207: SELECT APA.operand ,
208: APA.arithmetic_operator
209: FROM aso_price_adjustments APA
210: WHERE APA.modifier_line_type_code = 'FREIGHT_CHARGE'
211: AND APA.quote_header_id = l_quote_header_id
212: AND APA.quote_line_id IS NULL
213: AND APA.APPLIED_FLAG = 'Y';