DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on GME_BATCH_TXNS_MIG

Line 2702: UPDATE gme_batch_txns_mig

2698: END IF;
2699: END IF;
2700: END IF;
2701: END IF; /* IF NOT(l_mtl_rec.line_type = gme_common_pvt.g_line_type_ing AND l_mtl_rec.phantom_type IN (gme_common_pvt.g_auto_phantom, gme_common_pvt.g_manual_phantom)) THEN */
2702: UPDATE gme_batch_txns_mig
2703: SET migrated_ind = 1
2704: WHERE trans_id = l_txns_tbl(i).trans_id;
2705: IF (g_debug <= gme_debug.g_log_statement) THEN
2706: gme_debug.put_line('Done transaction');

Line 3329: gme_material_details gmdo, gme_batch_txns_mig txn, ic_tran_pnd itp

3325: ORDER BY s.batch_id, s.batchstep_no;
3326: CURSOR Cur_verify_txns(v_batchstep_id NUMBER, v_old_batch_id NUMBER) IS
3327: SELECT 1
3328: FROM gme_batch_step_items bsi, gme_material_details gmdn,
3329: gme_material_details gmdo, gme_batch_txns_mig txn, ic_tran_pnd itp
3330: WHERE bsi.batchstep_id = v_batchstep_id
3331: AND gmdn.material_detail_id = bsi.material_detail_id
3332: AND gmdo.batch_id = v_old_batch_id
3333: AND gmdo.line_type = gmdn.line_type