APPS.ONT_FREIGHT_UTIL SQL Statements

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

Line: 48

select b.list_header_id,
       b.list_line_id,
       b.list_line_type_code,
       b.start_date_active,
       b.end_date_active,
       b.modifier_level_code,
       b.pricing_phase_id,
       b.incompatibility_grp_code,
       b.price_break_type_code,
       b.operand,
       b.automatic_flag,
       b.arithmetic_operator,
       b.qualification_ind,
       b.product_precedence,
       b.price_by_formula_id
from qp_list_headers_vl a,
     qp_list_lines b
where a.name = p_header_name
and   a.list_header_id = b.list_header_id;

Line: 69

select b.list_header_id,
       b.list_line_id,
       b.list_line_type_code,
       b.start_date_active,
       b.end_date_active,
       b.modifier_level_code,
       b.pricing_phase_id,
       b.incompatibility_grp_code,
       b.price_break_type_code,
       b.operand,
       b.automatic_flag,
       b.arithmetic_operator,
       b.qualification_ind,
       b.product_precedence,
       b.price_by_formula_id
From qp_list_lines b
where list_line_id = p_list_line_id;

Line: 88

select  list_line_id
	 , list_header_id
	 , pricing_phase_id
	 , product_attribute_context
	 , product_attribute
	 , product_attr_value
	 , product_uom_code
	 , comparison_operator_code
	 , pricing_attribute_context
	 , pricing_attribute
	 , pricing_attr_value_from
	 , pricing_attr_value_to
	 , attribute_grouping_no
	 , qualification_ind
	 , excluder_flag
from  qp_pricing_attributes
where list_line_id = p_list_line_id;

Line: 106

/*select dl.delivery_id,
       pa.line_id,
       pa.cost_id,
       pa.list_line_type_code,
       pa.adjusted_amount,
       pa.operand
from oe_price_adjustments pa,
    wsh_delivery_details dd,
    wsh_delivery_assignments da,
    wsh_new_deliveries dl
where dl.name = 'delivery_name'
and dl.delivery_id = da.delivery_id
and da.delivery_detail_id = dd.delivery_detail_id
and dd.source_code = 'OE'
and dd.source_line_id = pa.line_id
and pa.list_line_type_code = 'COST'; */

Line: 124

Select CHARGE_TYPE_CODE,Adjusted_amount
From   oe_price_adjustments
Where  line_id = l_line_rec.line_id
and    list_line_type_code = 'COST';

Line: 130

Select a.pricing_attribute_context,
       a.pricing_attribute,
       a.price_formula_line_id,
       a.numeric_constant,
       a.step_number,
       a.start_date_active,
       a.end_date_active,
       b.name
From   qp_price_formula_lines a,
       qp_price_formulas_vl b
Where  a.price_formula_id = p_price_formula_id
and    b.price_formula_id = p_price_formula_id;

Line: 150

   Select org_id into l_org_id
   From   oe_order_lines_all
   Where  line_id = p_line_id;

Line: 208

    Select list_header_id,
           pricing_phase_id
    Into   l_list_header_id,l_pricing_phase_id
    from   qp_list_header_phases
    where  list_header_id = l_list_line_info.list_header_id;

Line: 217

      Select list_line_id into l_dummy
      From   qp_qualifiers
      Where  list_header_id = l_list_line_info.list_header_id
      and    nvl(list_line_id,-1)   = l_list_line_id
      and    rownum = 1;

Line: 243

  select a.freeze_override_flag
  into l_freeze_override_flag
  from qp_pricing_phases a, qp_event_phases b
  where a.pricing_phase_id = b.pricing_phase_id
        and b.pricing_event_code='SHIP'
        and a.pricing_phase_id  =l_list_line_info.pricing_phase_id;

Line: 378

 Select inv_interfaced_flag, oe_interfaced_flag
 Into   l_inv_interfaced_flag,l_oe_interfaced_flag
 From   wsh_delivery_details
 Where  source_line_id = l_line_rec.line_id;

Line: 415

       SELECT SUM(ADJUSTED_AMOUNT)
	  INTO l_cost_amount
	  FROM OE_PRICE_ADJUSTMENTS_V
	  WHERE LINE_ID = l_line_rec.line_id
	  AND LIST_LINE_TYPE_CODE = 'COST'
	  AND CHARGE_TYPE_CODE = l_cost_type_code;

Line: 422

 DBMS_DEBUG('  Passed. Cost record inserted with value:'||l_cost_amount);

Line: 433

  DBMS_DEBUG(' Inserted charge cost type in OM:'||i.charge_type_code);

Line: 464

Select pricing_status_code
into   l_pricing_status_code
From   qp_preq_ldets_tmp
Where  created_from_list_line_id = l_list_line_info.list_line_id;