APPS.MSD_DEM_COLLECT_UOMS dependencies on MSD_DEM_UOM_CONVERSIONS_GTT

Line 60: FROM msd_dem_uom_conversions_gtt t,

56: SELECT t.conversion_rate std_to_rate,
57: t.to_uom_class std_to_class,
58: f.conversion_rate std_from_rate,
59: f.from_uom_class std_from_class
60: FROM msd_dem_uom_conversions_gtt t,
61: msd_dem_uom_conversions_gtt f
62: WHERE t.sr_item_pk in (item_id, 0)
63: AND t.to_uom_code = to_unit
64: AND t.to_uom_class = t.from_uom_class

Line 61: msd_dem_uom_conversions_gtt f

57: t.to_uom_class std_to_class,
58: f.conversion_rate std_from_rate,
59: f.from_uom_class std_from_class
60: FROM msd_dem_uom_conversions_gtt t,
61: msd_dem_uom_conversions_gtt f
62: WHERE t.sr_item_pk in (item_id, 0)
63: AND t.to_uom_code = to_unit
64: AND t.to_uom_class = t.from_uom_class
65: AND f.sr_item_pk in (item_id, 0)

Line 79: from msd_dem_uom_conversions_gtt

75: CURSOR interclass_conversions(p_from_class VARCHAR2, p_to_class VARCHAR2) IS
76: select decode(from_uom_class, p_from_class, 1, 2) from_flag,
77: decode(to_uom_class, p_to_class, 1, 2) to_flag,
78: conversion_rate rate
79: from msd_dem_uom_conversions_gtt
80: where sr_item_pk = item_id and
81: ( (from_uom_class = p_from_class and to_uom_class = p_to_class) or
82: (from_uom_class = p_to_class and to_uom_class = p_from_class) );
83:

Line 489: from msd_dem_uom_conversions_gtt

485:
486:
487: l_stmt := null;
488: l_stmt := 'select distinct from_uom_code uom_code
489: from msd_dem_uom_conversions_gtt
490: union
491: select distinct to_uom_code uom_code
492: from msd_dem_uom_conversions_gtt';
493:

Line 492: from msd_dem_uom_conversions_gtt';

488: l_stmt := 'select distinct from_uom_code uom_code
489: from msd_dem_uom_conversions_gtt
490: union
491: select distinct to_uom_code uom_code
492: from msd_dem_uom_conversions_gtt';
493:
494: l_list := null;
495: l_list2 := null;
496: