DBA Data[Home] [Help]

APPS.GME_API_GRP dependencies on GME_BATCH_STEP_ITEMS

Line 412: gme_batch_step_items i

408:
409: CURSOR cur_get_step_status (v_material_detail_id NUMBER) IS
410: SELECT step_status
411: FROM gme_batch_steps s,
412: gme_batch_step_items i
413: WHERE s.batchstep_id = i.batchstep_id
414: AND i.material_detail_id = v_material_detail_id;
415:
416: CURSOR cur_item(v_org_id NUMBER, v_inventory_item_id NUMBER) IS

Line 1145: FROM gme_batch_step_items a, gme_batch_steps b

1141: ORDER BY m.material_requirement_date, m.batch_id, m.material_detail_id;
1142:
1143: CURSOR c_batchsteps (p_material_detail_id IN NUMBER) IS
1144: SELECT b.*
1145: FROM gme_batch_step_items a, gme_batch_steps b
1146: WHERE a.batchstep_id = b.batchstep_id
1147: AND a.material_detail_id = p_material_detail_id;
1148:
1149: CURSOR get_msg (v_msg_name IN VARCHAR2) IS