Metabuilder Query

Select  TMF.FUNCTION_NAME
        ,TMF.DEFINED_IN_DATABASE_FLAG
        ,MFO.CREATE_STMT_STORED_FLAG
        ,MFO.FUNCTION_OVERLOAD_NAME
        ,Case
            When (MFO.FUNCTION_OVERLOAD_NAME is null and MFO.CREATE_STMT_STORED_FLAG = 'Y')  Then 'Missing Function Overload Name'
--            When (MFO.FUNCTION_OVERLOAD_NAME is null and TMF.DEFINED_IN_DATABASE_FLAG = 'Y' and create_error_text = 'No Error')  Then 'Validate Function Name in WideMemo'
            When (MFO.FUNCTION_OVERLOAD_NAME is null and TMF.DEFINED_IN_DATABASE_FLAG = 'Y'and create_error_text <> 'No Error')  Then 'Test Function and Validate Name in WideMemo'
            When  (MFO.META_FUNCTION_OVERLOAD_ID <> to_number(ltrim( FUNCTION_OVERLOAD_NAME,'tick_f_0000000' ),'999999999')) Then  'Overload Name/Overload ID Mismatch'
         End AS Overload_Function_Problem
        ,meta_function_overload_id
        ,'tick_f_0000000'||to_char(meta_function_overload_id) Correct_Function_Name
        ,MFO.CREATE_STMT_TEXT Actual_Function_Name
    From TICK_META_FUNCTION_OVERLOADS mfo,
         TICK_META_FUNCTIONS tmf
Where MFO.META_FUNCTION_ID = TMF.META_FUNCTION_ID
and to_char(MFO.META_FUNCTION_OVERLOAD_ID) <> nvl(to_char(ltrim( FUNCTION_OVERLOAD_NAME,'tick_f_0000000' )),'0')
And TMF.PRODUCT_FAMILY_VERSION_ID >= 900000000 -- custom product
and create_error_text <> 'No Error'
order by 1