APPS.GME_SCALE_BATCH_PVT dependencies on GME_BATCH_STEP_ITEMS

Line 56: FROM gme_batch_steps s, gme_batch_step_items i

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

Line 285: FROM gme_batch_step_items

281:
282: CURSOR cur_item_step_asso (v_batch_id NUMBER)
283: IS
284: SELECT DISTINCT batchstep_id
285: FROM gme_batch_step_items
286: WHERE batch_id = v_batch_id;
287:
288: CURSOR cur_is_charge_associated (v_batch_id NUMBER)
289: IS

Line 1015: FROM gme_batch_step_items

1011:
1012: CURSOR cur_item_step_asso (v_batch_id NUMBER)
1013: IS
1014: SELECT DISTINCT batchstep_id
1015: FROM gme_batch_step_items
1016: WHERE batch_id = v_batch_id;
1017:
1018: CURSOR cur_get_all_steps (v_batch_id NUMBER)
1019: IS

Line 1027: FROM gme_batch_steps s, gme_batch_step_items i

1023:
1024: CURSOR cur_get_step_status (v_material_detail_id NUMBER)
1025: IS
1026: SELECT s.batchstep_no, step_status
1027: FROM gme_batch_steps s, gme_batch_step_items i
1028: WHERE s.batchstep_id = i.batchstep_id
1029: AND i.material_detail_id = v_material_detail_id;
1030:
1031: l_material_details_qty NUMBER;