APPS.GME_PHANTOM_PVT SQL Statements

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

Line: 87

         SELECT d.plan_start_date, d.plan_cmplt_date
           FROM gme_batch_step_items i, gme_batch_steps d
          WHERE d.batchstep_id = i.batchstep_id
            AND i.material_detail_id = v_material_detail_id;

Line: 98

         SELECT   material_detail_id
             FROM gme_material_details
            WHERE batch_id = v_batch_id
              AND inventory_item_id = v_inventory_item_id
              AND line_type = gme_common_pvt.g_line_type_prod
         ORDER BY line_no;

Line: 195

      l_phant_batch.update_inventory_ind :=
                                           l_batch_header.update_inventory_ind;

Line: 256

      l_phant_batch.last_update_date := gme_common_pvt.g_timestamp;

Line: 258

      IF NOT gme_batch_header_dbl.update_row (p_batch_header      => l_phant_batch) THEN
         RAISE batch_upd_error;

Line: 270

      UPDATE gme_material_details
         SET phantom_line_id = p_material_detail_rec.material_detail_id
            ,release_type = x_material_detail_rec.release_type
            ,subinventory = x_material_detail_rec.subinventory
            ,locator_id = x_material_detail_rec.locator_id
            ,last_update_date = gme_common_pvt.g_timestamp
            ,last_updated_by = gme_common_pvt.g_user_ident
            ,last_update_login = gme_common_pvt.g_login_id
       WHERE material_detail_id = l_prod_mtl_dtl_id;

Line: 283

      UPDATE gme_material_details
         SET phantom_line_id = l_prod_mtl_dtl_id
            ,phantom_id = l_phant_batch.batch_id
            ,last_update_date = gme_common_pvt.g_timestamp
            ,last_updated_by = gme_common_pvt.g_user_ident
            ,last_update_login = gme_common_pvt.g_login_id
       WHERE material_detail_id = p_material_detail_rec.material_detail_id;

Line: 402

         SELECT d.phantom_id
           FROM gme_batch_step_items i, gme_material_details d
          WHERE d.batch_id = v_batch_id
            AND i.material_detail_id = d.material_detail_id
            AND batchstep_id = v_batchstep_id
            AND (   d.release_type = gme_common_pvt.g_mtl_autobystep_release
                 OR (    d.release_type IN
                            (gme_common_pvt.g_mtl_manual_release
                            ,gme_common_pvt.g_mtl_incremental_release)
                     AND p_all_release_type_assoc = 1) )
            AND NVL (d.phantom_id, 0) > 0;

Line: 482

         SELECT d.phantom_id
           FROM gme_material_details d
          WHERE d.batch_id = v_batch_id
            AND d.release_type <= v_release_type
            AND NVL (d.phantom_id, 0) > 0;