DBA Data[Home] [Help]

APPS.GMD_AUTO_STEP_CALC dependencies on GMD_OPERATIONS_B

Line 561: gmd_operations_b o

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;
565:

Line 1796: gmd_operations_b o,

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
1800: AND o.process_qty_uom = u.uom_code;

Line 1806: gmd_operations_b o,

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
1810: AND o.process_qty_uom = u.uom_code;

Line 2369: gmd_operations_b o,

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
2373: AND o.process_qty_uom = u.uom_code;

Line 2378: gmd_operations_b o,

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
2382: AND o.process_qty_uom = u.uom_code;