DBA Data[Home] [Help]

APPS.ASO_SHIPPING_INT dependencies on ASO_QUOTE_LINES_ALL

Line 35: aso_quote_lines_all AQLA

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
39: AND APA.quote_line_id = AQLA.quote_line_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