APPS.GMI_OM_UTIL SQL Statements

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

Line: 48

  SELECT  iim.lot_ctl, iim.dualum_ind
  FROM    ic_item_mst iim, mtl_system_items msi
  WHERE   msi.inventory_item_id = p_reference_line_rec.inventory_item_id
  AND     msi.organization_id   = p_reference_line_rec.ship_from_org_id
  AND     msi.segment1          = iim.item_no;

Line: 57

  SELECT itp.lot_id, ilm.lot_no, ilm.sublot_no, ABS(itp.trans_qty) trans_qty, itp.trans_um,
         ABS(itp.trans_qty2) trans_qty2, itp.trans_um2
  FROM   ic_tran_pnd itp, ic_lots_mst ilm
  WHERE  itp.doc_type      ='OMSO'
  AND    itp.line_id       = p_original_line_rec.reference_line_id
  AND    itp.delete_mark   = 0
  AND    itp.completed_ind = 1
  AND    itp.lot_id        <> 0
  AND    itp.trans_qty     <> 0
  AND    itp.staged_ind    = 1
  AND    itp.line_detail_id is not null
  AND    ilm.item_id = itp.item_id
  AND    ilm.lot_id  = itp.lot_id
  ORDER BY trans_id;

Line: 80

    l_Lot_serial_tbl.DELETE;

Line: 219

  SELECT * from wsh_delivery_details
  where delivery_detail_id = p_delivery_detail_id;

Line: 225

  SELECT LOT_ID from ic_tran_pnd
  where  line_detail_id = p_delivery_detail_id and
         line_id = l_line_id and
         doc_type = 'OMSO' and
         delete_mark = 0 and
         staged_ind = 1;