APPS.GMI_ERES_UTILS SQL Statements

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

Line: 11

  SELECT item_no
  FROM   ic_item_mst
  WHERE  item_id = pitem_id;

Line: 31

  SELECT item_um
  FROM   ic_item_mst
  WHERE  item_id = pitem_id;

Line: 52

  SELECT item_desc1
  FROM   ic_item_mst
  WHERE  item_id = pitem_id;

Line: 72

  SELECT um_type
  FROM   sy_uoms_mst
  WHERE  um_code = pum;

Line: 93

  SELECT std_um
  FROM   sy_uoms_typ
  WHERE  um_type = pum_type;

Line: 116

  SELECT m.item_um, s.um_type
  FROM   ic_item_mst m, sy_uoms_mst s
  WHERE  m.item_id = pitem_id AND
         m.item_um = s.um_code;

Line: 139

  SELECT lot_no
  FROM   ic_lots_mst
  WHERE  lot_id = plot_id AND
         item_id = pitem_id;

Line: 162

  SELECT sublot_no
  FROM   ic_lots_mst
  WHERE  lot_id = plot_id AND
         item_id = pitem_id;

Line: 185

  SELECT lot_desc
  FROM   ic_lots_mst
  WHERE  lot_id = plot_id AND
         item_id = pitem_id;

Line: 208

  SELECT meaning
  FROM fnd_lookup_values_vl
  WHERE  lookup_type = plookup_type  and
         lookup_code = plookup_code;

Line: 230

  SELECT vendor_no
  FROM   po_vend_mst
  WHERE  vendor_id = pvendor_id;

Line: 250

  SELECT vendor_name
  FROM   po_vend_mst
  WHERE  vendor_id = pvendor_id;

Line: 281

      UPDATE ic_item_mst_b
       SET inactive_ind = 0,
           trans_cnt = -99
       WHERE item_id = pitem_id;

Line: 304

  SELECT journal_no
  FROM   ic_jrnl_mst
  WHERE  journal_id = pjournal_id;

Line: 324

  SELECT qc_grade_desc
  FROM   qc_grad_mst
  WHERE  qc_grade = pgrade;

Line: 344

  SELECT status_desc
  FROM   ic_lots_sts
  WHERE  lot_status = pstatus;

Line: 364

  SELECT reason_desc1
  FROM   sy_reas_cds
  WHERE  reason_code = preason_code;

Line: 386

  SELECT whse_name
  FROM   ic_whse_mst
  WHERE  whse_code = pwhse_code;

Line: 408

  SELECT journal_comment
  FROM   ic_jrnl_mst
  WHERE  journal_id = pjournal_id;

Line: 431

  SELECT *
  FROM   mtl_categories
  WHERE  structure_id = pstructure_id
  AND    category_id = pcategory_id;

Line: 502

  SELECT *
  FROM   ic_item_mst_b
  WHERE  item_id = pitem_id;

Line: 594

  SELECT batch_no
  FROM   gme_batch_header
  WHERE  batch_id = pbatch_id;

Line: 615

  SELECT ic_hold_date
  FROM   ic_lots_cpg
  WHERE  item_id = pitem_id
  AND    lot_id = plot_id;