APPS.INV_CONVERT dependencies on MTL_UOM_CLASS_CONVERSIONS

Line 121: from mtl_uom_class_conversions

117: cursor interclass_conversions is
118: select decode(to_uom_class, to_class, 1, 2) to_flag,
119: decode(from_uom_class, from_class, 1, to_class, 2, 0) from_flag,
120: conversion_rate rate
121: from mtl_uom_class_conversions
122: where inventory_item_id = item_id
123: and to_uom_class in (from_class, to_class)
124: and nvl(disable_date, trunc(sysdate) + 1) > trunc(sysdate);
125:

Line 158: from mtl_uom_class_conversions mucc

154: and nvl(disable_date, trunc(sysdate) + 1) > trunc(sysdate)
155: union all
156: (
157: select from_uom_class, to_uom_class , conversion_rate
158: from mtl_uom_class_conversions mucc
159: where inventory_item_id = item_id
160: and to_uom_class in (from_class, to_class)
161: and nvl(disable_date, trunc(sysdate) + 1) > trunc(sysdate)
162: and not exists (

Line 881: from MTL_UOM_CLASS_CONVERSIONS MTLUCC1

877: NVL(MTLUCV.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE) AND
878: l_allowed_units in (1,3) AND MTLUCV.inventory_item_id=0 AND
879: exists(
880: select 'UOM_CLASS conversion exists for the class of UOM supplied'
881: from MTL_UOM_CLASS_CONVERSIONS MTLUCC1
882: where
883: MTLUCC1.to_uom_class = MTLUCV.uom_class AND
884: MTLUCC1.inventory_item_id = p_item_id AND
885: NVL(MTLUCC1.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE)

Line 902: from MTL_UOM_CLASS_CONVERSIONS MTLUCC

898: NVL(MTLUCV.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE) AND
899: l_allowed_units in (2,3) AND MTLUCV.inventory_item_id=0 AND
900: exists(
901: select 'UOM_CLASS conversion exists for the class of UOM supplied'
902: from MTL_UOM_CLASS_CONVERSIONS MTLUCC
903: where
904: MTLUCC.to_uom_class = MTLUCV.uom_class AND
905: MTLUCC.INVENTORY_ITEM_ID = p_item_id AND
906: NVL(MTLUCC.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE)

Line 1739: WHERE (A.uom_class IN (SELECT to_uom_class FROM mtl_uom_class_conversions B

1735: WHERE I.enabled_flag = 'Y'
1736: AND (SYSDATE BETWEEN NVL(TRUNC(I.start_date_active),SYSDATE )
1737: AND NVL(TRUNC(I.end_date_active),SYSDATE))
1738: AND ( EXISTS (SELECT A.unit_of_measure FROM mtl_units_of_measure A
1739: WHERE (A.uom_class IN (SELECT to_uom_class FROM mtl_uom_class_conversions B
1740: WHERE B.inventory_item_id = I.inventory_item_id)
1741: OR A.uom_class = (SELECT Z.uom_class FROM mtl_units_of_measure Z
1742: WHERE Z.uom_code = I.primary_uom_code))
1743: AND A.base_uom_flag <> 'Y'

Line 1759: from mtl_uom_class_conversions b

1755: FROM mtl_units_of_measure x
1756: WHERE x.uom_code = p_to_uom_code
1757: AND x.uom_code IN (SELECT DISTINCT a.uom_code FROM mtl_units_of_measure a
1758: WHERE (a.uom_class in (select to_uom_class
1759: from mtl_uom_class_conversions b
1760: where b.inventory_item_id = p_item_id)
1761: or a.uom_class =(select DISTINCT z.uom_class
1762: from mtl_units_of_measure z , mtl_system_items_vl m
1763: where m.inventory_item_id = p_item_id

Line 1864: FROM mtl_uom_class_conversions

1860:
1861: BEGIN
1862: SELECT 'Y'
1863: INTO l_conversion_exists
1864: FROM mtl_uom_class_conversions
1865: WHERE inventory_item_id = p_item_id
1866: AND to_uom_code = p_to_uom_code ;
1867: EXCEPTION
1868: WHEN no_data_found THEN

Line 1874: INSERT INTO mtl_uom_class_conversions

1870: l_conversion_exists := 'N' ;
1871: END ;
1872:
1873: IF l_conversion_exists = 'N' THEN
1874: INSERT INTO mtl_uom_class_conversions
1875: (inventory_item_id,
1876: from_unit_of_measure,
1877: from_uom_code,
1878: from_uom_class,