APPS.GMD_AUTO_STEP_CALC dependencies on GME_BATCH_STEPS

Line 94: FROM gme_batch_step_dependencies d, gme_batch_steps s

90: AND routingstep_no = V_step;
91:
92: CURSOR Cur_get_pm_dep_steps (V_step_id NUMBER) IS
93: SELECT batchstep_no, transfer_percent, step_status
94: FROM gme_batch_step_dependencies d, gme_batch_steps s
95: WHERE d.batch_id = P_parent_id
96: AND d.batchstep_id = V_step_id
97: AND s.batchstep_id = d.dep_step_id
98: AND s.batch_id = d.batch_id;

Line 109: FROM gme_batch_steps

105: AND b.uom_code = V_uom_code;
106:
107: CURSOR Cur_get_step_status (V_step_id NUMBER) IS
108: SELECT step_status
109: FROM gme_batch_steps
110: WHERE batchstep_id = V_step_id;
111:
112: /* Cursor Record.
113: =====================*/

Line 584: FROM gme_batch_steps

580: ORDER BY max(level) desc;
581:
582: CURSOR Cur_get_pm_step_id (V_step_no NUMBER) IS
583: SELECT batchstep_id
584: FROM gme_batch_steps
585: WHERE batch_id = P_parent_id
586: AND batchstep_no = V_step_no;
587:
588: CURSOR Cur_get_pm_step_no (V_step_id NUMBER) IS

Line 590: FROM gme_batch_steps

586: AND batchstep_no = V_step_no;
587:
588: CURSOR Cur_get_pm_step_no (V_step_id NUMBER) IS
589: SELECT batchstep_no
590: FROM gme_batch_steps
591: WHERE batch_id = P_parent_id
592: AND batchstep_id = V_step_id;
593:
594: CURSOR Cur_get_pm_other_steps IS

Line 596: FROM gme_batch_steps s

592: AND batchstep_id = V_step_id;
593:
594: CURSOR Cur_get_pm_other_steps IS
595: SELECT batchstep_id, batchstep_no
596: FROM gme_batch_steps s
597: WHERE s.batch_id = P_parent_id
598: AND s.batchstep_id NOT IN
599: (SELECT dep_step_id
600: FROM gme_batch_step_dependencies

Line 605: FROM gme_batch_steps

601: WHERE batch_id = P_parent_id);
602:
603: CURSOR Cur_get_pm_process_uom (V_batchstep_no NUMBER) IS
604: SELECT STEP_QTY_UM
605: FROM gme_batch_steps
606: WHERE batch_id = P_parent_id
607: AND batchstep_no = V_batchstep_no;
608:
609: /* Cursor records.

Line 961: gme_batch_steps r

957: (d.actual_qty/(1+scrap_factor)) actual_qty,
958: d.dtl_um, d.inventory_item_id
959: FROM gme_batch_step_items b,
960: gme_material_details d,
961: gme_batch_steps r
962: WHERE b.batch_id = P_parent_id
963: AND b.batchstep_id = r.batchstep_id
964: AND b.material_detail_id = d.material_detail_id
965: AND b.batchstep_id = V_step_id