DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on IC_TRAN_PND

Line 75: FROM ic_tran_pnd

71: WHERE organization_id = v_org_id
72: AND inventory_item_id = v_inventory_item_id;
73: CURSOR Cur_get_trans_whse(v_trans_id NUMBER) IS
74: SELECT whse_code
75: FROM ic_tran_pnd
76: WHERE trans_id = v_trans_id;
77: CURSOR Cur_get_steps(v_batch_id NUMBER) IS
78: SELECT *
79: FROM gme_batch_steps_mig

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