APPS.INV_INVIRILC_XMLP_PKG dependencies on MTL_UOM_CLASS_CONVERSIONS

Line 81: MTL_UOM_CLASS_CONVERSIONS

77: ,2),
78: CONVERSION_RATE
79: INTO TO_UOM_FLAG,CLASS_RATE
80: FROM
81: MTL_UOM_CLASS_CONVERSIONS
82: WHERE INVENTORY_ITEM_ID = ITEM_ID
83: AND TO_UOM_CLASS IN ( FROM_CLASS , TO_CLASS )
84: AND FROM_UOM_CLASS IN ( FROM_CLASS , TO_CLASS )
85: AND FROM_UOM_CLASS <> TO_UOM_CLASS;

Line 112: MTL_UOM_CLASS_CONVERSIONS F,

108: F.CONVERSION_RATE,
109: T.CONVERSION_RATE
110: INTO FROM_CLASS_RATE,TO_CLASS_RATE
111: FROM
112: MTL_UOM_CLASS_CONVERSIONS F,
113: MTL_UOM_CLASS_CONVERSIONS T
114: WHERE F.INVENTORY_ITEM_ID = ITEM_ID
115: AND T.INVENTORY_ITEM_ID = ITEM_ID
116: AND F.TO_UOM_CLASS = FROM_CLASS

Line 113: MTL_UOM_CLASS_CONVERSIONS T

109: T.CONVERSION_RATE
110: INTO FROM_CLASS_RATE,TO_CLASS_RATE
111: FROM
112: MTL_UOM_CLASS_CONVERSIONS F,
113: MTL_UOM_CLASS_CONVERSIONS T
114: WHERE F.INVENTORY_ITEM_ID = ITEM_ID
115: AND T.INVENTORY_ITEM_ID = ITEM_ID
116: AND F.TO_UOM_CLASS = FROM_CLASS
117: AND T.TO_UOM_CLASS = TO_CLASS;

Line 262: MTL_UOM_CLASS_CONVERSIONS

258: ,2),
259: CONVERSION_RATE
260: INTO TO_UOM_FLAG,CLASS_RATE
261: FROM
262: MTL_UOM_CLASS_CONVERSIONS
263: WHERE INVENTORY_ITEM_ID = ITEM_ID
264: AND TO_UOM_CLASS IN ( FROM_CLASS , TO_CLASS )
265: AND FROM_UOM_CLASS IN ( FROM_CLASS , TO_CLASS )
266: AND FROM_UOM_CLASS <> TO_UOM_CLASS;

Line 293: MTL_UOM_CLASS_CONVERSIONS F,

289: F.CONVERSION_RATE,
290: T.CONVERSION_RATE
291: INTO FROM_CLASS_RATE,TO_CLASS_RATE
292: FROM
293: MTL_UOM_CLASS_CONVERSIONS F,
294: MTL_UOM_CLASS_CONVERSIONS T
295: WHERE F.INVENTORY_ITEM_ID = ITEM_ID
296: AND T.INVENTORY_ITEM_ID = ITEM_ID
297: AND F.TO_UOM_CLASS = FROM_CLASS

Line 294: MTL_UOM_CLASS_CONVERSIONS T

290: T.CONVERSION_RATE
291: INTO FROM_CLASS_RATE,TO_CLASS_RATE
292: FROM
293: MTL_UOM_CLASS_CONVERSIONS F,
294: MTL_UOM_CLASS_CONVERSIONS T
295: WHERE F.INVENTORY_ITEM_ID = ITEM_ID
296: AND T.INVENTORY_ITEM_ID = ITEM_ID
297: AND F.TO_UOM_CLASS = FROM_CLASS
298: AND T.TO_UOM_CLASS = TO_CLASS;