DBA Data[Home] [Help]

APPS.EAM_WORKORDER_UTIL_PKG dependencies on MTL_UOM_CONVERSIONS

Line 841: FROM MTL_UOM_CONVERSIONS muc1,

837: IF hour_uom_class_code <> uom_class_code THEN
838: RAISE different_uom_class;
839: ELSE
840: SELECT COUNT(*) INTO conversion_exists
841: FROM MTL_UOM_CONVERSIONS muc1,
842: MTL_UOM_CONVERSIONS muc2
843: WHERE muc1.UOM_CLASS = uom_class_code
844: AND muc1.UOM_CODE = X_Unit_Of_Measure
845: AND muc1.inventory_item_id = 0

Line 842: MTL_UOM_CONVERSIONS muc2

838: RAISE different_uom_class;
839: ELSE
840: SELECT COUNT(*) INTO conversion_exists
841: FROM MTL_UOM_CONVERSIONS muc1,
842: MTL_UOM_CONVERSIONS muc2
843: WHERE muc1.UOM_CLASS = uom_class_code
844: AND muc1.UOM_CODE = X_Unit_Of_Measure
845: AND muc1.inventory_item_id = 0
846: AND nvl(muc1.disable_date, sysdate +1) > sysdate