APPS.GMD_QC_MIGB12 SQL Statements

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

Line: 68

SELECT line_no, line_type
FROM   gme_material_details
WHERE  material_detail_id = p_old_mat_det_id;

Line: 80

SELECT material_detail_id
FROM   gme_material_details
WHERE  batch_id = p_new_batch_id
AND    line_no = l_line_no
AND    line_type = l_line_type;

Line: 228

   Counters for updates.
  =====================================*/

l_samp_event_upd         NUMBER;

Line: 242

SELECT old_batch_id, new_batch_id
FROM   gme_batch_mapping_mig;

Line: 253

SELECT step_no, step_id, material_detail_id, sampling_event_id
FROM   gmd_sampling_events
WHERE  batch_id = l_mig_batch.old_batch_id;

Line: 264

SELECT batchstep_id
FROM   gme_batch_steps
WHERE  batch_id = p_batch_id
AND    batchstep_no = p_step_no;

Line: 276

SELECT step_no, step_id, material_detail_id, spec_vr_id
FROM   gmd_wip_spec_vrs
WHERE  batch_id = l_mig_batch.old_batch_id;

Line: 287

SELECT source_id
FROM   gmd_ss_material_sources
WHERE  batch_id = l_mig_batch.old_batch_id;

Line: 352

          Update gmd_sampling_events and
          gmd_samples.
         ==================================*/

        UPDATE gmd_sampling_events
        SET    batch_id = l_mig_batch.new_batch_id,
               step_id = l_new_step_id,
               material_detail_id = l_new_det_id
        WHERE  sampling_event_id = l_sam_event.sampling_event_id;

Line: 365

        UPDATE gmd_samples
        SET    batch_id = l_mig_batch.new_batch_id,
               step_id = l_new_step_id,
               material_detail_id = l_new_det_id
        WHERE  sampling_event_id = l_sam_event.sampling_event_id;

Line: 450

         UPDATE gmd_wip_spec_vrs
         SET   batch_id = l_mig_batch.new_batch_id,
               step_id = l_new_step_id,
               material_detail_id = l_new_det_id
         WHERE  spec_vr_id = l_wip_spec.spec_vr_id;

Line: 505

         UPDATE gmd_ss_material_sources
         SET   batch_id = l_mig_batch.new_batch_id
         WHERE source_id = l_ss_matl.source_id;

Line: 551

    Log update counts.
  ============================*/
-- Bug# 5559748 Changed FND_LOG.LEVEL_UNEXPECTED to LEVEL_EVENT
GMA_COMMON_LOGGING.gma_migration_central_log (
       p_run_id          => p_migration_run_id,
       p_log_level       => FND_LOG.LEVEL_EVENT,
       p_message_token   => 'GMD_MIG_BATCH_SUMMARY',
       p_context         => 'Quality Batch Migration',
       p_token1          => 'SAMEVTUPD',
       p_token2          => 'SAMPUPD',
       p_token3          => 'WIPUPD',
       p_token4          => 'MATDET',
       p_param1          => to_char(l_samp_event_upd),
       p_param2          => to_char(l_samples_upd),
       p_param3          => to_char(l_wip_spec_upd),
       p_param4          => to_char(l_ss_matl_upd),
       p_app_short_name  => 'GMD');