APPS.GML_INTORD_LOT_STS SQL Statements

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

Line: 74

  SELECT loct_onhand, lot_status
  FROM   ic_loct_inv
  WHERE  item_id   = p_item_id
  AND    whse_code = p_whse_code
  AND    lot_id    = p_lot_id
  AND    location  = p_location;

Line: 241

SELECT lot_no, sublot_no
FROM   ic_lots_mst
WHERE  lot_id = p_lot_id;

Line: 248

SELECT reason_code
FROM   sy_reas_cds
WHERE  delete_mark = 0
AND    (l_reason_code_security = 'Y')
AND    (reason_code in (select reason_code from gma_reason_code_security
        where (doc_type = 'PORC' or doc_type IS NULL) and
        (responsibility_id = FND_GLOBAL.RESP_id or responsibility_id IS NULL)))
UNION ALL
SELECT  reason_code
FROM    sy_reas_cds
WHERE   delete_mark = 0;

Line: 265

  SELECT  *
  INTO    l_item_rec
  FROM    ic_item_mst
  WHERE   item_id     = p_item_id;

Line: 276

  SELECT s.co_code, w.orgn_code
  INTO   l_trans_rec.co_code, l_trans_rec.orgn_code
  FROM   ic_whse_mst w, sy_orgn_mst s
  WHERE  w.whse_code = p_whse_code
  AND    w.orgn_code = s.orgn_code;

Line: 302

      UPDATE IC_LOCT_INV
      SET    lot_status = p_to_status
      WHERE  item_id    = p_item_id
      AND    whse_code  = p_whse_code
      AND    location   = p_location
      AND    lot_id     = p_lot_id;

Line: 420

  SELECT lot_id,lot_status
  FROM   ic_tran_pnd
  WHERE  doc_type      = 'OMSO'
  AND    item_id       = p_item_id
  AND    completed_ind = 1
  AND    delete_mark   = 0
  AND    line_id  IN(SELECT line_id FROM oe_order_lines_all
                     WHERE  source_document_line_id = p_req_line_id);

Line: 436

  x_lot_sts_tab.DELETE;