APPS.GMI_PICK_RELEASE_UTIL SQL Statements

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

Line: 56

   SELECT *
   FROM wsh_inv_delivery_details_v
   WHERE move_order_line_id = mo_line_id
   AND   move_order_line_id IS NOT NULL
   AND   released_status = 'S';

Line: 161

   SELECT trans_id, whse_code
   FROM ic_tran_pnd
   WHERE line_id = mo_source_line_id
   AND pick_slip_number IS NULL
   AND (lot_id <> 0 or location <> ic$default_loct); -- added this condition for bug3069040

Line: 170

   SELECT document_set_id
   FROM wsh_picking_batches
   WHERE name  = l_request_number;

Line: 177

   SELECT request_number
   FROM ic_txn_request_headers
   WHERE header_id = mo_header_id
   AND organization_id = mo_organization_id;

Line: 269

      GMI_Reservation_Util.PrintLn('In Create_Pick_Slip_and_Print update ic_tran_pnd with pick_slip_number='||l_pick_slip_number);

Line: 270

      UPDATE ic_tran_pnd
      SET pick_slip_number = l_pick_slip_number
      WHERE trans_id = l_trans_id;

Line: 379

   SELECT pick_slip_number
     FROM ic_tran_pnd
    WHERE line_id = mo_source_line_id
      AND pick_slip_number is NOT NULL
      AND (location     <> GMI_Reservation_Util.G_DEFAULT_LOCT OR  lot_id <> 0)
      AND delete_mark   = 0
      AND completed_ind = 0
      AND doc_type      = 'OMSO';

Line: 390

   SELECT pick_slip_number
     FROM ic_tran_pnd
    WHERE line_id = mo_source_line_id
      AND pick_slip_number is NOT NULL
      AND delete_mark   = 0
      AND completed_ind = 0
      AND doc_type      = 'OMSO';

Line: 399

   SELECT lot_ctl, loct_ctl, noninv_ind
     FROM ic_item_mst
    WHERE item_id = p_item_id;

Line: 404

   SELECT loct_ctl
     FROM ic_whse_mst
    WHERE whse_code=p_whse_code;

Line: 411

   SELECT whse_code,item_id
     FROM ic_tran_pnd
    WHERE line_id = mo_source_line_id;

Line: 416

    SELECT grouping_rule_id
      FROM ic_txn_request_headers
     WHERE HEADER_ID = p_header_id;

Line: 490

       SELECT NVL(print_pick_slip_mode, 'E')
       INTO l_print_mode
       FROM WSH_SHIPPING_PARAMETERS
       WHERE organization_id = p_organization_id;

Line: 607

PROCEDURE UPDATE_TXN_WITH_PICK_SLIP
   (   p_mo_line_rec                   IN  GMI_Move_Order_Global.mo_line_rec
     , p_pick_slip_number              IN  NUMBER
     , x_return_status                 OUT NOCOPY VARCHAR2
     , x_msg_count                     OUT NOCOPY NUMBER
     , x_msg_data                      OUT NOCOPY VARCHAR2
   ) IS


  l_whse_code        VARCHAR2(10);

Line: 624

  l_api_name         CONSTANT VARCHAR2(30) := 'Update txn with Pick Slip ';

Line: 627

   Select trans_id
   From ic_tran_pnd
   Where line_id = p_mo_line_rec.txn_source_line_id
     and doc_type = 'OMSO'
     and delete_mark = 0
     and completed_ind = 0
     and (lot_id <> 0 or location <> ic$default_loct);

Line: 637

   SELECT whse_code, item_id
     FROM ic_tran_pnd
    WHERE line_id = mo_source_line_id;

Line: 643

   SELECT lot_ctl, loct_ctl, noninv_ind
     FROM ic_item_mst
    WHERE item_id = p_item_id;

Line: 648

   SELECT loct_ctl
     FROM ic_whse_mst
    WHERE whse_code=p_whse_code;

Line: 670

                UPDATE ic_tran_pnd
                SET    pick_slip_number = p_pick_slip_number
                WHERE  trans_id = transaction_ids.trans_id;

Line: 675

              SELECT trans_id
                INTO l_trans_id
                FROM ic_tran_pnd
               WHERE line_id = p_mo_line_rec.txn_source_line_id
                 AND doc_type = 'OMSO'
                 AND delete_mark = 0
                 AND completed_ind = 0
                 AND staged_ind = 0
                 AND (lot_id = 0 and location = ic$default_loct);

Line: 685

              UPDATE ic_tran_pnd
                 SET pick_slip_number = p_pick_slip_number
               WHERE trans_id = l_trans_id;

Line: 691

      GMI_Reservation_Util.PrintLn('In UPDATE_TXN_WITH_PICK_SLIP  NO Error');

Line: 715

END UPDATE_TXN_WITH_PICK_SLIP;