APPS.OE_LINE_REPRICE SQL Statements

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

Line: 17

    SELECT qp.modifier_level_code
    FROM   qp_pricing_phases qp, qp_event_phases qe
    WHERE  qp.pricing_phase_id = qe.pricing_phase_id
    AND    qe.pricing_event_code = p_repricing_event;

Line: 90

  l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

Line: 224

  select header_id, order_source_id, orig_sys_document_ref,
         orig_sys_line_ref, orig_sys_shipment_ref, change_sequence,
         source_document_type_id,source_document_id,source_document_line_id
  into   l_header_id, l_order_source_id, l_orig_sys_document_ref,
         l_orig_sys_line_ref, l_orig_sys_shipment_ref, l_change_sequence,
         l_source_document_type_id, l_source_document_id, l_source_document_line_id
  from   oe_order_lines_all
  where   line_id = to_number(p_item_key);

Line: 541

     Update oe_order_lines_all
     Set flow_status_code = p_flow_status
     Where line_id = p_line_id;