APPS.OE_SERVICE_WF SQL Statements

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

Line: 36

    SELECT NVL(m.serviceable_product_flag, 'N')
    INTO  l_serviceable_flag
    FROM   oe_order_lines l,
           mtl_system_items m
    WHERE  l.line_id = l_line_id
    AND	   l.inventory_item_id = m.inventory_item_id
    AND    m.organization_id = to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));

Line: 45

      Update oe_order_lines_all
      Set service_credit_eligible_code = l_credit_type
      Where line_id=l_line_id;

Line: 50

      Update oe_order_lines_all
      Set service_credit_eligible_code = 'NONE'
      Where line_id=l_line_id;