APPS.GME_POST_MIGRATION dependencies on GME_BATCH_TXNS_MIG

Line 3087: UPDATE gme_batch_txns_mig

3083: END IF;
3084: 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 */
3085:
3086: -- Bug 13706812 - Changed update statement to take advantage of existing index which includes batch_id.
3087: UPDATE gme_batch_txns_mig
3088: SET migrated_ind = 1
3089: WHERE trans_id = l_txns_tbl(i).trans_id
3090: AND batch_id = l_txns_tbl(i).doc_id; -- This is the 11i batch id.
3091:

Line 3879: gme_material_details gmdo, gme_batch_txns_mig txn, ic_tran_pnd itp

3875: ORDER BY s.batch_id, s.batchstep_no;
3876: CURSOR Cur_verify_txns(v_batchstep_id NUMBER, v_old_batch_id NUMBER) IS
3877: SELECT 1
3878: FROM gme_batch_step_items bsi, gme_material_details gmdn,
3879: gme_material_details gmdo, gme_batch_txns_mig txn, ic_tran_pnd itp
3880: WHERE bsi.batchstep_id = v_batchstep_id
3881: AND gmdn.material_detail_id = bsi.material_detail_id
3882: AND gmdo.batch_id = v_old_batch_id
3883: AND gmdo.line_type = gmdn.line_type