eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_AUTO_STEP_CALC dependencies on MTL_UNITS_OF_MEASURE

Line 54: X_um_type mtl_units_of_measure.uom_class%TYPE;

50: X_step_vol_qty NUMBER;
51: X_cur_mass_qty NUMBER;
52: X_cur_vol_qty NUMBER;
53: X_new_factor NUMBER;
54: X_um_type mtl_units_of_measure.uom_class%TYPE;
55: X_return_status VARCHAR2(1);
56: X_cur_step_status NUMBER;
57:
58: X_plan_mass_qty NUMBER;

Line 102: FROM mtl_uom_conversions a, mtl_units_of_measure b

98: AND s.batch_id = d.batch_id;
99:
100: CURSOR Cur_get_std_factor (V_uom_code VARCHAR2) IS
101: SELECT a.conversion_rate, b.uom_class
102: FROM mtl_uom_conversions a, mtl_units_of_measure b
103: WHERE a.uom_code = b.uom_code
104: AND a.inventory_item_id = 0
105: AND b.uom_code = V_uom_code;
106:

Line 529: X_process_qty_um mtl_units_of_measure.uom_code%TYPE;

525: X_return_status VARCHAR2(1);
526: X_step_no NUMBER;
527: X_step_id NUMBER;
528: X_num_steps NUMBER := 0;
529: X_process_qty_um mtl_units_of_measure.uom_code%TYPE;
530: /* Cursor Definitions.
531: =====================*/
532: CURSOR Cur_get_routing IS
533: SELECT routing_id

Line 825: X_um_type mtl_units_of_measure.uom_class%TYPE;

821: FUNCTION step_uom_mass_volume (P_step_tbl IN step_rec_tbl)
822: RETURN BOOLEAN IS
823: /* Local variables.
824: ==================*/
825: X_um_type mtl_units_of_measure.uom_class%TYPE;
826: l_previous_um_type mtl_units_of_measure.uom_class%TYPE;
827: X_num_rows NUMBER(10);
828:
829: l_other_type_cnt NUMBER := 1;

Line 826: l_previous_um_type mtl_units_of_measure.uom_class%TYPE;

822: RETURN BOOLEAN IS
823: /* Local variables.
824: ==================*/
825: X_um_type mtl_units_of_measure.uom_class%TYPE;
826: l_previous_um_type mtl_units_of_measure.uom_class%TYPE;
827: X_num_rows NUMBER(10);
828:
829: l_other_type_cnt NUMBER := 1;
830:

Line 835: FROM mtl_units_of_measure

831: /* Cursor Definitions.
832: =====================*/
833: CURSOR Cur_get_um_type (V_uom_code VARCHAR2) IS
834: SELECT uom_class
835: FROM mtl_units_of_measure
836: WHERE uom_code = V_uom_code;
837:
838: CURSOR Cur_get_std_um (V_uom_class VARCHAR2) IS
839: SELECT uom_code

Line 840: FROM mtl_units_of_measure

836: WHERE uom_code = V_uom_code;
837:
838: CURSOR Cur_get_std_um (V_uom_class VARCHAR2) IS
839: SELECT uom_code
840: FROM mtl_units_of_measure
841: WHERE uom_class = V_uom_class;
842: BEGIN
843: X_num_rows := P_step_tbl.COUNT;
844: FOR i IN 1..X_num_rows LOOP

Line 937: X_from_uom mtl_units_of_measure.uom_code%TYPE;

933: X_cur_rec NUMBER DEFAULT 0;
934: X_line_qty NUMBER;
935: X_temp_qty NUMBER;
936: X_item_id NUMBER;
937: X_from_uom mtl_units_of_measure.uom_code%TYPE;
938: X_to_uom mtl_units_of_measure.uom_code%TYPE;
939: X_item_no mtl_system_items_kfv.concatenated_segments%TYPE;
940:
941: /* Cursor Definitions.

Line 938: X_to_uom mtl_units_of_measure.uom_code%TYPE;

934: X_line_qty NUMBER;
935: X_temp_qty NUMBER;
936: X_item_id NUMBER;
937: X_from_uom mtl_units_of_measure.uom_code%TYPE;
938: X_to_uom mtl_units_of_measure.uom_code%TYPE;
939: X_item_no mtl_system_items_kfv.concatenated_segments%TYPE;
940:
941: /* Cursor Definitions.
942: =====================*/

Line 1304: X_from_uom mtl_units_of_measure.uom_code%TYPE;

1300: X_cur_rec NUMBER DEFAULT 0;
1301: X_line_qty NUMBER;
1302: X_temp_qty NUMBER;
1303: X_item_id NUMBER;
1304: X_from_uom mtl_units_of_measure.uom_code%TYPE;
1305: X_to_uom mtl_units_of_measure.uom_code%TYPE;
1306: X_item_no mtl_system_items_kfv.concatenated_segments%TYPE;
1307:
1308:

Line 1305: X_to_uom mtl_units_of_measure.uom_code%TYPE;

1301: X_line_qty NUMBER;
1302: X_temp_qty NUMBER;
1303: X_item_id NUMBER;
1304: X_from_uom mtl_units_of_measure.uom_code%TYPE;
1305: X_to_uom mtl_units_of_measure.uom_code%TYPE;
1306: X_item_no mtl_system_items_kfv.concatenated_segments%TYPE;
1307:
1308:
1309: /* Scaling realted variables */

Line 1716: X_from_uom mtl_units_of_measure.uom_code%TYPE;

