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 1737: FROM fm_rout_dtl

1733: CURSOR Cur_get_rout_details (V_routing_id NUMBER) IS
1734: SELECT 1
1735: FROM sys.dual
1736: WHERE EXISTS (SELECT 1
1737: FROM fm_rout_dtl
1738: WHERE routing_id = V_routing_id);
1739:
1740: -- p_formulaline_id would have a value if this procedure is called
1741: -- from cascade_del_to_step_mat. From the formula details form, the delete of

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

Line 1803: FROM fm_rout_dtl d,

1799: h.routing_id = d.routing_id;
1800:
1801: CURSOR Cur_get_umtyp_cnt(prouting_id NUMBER) IS
1802: SELECT count(distinct u.uom_class)
1803: FROM fm_rout_dtl d,
1804: gmd_operations_b o,
1805: mtl_units_of_measure u
1806: WHERE d.oprn_id = o.oprn_id
1807: AND d.routing_id = prouting_id

Line 1813: FROM fm_rout_dtl d,

1809:
1810:
1811: CURSOR Cur_get_process_umtyp(prouting_id NUMBER) IS
1812: SELECT distinct u.uom_class
1813: FROM fm_rout_dtl d,
1814: gmd_operations_b o,
1815: mtl_units_of_measure u
1816: WHERE d.oprn_id = o.oprn_id
1817: AND d.routing_id = prouting_id

Line 2376: FROM fm_rout_dtl d,

2372: formulaline_id <> P_check.formulaline_id);
2373:
2374: CURSOR Cur_get_umtyp_cnt(prouting_id NUMBER) IS
2375: SELECT count(distinct u.uom_class)
2376: FROM fm_rout_dtl d,
2377: gmd_operations_b o,
2378: mtl_units_of_measure u
2379: WHERE d.oprn_id = o.oprn_id
2380: AND d.routing_id = prouting_id

Line 2385: FROM fm_rout_dtl d,

2381: AND o.process_qty_uom = u.uom_code;
2382:
2383: CURSOR Cur_get_process_umtyp(prouting_id NUMBER) IS
2384: SELECT distinct u.uom_class
2385: FROM fm_rout_dtl d,
2386: gmd_operations_b o,
2387: mtl_units_of_measure u
2388: WHERE d.oprn_id = o.oprn_id
2389: AND d.routing_id = prouting_id