APPS.GME_API_GRP dependencies on GME_BATCH_STEP_ITEMS

Line 433: gme_batch_step_items i

429:
430: CURSOR cur_get_step_status (v_material_detail_id NUMBER) IS
431: SELECT step_status
432: FROM gme_batch_steps s,
433: gme_batch_step_items i
434: WHERE s.batchstep_id = i.batchstep_id
435: AND i.material_detail_id = v_material_detail_id;
436:
437: CURSOR cur_item(v_org_id NUMBER, v_inventory_item_id NUMBER) IS

Line 1174: FROM gme_batch_step_items a, gme_batch_steps b

1170: ORDER BY m.material_requirement_date, m.batch_id, m.material_detail_id;
1171:
1172: CURSOR c_batchsteps (p_material_detail_id IN NUMBER) IS
1173: SELECT b.*
1174: FROM gme_batch_step_items a, gme_batch_steps b
1175: WHERE a.batchstep_id = b.batchstep_id
1176: AND a.material_detail_id = p_material_detail_id;
1177:
1178: CURSOR get_msg (v_msg_name IN VARCHAR2) IS