eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_POST_MIGRATION dependencies on GME_BATCH_STEP_ITEMS

Line 1340: FROM gme_batch_step_items_mig

1336: PROCEDURE create_item_step_assoc(p_old_batch_id IN NUMBER,
1337: p_new_batch_id IN NUMBER) IS
1338: CURSOR Cur_item_assocs IS
1339: SELECT *
1340: FROM gme_batch_step_items_mig
1341: WHERE batch_id = p_old_batch_id;
1342: TYPE item_step_mig_tab IS TABLE OF gme_batch_step_items_mig%ROWTYPE INDEX BY BINARY_INTEGER;
1343: l_item_step_mig_tbl item_step_mig_tab;
1344: TYPE item_step_tab IS TABLE OF gme_batch_step_items%ROWTYPE INDEX BY BINARY_INTEGER;

Line 1342: TYPE item_step_mig_tab IS TABLE OF gme_batch_step_items_mig%ROWTYPE INDEX BY BINARY_INTEGER;

1338: CURSOR Cur_item_assocs IS
1339: SELECT *
1340: FROM gme_batch_step_items_mig
1341: WHERE batch_id = p_old_batch_id;
1342: TYPE item_step_mig_tab IS TABLE OF gme_batch_step_items_mig%ROWTYPE INDEX BY BINARY_INTEGER;
1343: l_item_step_mig_tbl item_step_mig_tab;
1344: TYPE item_step_tab IS TABLE OF gme_batch_step_items%ROWTYPE INDEX BY BINARY_INTEGER;
1345: l_item_step_tbl item_step_tab;
1346: l_api_name VARCHAR2(30) := 'create_item_step_assoc';

Line 1344: TYPE item_step_tab IS TABLE OF gme_batch_step_items%ROWTYPE INDEX BY BINARY_INTEGER;

1340: FROM gme_batch_step_items_mig
1341: WHERE batch_id = p_old_batch_id;
1342: TYPE item_step_mig_tab IS TABLE OF gme_batch_step_items_mig%ROWTYPE INDEX BY BINARY_INTEGER;
1343: l_item_step_mig_tbl item_step_mig_tab;
1344: TYPE item_step_tab IS TABLE OF gme_batch_step_items%ROWTYPE INDEX BY BINARY_INTEGER;
1345: l_item_step_tbl item_step_tab;
1346: l_api_name VARCHAR2(30) := 'create_item_step_assoc';
1347: BEGIN
1348: IF (g_debug <= gme_debug.g_log_procedure) THEN

Line 1369: INSERT INTO gme_batch_step_items VALUES l_item_step_tbl(a);

1365: l_item_step_tbl(i).minimum_delay := l_item_step_mig_tbl(i).minimum_delay;
1366: l_item_step_tbl(i).minimum_transfer_qty := l_item_step_mig_tbl(i).minimum_transfer_qty;
1367: END LOOP;
1368: FORALL a IN 1..l_item_step_tbl.count
1369: INSERT INTO gme_batch_step_items VALUES l_item_step_tbl(a);
1370: IF (g_debug <= gme_debug.g_log_procedure) THEN
1371: gme_debug.put_line('End procedure '||l_api_name);
1372: END IF;
1373: END create_item_step_assoc;

Line 3878: FROM gme_batch_step_items bsi, gme_material_details gmdn,

3874: AND s.step_status = gme_common_pvt.g_step_completed
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