DBA Data[Home] [Help]

APPS.BOM_RESOURCES_PKG dependencies on MTL_UNITS_OF_MEASURE

Line 898: SELECT COUNT(*) INTO uom_value FROM MTL_UNITS_OF_MEASURE

894:
895: FUNCTION Check_Valid_UOM(X_Unit_Of_Measure VARCHAR2) RETURN NUMBER IS
896: uom_value NUMBER;
897: BEGIN
898: SELECT COUNT(*) INTO uom_value FROM MTL_UNITS_OF_MEASURE
899: WHERE UOM_CODE = SUBSTR(X_Unit_Of_Measure, 1, 3)
900: AND NVL(DISABLE_DATE, SYSDATE+1) > SYSDATE;
901: RETURN(uom_value);
902: END Check_Valid_UOM;