DBA Data[Home] [Help]

APPS.MSC_X_UTIL dependencies on MSC_UOM_CONVERSIONS

Line 245: msc_uom_conversions muc1,

241: select muc1.conversion_rate/muc2.conversion_rate
242: INTO
243: p_conv_rate
244: FROM
245: msc_uom_conversions muc1,
246: msc_uom_conversions muc2
247: where muc1.inventory_item_id = 0
248: and muc2.inventory_item_id = 0
249: and muc1.uom_class = muc2.uom_class

Line 246: msc_uom_conversions muc2

242: INTO
243: p_conv_rate
244: FROM
245: msc_uom_conversions muc1,
246: msc_uom_conversions muc2
247: where muc1.inventory_item_id = 0
248: and muc2.inventory_item_id = 0
249: and muc1.uom_class = muc2.uom_class
250: and muc1.uom_class = l_uom_class

Line 267: msc_uom_conversions_view muc

263: select muc.conversion_rate
264: INTO
265: p_conv_rate
266: FROM
267: msc_uom_conversions_view muc
268: where muc.inventory_item_id = p_inventory_item_id
269: and muc.primary_uom_code = p_uom_code
270: and muc.uom_code = p_dest_uom_code
271: and rownum = 1;

Line 279: msc_uom_conversions_view muc

275: select muc.conversion_rate
276: INTO
277: p_conv_rate
278: FROM
279: msc_uom_conversions_view muc
280: where muc.inventory_item_id = p_inventory_item_id
281: and muc.primary_uom_code = p_dest_uom_code
282: and muc.uom_code = p_uom_code
283: and rownum = 1;