DBA Data[Home] [Help]

APPS.GME_INSERT_STEP_PVT dependencies on MTL_UOM_CONVERSIONS

Line 32: FROM mtl_uom_conversions

28: /* Bug#5231180 */
29: CURSOR cur_get_std_factor (v_um_code VARCHAR2)
30: IS
31: SELECT conversion_rate, uom_class
32: FROM mtl_uom_conversions
33: WHERE uom_code = v_um_code
34: AND inventory_item_id = 0;
35:
36: --nsinghi bug#5202811.

Line 473: --Bug#5231180 rewritten the folloiwing cursor to use mtl_uom_conversions table

469: WHERE resources = p_rsrc
470: AND delete_mark = 0
471: AND capacity_constraint = 1;
472:
473: --Bug#5231180 rewritten the folloiwing cursor to use mtl_uom_conversions table
474: /*CURSOR cur_get_std_factor (v_um_code VARCHAR2)
475: IS
476: SELECT std_factor, um_type
477: FROM sy_uoms_mst

Line 482: FROM mtl_uom_conversions

478: WHERE um_code = v_um_code; */
479: CURSOR cur_get_std_factor (v_um_code VARCHAR2)
480: IS
481: SELECT conversion_rate, uom_class
482: FROM mtl_uom_conversions
483: WHERE uom_code = v_um_code
484: AND inventory_item_id = 0;
485:
486: error_rsrc_diff_um_type EXCEPTION;