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 1804: gmd_operations_b o,

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

Line 1814: gmd_operations_b o,

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

Line 2377: gmd_operations_b o,

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

Line 2386: gmd_operations_b o,

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