Using a PARTITION BY JOIN to Fill In The Gaps in Sparse Data

thanks, @Ifor for the answer, it works, but the "AUDIT_DATA " table contains lots of records hence the query takes lot of time the final return data.