DBA Data[Home] [Help]

APPS.GME_UPDATE_STEP_QTY_PVT dependencies on MTL_UOM_CONVERSIONS

Line 374: FROM mtl_uom_conversions

370: /* Cursor definition */
371: CURSOR cur_get_uom
372: IS
373: SELECT uom_class, conversion_rate
374: FROM mtl_uom_conversions
375: WHERE uom_code = p_batch_step_rec.step_qty_um
376: AND inventory_item_id = 0;
377:
378: /* Local Variables */

Line 379: l_um_type mtl_uom_conversions.uom_class%TYPE;

375: WHERE uom_code = p_batch_step_rec.step_qty_um
376: AND inventory_item_id = 0;
377:
378: /* Local Variables */
379: l_um_type mtl_uom_conversions.uom_class%TYPE;
380: l_std_factor NUMBER;
381: l_api_name CONSTANT VARCHAR2 (30) := 'calculate_mass_vol_qty';
382: BEGIN
383: IF g_debug <= gme_debug.g_log_procedure THEN

Line 603: FROM mtl_uom_conversions

599:
600: CURSOR cur_get_std_factor (v_um_code VARCHAR2)
601: IS
602: SELECT uom_class, conversion_rate
603: FROM mtl_uom_conversions
604: WHERE uom_code = v_um_code AND inventory_item_id = 0;
605:
606: CURSOR cur_get_tolerance
607: IS