1712: ==================*/
1713: X_exists NUMBER(5);
1714: X_temp_qty NUMBER;
1715: X_item_id NUMBER;
1716: X_from_uom mtl_units_of_measure.uom_code%TYPE;
1717: X_to_uom mtl_units_of_measure.uom_code%TYPE;
1718: X_item_no mtl_system_items_kfv.concatenated_segments%TYPE;
1719:
1720: /* Cursor Definitions.

Line 1717: X_to_uom mtl_units_of_measure.uom_code%TYPE;

1713: X_exists NUMBER(5);
1714: X_temp_qty NUMBER;
1715: X_item_id NUMBER;
1716: X_from_uom mtl_units_of_measure.uom_code%TYPE;
1717: X_to_uom mtl_units_of_measure.uom_code%TYPE;
1718: X_item_no mtl_system_items_kfv.concatenated_segments%TYPE;
1719:
1720: /* Cursor Definitions.
1721: =====================*/

Line 1766: FROM mtl_units_of_measure

1762: WHERE inventory_item_id = X_item_id;
1763:
1764: CURSOR Cur_get_std_um (V_uom_class VARCHAR2) IS
1765: SELECT uom_code
1766: FROM mtl_units_of_measure
1767: WHERE uom_class = V_uom_class;
1768:
1769: CURSOR Cur_chk_matrl_umtype(pformula_id NUMBER) IS
1770: SELECT COUNT(distinct uom_class)

Line 1771: FROM fm_matl_dtl d ,mtl_units_of_measure m

1767: WHERE uom_class = V_uom_class;
1768:
1769: CURSOR Cur_chk_matrl_umtype(pformula_id NUMBER) IS
1770: SELECT COUNT(distinct uom_class)
1771: FROM fm_matl_dtl d ,mtl_units_of_measure m
1772: WHERE d.detail_uom = m.uom_code
1773: AND d.formula_id = pformula_id
1774: AND NVL(d.contribute_step_qty_ind, 'Y') = 'Y'
1775: AND (P_check.formulaline_id IS NULL OR

Line 1780: FROM fm_matl_dtl d ,mtl_units_of_measure m

1776: formulaline_id <> P_check.formulaline_id);
1777:
1778: CURSOR Cur_get_mtl_umtype(pformula_id NUMBER) IS
1779: SELECT distinct m.uom_class
1780: FROM fm_matl_dtl d ,mtl_units_of_measure m
1781: WHERE d.detail_uom = m.uom_code
1782: AND d.formula_id = pformula_id
1783: AND NVL(d.contribute_step_qty_ind, 'Y') = 'Y'
1784: AND (P_check.formulaline_id IS NULL OR

Line 1797: mtl_units_of_measure u

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

Line 1807: mtl_units_of_measure u

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

Line 1817: X_um_type mtl_units_of_measure.uom_class%TYPE;

1813: /* Cursor records.
1814: =====================*/
1815: X_recipe_details_rec Cur_get_recipe_details%ROWTYPE;
1816: -- X_material_rec Cur_get_material_lines%ROWTYPE;
1817: X_um_type mtl_units_of_measure.uom_class%TYPE;
1818: X_count NUMBER := 0;
1819: l_return_status VARCHAR2(10);
1820: /* Exceptions.
1821: =====================*/

Line 2327: -- 08-08-06 Kapil M Replaced sy_uoms_mst with mtl_units_of_measure

2323: -- Handles the UOM type conversion
2324: --
2325: -- HISTORY
2326: -- 26-06-06 Kapil M Created the procedure for bug# 5347857.
2327: -- 08-08-06 Kapil M Replaced sy_uoms_mst with mtl_units_of_measure
2328: **************************************************************/
2329:
2330: PROCEDURE check_Bch_stp_qty_calculatable (P_check IN calculatable_rec_type,
2331: P_ignore_mass_conv OUT NOCOPY BOOLEAN,

Line 2344: FROM mtl_units_of_measure

2340:
2341:
2342: CURSOR Cur_get_std_um (V_um_type VARCHAR2) IS
2343: SELECT UOM_CODE
2344: FROM mtl_units_of_measure
2345: WHERE uom_class = V_um_type
2346: AND BASE_UOM_FLAG = 'Y';
2347:
2348: CURSOR Cur_chk_matrl_umtype(pformula_id NUMBER) IS

Line 2350: FROM fm_matl_dtl d ,mtl_units_of_measure m

2346: AND BASE_UOM_FLAG = 'Y';
2347:
2348: CURSOR Cur_chk_matrl_umtype(pformula_id NUMBER) IS
2349: SELECT COUNT(distinct m.uom_class)
2350: FROM fm_matl_dtl d ,mtl_units_of_measure m
2351: WHERE d.DETAIL_UOM = m.uom_code
2352: AND d.formula_id = pformula_id
2353: AND NVL(d.contribute_step_qty_ind, 'Y') = 'Y'
2354: AND (P_check.formulaline_id IS NULL OR

Line 2359: FROM fm_matl_dtl d ,mtl_units_of_measure m

2355: formulaline_id <> P_check.formulaline_id);
2356:
2357: CURSOR Cur_get_mtl_umtype(pformula_id NUMBER) IS
2358: SELECT distinct m.uom_class
2359: FROM fm_matl_dtl d ,mtl_units_of_measure m
2360: WHERE d.DETAIL_UOM= m.uom_code
2361: AND d.formula_id = pformula_id
2362: AND NVL(d.contribute_step_qty_ind, 'Y') = 'Y'
2363: AND (P_check.formulaline_id IS NULL OR

Line 2370: mtl_units_of_measure u

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

Line 2379: mtl_units_of_measure u

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