APPS.OKS_WARRDATA_PUB SQL Statements

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

Line: 15

       SELECT KL.id,
              KL.sts_code,
              KL.start_date,
              KL.end_date

        FROM  okc_k_headers_v KH,
              okc_k_lines_v   KL,
              okc_k_items_v   KI,
              okc_statuses_v  ST

       WHERE  KI.object1_id1       = to_char(P_INSTANCE_ID)
         AND  KI.jtot_object1_code = 'OKX_CUSTPROD'
         AND  KI.cle_id            = KL.id
         AND  KL.lse_id            = 18
         AND  KL.dnz_chr_id        = KH.id
         AND  KH.scs_code          = 'WARRANTY'
         AND  KL.date_terminated is not null
         AND  KL.sts_code          = ST.code
         AND  ST.ste_code not in   ('EXPIRED' , 'CANCELLED');

Line: 41

      UPDATE okc_k_lines_b
      Set date_terminated = null
      where id =  l_get_sublines_rec.id;

Line: 48

                   Update OKC_K_LINES_B set sts_code = 'SIGNED'  Where id = l_get_sublines_rec.id;

Line: 51

                             Update Okc_k_lines_b Set sts_code = 'ACTIVE' Where id = l_get_sublines_rec.id;