APPS.GMD_AUTO_STEP_CALC dependencies on FM_ROUT_DEP

Line 88: FROM fm_rout_dep

84: /* Cursor Definitions.
85: =====================*/
86: CURSOR Cur_get_fm_dep_steps (V_step NUMBER) IS
87: SELECT dep_routingstep_no, transfer_pct
88: FROM fm_rout_dep
89: WHERE routing_id = X_routing_id
90: AND routingstep_no = V_step;
91:
92: CURSOR Cur_get_pm_dep_steps (V_step_id NUMBER) IS

Line 540: FROM fm_rout_dep

536:
537: /* Gets all step no's that are dependent */
538: CURSOR Cur_get_steps IS
539: SELECT dep_routingstep_no, max(level)
540: FROM fm_rout_dep
541: START WITH ((routing_id = P_routing_id) AND
542: ((p_step_no IS NULL) OR (routingstep_no = p_step_no)))
543: CONNECT BY routing_id = prior routing_id
544: AND routingstep_no = prior dep_routingstep_no

Line 555: FROM fm_rout_dep

551: FROM fm_rout_dtl
552: WHERE routing_id = P_routing_id
553: AND routingstep_no NOT IN
554: (SELECT dep_routingstep_no
555: FROM fm_rout_dep
556: WHERE routing_id = P_routing_id);
557:
558: CURSOR Cur_get_process_uom (V_routingstep_no NUMBER) IS
559: SELECT o.process_qty_uom, d.routingstep_id

Line 1797: FROM fm_rout_dtl h,fm_rout_dep d

1793: formulaline_id <> P_check.formulaline_id);
1794:
1795: CURSOR Cur_check_depstps (prouting_id NUMBER) IS
1796: SELECT count(*)
1797: FROM fm_rout_dtl h,fm_rout_dep d
1798: WHERE h.routing_id = prouting_id AND
1799: h.routing_id = d.routing_id;
1800:
1801: CURSOR Cur_get_umtyp_cnt(prouting_id NUMBER) IS