APPS.GME_INCREMENTAL_BACKFLUSH_PVT dependencies on GME_BATCH_STEP_ITEMS

Line 87: FROM gme_batch_step_items

83: CURSOR Cur_assoc_step(v_batch_id NUMBER) IS
84: SELECT *
85: FROM gme_batch_steps
86: WHERE batchstep_id IN (SELECT DISTINCT batchstep_id
87: FROM gme_batch_step_items
88: WHERE batch_id = v_batch_id);
89:
90: CURSOR Cur_prod_assoc(V_batch_id NUMBER, V_material_detail_id NUMBER) IS
91: SELECT s.*

Line 92: FROM gme_batch_step_items m, gme_batch_steps s

88: WHERE batch_id = v_batch_id);
89:
90: CURSOR Cur_prod_assoc(V_batch_id NUMBER, V_material_detail_id NUMBER) IS
91: SELECT s.*
92: FROM gme_batch_step_items m, gme_batch_steps s
93: WHERE m.batch_id = V_batch_id
94: AND m.material_detail_id = V_material_detail_id
95: AND s.batch_id = m.batch_id
96: AND s.batchstep_id = m.batchstep_id

Line 1457: FROM gme_batch_steps s, gme_batch_step_items i

1453: l_step_status NUMBER;
1454:
1455: CURSOR cur_get_step_status(v_material_detail_id NUMBER) IS
1456: SELECT s.batchstep_no, step_status
1457: FROM gme_batch_steps s, gme_batch_step_items i
1458: WHERE s.batchstep_id = i.batchstep_id
1459: AND i.material_detail_id = v_material_detail_id;
1460:
1461: ERROR_INV_ACTION_FPO EXCEPTION;