APPS.GMIVITM SQL Statements

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

Line: 20

Select count(*)
from   ic_rank_mst
where  abc_code=p_item_rec.item_abccode and delete_mark = 0;

Line: 30

       select 1 into row_count from ic_allc_cls
       where alloc_class=RTRIM(p_item_rec.alloc_class) and delete_mark = 0;

Line: 41

       select 1 into row_count from ic_cost_cls
       where itemcost_class=RTRIM(p_item_rec.itemcost_class) and delete_mark = 0;

Line: 52

       select 1 into row_count from ic_ctms_cls
       where iccustoms_class=RTRIM(p_item_rec.customs_class) and delete_mark = 0;

Line: 64

       select 1 into row_count from ic_frgt_cls
       where icfrt_class=RTRIM(p_item_rec.frt_class) and delete_mark = 0;

Line: 76

       select 1 into row_count from ic_gled_cls
       where icgl_class=RTRIM(p_item_rec.gl_class) and delete_mark = 0;

Line: 87

       select 1 into row_count from ic_invn_cls
       where icinv_class=RTRIM(p_item_rec.inv_class) and delete_mark = 0;

Line: 98

       select 1 into row_count from ic_prce_cls
       where icprice_class=RTRIM(p_item_rec.price_class) and delete_mark = 0;

Line: 109

       select 1 into row_count from ic_prch_cls
       where icpurch_class=RTRIM(p_item_rec.purch_class) and delete_mark = 0;

Line: 133

       select 1 into row_count from ic_sale_cls
       where icsales_class=RTRIM(p_item_rec.sales_class) and delete_mark = 0;

Line: 145

       select 1 into row_count from ic_ship_cls
       where icship_class=RTRIM(p_item_rec.ship_class) and delete_mark = 0;

Line: 157

       select 1 into row_count from ic_stor_cls
       where icstorage_class=RTRIM(p_item_rec.storage_class) and delete_mark = 0;

Line: 169

       select 1 into row_count from ic_taxn_cls
       where ictax_class=RTRIM(p_item_rec.tax_class) and delete_mark = 0;

Line: 181

       select 1 into row_count from ps_plng_cls
       where planning_class=RTRIM(p_item_rec.planning_class) and delete_mark = 0;

Line: 193

       select 1 into row_count from qc_hres_mst
       where qchold_res_code=RTRIM(p_item_rec.qchold_res_code) and delete_mark = 0;

Line: 205

       select 1 into row_count from cr_sqdt_cls
       where seq_dpnd_class=RTRIM(p_item_rec.seq_dpnd_class) and delete_mark = 0;

Line: 217

       select 1 into row_count from ic_invn_typ
       where inv_type=RTRIM(p_item_rec.inv_type) and delete_mark = 0;

Line: 229

       select 1 into row_count from cm_mthd_mst
       where cost_mthd_code=RTRIM(p_item_rec.cost_mthd_code) and delete_mark = 0;

Line: 243

       select 1 into row_count from gl_business_cls_vw
       where gl_business_class=RTRIM(p_item_rec.gl_business_class) and delete_mark = 0;

Line: 255

       select 1 into row_count from gl_prod_line_vw
       where gl_product_line=RTRIM(p_item_rec.gl_prod_line) and delete_mark = 0;

Line: 267

       select 1 into row_count from sub_std_item_cls_vw
       where sub_standard_class=RTRIM(p_item_rec.sub_standard_class) and delete_mark = 0;

Line: 279

       select 1 into row_count from tech_cls_subcls_vw
       where tech_class=RTRIM(p_item_rec.tech_class) and delete_mark = 0;

Line: 302

  SELECT 1 INTO l_row_count
  FROM ic_comd_cds
  WHERE commodity_code=UPPER(p_item_rec.commodity_code)
  AND   delete_mark = 0;

Line: 790

  x_ic_item_mst_row.last_update_date   := SYSDATE;

Line: 792

  x_ic_item_mst_row.last_updated_by    := GMIGUTL.DEFAULT_USER_ID;

Line: 793

  x_ic_item_mst_row.last_update_login  := GMIGUTL.DEFAULT_LOGIN;

Line: 794

  x_ic_item_mst_row.delete_mark        := 0;

Line: 902

    x_ic_item_cpg_row.last_update_date   := SYSDATE;

Line: 904

    x_ic_item_cpg_row.last_updated_by    := GMIGUTL.DEFAULT_USER_ID;

Line: 905

    x_ic_item_cpg_row.last_update_login  := GMIGUTL.DEFAULT_LOGIN;