APPS.GMICUOM dependencies on SY_UOMS_MST

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 313: FROM sy_uoms_mst

309: AND ( (uomc.disable_date IS NULL)
310: OR (uomc.disable_date > sysdate) )
311: UNION
312: SELECT 2, um_type, std_factor
313: FROM sy_uoms_mst
314: WHERE um_code = Vum_code
315: AND delete_mark = 0
316: ORDER by 1;
317:

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

Line 743: FROM sy_uoms_mst

739: AND uomc.uom_code = uom.uom_code
740: AND uomc.inventory_item_id = Vinventory_item_id
741: UNION
742: SELECT 2, um_type, std_factor
743: FROM sy_uoms_mst
744: WHERE um_code = Vum_code
745: AND delete_mark = 0
746: ORDER by 1;
747: