APPS.GMD_AUTO_STEP_CALC dependencies on FM_ROUT_DTL

Line 551: FROM fm_rout_dtl

547:
548: /* Gets all step no's that are independent */
549: CURSOR cur_get_other_steps IS
550: SELECT routingstep_no
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

Line 560: FROM fm_rout_dtl d,

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
560: FROM fm_rout_dtl d,
561: gmd_operations_b o
562: WHERE d.oprn_id = o.oprn_id
563: AND d.routing_id = P_routing_id
564: AND d.routingstep_no = V_routingstep_no;

Line 1731: FROM fm_rout_dtl

1727: CURSOR Cur_get_rout_details (V_routing_id NUMBER) IS
1728: SELECT 1
1729: FROM sys.dual
1730: WHERE EXISTS (SELECT 1
1731: FROM fm_rout_dtl
1732: WHERE routing_id = V_routing_id);
1733:
1734: -- p_formulaline_id would have a value if this procedure is called
1735: -- from cascade_del_to_step_mat. From the formula details form, the delete of

Line 1789: FROM fm_rout_dtl h,fm_rout_dep d

1785: formulaline_id <> P_check.formulaline_id);
1786:
1787: CURSOR Cur_check_depstps (prouting_id NUMBER) IS
1788: SELECT count(*)
1789: FROM fm_rout_dtl h,fm_rout_dep d
1790: WHERE h.routing_id = prouting_id AND
1791: h.routing_id = d.routing_id;
1792:
1793: CURSOR Cur_get_umtyp_cnt(prouting_id NUMBER) IS

Line 1795: FROM fm_rout_dtl d,

1791: h.routing_id = d.routing_id;
1792:
1793: CURSOR Cur_get_umtyp_cnt(prouting_id NUMBER) IS
1794: SELECT count(distinct u.uom_class)
1795: FROM fm_rout_dtl d,
1796: gmd_operations_b o,
1797: mtl_units_of_measure u
1798: WHERE d.oprn_id = o.oprn_id
1799: AND d.routing_id = prouting_id

Line 1805: FROM fm_rout_dtl d,

1801:
1802:
1803: CURSOR Cur_get_process_umtyp(prouting_id NUMBER) IS
1804: SELECT distinct u.uom_class
1805: FROM fm_rout_dtl d,
1806: gmd_operations_b o,
1807: mtl_units_of_measure u
1808: WHERE d.oprn_id = o.oprn_id
1809: AND d.routing_id = prouting_id

Line 2368: FROM fm_rout_dtl d,

2364: formulaline_id <> P_check.formulaline_id);
2365:
2366: CURSOR Cur_get_umtyp_cnt(prouting_id NUMBER) IS
2367: SELECT count(distinct u.uom_class)
2368: FROM fm_rout_dtl d,
2369: gmd_operations_b o,
2370: mtl_units_of_measure u
2371: WHERE d.oprn_id = o.oprn_id
2372: AND d.routing_id = prouting_id

Line 2377: FROM fm_rout_dtl d,

2373: AND o.process_qty_uom = u.uom_code;
2374:
2375: CURSOR Cur_get_process_umtyp(prouting_id NUMBER) IS
2376: SELECT distinct u.uom_class
2377: FROM fm_rout_dtl d,
2378: gmd_operations_b o,
2379: mtl_units_of_measure u
2380: WHERE d.oprn_id = o.oprn_id
2381: AND d.routing_id = prouting_id