DBA Data[Home] [Help]

APPS.MRP_CL_FUNCTION dependencies on MTL_UOM_CONVERSIONS

Line 804: FROM mtl_uom_conversions muc

800: lv_base_conversion_rate number;
801:
802: CURSOR get_conversion(user_uom_code varchar2,prf_uom_code varchar2) IS
803: SELECT conversion_rate
804: FROM mtl_uom_conversions muc
805: WHERE muc.uom_code = user_uom_code
806: AND muc.inventory_item_id = 0
807: AND NVL(muc.disable_date, SYSDATE + 1) > SYSDATE
808: AND EXISTS (SELECT 1 from mtl_units_of_measure_tl b

Line 851: FROM mtl_uom_conversions muc

847: BEGIN
848: /* get the conversion rate between MSC: Day UOM and the base UOM*/
849: SELECT conversion_rate
850: INTO lv_day_conversion_rate
851: FROM mtl_uom_conversions muc
852: WHERE muc.uom_code = lv_day_uom_code
853: AND muc.inventory_item_id = 0
854: AND NVL(muc.disable_date, SYSDATE + 1) > SYSDATE;
855:

Line 905: FROM mtl_uom_conversions muc

901: BEGIN
902: /* Get conversion betwwen BOM: Hour UOM and base UOM */
903: SELECT nvl(conversion_rate,1/24)
904: INTO lv_hr_conversion_rate
905: FROM mtl_uom_conversions muc
906: WHERE muc.uom_code = lv_hr_uom_code
907: AND muc.inventory_item_id = 0
908: AND NVL(muc.disable_date, SYSDATE + 1) > SYSDATE;
909: