DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on IC_TRAN_PND

Line 82: FROM ic_tran_pnd

78: AND inventory_item_id = v_inventory_item_id;
79:
80: CURSOR Cur_get_trans_whse(v_trans_id NUMBER) IS
81: SELECT whse_code
82: FROM ic_tran_pnd
83: WHERE trans_id = v_trans_id;
84:
85: CURSOR Cur_get_steps(v_batch_id NUMBER) IS
86: SELECT *

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