DBA Data[Home] [Help]

APPS.GME_UPDATE_STEP_QTY_PVT dependencies on MTL_UOM_CONVERSIONS

Line 385: FROM mtl_uom_conversions

381: /* Cursor definition */
382: CURSOR cur_get_uom
383: IS
384: SELECT uom_class, conversion_rate
385: FROM mtl_uom_conversions
386: WHERE uom_code = p_batch_step_rec.step_qty_um
387: AND inventory_item_id = 0;
388:
389: /* Local Variables */

Line 390: l_um_type mtl_uom_conversions.uom_class%TYPE;

386: WHERE uom_code = p_batch_step_rec.step_qty_um
387: AND inventory_item_id = 0;
388:
389: /* Local Variables */
390: l_um_type mtl_uom_conversions.uom_class%TYPE;
391: l_std_factor NUMBER;
392: l_api_name CONSTANT VARCHAR2 (30) := 'calculate_mass_vol_qty';
393: BEGIN
394: IF g_debug <= gme_debug.g_log_procedure THEN

Line 628: FROM mtl_uom_conversions

624:
625: CURSOR cur_get_std_factor (v_um_code VARCHAR2)
626: IS
627: SELECT uom_class, conversion_rate
628: FROM mtl_uom_conversions
629: WHERE uom_code = v_um_code AND inventory_item_id = 0;
630:
631: CURSOR cur_get_tolerance
632: IS