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 510: from msd_dem_uom_conversions_gtt

506:
507:
508: l_stmt := null;
509: l_stmt := 'select distinct from_uom_code uom_code
510: from msd_dem_uom_conversions_gtt
511: union
512: select distinct to_uom_code uom_code
513: from msd_dem_uom_conversions_gtt';
514:

Line 513: from msd_dem_uom_conversions_gtt';

509: l_stmt := 'select distinct from_uom_code uom_code
510: from msd_dem_uom_conversions_gtt
511: union
512: select distinct to_uom_code uom_code
513: from msd_dem_uom_conversions_gtt';
514:
515: l_list := null;
516: l_list2 := null;
517: