APPS.GME_PICKING_PVT SQL Statements

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

Line: 15

/* GME_NO_MATERIALS_SELECTED                                                                     */

-- HALUTHRA   22-SEP-2008   Bug 7383625
--    Added IF condition to populate detailed_quantity
--    in PROCEDURE process_line

/*************************************************************************************************/

   PROCEDURE conc_picking (
      err_buf                OUT NOCOPY      VARCHAR2
     ,ret_code               OUT NOCOPY      VARCHAR2
     ,p_organization_id      IN              NUMBER
     ,p_all_batches          IN              VARCHAR2
     ,                                             -- 1 = All, 2 = Backordered
      p_include_pending      IN              VARCHAR2
     ,p_include_wip          IN              VARCHAR2
     ,p_from_batch           IN              VARCHAR2
     ,p_to_batch             IN              VARCHAR2
     ,p_oprn_no              IN              VARCHAR2
     ,p_oprn_vers            IN              NUMBER
     ,p_product_no           IN              VARCHAR2
     ,p_ingredient_no        IN              VARCHAR2
     ,p_days_forward         IN              NUMBER
     ,p_from_req_date        IN              VARCHAR2
     ,p_to_req_date          IN              VARCHAR2
     ,p_pick_grouping_rule   IN              VARCHAR2
     ,p_print_pick_slip      IN              VARCHAR2 DEFAULT 'N'
     ,p_plan_tasks           IN              VARCHAR2 DEFAULT 'N'
     ,p_sales_order          IN              VARCHAR2)
   IS
      l_api_name   CONSTANT VARCHAR2 (30)               := 'conc_picking';

Line: 90

                         || ' AND (:product_no IS NULL OR batch_id IN (SELECT DISTINCT batch_id FROM gme_material_details'
                         || ' WHERE organization_id = :organization_id'
                         || ' AND line_type = 1 AND inventory_item_id IN'
                         || ' (SELECT inventory_item_id FROM mtl_system_items_kfv WHERE organization_id = :organization_id'
                         || ' AND concatenated_segments LIKE :product_no)))'
                         || ' AND (:ingredient_no IS NULL OR batch_id IN (SELECT DISTINCT batch_id FROM gme_material_details'
                         || ' WHERE organization_id = :organization_id'
                         || ' AND line_type = -1 AND inventory_item_id IN'
                         || ' (SELECT inventory_item_id FROM mtl_system_items_kfv WHERE organization_id = :organization_id'
                         || ' AND concatenated_segments LIKE :ingredient_no)))'
                         || ' AND material_requirement_date <= SYSDATE + NVL(:days_forward, 100000)'
                         || ' AND material_requirement_date >= NVL(:from_req_date, material_requirement_date)'
                         || ' AND material_requirement_date <= NVL(:to_req_date, material_requirement_date)';

Line: 103

      l_sql_stmt := 'SELECT * FROM gme_ingred_pick_vw WHERE ' || l_where;

Line: 268

         SELECT   l.line_id, l.header_id
             FROM mtl_txn_request_lines l, mtl_txn_request_headers h
            WHERE l.organization_id = v_org_id
              AND transaction_source_type_id =
                                              gme_common_pvt.g_txn_source_type
              AND l.txn_source_id = v_batch_id
              AND l.txn_source_line_id = v_material_detail_id
              AND l.line_status NOT IN (5, 6)
              AND h.header_id = l.header_id
              AND h.move_order_type NOT IN
                     (gme_common_pvt.g_invis_move_order_type
                     ,inv_globals.g_move_order_put_away)
         ORDER BY l.header_id, l.line_id;

Line: 531

         FND_MESSAGE.SET_NAME('GME','GME_NO_MATERIALS_SELECTED');

Line: 564

         SELECT SUM (transaction_quantity) qty_detailed
               ,SUM (secondary_transaction_quantity) sec_qty_detailed
           FROM mtl_material_transactions_temp
          WHERE move_order_line_id = v_move_order_line_id;

Line: 571

         SELECT *
           FROM mtl_material_transactions_temp
          WHERE move_order_line_id = v_move_order_line_id;

Line: 745

              update mtl_reservations
              set detailed_quantity = get_mmtt.primary_quantity
              where reservation_id = get_mmtt.reservation_id;

Line: 840

               UPDATE mtl_material_transactions_temp
                  SET pick_slip_number = l_pick_slip_number,
                      wip_entity_type = gme_common_pvt.g_wip_entity_type_batch
                WHERE transaction_temp_id = get_mmtt.transaction_temp_id;

Line: 845

              UPDATE mtl_material_transactions_temp
              SET wip_entity_type = gme_common_pvt.g_wip_entity_type_batch
              WHERE transaction_temp_id = get_mmtt.transaction_temp_id;

Line: 879

      inv_trolin_util.update_row (l_mo_line_rec);

Line: 897

         UPDATE gme_material_details
            SET backordered_qty = l_backordered_qty
          WHERE material_detail_id = p_mo_line_rec.txn_source_line_id;