DBA Data[Home] [Help]

APPS.GMICUOM dependencies on MTL_UOM_CONVERSIONS

Line 304: FROM mtl_uom_conversions uomc, mtl_units_of_measure uom, sy_uoms_mst sy

300: ==================*/
301: CURSOR get_uom_type(Vum_code uomcode_type,
302: Vinventory_item_id mtl_system_items.inventory_item_id%type) IS
303: SELECT 1, uomc.uom_class um_type, uomc.conversion_rate std_factor
304: FROM mtl_uom_conversions uomc, mtl_units_of_measure uom, sy_uoms_mst sy
305: WHERE sy.um_code = Vum_code
306: AND uom.unit_of_measure = sy.unit_of_measure
307: AND uomc.uom_code = uom.uom_code
308: AND uomc.inventory_item_id = Vinventory_item_id

Line 736: FROM mtl_uom_conversions uomc, mtl_units_of_measure uom, sy_uoms_mst sy

732: ==================*/
733: CURSOR get_uom_type(Vum_code uomcode_type,
734: Vinventory_item_id mtl_system_items.inventory_item_id%type) IS
735: SELECT 1, uomc.uom_class um_type, uomc.conversion_rate std_factor
736: FROM mtl_uom_conversions uomc, mtl_units_of_measure uom, sy_uoms_mst sy
737: WHERE sy.um_code = Vum_code
738: AND uom.unit_of_measure = sy.unit_of_measure
739: AND uomc.uom_code = uom.uom_code
740: AND uomc.inventory_item_id = Vinventory_item_id