APPS.ASO_SHIPPING_INT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 21

      SELECT APA.operand            ,
             APA.arithmetic_operator
      FROM aso_price_adjustments APA
      WHERE APA.modifier_line_type_code = 'FREIGHT_CHARGE'
        AND APA.quote_header_id = l_quote_header_id
        AND APA.quote_line_id IS NULL
	   AND APA.APPLIED_FLAG = 'Y';

Line: 30

      SELECT APA.operand            ,
             APA.arithmetic_operator,
             AQLA.quantity          ,
             AQLA.line_list_price
      FROM aso_price_adjustments APA,
           aso_quote_lines_all   AQLA
      WHERE APA.modifier_line_type_code = 'FREIGHT_CHARGE'
        AND APA.quote_header_id = l_quote_header_id
--        AND APA.quote_header_id = AQLA.quote_header_id
        AND APA.quote_line_id   = AQLA.quote_line_id
	   AND APA.APPLIED_FLAG = 'Y';

Line: 80

   select p.operand, p.arithmetic_operator, l.quantity, l.line_list_price,p.ADJUSTED_AMOUNT
   from aso_price_adjustments p, aso_quote_lines_all l
   where p.modifier_line_type_code = 'FREIGHT_CHARGE'
   and p.quote_line_id = l.quote_line_id
   and p.quote_header_id = l_qte_header_id
   and p.quote_line_id = l_qte_line_id
   AND p.APPLIED_FLAG = 'Y';

Line: 207

      SELECT APA.operand            ,
             APA.arithmetic_operator
      FROM aso_price_adjustments APA
      WHERE APA.modifier_line_type_code = 'FREIGHT_CHARGE'
        AND APA.quote_header_id = l_quote_header_id
        AND APA.quote_line_id IS NULL
	   AND APA.APPLIED_FLAG = 'Y';