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: --QZENG Bug 14197174 Added condition BASE_UOM_FLAG = 'Y' to fetch the base uom
839: CURSOR Cur_get_std_um (V_uom_class VARCHAR2) IS

Line 841: FROM mtl_units_of_measure

837:
838: --QZENG Bug 14197174 Added condition BASE_UOM_FLAG = 'Y' to fetch the base uom
839: CURSOR Cur_get_std_um (V_uom_class VARCHAR2) IS
840: SELECT uom_code
841: FROM mtl_units_of_measure
842: WHERE uom_class = V_uom_class
843: AND BASE_UOM_FLAG = 'Y';
844: BEGIN
845: -- Initialize the global variable to fix the bug 10161595

Line 941: X_from_uom mtl_units_of_measure.uom_code%TYPE;

937: X_cur_rec NUMBER DEFAULT 0;
938: X_line_qty NUMBER;
939: X_temp_qty NUMBER;
940: X_item_id NUMBER;
941: X_from_uom mtl_units_of_measure.uom_code%TYPE;
942: X_to_uom mtl_units_of_measure.uom_code%TYPE;
943: X_item_no mtl_system_items_kfv.concatenated_segments%TYPE;
944:
945: /* Cursor Definitions.

Line 942: X_to_uom mtl_units_of_measure.uom_code%TYPE;

938: X_line_qty NUMBER;
939: X_temp_qty NUMBER;
940: X_item_id NUMBER;
941: X_from_uom mtl_units_of_measure.uom_code%TYPE;
942: X_to_uom mtl_units_of_measure.uom_code%TYPE;
943: X_item_no mtl_system_items_kfv.concatenated_segments%TYPE;
944:
945: /* Cursor Definitions.
946: =====================*/

Line 1310: X_from_uom mtl_units_of_measure.uom_code%TYPE;

1306: X_cur_rec NUMBER DEFAULT 0;
1307: X_line_qty NUMBER;
1308: X_temp_qty NUMBER;
1309: X_item_id NUMBER;
1310: X_from_uom mtl_units_of_measure.uom_code%TYPE;
1311: X_to_uom mtl_units_of_measure.uom_code%TYPE;
1312: X_item_no mtl_system_items_kfv.concatenated_segments%TYPE;
1313:
1314:

Line 1311: X_to_uom mtl_units_of_measure.uom_code%TYPE;

1307: X_line_qty NUMBER;
1308: X_temp_qty NUMBER;
1309: X_item_id NUMBER;
1310: X_from_uom mtl_units_of_measure.uom_code%TYPE;
1311: X_to_uom mtl_units_of_measure.uom_code%TYPE;
1312: X_item_no mtl_system_items_kfv.concatenated_segments%TYPE;
1313:
1314:
1315: /* Scaling realted variables */

Line 1722: X_from_uom mtl_units_of_measure.uom_code%TYPE;

1718: ==================*/
1719: X_exists NUMBER(5);
1720: X_temp_qty NUMBER;
1721: X_item_id NUMBER;
1722: X_from_uom mtl_units_of_measure.uom_code%TYPE;
1723: X_to_uom mtl_units_of_measure.uom_code%TYPE;
1724: X_item_no mtl_system_items_kfv.concatenated_segments%TYPE;
1725:
1726: /* Cursor Definitions.

Line 1723: X_to_uom mtl_units_of_measure.uom_code%TYPE;

1719: X_exists NUMBER(5);
1720: X_temp_qty NUMBER;
1721: X_item_id NUMBER;
1722: X_from_uom mtl_units_of_measure.uom_code%TYPE;
1723: X_to_uom mtl_units_of_measure.uom_code%TYPE;
1724: X_item_no mtl_system_items_kfv.concatenated_segments%TYPE;
1725:
1726: /* Cursor Definitions.
1727: =====================*/

Line 1773: FROM mtl_units_of_measure

1769:
1770: --QZENG Bug 14197174 Added condition BASE_UOM_FLAG = 'Y' to fetch the base uom
1771: CURSOR Cur_get_std_um (V_uom_class VARCHAR2) IS
1772: SELECT uom_code
1773: FROM mtl_units_of_measure
1774: WHERE uom_class = V_uom_class
1775: AND BASE_UOM_FLAG = 'Y';
1776:
1777: CURSOR Cur_chk_matrl_umtype(pformula_id NUMBER) IS

Line 1779: FROM fm_matl_dtl d ,mtl_units_of_measure m

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

Line 1788: FROM fm_matl_dtl d ,mtl_units_of_measure m

1784: formulaline_id <> P_check.formulaline_id);
1785:
1786: CURSOR Cur_get_mtl_umtype(pformula_id NUMBER) IS
1787: SELECT distinct m.uom_class
1788: FROM fm_matl_dtl d ,mtl_units_of_measure m
1789: WHERE d.detail_uom = m.uom_code
1790: AND d.formula_id = pformula_id
1791: AND NVL(d.contribute_step_qty_ind, 'Y') = 'Y'
1792: AND (P_check.formulaline_id IS NULL OR

Line 1805: mtl_units_of_measure u

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

Line 1815: mtl_units_of_measure u

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

Line 1825: X_um_type mtl_units_of_measure.uom_class%TYPE;

1821: /* Cursor records.
1822: =====================*/
1823: X_recipe_details_rec Cur_get_recipe_details%ROWTYPE;
1824: -- X_material_rec Cur_get_material_lines%ROWTYPE;
1825: X_um_type mtl_units_of_measure.uom_class%TYPE;
1826: X_count NUMBER := 0;
1827: l_return_status VARCHAR2(10);
1828: /* Exceptions.
1829: =====================*/

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

2331: -- Handles the UOM type conversion
2332: --
2333: -- HISTORY
2334: -- 26-06-06 Kapil M Created the procedure for bug# 5347857.
2335: -- 08-08-06 Kapil M Replaced sy_uoms_mst with mtl_units_of_measure
2336: **************************************************************/
2337:
2338: PROCEDURE check_Bch_stp_qty_calculatable (P_check IN calculatable_rec_type,
2339: P_ignore_mass_conv OUT NOCOPY BOOLEAN,

Line 2352: FROM mtl_units_of_measure

2348:
2349:
2350: CURSOR Cur_get_std_um (V_um_type VARCHAR2) IS
2351: SELECT UOM_CODE
2352: FROM mtl_units_of_measure
2353: WHERE uom_class = V_um_type
2354: AND BASE_UOM_FLAG = 'Y';
2355:
2356: CURSOR Cur_chk_matrl_umtype(pformula_id NUMBER) IS

Line 2358: FROM fm_matl_dtl d ,mtl_units_of_measure m

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

Line 2367: FROM fm_matl_dtl d ,mtl_units_of_measure m

2363: formulaline_id <> P_check.formulaline_id);
2364:
2365: CURSOR Cur_get_mtl_umtype(pformula_id NUMBER) IS
2366: SELECT distinct m.uom_class
2367: FROM fm_matl_dtl d ,mtl_units_of_measure m
2368: WHERE d.DETAIL_UOM= m.uom_code
2369: AND d.formula_id = pformula_id
2370: AND NVL(d.contribute_step_qty_ind, 'Y') = 'Y'
2371: AND (P_check.formulaline_id IS NULL OR

Line 2378: mtl_units_of_measure u

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

Line 2387: mtl_units_of_measure u

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