APPS.GMI_MOVE_ORDER_LINES_PVT SQL Statements

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

Line: 61

   Select distinct ic.item_id ,
          ic.noninv_ind,
          ic.lot_ctl,
          ic.loct_ctl
   From ic_item_mst ic,
        mtl_system_items mtl
   Where mtl.inventory_item_id = l_mo_line_rec.inventory_item_id
    And mtl.segment1= ic.item_no;

Line: 71

   Select sum(abs(trans_qty)), sum(abs(trans_qty2))
   From ic_tran_pnd
   Where line_id = l_mo_line_rec.txn_source_line_id
    -- And item_id = l_opm_item_id (commenting this line so that index on line_id gets used)
    And lot_id <> 0
    And doc_type = 'OMSO'
    And delete_mark = 0
    And completed_ind = 0;

Line: 81

   Select sum(abs(trans_qty)), sum(abs(trans_qty2))
   From ic_tran_pnd
   Where line_id = l_mo_line_rec.txn_source_line_id
   -- And item_id = l_opm_item_id (commenting this line so that index on line_id gets used)
    And lot_id = 0
    And doc_type = 'OMSO'
    And delete_mark = 0
    And completed_ind = 0;

Line: 91

   Select line_id
   From ic_txn_request_lines
   Where txn_source_line_id = l_mo_line_rec.txn_source_line_id;

Line: 100

  SELECT count(*)
  FROM   ic_tran_pnd
  WHERE  line_id       = p_line_id
  AND    doc_type      = 'OMSO'
  -- AND    item_id       = p_item_id (commenting this line so that index on line_id gets used)
  AND    staged_ind    = 0
  AND    completed_ind = 0
  AND    delete_mark   = 0
  AND    lot_id        = 0
  AND    location      = ic$default_loct
  AND    line_detail_id IS NULL;

Line: 115

  SELECT whse_code
  FROM   IC_WHSE_MST
  WHERE  mtl_organization_id = p_organization_id;

Line: 163

     IF l_mo_line_rec.operation = INV_GLOBALS.G_OPR_DELETE THEN
       /*  physically delete this row */
       /*  This first Queries To see If Any Reservations Exist */
       /*  ( GMI Transcations) Then deletes or Updates. */
       /*  Else it will just delete this line. */
        gmi_reservation_util.println('Operation delete');

Line: 169

       GMI_Move_Order_LINE_Util.delete_Row( l_mo_line_rec.LINE_id);

Line: 179

       IF l_mo_line_rec.operation = INV_GLOBALS.G_OPR_UPDATE THEN
gmi_reservation_util.println('Operation update');

Line: 207

       l_mo_line_rec.last_update_date   := SYSDATE;

Line: 208

       l_mo_line_rec.last_updated_by    := FND_GLOBAL.USER_ID;

Line: 209

       l_mo_line_rec.last_update_login  := FND_GLOBAL.USER_ID;

Line: 211

       IF l_mo_line_rec.operation = INV_GLOBALS.G_OPR_UPDATE THEN
         /*  This will first check if old_line quantity or line_status */
         /*  or quantity_detailed is different from New Then Call */
         /*  query to get reservations and do update logic. */
         /*  Else it will just update this row.  */
          gmi_reservation_util.println('Going to update row');

Line: 217

         GMI_Move_Order_LINE_Util.update_Row( l_mo_line_rec);

Line: 226

         select MTL_TXN_REQUEST_LINES_S.nextval
         -- END Bug 2628244
         INTO   l_mo_line_rec.LINE_id
         FROM   DUAL;

Line: 231

         WSH_Util_Core.PrintLn('Insert For Row > '|| I);

Line: 233

         GMI_Move_Order_LINE_Util.Insert_Row( l_mo_line_rec);

Line: 293

                FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');

Line: 294

                FND_MESSAGE.Set_Token('WHERE', 'Delete_Reservation');

Line: 384

 ELSIF ( p_mo_line_rec.operation = INV_GLOBALS.G_OPR_UPDATE)  THEN

    IF  p_mo_line_rec.header_id           is NULL OR
        p_mo_line_rec.line_id             is NULL OR
        p_mo_line_rec.line_number         is NULL OR
        p_mo_line_rec.organization_id     is NULL OR
        p_mo_line_rec.inventory_item_id   is NULL OR
        p_mo_line_rec.uom_code            is NULL OR
        p_mo_line_rec.quantity            is NULL OR
        p_mo_line_rec.line_status         is NULL OR
        p_mo_line_rec.transaction_type_id is NULL THEN

	   RETURN TRUE;

Line: 403

  /*  This should Catch DELETE, LOCK_ROW and QUERY */
  /*  Which all need a LINES ID. */
  ELSE

    IF  p_mo_line_rec.header_id        is NULL OR
        p_mo_line_rec.LINE_id         is NULL THEN
	   RETURN TRUE;