APPS.GMICVAL SQL Statements

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

Line: 240

      SELECT item_no
      FROM   ic_item_mst
      WHERE  item_id = pitem_id
      AND    delete_mark = 0;

Line: 306

      SELECT item_id
      FROM   ic_item_mst
      WHERE  item_no = UPPER(pitem_no)
      AND    delete_mark = 0;

Line: 368

      SELECT reason_desc1
      FROM   sy_reas_cds
      WHERE  reason_code = UPPER(preason_code)
      AND    delete_mark = 0;

Line: 446

      SELECT whse_code
      FROM   ic_whse_mst
      WHERE  whse_code = UPPER(pwhse_code)
      AND    delete_mark = 0;

Line: 452

      SELECT location
      FROM   ic_loct_mst
      WHERE  location = UPPER(plocation)
      AND    whse_code = UPPER(pwhse_code)
      AND    delete_mark = 0;

Line: 459

      SELECT loct_ctl
      FROM   ic_whse_mst
      WHERE  whse_code = UPPER(pwhse_code);

Line: 613

      SELECT whse_code
      FROM   ic_whse_mst
      WHERE  whse_code = UPPER(pwhse_code)
      AND    orgn_code = UPPER(porgn_code)
      AND    delete_mark = 0;

Line: 620

      SELECT location
      FROM   ic_loct_mst
      WHERE  location = UPPER(plocation)
      AND    whse_code = UPPER(pwhse_code)
      AND    delete_mark = 0;

Line: 719

      SELECT qc_grade_desc
      FROM   qc_grad_mst
      WHERE  qc_grade = UPPER(pqc_grade)
      AND    delete_mark = 0;

Line: 781

      SELECT status_desc
      FROM   ic_lots_sts
      WHERE  lot_status = UPPER(plot_status)
      AND    delete_mark = 0;

Line: 844

      SELECT whse_code
      FROM   ic_whse_mst
      WHERE  whse_code = UPPER(pwhse_code)
      AND    orgn_code = UPPER(porgn_code)
      AND    delete_mark = 0;

Line: 921

      SELECT item_id, lot_ctl, sublot_ctl
      FROM   ic_item_mst
      WHERE  item_no = UPPER(pitem_no)
      AND    delete_mark = 0;

Line: 927

      SELECT lot_id
      FROM   ic_lots_mst
      where  item_id = l_item_id
      AND    lot_no  = UPPER(plot_no)
      AND    delete_mark = 0;

Line: 934

      SELECT lot_id
      FROM   ic_lots_mst
      WHERE  item_id = l_item_id
      AND    lot_no  = UPPER(plot_no)
      AND    sublot_no = UPPER(psublot_no)
      AND    delete_mark = 0;

Line: 1067

      SELECT item_id, lot_ctl, sublot_ctl
      FROM   ic_item_mst
      WHERE  item_no = UPPER(pitem_id)
      AND    delete_mark = 0;

Line: 1073

      SELECT lot_id
      FROM   ic_lots_mst
      where  item_id = pitem_id
      AND    lot_id  = plot_id
      AND    delete_mark = 0;

Line: 1153

      SELECT orgn_name
      FROM   sy_orgn_mst
      WHERE  co_code   = UPPER(porgn_code)
      AND    orgn_code = UPPER(porgn_code)
      AND    delete_mark = 0;

Line: 1221

      SELECT orgn_name
      FROM   sy_orgn_mst
      WHERE  orgn_code  = UPPER(porgn_code)
      AND    delete_mark = 0;

Line: 1288

      SELECT um_desc
      FROM   sy_uoms_mst
      WHERE  um_code  = puom_code
      AND    delete_mark = 0;

Line: 1515

      SELECT dualum_ind
      FROM   ic_item_mst
      WHERE  item_id = pitem_id
      AND    delete_mark = 0;

Line: 1599

      SELECT deviation_hi, deviation_lo
      FROM   ic_item_mst
      WHERE  item_id = pitem_id
      AND    delete_mark = 0;