select
        ifrs17guif2_.[FUNCTION_NAME] as col_0_0_,
        dimifrs17b1_.[VALID_FROM] as col_1_0_,
        dimifrs17b1_.[VALID_TO] as col_2_0_,
        ifrs17guif0_.[USER_NAME] as col_3_0_,
        ifrs17guif0_.[EVENT_TIME_STAMP] as col_4_0_,
        ifrs17guif0_.[FUNCTION_STATUS] as col_5_0_
    from
        [META].[dbo].[IFRS17_GUI_FUNCTION_STATUS_HISTORY] ifrs17guif0_ cross
    join
        [DW].[DW].[dim_ifrs17_business_validity] dimifrs17b1_
    inner join
        [META].[dbo].[IFRS17_GUI_FUNCTIONS] ifrs17guif2_
            on (
                ifrs17guif0_.[FUNCTION_ID]=ifrs17guif2_.[FUNCTION_ID]
            )
    where
        ifrs17guif0_.[FUNCTION_ID]=ifrs17guif2_.[FUNCTION_ID]
        and ifrs17guif0_.[DML_TYPE]<>'D'
        and dimifrs17b1_.[IS_ACTIVE]=1
    order by
        ifrs17guif0_.[EVENT_TIME_STAMP] desc