APPS.GME_SCALE_BATCH_PVT dependencies on GME_BATCH_STEP_ITEMS

Line 59: FROM gme_batch_steps s, gme_batch_step_items i

55:
56: CURSOR cur_get_step_status (v_material_detail_id NUMBER)
57: IS
58: SELECT s.batchstep_no, step_status
59: FROM gme_batch_steps s, gme_batch_step_items i
60: WHERE s.batchstep_id = i.batchstep_id
61: AND i.material_detail_id = v_material_detail_id;
62:
63: CURSOR cur_check_zero_qty_line (v_batch_id NUMBER, v_batch_status NUMBER)

Line 291: FROM gme_batch_step_items

287:
288: CURSOR cur_item_step_asso (v_batch_id NUMBER)
289: IS
290: SELECT DISTINCT batchstep_id
291: FROM gme_batch_step_items
292: WHERE batch_id = v_batch_id;
293:
294: CURSOR cur_is_charge_associated (v_batch_id NUMBER)
295: IS

Line 1025: FROM gme_batch_step_items

1021:
1022: CURSOR cur_item_step_asso (v_batch_id NUMBER)
1023: IS
1024: SELECT DISTINCT batchstep_id
1025: FROM gme_batch_step_items
1026: WHERE batch_id = v_batch_id;
1027:
1028: CURSOR cur_get_all_steps (v_batch_id NUMBER)
1029: IS

Line 1037: FROM gme_batch_steps s, gme_batch_step_items i

1033:
1034: CURSOR cur_get_step_status (v_material_detail_id NUMBER)
1035: IS
1036: SELECT s.batchstep_no, step_status
1037: FROM gme_batch_steps s, gme_batch_step_items i
1038: WHERE s.batchstep_id = i.batchstep_id
1039: AND i.material_detail_id = v_material_detail_id;
1040:
1041: l_material_details_qty NUMBER;