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 851: from MTL_UOM_CLASS_CONVERSIONS MTLUCC1

847: NVL(MTLUCV.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE) AND
848: l_allowed_units in (1,3) AND MTLUCV.inventory_item_id=0 AND
849: exists(
850: select 'UOM_CLASS conversion exists for the class of UOM supplied'
851: from MTL_UOM_CLASS_CONVERSIONS MTLUCC1
852: where
853: MTLUCC1.to_uom_class = MTLUCV.uom_class AND
854: MTLUCC1.inventory_item_id = p_item_id AND
855: NVL(MTLUCC1.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE)

Line 872: from MTL_UOM_CLASS_CONVERSIONS MTLUCC

868: NVL(MTLUCV.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE) AND
869: l_allowed_units in (2,3) AND MTLUCV.inventory_item_id=0 AND
870: exists(
871: select 'UOM_CLASS conversion exists for the class of UOM supplied'
872: from MTL_UOM_CLASS_CONVERSIONS MTLUCC
873: where
874: MTLUCC.to_uom_class = MTLUCV.uom_class AND
875: MTLUCC.INVENTORY_ITEM_ID = p_item_id AND
876: NVL(MTLUCC.DISABLE_DATE,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE)